# -*- coding: utf-8 -*-
import csv
with open('E:/iris.csv') as csvfile:
reader = csv.DictReader(csvfile, fieldnames=None) # fieldnames默認(rèn)為None,如果所讀csv文件沒(méi)有表頭，則需要指定
list_1 = [e for e in reader] # 每行數(shù)據(jù)作為一個(gè)dict存入鏈表中
csvfile.close()
print list_1[0]

{'Petal.Length': '1.4', 'Sepal.Length': '5.1', 'Petal.Width': '0.2', 'Sepal.Width': '3.5', 'Species': 'setosa'}

list_1 = list()
for e in reader:
 list_1.append(your_func(e)) # your_func為每條數(shù)據(jù)的處理函數(shù)

# 數(shù)據(jù)
data = [
{'Petal.Length': '1.4', 'Sepal.Length': '5.1', 'Petal.Width': '0.2', 'Sepal.Width': '3.5', 'Species': 'setosa'},
{'Petal.Length': '1.4', 'Sepal.Length': '4.9', 'Petal.Width': '0.2', 'Sepal.Width': '3', 'Species': 'setosa'},
{'Petal.Length': '1.3', 'Sepal.Length': '4.7', 'Petal.Width': '0.2', 'Sepal.Width': '3.2', 'Species': 'setosa'},
{'Petal.Length': '1.5', 'Sepal.Length': '4.6', 'Petal.Width': '0.2', 'Sepal.Width': '3.1', 'Species': 'setosa'}
]
# 表頭
header = ['Petal.Length', 'Sepal.Length', 'Petal.Width', 'Sepal.Width', 'Species']
print len(data)
with open('E:/dst.csv', 'wb') as dstfile: #寫(xiě)入方式選擇wb，否則有空行
 writer = csv.DictWriter(dstfile, fieldnames=header)
 writer.writeheader() # 寫(xiě)入表頭
 writer.writerows(data) # 批量寫(xiě)入
dstfile.close()

# 讀取csv文件為DataFrame
import pandas as pd
dframe = pd.DataFrame.from_csv('E:/iris.csv')

import csv
import pandas as pd
with open('E:/iris.csv') as csvfile:
 reader = csv.DictReader(csvfile, fieldnames=None) # fieldnames默認(rèn)為None,如果所讀csv文件沒(méi)有表頭，則需要指定
 list_1 = [e for e in reader] # 每行數(shù)據(jù)作為一個(gè)dict存入鏈表中
csvfile.close()
dfrme = pd.DataFrame.from_records(list_1)

dfrme.to_csv('E:/dst.csv', index=False) # 不要每行的編號(hào)