is there any quick way using python to transform data from:
| ID | Item | Value |
|---|---|---|
| 0001 | A | 100 |
| 0001 | D | 200 |
| 0002 | A | 400 |
| 0002 | B | 100 |
| 0002 | A | 200 |
| 0003 | A | 500 |
| 0003 | C | 800 |
to:
| ID | A | B | C | D |
|---|---|---|---|---|
| 0001 | 100 | 0 | 0 | 200 |
| 0002 | 600 | 100 | 0 | 0 |
| 0003 | 500 | 0 | 800 | 0 |
Thanks!
is there any quick way using python to transform data from:
| ID | Item | Value |
|---|---|---|
| 0001 | A | 100 |
| 0001 | D | 200 |
| 0002 | A | 400 |
| 0002 | B | 100 |
| 0002 | A | 200 |
| 0003 | A | 500 |
| 0003 | C | 800 |
to:
| ID | A | B | C | D |
|---|---|---|---|---|
| 0001 | 100 | 0 | 0 | 200 |
| 0002 | 600 | 100 | 0 | 0 |
| 0003 | 500 | 0 | 800 | 0 |
Thanks!