In this hands-on course, "Advanced Hands-On Python: Working with Excel and Spreadsheet Data," tech industry expert Joe Marini joins me today to provide you with tangible approaches to how to use Python to work with Excel and Spreadsheet Data. The course describes dealing with CSV data in Python, importing/exporting data in CSV format, and creating, reading, and writing Excel documents in Python. Joe also explains how to use Excel sheet data and formulas to simplify your work and save time on your spreadsheet work.
Advanced Hands-On Python: Working with Excel and Spreadsheet Data Table of Contents:
- Introduction
- Working with CSV Files
- Manipulating Excel Files with openpyxl
- Creating Excel Files with XlsxWriter
- Spreadsheets with pandas
- Conclusion
Who is this course for?
- Data analysts
- Covers MS Excel’s basic to advanced functions, recommended for people who want to automate work in Excel.
- Python programmers
- Any student or employee involved in increasing the effectiveness of spreadsheet work
