如何将城市时间和value都取出来,。每个城市都有30条类似内容,只有value和时间不同,把他们都存在字典吧,好像会因为key重复替换,有没有什么好的方法可以获取完整数据
#{"CityName":"广州市"
"AreaCode":"440100"
"AreaName":"广州市"
"Rank":"—"
"Value":"6"
"PrimaryPollutant":"—"
"TimePoint":"2022-01-26 00:00:00"
"Grade":"优"
"Goal":"—"}
{"CityName":"韶关市"
"AreaCode":"440200"
"AreaName":"韶关市"
"Rank":"—"
"Value":"8"
"PrimaryPollutant":"—"
"TimePoint":"2022-01-26 00:00:00"
"Grade":"优"
"Goal":"—"}
{"CityName":"深圳市"
"AreaCode":"440300"
"AreaName":"深圳市"
"Rank":"—"
"Value":"5"
"PrimaryPollutant":"—"
"TimePoint":"2022-01-26 00:00:00"
"Grade":"优"
"Goal":"—"}
{"CityName":"韶关市"
"AreaCode":"440200"
"AreaName":"韶关市"
"Rank":"—"
"Value":"8"
"PrimaryPollutant":"—"
"TimePoint":"2022-02-24 00:00:00"
"Grade":"优"
"Goal":"—"}
还有地区编码不同,你是想怎么个取法呢?将每个城市的三个变量存进列表里吗?["广州", "400100","6"],["韶关"....]....这种?
你这个存数据框得了,key 作为字段名