This is the repository for the LinkedIn Learning course Python: Working with Spreadsheet and Excel Data. The full course is available from LinkedIn Learning.
In this hands-on course, technology industry veteran Joe Marini guides you through a variety of practical ways that you can leverage Python to work more effectively with data from spreadsheets and Excel. Find out how to read and write CSV data, as well as how to convert data to and from CSV. Learn how Python can help you in creating, reading, and writing Excel workbooks. Plus, explore ways you can use Python when you’re working with Excel sheet data and formulas.
Spreadsheets are one of the most common tools you'll find in businesses today. They are used for everything from monitoring project status, to reporting financial information, to tracking inventory levels. Using the power of Python, you can create spreadsheets, extract data, and automate just about any workflow you can think of. By the time you finish this course, you'll be able to build all kinds of sophisticated automations for your data workflows.
- To use these exercise files, you must have the following installed:
- Microsoft Excel (to view the results)
- Python (at least 3.8)
- Clone this repository into your local machine using the terminal (Mac), CMD (Windows), or a GUI tool like SourceTree.
- Install the pandas, openpyxl, and xlsxwriter libraries using pip
pip install pandas, openpyxl, xlsxwriter
Joe Marini
Technology Industry Veteran
Check out my other courses on LinkedIn Learning.