JSON to Python to JSON



我正在尝试从JSON对象中提取一些数据,将它们存储到另一个JSON文件中,然后在Python中需要时重新调用它们。

目前我无法按自己的意愿格式化它们。

response = requests.get(URL)
# getting data in the json format
data = response.json()
# looking for specific data
for result in data['daily']:
#formatting results
extracted = ("dt: {}, temp: {}".format(result['dt'], result['temp']['max']))
#results Pretty printing to json (can't make it work)
extractedJson = json.dumps(extracted, sort_keys=True, indent=4 * ' ')
print (extractedJson)
#save to file (saves only last extracted data)
with open('data.json', 'w') as f:
f.write(extractedJson)

数据[每日]为:

"daily": [
{
"clouds": 41,
"dew_point": 15.02,
"dt": 1623927600,
"temp": {
"max": 31.05,
"min": 20.39,
"morn": 21.52,
"night": 24.44
},
{
"clouds": 30,
"dew_point": 15.02,
"dt": 1624014000,
"temp": {
"max": 31.3,
"min": 12.58,
"morn": 14.26,
"night": 15.14
},
{
"clouds": 50,
"dew_point": 15.02,
"dt": 1624100400,
"temp": {
"max": 31.37,
"min": 11.08,
"morn": 13.51,
"night": 16.13
},
]

打印(extractedJson(给我:

"dt: 1623927600, temp: 31.06"
"dt: 1624014000, temp: 31.3"
"dt: 1624100400, temp: 31.37"

我想要一些类似的东西

"day1": {
"dt": 1623927600,
"temp": 31.06 
},
"day2": {
"dt": 1624014000,
"temp": 31.3
},
"day3": {
"dt": 1624100400,
"temp": 31.37 
},

你能给我一些代码示例吗?或者建议我寻找什么方法?

非常感谢

output = {}
for index,value in enumerate(data['daily'], start=1):
output[f'day{index}'] = { "dt": value['dt'], "temp": value['temp']['max']}

最新更新