Converting column values to column names in pandas with other column values as new column values

Question

I know the title sounds confusing. But let me explain with an example. I have date vise data of covid cases in states of India.

The data is of the below form

I want it to be like

Each date can have new state names based of if those states got new cases. So for each date the data can have varied number of states name as per first image.

you need to use pandas `pivot_table` https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.pivot_table.html — Yati Raj, Jun 29 '20 at 17:48

score 2 · Accepted Answer · answered Jun 29 '20 at 17:49

2

You could use pandas.DataFrame.pivot:

df.pivot(index='Date', columns='Name', values='Numbers')

answered Jun 29 '20 at 17:49

Jonas

1,749
1
10
18

How can I sort these values based on the values after pivoting – EXODIA Jun 29 '20 at 18:01
like this: df.sort_values(by=1, ascending=False, axis=1) – Jonas Jun 29 '20 at 18:14
1694 # Check for duplicates KeyError: 1 – EXODIA Jun 29 '20 at 18:15
Did you try to rename the rowname? df.sort_values(by='date', ascending=False, axis=1) – Jonas Jun 29 '20 at 18:17
No I used as it is.... – EXODIA Jun 29 '20 at 18:20

Converting column values to column names in pandas with other column values as new column values

1 Answers1