コース概要

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
 14 時間

参加者の人数



Price per participant

お客様の声 (1)

関連コース

ArcGIS for Spatial Analysis

14 時間

ArcMap in ArcGIS

14 時間

ArcGIS Pro for Spatial Analysis

14 時間

ArcGIS with Python Scripting

14 時間

QGIS for Geographic Information System

21 時間

Advanced Data Analysis with TIBCO Spotfire

14 時間

Introduction to Spotfire

14 時間

AI-Driven Data Analysis with TIBCO Spotfire X

14 時間

Data Analysis with SQL, Python and Spotfire

14 時間

Sensu: Beginner to Advanced

14 時間

Monitoring Your Resources with Munin

7 時間

Automated Monitoring with Zabbix

14 時間

Fluentd for Log Data Unification

14 時間

Nagios Certified Administrator Preparation

21 時間

Advanced Nagios

21 時間

関連カテゴリー