Pandas question: How can I convert series of data to columns - series data made by groupby().count_values()

Question

I have a dataframe - df

grouped = df.groupby('run')
s = grouped['chip'].value_counts()

then I get this, a series

What I have:

What I want is:

So I am guessing if I can change those series into columns then everything will be good. any ideas? Help needed thank you!

score 1 · Answer 1 · answered Jun 18 '21 at 04:59

1

Try via unstack(),rename(),rename_axis() and reset_index() method:

s=(s.unstack(level=1)
    .rename(columns=lambda x:'chip'+str(x))
    .rename_axis(columns=None)
    .reset_index())

answered Jun 18 '21 at 04:59

Anurag Dabas

Are you a genius?? – steve workspace Jun 18 '21 at 05:00
@steveworkspace nope btw if it solves your query then you can try considering accepting this answer(click on the tick to make it green) to indicate others that the issue is solved...Thnx ***:)*** – Anurag Dabas Jun 18 '21 at 05:19
but I think it's not same @KarnKumar – Anurag Dabas Jun 18 '21 at 05:34
1

@AnuragDabas, its not same but it has nearby same approach [this may be helpful](https://stackoverflow.com/questions/54863165/pandas-dataframe-to-convert-the-unique-value-as-column-name) , i appreciate your help though +1 – Karn Kumar Jun 18 '21 at 05:37

1 Answers1