每月分组，并绘制一个大Pandas堆积的酒吧

Question

我想得到一个数据帧，其中的数据代表不同的类和每个类的每月频率。例如，在下面的dataframe中，想要使用列Forma来获取一个dataframe，它表示Forma y get列中每个类的每月频率，例如dataframe df1

df    
                       Evento  Forma  Excentricidad
Fecha                                      
2004-04-09 22:45:00       1  MBCCM            0.7
2004-04-12 22:45:00       2  MBSCL            0.6
2004-04-24 03:45:00       3    SCL            0.4
2004-05-02 06:45:00       4    SCL            0.5
2004-05-30 04:45:00       5  MBCCM            0.9
2004-05-31 03:15:00       6  MBCCM            0.8
2004-06-08 00:15:00       7  MBSCL            0.6
2004-06-12 22:15:00       8    CCM            1.0
2004-06-13 02:45:00       9  MBCCM            0.8
2004-06-13 23:45:00      10  MBSCL            0.6
2004-06-14 03:15:00      11  MBSCL            0.6
2004-06-17 08:15:00      12  MBCCM            0.7
2004-06-17 11:45:00      13  MBCCM            0.7
2004-06-22 00:15:00      14    SCL            0.5
2004-06-22 07:45:00      15  MBCCM            0.9
2004-06-22 22:45:00      16    CCM            0.8 
2004-07-01 05:15:00      17  MBCCM            0.8
2004-07-02 00:15:00      18  MBSCL            0.6
2004-07-04 11:45:00      19  MBCCM            0.9
2004-07-06 03:45:00      20    SCL            0.6
2004-07-07 04:15:00      21    CCM            0.9
2004-07-08 02:45:00      22  MBCCM            1.0
2004-07-08 11:45:00      23  MBCCM            0.8
2004-07-08 02:15:00      24  MBCCM            0.9
2004-07-09 04:45:00      25    CCM            0.7
2004-07-11 18:15:00      26  MBSCL            0.4
2004-07-11 23:15:00      27  MBSCL            0.3
2004-07-15 10:45:00      28    CCM            0.8
2004-07-16 12:15:00      29  MBCCM            0.8
2004-07-17 02:15:00      30  MBCCM            0.8
2004-07-17 05:45:00      31  MBCCM            0.7
2004-07-19 23:15:00      32    CCM            0.9
2004-07-20 09:15:00      33    CCM            0.7
2004-07-20 21:45:00      34    SCL            0.6
2004-07-23 03:45:00      35    SCL            0.6
2004-07-23 12:45:00      36  MBCCM            0.9
2004-07-24 00:45:00      37    CCM            0.7
2004-07-26 00:15:00      38  MBCCM            0.8
2004-07-27 05:15:00      39  MBSCL            0.6
2004-07-27 07:15:00      40  MBSCL            0.6
2004-07-27 14:15:00      41  MBCCM            0.7
2004-07-27 19:45:00      42    SCL            0.6
2004-07-27 23:15:00      43  MBSCL            0.6
2004-07-28 07:15:00      44  MBCCM            0.8
2004-07-30 05:15:00      45  MBCCM            0.7
2004-07-31 00:15:00      46    SCL            0.5
2004-07-31 04:15:00      47  MBSCL            0.6

df1型

^{pr2}$

我怎么做，从df？在

Answer 1

import pandas as pd
df = pd.read_table('data', sep='\s{2,}')
df.index = pd.to_datetime(df.index)
df['Month'] = [date.strftime('%B') for date in df.index]
print(pd.crosstab(rows=[df['Forma']], cols=[df['Month']], margins=False))

收益率

^{pr2}$