Python从入门到实践，总结笔记6：CSV格式+JSON格式

最新推荐文章于 2024-07-03 09:00:00 发布

三少Algorithm

最新推荐文章于 2024-07-03 09:00:00 发布

阅读量667

点赞数

分类专栏： Python 文章标签： CSV JSON Python

本文链接：https://blog.csdn.net/weixin_42717395/article/details/88916875

版权

本文介绍了Python中CSV和JSON两种数据格式的使用。对于CSV，讲解了如何读取和绘制CSV文件中的气温数据；而对于JSON，阐述了其作为数据交换格式的特点，并展示了如何解析JSON文件制作世界人口地图。

摘要由CSDN通过智能技术生成

1、CSV格式：要在文本文件中存储数据，最简单的方式是将数据作为一系列以以逗逗号号分分隔隔的的值值（CSV）写入文件。这样的文件称为CSV文件。

创建reader对象；

对列表调用了enumerate() 来获取每个元素的索引及其值；

打印文件头：

import csv
from datetime import datetime
from matplotlib import pyplot as plt

filename = 'death_valley_2014.csv'

with open(filename) as f:
    reader = csv.reader(f)
    header_row = next(reader)
    for index, column_header in enumerate(header_row):
        print(index, column_header)

death_valley_2014.csv：

