Excel files and CSV files are some of the most common inputs to python programs, so it's important to understand how to get this data into your python environment.

Also, since Excel and CSVs are so popular, it's handy to know how to export data from python in a way that makes the data easy to access.

The pandas library in python makes it super simple to begin importing and exporting this data - let's get started!

All the code from the video can be found below.

https://github.com/AdamGetbags/dataProcessing/blob/main/readWriteFlatFiles.py0:30 open the docs

1:03 import modules and check working directory

1:26 read CSV file into python

1:41 read Excel file into python

2:02 export python data to CSV

2:27 export python data to Excel

- - -  

Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!   

https://www.youtube.com/c/adamgetbags

If you love the content, buy me a coffee! 

https://www.buymeacoffee.com/adamgetbags   

Keep up with me! 

https://www.instagram.com/damgetbags 

https://twitter.com/damgetbag

- - -   

Need some ideas for your project portfolio?  

Check out how to get historical option price data in Python from the Polygon API. 

https://youtu.be/87O9qxfMJ-g

Here's how to quickly get crypto data in Python from the CoinGecko API

https://youtu.be/4-CC3u4i73k

Here's how to create a SQL database from a Pandas DataFrame in Python

https://youtu.be/9IPlc-nKD1k

- - -   

DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.