How to convert pandas series to dataframe with column name from series values?

Asked May 11 '22 at 11:34

Active May 11 '22 at 11:37

Viewed 12 times

This is the series I have:

stars  state
1.0    AZ       1348
       NC        371
       NV        754
       OH        345
1.5    AZ       1342
       NC        393
       NV        829
       OH        375

I wish to convert this to.

state  AZ    NV   NC  OH
starts
1      1348  371 754 345
1.5    1342  393 829 375

edited May 11 '22 at 11:37

asked May 11 '22 at 11:34

GunJack

1,928
2
22
35

Is the data in the `stars` column a list? – Zero May 11 '22 at 11:36
It came from another dataframe ```data.groupby(['stars', 'state'])['stars'].count()``` – GunJack May 11 '22 at 11:36
https://stackoverflow.com/questions/28337117/how-to-pivot-a-dataframe-in-pandas – Gedas Miksenas May 11 '22 at 11:37
How do I specify the value column for ```pivot_table(df, values = 'Value', index=['Country','Year'], columns = 'Indicator').reset_index()``` – GunJack May 11 '22 at 11:39
@GunJack Can you just show the original dataframe itself then? It'll be easier to work on. – Zero May 11 '22 at 11:52

How to convert pandas series to dataframe with column name from series values?

0 Answers0