analyse csv file python code example

Example 1: python read csv

# pip install pandas 
import pandas as pd

# Read the csv file
data = pd.read_csv('data.csv')

# Print it out if you want
print(data)

Example 2: read csv python

import pandas as pd 
data = pd.read_csv("filename.csv") 
data.head()

Example 3: spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')

>>> import csv
>>> with open('eggs.csv', newline='') as csvfile:
...     spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
...     for row in spamreader:
...         print(', '.join(row))
Spam, Spam, Spam, Spam, Spam, Baked Beans
Spam, Lovely Spam, Wonderful Spam