I would like to transform my data from this way :
order | station | up | down |
1 | A | 48 | 0 |
2 | B | 11 | 1 |
3 | C | 52 | 23 |
4 | D | 31 | 3 |
5 | E | 28 | 8 |
1 | X | 186 | 0 |
2 | Y | 12 | 62 |
3 | Z | 45 | 11 |
Origin | Destination | up | down |
A | B | 48 | 1 |
B | C | 11 | 23 |
C | D | 52 | 3 |
D | E | 31 | 8 |
X | Y | 186 | 62 |
Y | Z | 45 | 11 |
Thank You in advance!
0 Response to Shaping data
Post a Comment