将pandas DataFrame中的CSV重塑为不同的行

Name,Year,Month,Value
John,2020,1,100
John,2020,2,200
John,2020,3,300
Alice,2020,1,150
Alice,2020,2,250
Alice,2020,3,350

import pandas as pd

df = pd.read_csv('data.csv')
df_pivot = df.pivot(index='Name', columns=['Year', 'Month'], values='Value')

        2020
        1     2     3
Name
Alice   150   250   350
John    100   200   300

Name,2020-01,2020-02,2020-03
John,100,200,300
Alice,150,250,350

import pandas as pd

df = pd.read_csv('data.csv')
df_melt = df.melt(id_vars='Name', var_name='Date', value_name='Value')

    Name    Date  Value
0   John 2020-01    100
1  Alice 2020-01    150
2   John 2020-02    200
3  Alice 2020-02    250
4   John 2020-03    300
5  Alice 2020-03    350