Course Outline
Introduction
Overview of Python Packages for Excel for Government Use
- pandas
- openpyxl
- xlsxwriter
- xlrd
- xlwt
- xlutils
- pyexcel
Installing the Python Packages for Excel for Government Use
Preparing Your Spreadsheet and Data for Government Operations
- Performing Quality Check
- Best Practices for Spreadsheet Data for Government
Preparing Your Workspace for Government Use
Importing Your Excel Files and Loading Your Data Using pandas for Government
Writing Data, Formatting Information, and Modifying Charts in Excel for Government
- Using openpyxl
- Using xlsxwriter
- Using xlwt
- Using pyexcel
Reading and Formatting Data from Older Excel Files for Government Use
- Using openpyxl
- Using xlrd
- Using pyexcel
Implementing Final Check of Your Data for Government Operations
Calling Python Functions from Excel for Government Applications
Create User Defined Functions with Python and Excel for Government Use
Troubleshooting for Government Users
Summary and Conclusion for Government Audiences
Requirements
- Experience in Python programming
- Familiarity or basic experience with Excel
Audience for Government:
- Developers
- Programmers
Testimonials (2)
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.