I have this Dataframe:
| ID | ACTION | TIME |
|---|---|---|
| 1 | new order | 2018-04-19 07:20:19 |
| 1 | order shipped | 2018-04-19 08:20:19 |
| 2 | new order | 2018-05-19 07:20:19 |
| 2 | order shipped | 2018-06-19 07:20:19 |
| 2 | order delivered | 2018-07-19 07:20:19 |
| 2 | return started | 2018-08-19 07:20:19 |
How can I turn it into this:
| ID | Time new order | Time order shipped | tme order deliverd | time return started |
|---|---|---|---|---|
| 1 | 2018-04-19 07:20:19 | 2018-04-19 08:20:19 | -1 | -1 |
| 2 | 2018-05-19 07:20:19 | 2018-06-19 07:20:19 | 2018-07-19 07:20:19 | 2018-08-19 07:20:19 |
Thank you!
