我有一個(gè)如下所示的數(shù)據(jù)框：df = pd.DataFrame({'publisher': ['facebook', 'facebook', 'facebook', 'google', 'google', 'google'], 'month_leadgen': ['2019-01', '2019-02', '2019-03', '2019-01', '2019-02', '2019-03'], 'month_payment': ['2019-01', '2019-02', '2019-03', '2019-01', '2019-02', '2019-03'], 'revenue': [60, 150, 450, 85, 250, 150]})然后我創(chuàng)建了一個(gè)數(shù)據(jù)透視表：df = df.pivot_table(index=['publisher', 'month_leadgen'], columns='month_payment', values='revenue').reset_index()我正在嘗試選擇該列df['2020-01']，但收到一條錯(cuò)誤消息：KeyError: '2020-01'您能幫我理解為什么我不能選擇此列嗎？df 似乎沒有多重索引。我無法選擇任何月份列，但可以毫無問題地選擇“month_ payment”、“campaign_name”和“month_leadgen”。
1 回答
不負(fù)相思意
TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超10個(gè)贊
用于slice(None)選擇該級(jí)別的所有內(nèi)容。slice(None) 使您免于陳述更深層次的內(nèi)容。這意味著他們
df=df.pivot_table(index=['publisher', 'month_leadgen'], columns=['month_payment'], values=['revenue']).reset_index()
print(df)
publisher month_leadgen revenue
month_payment 2019-01 2019-02 2019-03
0 facebook 2019-01 60.0 NaN NaN
1 facebook 2019-02 NaN 150.0 NaN
2 facebook 2019-03 NaN NaN 450.0
3 google 2019-01 85.0 NaN NaN
4 google 2019-02 NaN 250.0 NaN
5 google 2019-03 NaN NaN 150.0
選擇
df.loc[:, (slice(None), '2019-01')]
revenue
month_payment 2019-01
0 60.0
1 NaN
2 NaN
3 85.0
4 NaN
5 NaN
添加回答
舉報(bào)
0/150
提交
取消