Working with CSV file Using Python

-

About CSV

Comma-separated values are known as CSV. It is the simplest form of storing data in tabular form as plain text. Data Scientists need to know how to work with CSV data because most of their activities involve CSV data.In CSV files, the first line contains the field/feature names.

The following lines of the file are observations/records. The values of a record are separated by “comma.”


Here we have a file named “annual-energy-survey-demo-csv.csv” using this CSV file, we will try to learn how to  read and write the CSV files.


In this article, I'll explain in detail how you can read and write CSV files in Python.  


# Import the csv library

import csv


# Open the CSV file

file = open('/content/drive/MyDrive/annual-enpr-survey-demo-csv.csv')

type(file)

output:io.TextIOWrapper


# Use the csv.reader object to read the CSV file 

csvreader = csv.reader(file)


# Extract the fields names

csv_header = []

csv_header = next(csvreader)

print(header)

 

Output:

['Year', 'Industry_aggregation', 'Industry_code']


#Extract the rows or records

csv_rows = []

for each_row in csvreader:

        csv_rows.append(each_row)

print(csv_rows)

Output:


[['2019', 'Level 4', 'AA111'],

 ['2020', 'Level 5', 'AA112'],

 ['2020', 'Level 4', 'AA111'],

 ['2019', 'Level 2', 'AA156'],

 ['2020', 'Level 5', 'AA111'],

 ['2020', 'Level 4', 'AA112'],

 ['2021', 'Level 2', 'AA111'],

 ['2020', 'Level 4', 'AA111'],

 ['2021', 'Level 5', 'AA111'],

 ['2020', 'Level 4', 'AA111'],

 ['2021', 'Level 4', 'AA110'],

 ['2020', 'Level 5', 'AA111'],

 ['2020', 'Level 4', 'AA114'],

 ['2020', 'Level 5', 'AA111'],

 ['2021', 'Level 4', 'AA113'],

 ['2020', 'Level 4', 'AA116'],

 ['2018', 'Level 5', 'AA111'],

 ['2021', 'Level 2', 'AA115'],

 ['2020', 'Level 4', 'AA116'],

 ['2020', 'Level 5', 'AA111']]


#Close the file

file.close()

Comments

Post a Comment

Popular posts from this blog

Validation Code For Phone Number Using preg_match() in Php

-
Image
Phone Number Validation Using preg_match() Below code shows validation of Phone Number 1)Checking whether user input (Phone Number) contains an alphabet in Phone Number          <?php         $mobile_no="123fdgdg890";        if(preg_match("/[a-z][A-Z]/i", $mobile_no))        {   echo "Invalid Phone Number!";        }else{                echo "Valid Phone Number!";        }      ?> Output :Invalid Phone Number! Syntax preg_match("/[a-z][A-Z]/i", $mobile_no) The above syntax will verify whether given phone number is well-formed or not.if it is not, it will show an error message. The    preg_match()  function helps to find whether a given variable is valid or not. 2 )Checking whether user input (Phone Number) contains 10 digits in Phone Number      <?php...
Read more

Writing data to a file using Python

-
  Writing data to a file using Python Writing data to a file in Python can be done in a variety of ways, depending on the file type and how you want to save the data. Here's a general guide to common formats. 1. Writing Text to a Plain Text File # Writing text data data = "This is some text data." # Open a file in write mode ('w') and write data with open("output.txt", "w") as file:     file.write(data) 2. Writing Data to a CSV File import csv # Data to write data = [     ["Name", "Age", "City"],     ["Rajesh", 25, "India"],     ["Shaun", 30, "San Francisco"],     ["Afzal", 35, "Chicago"] ] # Writing to a CSV file with open("output.csv", "w", newline="") as file:     writer = csv.writer(file)     writer.writerows(data) 3. Writing Data to a JSON File import json # Data to write data = {     "Name": "Alice", ...
Read more

Simple HTML Form Elements For Registration Page Example

-
Image
<!DOCTYPE html> <html lang="en">     <head>         <title>Form Elements</title>         <link href="bootstrap.min.css" rel="stylesheet" type="text/css"  />         <style type="text/css">             .Mycontainer{                 margin-left: 30px;                 margin-right: 50px;                 margin-top: 10px;             }             .mb10{                 margin-bottom: 10px;             }         </style>     </head>     <body>         <div class="Mycontainer">             ...
Read more