Video TimeLine: ---------------------------- - (00:00) Content Start - (00:06) Content Intro - (4:00) Using shift() function to shift rows upward and downward - (10:30) Using shift() function to shift columns towards left and right - Update values in the new created rows and columns with shift() function - (13:40) Using shift() method with timeseries dataset to update datetime based index - (19:00) Creating rolling update using shift method() - (21:50) Combine shift with transpose and groupby to generate rolling value based on rows - (27:06) Content Reacp
I have vertical data in csv file, i need to make it horizontal. I tried using transpose but it is getting concatenated in the first row. As a result headers are repeated. How should I process this in order to have unique headers and corresponding values.
Thank you so much for the tutorial, it helped me a lot.
I am glad you find it useful, appreciate your comment.
Video TimeLine:
----------------------------
- (00:00) Content Start
- (00:06) Content Intro
- (4:00) Using shift() function to shift rows upward and downward
- (10:30) Using shift() function to shift columns towards left and right
- Update values in the new created rows and columns with shift() function
- (13:40) Using shift() method with timeseries dataset to update datetime based index
- (19:00) Creating rolling update using shift method()
- (21:50) Combine shift with transpose and groupby to generate rolling value based on rows
- (27:06) Content Reacp
I have vertical data in csv file, i need to make it horizontal. I tried using transpose but it is getting concatenated in the first row. As a result headers are repeated. How should I process this in order to have unique headers and corresponding values.
First make sure your CSV is read correctly without any problem. Once you have the CSV into dataframe then u can run the transpose correctly.
good video
Glad you enjoyed, appreciate your feedback.