(一)获取数据
1.下载sitka_weather_07-2014.csv数据:https://ehmatthes.github.io/pcc/
(二)分析CSV文件头
csv模块包含在python标准库中,不需额外要下载。调用一次next()方法读取文件头信息。如果调用n次next()方法,那么读取到n行数据。
import csv
import os
filename='sitka_weather_07-2014.csv'
with open(filename,'r')as file:
#1.创建阅读器对象
reader=csv.reader(file)
#2.读取文件头信息
header_row=next(reader)
print(header_row)
结果演示:
['AKDT', 'Max TemperatureF', 'Mean TemperatureF', 'Min TemperatureF', 'Max Dew PointF', 'MeanDew PointF', 'Min DewpointF', 'Max Humidity', ' Mean Humidity', ' Min Humidity', ' Max Sea Level PressureIn', ' Mean Sea Level PressureIn', ' Min Sea Level PressureIn', ' Max VisibilityMiles', ' Mean VisibilityMiles', ' Min VisibilityMiles', ' Max Wind SpeedMPH', ' Mean Wind SpeedMPH', ' Max Gust SpeedMPH', 'PrecipitationIn', ' CloudCover', ' Events', ' WindDirDegrees']
(三)打印文件头及其位置(打印列表的索引和值)
import csv
import os
filename='sitka_weather_07-2014.csv'
with open(filename,'r')as file:
#1.创建阅读器对象
reader=csv.reader(file)
#2.读取文件头信息
header_row=next(reader)
for index,column_header in enumerate(header_row):
print(index,column_header)
结果演示:
0 AKDT
1 Max TemperatureF
2 Mean Tem