I have a dataframe like this:
date station value_0 value_1 ... value_N
2019-01-01 0 ... ... ... ...
2019-01-01 1 ... ... ... ...
2019-01-01 2 ... ... ... ...
.
.
.
2019-01-01 M ... ... ... ...
2019-01-02 0 ... ... ... ...
2019-01-02 1 ... ... ... ...
2019-01-03 2 ... ... ... ...
.
.
.
2019-12-31 M ... ... ... ...
And I would like to transform it into this:
date value_0_station_0 value_1_station_0 ... value_N_station_0 value_0_station_1 ... value_N_station_M
2019-01-01 ... ... ... ... ... ... ...
2019-01-02 ... ... ... ... ... ... ...
2019-01-03 ... ... ... ... ... ... ...
.
.
.
2019-12-31 ... ... ... ... ... ... ...
I tried both groupby and dummies, but couldn't get the required dataframe. Any ideas?
