Pandas Dataframe

Asked Jan 12 '20 at 13:38

Active Jan 12 '20 at 13:38

Viewed 22 times

I am using pandas dataframe (python), it is currently in this format:

df =

I am trying to convert the above dataframe into a new dataframe in below format:

new_df =

I am trying to avoid doing this using a lot of code as performance will be impacted, is there some dataframe function that can be used to achieve this?

asked Jan 12 '20 at 13:38

user5711693

1

If first column is index solution is `df1 = df.unstack().reset_index(name='count')` – jezrael Jan 12 '20 at 13:40
I tried this but I get: TypeError: only integer scalar arrays can be converted to a scalar index.. Count in above example is integer but I am using float in dataframe.. – user5711693 Jan 12 '20 at 18:09
So solutions from dupe not working? – jezrael Jan 13 '20 at 06:05
1

pd.melt did work - the issue was with data type used within dataframe so you can leave this question as marked as duplicate. – user5711693 Jan 14 '20 at 05:45

Pandas Dataframe

0 Answers0