Reshape pandas dataframe for multiple columns

Question

I am trying to convert the following pandas df

Error   Fore    time    loc qty           con   FA
2960    32863   2086    CFA Ahmedabad   29903   1   90
2960    32863   2087    CFA Ahmedabad   29903   1   90
8090    71453   2086    CFA Bangalore   79543   2   90
8090    71453   2087    CFA Bangalore   79543   2   90

to

loc              var      2086    2087
CFA Ahmedabad   qty    29903    29903
CFA Ahmedabad   Fore    32863     32863
CFA Ahmedabad   Error   2960      2960
CFA Ahmedabad   con      1       1
CFA Ahmedabad   FA       90      90

I have tried using melt/stack but nothing seems worked

df = pd.melt(df, id_vars='loc', value_vars=var, value_name='time')

this code is not working to get columns as time, any idea will be much appreciated?

anky · Accepted Answer · 2019-04-30 09:27:40Z

1

From what I understand, you can use melt() + pivot_table():

m=df.melt(['time','loc']).pivot_table(index=['loc','variable'],columns='time')
print(m)

time                     2086   2087
loc           variable              
CFA Ahmedabad Error      2960   2960
              FA           90     90
              Fore      32863  32863
              con           1      1
              qty       29903  29903
CFA Bangalore Error      8090   8090
              FA           90     90
              Fore      71453  71453
              con           2      2
              qty       79543  79543

edited Apr 30, 2019 at 9:27

answered Apr 29, 2019 at 10:19

anky

75.3k11 gold badges46 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reshape pandas dataframe for multiple columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related