Create a new Dataframe with restructured data using lambda function

Asked May 05 '20 at 06:47

Active May 05 '20 at 06:47

Viewed 11 times

I have a DataFrame:

and I wish to convert it to:

I think I have to use groupby and a lambda function. I just can't think of the lambda function

new_df = rwy16_df.groupby('height').to_frame().loc[lambda ]

asked May 05 '20 at 06:47

Tim

1

Check Q10 in dupe – jezrael May 05 '20 at 06:48
Thanks @jezrael I'm a little confused as to what is my df in the solution to Q10 in dupe as I only have one df? – Tim May 05 '20 at 07:15
One df that I wish to cumcount and pivot that is. – Tim May 05 '20 at 07:15
1

There are 2 columns, `rate` and `height` – jezrael May 05 '20 at 07:16

0 Answers0