read csv file and process all records 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: csv manipulation python
import csv, sys
filename = 'some.csv'
with open(filename, 'rb') as f:
reader = csv.reader(f)
try:
for row in reader:
print row
except csv.Error as e:
sys.exit('file %s, line %d: %s' % (filename, reader.line_num, e))