Course Outline
Introduction
Overview of Python Packages for Excel
- pandas
- openpyxl
- xlsxwriter
- xlrd
- xlwt
- xlutils
- pyexcel
Installing the Python Packages for Excel
Preparing Your Spreadsheet and Data
- Performing Quality Check
- Best Practices for Spreadsheet Data
Preparing Your Workspace
Importing Your Excel Files and Loading Your Data Using pandas
Writing Data, Formatting Information, and Modifying Charts in Excel
- Using openpyxl
- Using xlsxwriter
- Using xlwt
- Using pyexcel
Reading and Formatting Data from Older Excel Files
- Using openpyxl
- Using xlrd
- Using pyexcel
Implementing Final Check of Your Data
Calling Python Functions from Excel
Create User Defined Functions with Python and Excel
Troubleshooting
Summary and Conclusion
Requirements
- Python programming experience
- Basic experience or familiarity with Excel
Audience
- Developers
- Programmers
Testimonials (3)
Doing Exercise
Joe Pang - Lands Department, Hong Kong
Course - QGIS for Geographic Information System
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
I'm looking forward to having a training again with Any, he was really good, I'm just a GIS guy, but Any made everything clear to me, he explained complex processes in layman's terms. Keep it up, thank you.