export data to csv in class from class python

Question

I have a python code that is used to pull data from azure methods.

for item in response:

    print(type(item))
    print(item)
    df = pd.DataFrame([item])
    print(df)

below is the print statements output.

 1. print(type(item)) :
     <class 'azure.mgmt.costmanagement.models._models_py3.SavingsPlanUtilizationSummary'>



2.print(item) : 
{'usage_date': datetime.datetime(2022, 12, 26, 0, 0, tzinfo=<isodate.tzinfo.Utc object at 0x00000277D15A2D60>), 'avg_utilization_percentage': 95.83333333039417, 'min_utilization_percentage': 0.0}

3.print(df):
                                                   0
0  {'usage_date': datetime.datetime(2022, 12, 26, 0, 0, tzinfo=<isodate.tzinfo.Utc object at 0x00000277D15A2D60>), 'avg_utilization_percentage': 95.83333333039417, 'min_utilization_percentage': 0.0}

Above Output I am getting but I am trying to export data into csv with different columns. How can I do that with correct date format as well. can you please help me?

Might be relevant: https://stackoverflow.com/questions/50128934/pandas-dict-keys-to-columns — Mark Moretto, Dec 27 '22 at 14:41

IvanaGyro · Answer 1 · 2022-12-27T15:29:21.677

0

Try this if you want to store all rows in the response to one CSV file.

usage_statistics = pd.DataFrame([row for row in response])
usage_statistics.to_csv('output.csv', index=False)

You can also use date_format parameter to format datetime objects as you want.

usage_statistics.to_csv('output.csv', date_format='%Y%m%d', index=False)

Here is the content of the CSV file.

usage_date,avg_utilization_percentage,min_utilization_percentage
2022-12-26,95.83333333039417,0.0

Refer to the official document: strftime() and strptime() Behavior for the codes of the format string.

edited Dec 27 '22 at 15:29

answered Dec 27 '22 at 15:10

IvanaGyro

598
7
25

it append everything thing to one column . how can i create separate column for usag_date,avg_utillization_percent…. etc) – learningtocode Dec 27 '22 at 15:23
They are in different columns indeed. Did you mean you want to store them in a transposed form? – IvanaGyro Dec 27 '22 at 15:26
I tried running but I am getting output like 0 {'usage_date': datetime.datetime(2022, 12, 26, 0, 0, tzinfo=), 'avg_utilization_percentage': 95.83333333039417, 'min_utilization_percentage': 0.0} – learningtocode Dec 27 '22 at 15:35
`0` in your output is the index of the row, not the column. Do you want to output the date into CSV or want to show the data in the terminal (by `print()`)? – IvanaGyro Dec 27 '22 at 15:39
I want data in csv . – learningtocode Dec 27 '22 at 15:40
i don’t know why it is not working for me. – learningtocode Dec 27 '22 at 15:59
Can you provide more information? What is the content of the output csv? What's your error message? What is the version of pandas? – IvanaGyro Dec 27 '22 at 21:35
there is no error it is just exporting data in one columns rather than creating multiple columns in csv – learningtocode Dec 28 '22 at 02:48
Can you copy paste the content of CSV to here? – IvanaGyro Dec 28 '22 at 08:44

score 0 · Answer 2 · answered Dec 27 '22 at 18:18

The problem here is that you are not formatting usage_date when importing data from Azure. When importing data from azure, please convert datetime to dataframe after .strftime("%Y-%m-%d") it will be fine. then you can convert it to csv file with to_csv.

export data to csv in class from class python

2 Answers2