pandas - 使用列标题年份的时间序列

Question

数据透视表数据

Boom_period = pd.pivot_table(df, values=['2000-01','2000-02','2000-03','2000-04','2000-05','2000-06',
                                             '2000-07','2000-08','2000-09','2000-10','2000-11','2000-12','2001-01',
                                             '2001-02','2001-03','2001-04','2001-05','2001-06','2001-07','2001-08',
                                             '2001-09','2001-10','2001-11','2001-12','2002-01','2002-02','2002-03',
                                             '2002-04','2002-05','2002-06','2002-07','2002-08','2002-09','2002-10',
                                             '2002-11','2002-12','2003-01','2003-02','2003-03','2003-04','2003-05',
                                             '2003-06','2003-07','2003-08','2003-09','2003-10','2003-11','2003-12',
                                             '2004-01','2004-02','2004-03','2004-04','2004-05','2004-06','2004-07',
                                             '2004-08','2004-09','2004-10','2004-11','2004-12','2005-01','2005-02',
                                             '2005-03','2005-04','2005-05','2005-06','2005-07','2005-08','2005-09',
                                             '2005-10','2005-11','2005-12'],
                   index=['State','BedroomCount'])
           

繁荣时期

尝试使用此数据透视表按州绘制所有房屋的时间序列（2000-2005），不确定如何选择（BedroomCount == State_AllHomes）。

原始df

从中派生的数据框的列标题为年份，房屋值作为值，我将如何将这些标题转换为列？或使用年份标题作为索引进行整形。

df.transpose().reset_index().rename(columns={'index':('2000-01','2000-02','2000-03','2000-04','2000-05','2000-06',
                                             '2000-07','2000-08','2000-09','2000-10','2000-11','2000-12','2001-01',
                                             '2001-02','2001-03','2001-04','2001-05','2001-06','2001-07','2001-08',
                                             '2001-09','2001-10','2001-11','2001-12','2002-01','2002-02','2002-03',
                                             '2002-04','2002-05','2002-06','2002-07','2002-08','2002-09','2002-10',
                                             '2002-11','2002-12','2003-01','2003-02','2003-03','2003-04','2003-05',
                                             '2003-06','2003-07','2003-08','2003-09','2003-10','2003-11','2003-12',
                                             '2004-01','2004-02','2004-03','2004-04','2004-05','2004-06','2004-07',
                                             '2004-08','2004-09','2004-10','2004-11','2004-12','2005-01','2005-02',
                                             '2005-03','2005-04','2005-05','2005-06','2005-07','2005-08','2005-09',
                                             '2005-10','2005-11','2005-12')})

标签： pandasindexingtimeseriestranspose