将pandas数据帧打印为格式，以便可以在powerbi中读取

Question

我正在尝试将以下dictionary/pandas数据帧打印到csv文件中，以便可以在power bi中读取。

df_2 = {'Status': {'AvailablePickup': 2,
'Collected': 4,
'Delivered': 55,
'Totaal aantal orders': 53,
'Packages sent out': 53,
'Packages received by customers': 51,
'result received': 220,
'Test Approved': 210,
'Test Failed': 16,
'Not yet executed': 7}}
df2 = pd.DataFrame(df_2)
df2
df2.to_csv('lolol.csv', sep=",")

但是，我希望Status作为第一列的标题，amount作为第二列的标题。这可能吗？如果是，如何？提前谢谢。

Answer 1

在您的基本字典中"状态"；key将所有必需的数据作为dictionay保存在键值对中。因此，您可以导出"；状态"；列通过CCD_ 1；金额"；列通过amount = data['Status'].values()，然后可以轻松地将其转换为数据帧。

这是代码，供快速参考：

import pandas as pd
data = {'Status': {'AvailablePickup': 2,
'Collected': 4,
'Delivered': 55,
'Totaal aantal orders': 53,
'Packages sent out': 53,
'Packages received by customers': 51,
'result received': 220,
'Test Approved': 210,
'Test Failed': 16,
'Not yet executed': 7}}
status = data['Status'].keys()
amount = data['Status'].values()
df = pd.DataFrame(list(zip(status, amount)), columns=['Status', 'Amount'])
print(df)
#                            Status  Amount
# 0                 AvailablePickup       2
# 1                       Collected       4
# 2                       Delivered      55
# 3            Totaal aantal orders      53
# 4               Packages sent out      53
# 5  Packages received by customers      51
# 6                 result received     220
# 7                   Test Approved     210
# 8                     Test Failed      16
# 9                Not yet executed       7
df.to_csv('final.csv')