csv文件格式的处理
读取整个csv文件
# 读取整个csv
filename = 'sitka_weather_07-2014.csv'
with open(filename) as f:
read = f.read()
print(read)
分析csv头文件
# 分析csv头文件
import csv
filename = 'sitka_weather_07-2014.csv'
with open(filename) as f:
read = csv.reader(f)
header_row = next(read) # next迭代器
print(header_row)
# 打印文件头极其位置
import csv
filename = 'sitka_weather_07-2014.csv'
with open(filename) as f:
read = csv.reader(f)
header_row = next(read)
for index, column_header in enumerate(header_row):
print(index, column_header)
# 将头文件处理成字典形式
import csv
filename = 'sitka_weather_07-2014.csv'
file_header = {}
# enumerate() 函数用于将一个可遍历的数据对象(如列表、元组或字符串)组合为一个索引序列,同时列出数据和数据下标
with open(filename) as f:
read = csv.reader(f)# reader 为阅读器
header_row = next(read)
for index, column_header in enumerate(header_row):