PST,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
2014-1-1,63,42,24,14,9,5,48,32,15,30.31,30.25,30.19,,,,7,2,,0.00,0,,203
2014-1-2,66,47,28,22,19,16,58,36,19,30.29,30.19,30.11,10,10,10,9,2,,0.00,0,,135
2014-1-3,64,46,28,24,21,15,61,40,22,30.14,30.04,29.96,,,,9,3,,0.00,0,,205
2014-1-4,66,47,28,25,21,16,61,42,20,30.14,30.02,29.93,,,,9,4,,0.00,0,,148
2014-1-5,61,44,26,18,7,-1,56,30,9,30.34,30.27,30.15,,,,10,4,,0.00,0,,195
2014-1-6,57,40,23,7,3,-1,37,24,11,30.45,30.34,30.22,10,10,10,9,4,,0.00,3,,254
2014-1-7,57,44,30,10,7,5,37,26,14,30.24,30.15,30.09,10,10,10,9,4,,0.00,4,,211
2014-1-8,60,40,21,11,8,3,46,29,14,30.21,30.11,30.05,10,10,10,12,5,,0.00,3,,226
2014-1-9,57,42,27,19,14,8,52,36,20,30.14,30.08,30.01,10,10,10,9,4,,0.00,3,,241
2014-1-10,63,44,26,25,20,14,66,42,21,30.22,30.16,30.09,10,10,10,6,3,,0.00,3,,204
2014-1-11,64,47,30,29,25,17,67,38,22,30.23,30.08,29.94,10,10,10,23,6,37,0.00,0,,235
2014-1-12,63,50,35,29,22,17,49,33,18,30.37,30.15,29.92,10,10,10,15,8,18,0.00,0,,169
2014-1-13,64,46,28,16,14,11,51,31,14,30.53,30.44,30.36,10,10,10,10,4,,0.00,0,,159
2014-1-14,70,50,30,15,10,7,47,25,9,30.54,30.45,30.38,10,10,10,13,6,,0.00,0,,148
2014-1-15,70,50,30,12,8,4,34,21,9,30.46,30.37,30.29,10,10,10,12,6,,0.00,0,,177
2014-1-16,72,50,27,10,3,-1,39,20,6,30.35,30.28,30.22,10,10,10,12,5,,0.00,0,,167
2014-1-17,71,50,28,7,3,1,31,18,7,30.31,30.23,30.16,10,10,10,12,5,,0.00,0,,203
2014-1-18,69,48,28,9,4,-1,31,19,8,30.29,30.20,30.14,10,10,10,10,3,,0.00,0,,189
2014-1-19,69,48,27,8,5,1,33,20,9,30.26,30.19,30.12,10,10,10,12,4,,0.00,0,,223
2014-1-20,68,49,30,10,6,3,35,22,10,30.32,30.25,30.18,10,10,10,10,3,,0.00,0,,184
2014-1-21,62,45,28,11,8,4,36,23,13,30.35,30.27,30.18,10,10,10,8,3,,0.00,5,,251
2014-1-22,70,52,34,11,9,4,36,22,10,30.17,30.04,29.93,10,10,10,9,3,,0.00,2,,214
2014-1-23,66,46,27,17,10,3,36,23,12,30.22,30.09,29.95,10,10,10,14,6,22,0.00,3,,127
2014-1-24,66,54,41,19,16,15,36,24,15,30.38,30.31,30.25,10,10,10,12,4,,0.00,5,,141
2014-1-25,68,54,39,17,15,11,36,24,12,30.30,30.23,30.15,10,10,10,9,5,,0.00,0,,177
2014-1-26,63,48,33,19,14,11,42,28,16,30.18,30.09,30.02,10,10,10,9,3,,0.00,1,,221
2014-1-27,71,50,28,19,15,12,49,28,11,30.12,30.07,30.01,10,10,10,8,3,,0.00,3,,165
2014-1-28,71,52,34,20,17,14,44,29,13,30.19,30.13,30.08,10,10,10,9,2,,0.00,4,,281
2014-1-29,72,54,35,34,22,15,50,29,15,30.16,30.00,29.77,10,10,10,24,5,36,0.00,4,,221
2014-1-30,66,60,52,42,36,24,59,43,25,29.78,29.72,29.66,10,10,10,26,20,37,0.00,3,,213
2014-1-31,59,52,42,35,28,18,63,42,28,29.96,29.82,29.72,10,10,10,22,14,30,0.00,1,Rain,262
2014-2-1,55,44,33,30,12,2,65,32,11,30.10,30.05,29.97,10,10,10,20,8,26,0.00,1,,314
2014-2-2,54,40,25,27,19,13,69,46,21,30.10,30.00,29.90,10,10,10,21,5,25,0.00,2,,203
2014-2-3,55,40,26,26,24,20,81,55,29,29.96,29.91,29.84,10,10,10,10,5,,0.00,0,,204
2014-2-4,54,39,24,27,22,18,78,52,31,30.08,30.02,29.94,10,10,10,9,4,,0.00,3,,149
2014-2-5,55,41,27,28,23,15,66,48,29,30.13,30.04,29.99,10,10,10,10,3,,0.00,1,,185
2014-2-6,55,45,35,40,31,23,83,59,37,29.98,29.90,29.83,10,10,10,20,7,26,0.00,5,,238
2014-2-7,64,50,35,35,32,27,89,53,25,30.01,29.96,29.92,10,10,10,30,11,43,0.00,3,,220
2014-2-8,70,56,43,42,37,31,71,48,26,30.14,30.04,29.97,10,10,10,32,12,41,0.00,0,,214
2014-2-9,75,57,39,41,36,33,82,45,22,30.04,29.97,29.87,10,10,10,30,7,39,0.00,0,,229
2014-2-10,73,62,46,40,33,27,61,35,18,30.10,30.00,29.90,10,10,10,25,13,34,0.00,0,,183
2014-2-11,71,54,37,34,30,23,71,45,17,30.17,30.12,30.06,10,10,10,8,4,,0.00,3,,193
2014-2-12,70,54,37,29,26,22,57,37,21,30.23,30.14,30.08,10,10,10,8,5,,0.00,4,,183
2014-2-13,77,56,34,27,23,19,54,32,15,30.15,30.05,29.95,10,10,10,8,4,,0.00,2,,278
2014-2-14,78,58,37,23,20,17,48,25,13,30.12,30.03,29.97,10,10,10,24,4,,0.00,0,,263
2014-2-15,82,60,37,20,17,14,39,21,9,30.05,29.97,29.91,10,10,10,23,7,28,0.00,0,,247
2014-2-16,,,,,,,,,,,,,,,,,,,0.00,,,-1
2014-2-18,75,56,37,25,21,16,51,25,13,30.08,30.01,29.93,10,10,10,9,3,,0.00,6,,157
2014-2-19,80,61,42,27,21,12,38,25,8,29.98,29.85,29.77,10,10,10,24,7,33,0.00,1,,157
2014-2-20,68,52,37,26,18,12,49,27,13,30.19,30.10,30.00,10,10,10,12,5,,0.00,4,,148
2014-2-21,71,53,35,23,16,14,42,25,12,30.10,30.00,29.91,10,10,10,8,5,,0.00,0,,183
2014-2-22,72,54,35,22,18,15,47,27,13,29.99,29.92,29.87,10,10,10,7,4,,0.00,0,,179
2014-2-23,73,55,37,25,23,20,53,31,15,30.02,29.96,29.91,10,10,10,9,4,,0.00,0,,191
2014-2-24,75,56,37,24,21,15,51,28,12,30.04,29.97,29.91,10,10,10,10,2,,0.00,0,,218
2014-2-25,75,56,37,37,23,14,42,28,14,30.01,29.94,29.88,10,10,10,16,6,,0.00,1,,188
2014-2-26,68,55,42,46,37,27,75,50,36,29.98,29.92,29.88,10,10,10,21,8,29,0.00,4,,196
2014-2-27,70,62,53,47,32,13,75,41,16,29.91,29.81,29.72,10,10,10,28,18,39,0.01,4,Rain,209
2014-2-28,59,52,45,51,46,39,100,91,55,29.79,29.67,29.52,10,7,2,29,7,36,0.77,7,Rain,221
2014-3-1,57,50,43,46,42,40,97,77,57,29.93,29.81,29.68,10,10,10,20,10,24,0.01,4,Rain,185
2014-3-2,59,48,37,45,42,37,100,76,53,30.12,30.05,29.95,10,10,10,18,6,23,0.00,1,,181
2014-3-3,63,51,39,46,43,39,100,73,46,30.17,30.08,30.00,10,10,10,8,4,,0.00,4,,186
2014-3-4,70,59,48,46,44,40,93,63,33,30.06,29.99,29.93,10,10,10,10,5,,0.00,3,,183
2014-3-5,75,58,41,44,39,33,93,53,22,30.22,30.04,29.97,10,10,10,13,6,,0.00,4,,180
2014-3-6,79,64,50,42,38,29,68,40,22,29.99,29.89,29.79,10,10,10,26,8,36,0.00,4,,241
2014-3-7,73,62,52,33,20,11,38,22,10,30.09,30.01,29.90,10,10,10,20,10,30,0.00,3,,329
2014-3-8,73,58,44,28,24,18,51,28,13,30.25,30.19,30.12,10,10,10,13,6,,0.00,0,,180
2014-3-9,73,60,48,31,25,15,50,28,11,30.30,30.20,30.09,10,10,10,9,5,,0.00,1,,212
2014-3-10,80,62,46,35,27,16,46,28,10,30.09,29.97,29.88,10,10,10,22,10,31,0.00,4,,233
2014-3-11,69,58,48,34,22,11,54,28,16,30.13,30.07,29.98,10,10,10,14,5,21,0.00,4,,29
2014-3-12,66,58,50,19,16,12,27,21,13,30.20,30.10,30.03,10,10,10,21,11,30,0.00,1,,346
2014-3-13,71,56,42,22,16,8,41,22,9,30.03,29.98,29.91,10,10,10,13,5,,0.00,3,,339
2014-3-14,79,58,37,23,16,0,50,24,5,30.12,30.04,29.99,10,10,10,10,5,,0.00,0,,227
2014-3-15,78,62,48,28,25,20,37,25,14,30.32,30.24,30.13,10,10,10,10,5,,0.00,0,,182
2014-3-16,82,62,42,30,23,16,55,26,8,30.35,30.22,30.03,10,10,10,15,6,,0.00,0,,189
2014-3-17,80,68,57,25,20,14,25,15,9,30.01,29.77,29.60,10,10,10,32,14,43,0.00,4,,230
2014-3-18,68,57,43,21,12,5,32,18,9,30.04,2