how to group several columns into one column

Question

I am trying to analyze chines GDP according to its provinces. I want to make a line chart that shows changing GDP over time but I cannot group them. i want to pivot the table but it is not working as I want.

but I want to make it like this

Please see [ask] and [reprex]. Screenshots of code/data don't quite work here. — BigBen, Mar 24 '22 at 14:09

score 1 · Answer 1 · answered Mar 24 '22 at 14:10

1

It looks like you want to switch x and y axes. Use transpose. You can call it with T.

transposed_df = df_data.T
print(transposed_df)

answered Mar 24 '22 at 14:10

Damiaan

777
4
11

how to group several columns into one column

1 Answers1