我正在学习Pandas 和Python .
我有这个数据框:
dfsupport = pd.DataFrame({'Date': ['8/12/2020','8/12/2020','13/1/2020','24/5/2020','31/10/2020','11/7/2020','11/7/2020','4/4/2020','1/2/2020'],
'Category': ['Table','Chair','Cushion','Table','Chair','Mats','Mats','Large','Large'],
'Sales': ['1 table','3chairs','8 cushions','3Tables','12 Chairs','12Mats','4Mats','13 Chairs and 2 Tables', '3 mats, 2 cushions 4@chairs'],
'Paid': ['Yes','Yes','Yes','Yes','No','Yes','Yes','No','Yes'],
'Amount': ['93.78','$51.99','44.99','38.24','£29.99','29 21 only','18','312.8','63.77' ]
})
这将产生:
Date Category Sales Paid Amount
0 8/12/2020 Table 1 table Yes 93.78
1 8/12/2020 Chair 3chairs Yes 51.99
2 13/1/2020 Cushion 8 cushions Yes 44.99
3 24/5/2020 Table 3Tables Yes 38.24
4 31/10/2020 Chair 12 Chairs No 29.99
5 11/7/2020 Mats 12Mats Yes 29.21
6 11/7/2020 Mats 4Mats Yes 18
7 4/4/2020 Large 13 Chairs and 2 Tables No 312.8
8 1/2/2020 Large 3 mats, 2 cushions 4@chairs Yes 63.77
我想找到卖得最多的日期,所以我跑了:
print("######\n",dfsupport['Date'].value_counts().max())
这提供了:
2
我现在想要做的是打开这2
个包,找出哪些日期是在这些情况下发生的,以及在每个情况下发生了哪些"销售".
我被卡住了,不知道如何打印出那些专栏.希望能得到一些指导.