I have a dataframe in python that looks like:
| id | Date | wages |
|---|---|---|
| A | 2018-01-01 | 100 |
| A | 2018-02-01 | 200 |
| A | 2018-03-01 | 100 |
| B | 2018-01-01 | 200 |
| B | 2018-02-01 | 100 |
| B | 2018-03-01 | 200 |
How can I transform this in a new dataframe that looks like the one below:
| id | 2018-01-01 | 2018-02-01 | 2018-03-01 |
|---|---|---|---|
| A | 100 | 200 | 100 |
| B | 200 | 100 | 200 |
