I have the following data in a Pandas data frame:
Cavity | Dimension |
---|---|
1 | 1.45 |
1 | 1.47 |
1 | 1.46 |
1 | 1.45 |
1 | 1.43 |
2 | 1.40 |
2 | 1.39 |
2 | 1.41 |
2 | 1.40 |
2 | 1.42 |
3 | 1.51 |
3 | 1.5 |
3 | 1.49 |
3 | 1.5 |
3 | 1.52 |
how can I reshape the data to the following format in pandas?
Cavity 1 | Cavity 2 | Cavity 3 |
---|---|---|
1.45 | 1.40 | 1.51 |
1.47 | 1.39 | 1.50 |
1.46 | 1.41 | 1.49 |
1.45 | 1.40 | 1.50 |
1.43 | 1.42 | 1.52 |
is there any way to do this reshape (melt backwards)?
thanks for your help!!