Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Advanced Hands-On Python: Working with Excel and Spreadsheet Data

via LinkedIn Learning

Go to class Write review
Coursera Ad

Save 40% on 3 months of Coursera Plus

Learn More → Datacamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This course demonstrates ways to use Python to work with Excel and spreadsheet data, such as reading, writing, and converting content and working with Excel workbooks, sheet data, and formulas.

Syllabus

Introduction
  • Python and spreadsheets: Made for each other
  • Getting set up
1. Working with CSV Files
  • The CSV format
  • Reading CSV files into an array
  • Reading CSV files into a dictionary
  • Reading CSV files with a filter
  • Writing a CSV file
  • Writing a dictionary as CSV
  • Challenge: Modify CSV content
  • Solution: Modify CSV content
2. Manipulating Excel Files with openpyxl
  • Overview of openpyxl
  • Loading and exploring a workbook
  • Creating a workbook
  • Working with content
  • Styling cells
  • Applying conditional formatting
  • Adding filters
  • Challenge: Split a workbook
  • Solution: Split a workbook
3. Creating Excel Files with XlsxWriter
  • Introduction to XlsxWriter
  • Creating a workbook
  • Formatting worksheet content
  • Creating an Excel table
  • Applying conditional formatting
  • Writing workbook properties
  • Challenge: Split a workbook
  • Solution: Split a workbook
4. Spreadsheets with pandas
  • Introduction to pandas
  • Reading CSV and Excel data
  • Writing CSV and Excel data
  • Exploring DataFrame content
  • Manipulating DataFrame content
  • Challenge: Excel insight
  • Solution: Excel insight
Conclusion
  • Next steps

Taught by

Joe Marini

Reviews

4.6 rating at LinkedIn Learning based on 20 ratings

Start your review of Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.