python - 我想将数据帧转换为特定格式的数据帧或列表列表

Question

这是数据框

Year    Category    Performance
2014    Sales           1000
2014    Expenses        400
2014    Profit          200
2015    Sales           1170
2015    Expenses        460
2015    Profit          250
2016    Sales           660
2016    Expenses        1120
2016    Profit          300

这是预期的输出

 [          
          ['Year', 'Sales', 'Expenses', 'Profit'],          
          ['2014', 1000, 400, 200],         
          ['2015', 1170, 460, 250],         
          ['2016', 660, 1120, 300],                     
        ]           

或者您是否可以帮我将此数据框转换为此

Year Sales Expenses Profit      
2014 1000  400       200        
2015 1170  460       250        
2016 660   1120      300

Answer 1

df = pd.pivot_table(df, index='Year', columns='Category', values='Performence').reset_index()