Python: transpose and group dataframe

Question

I have dataframe: table_revenue

how can I transpose the dataframe and have grouping by 'stations_id' to see final result as:

where values of cells is the price, aggregated by exact date (column) for specific 'station_id' (row)

score 1 · Answer 1 · answered Nov 06 '20 at 20:18

1

It seems you need pivot_table():

output = input.pivot_table(index='station_id',columns='endAt',values='price',aggfunc='sum',fill_value=0)

answered Nov 06 '20 at 20:18

Celius Stingher

Thank you!! From the first look it works! will investigate new table to be sure. – OcMaRUS Nov 06 '20 at 20:35
Good to know! Let me know if you face any issue! – Celius Stingher Nov 06 '20 at 21:21

1 Answers1