コース概要
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
要求
- Python programming experience
- Basic experience or familiarity with Excel
Audience
- Developers
- Programmers
お客様の声 (5)
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.
コース - ArcGIS Fundamentals
Lab exercise
Tse Kiat - ST Engineering Training & Simulation Systems Pte. Ltd.
コース - 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
コース - QGIS for Geographic Information System
私はパブロのスタイル、レポートのデザイン、HTML によるカスタマイズからシンプルな ML アルゴリズムの実装まで、多くのテーマをカバーしている点が気に入りました。Go理論情報と演習のバランスも取れています。パブロは私が興味を持っているすべてのトピックを実際にカバーし、私の質問に包括的に答えてくれました。
Cristian Tudose - SC Automobile Dacia SA
コース - Advanced Data Analysis with TIBCO Spotfire
Machine Translated
Actual application of spotfire and all basic functions.