pandas - Pandas for循环将每日数据提取到csv

Question

我有以下代码，我需要对其进行修改，以便我可以自动读取每天的数据并将其添加到两列 csv 文件中。我不知道如何达到这一点。

year = 2019
month = 1
day = 1


def energydata(UDID,year,month,day):
    'calls the energy demand for a particular day by hour'
    data = str('{ "intent":"action.entities.ENERGY_DATA", \
        "payload": { "device_ids":["') + \
                                      str(UDID) + \
                                      str('"],"duration":"day",\
                                          "startDay": "')+\
                                          str(day)+ \
                                        str('","month":') + \
                                          str(month) + \
                                          str(',"year":')+ \
                                          str(year)+ \
                                          str("}}")
    print(data)
    response = requests.post('https://api.kiot.io/integrations/ctp/go',
                             headers=headers,
                             data=data)
    print(response.json())
    energydemand = \
        pd.DataFrame.from_dict(response.json()).sort_values(by=['_id'])
    return energydemand




test = energydata(UDID[0],year,month,day)

test.to_csv("HeatPumps.csv")
test.plot()

标签： pandasloopsexport-to-csvdata-extraction