Working on a data science project makes you play with diverse data sources in the most crazy way you can imagine.
While aligning the data programmatically via data frames in the most sane way to do, but sometime you just want to check the data in a quick dirty way via the all familiar Excel.
Aligning the data in one format (vertically or horizontally) can be a challenge though, since there is no universal rule for defining what should be on X axis and what should be on Y. There is one trick though you can use to quickly transpose the numbers either way (vertical to horizontal or vice versa)
1. Copy the data, say which is present in the horizontal format.
2. Go the sheet now where you want to paste this in the vertical format, right click on cell where you want data to start from, right click, and from Paste options choose Transpose option.
3. You will have the data in the format you want.
While aligning the data programmatically via data frames in the most sane way to do, but sometime you just want to check the data in a quick dirty way via the all familiar Excel.
Aligning the data in one format (vertically or horizontally) can be a challenge though, since there is no universal rule for defining what should be on X axis and what should be on Y. There is one trick though you can use to quickly transpose the numbers either way (vertical to horizontal or vice versa)
1. Copy the data, say which is present in the horizontal format.
2. Go the sheet now where you want to paste this in the vertical format, right click on cell where you want data to start from, right click, and from Paste options choose Transpose option.
3. You will have the data in the format you want.
