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 (5)
Rapide et efficace VM Azure et support au top
Tom Léonard - Civadis
Course - Automated Monitoring with Zabbix
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
I liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.
Cristian Tudose - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Actual application of spotfire and all basic functions.
Michael Capili - STMicroelectronics, Inc.
Course - Introduction to Spotfire
The thing I liked the most about the training was the organization and the location