How to Quickly CONVERT a TEXT Time Series File Into an EXCEL File Using Python

#python #pandas #dataframe #dataframes #excel #exceltutorial #pythontutorial #pythontutorialforbeginners #exceltutorialforbeginners #texttocolumn #texttoexcel
#timeseries #timeseriesanalysis #pythontutorialforbeginners #pythonprogramming #pythonforeveryone

This video (episode 14 of the PyBasics series) demonstrates how to convert a text file into an MS Excel file using Python. The input text file is an output of hydraulic modeling, which contains water level and discharge data that are separated by tabs.

In this video, you learn the following, as co-benefits of converting tab separated text file into an Excel file, which could be applicable for other similar projects you may be working on:
1. Read a tab separated text file into a Pandas DataFrame (DF).
2. Take the values of an entire DF row and return them as list.
3. Remove the space between a column name using the strip() function.
4. Set Date column from object to datetime formate
5. Set Date (on datetime format) as the DF's index.
6. Rename all the DF's columns at once.
7. Export a DF into an Excel file that includes the Date index as part of the columns

Thank you for watching. Your time is highly appreciated. If you think this video is helpful, please don't forget to like and share, and most importantly, SUBSCRIBE to my channel.

Best of luck to you, and take care.