Reshaping DataFrames, turning values to colums and other values to data

Asked May 15 '20 at 04:59

Active May 15 '20 at 05:03

Viewed 15 times

Which is a duplicate here: How to pivot a dataframe

But there are few things I just can't seem to get.

I've inserted a 'count' column on my rwy16_df DataFrame using:

rwy16_df.insert(0, 'count', rwy16_df.groupby('cloud_range').cumcount())

To get:

And now I want to reshape the DataFrame to something like:

Having tried:

pivoted_count = pd.pivot_table(rwy16_df, values='maestro_rate', columns='cloud_range', aggfunc='count')

Which give me:

edited May 15 '20 at 05:03

asked May 15 '20 at 04:59

Tim

@jezrael added what pivot_count gives. – Tim May 15 '20 at 05:03
1

So `pivoted_count = pd.pivot_table(rwy16_df, values='maestro_rate', columns='cloud_range', index='count')` ? – jezrael May 15 '20 at 05:05

0 Answers0