Advanced Hands-On Python: Working with Excel and Spreadsheet Data
Offered By: LinkedIn Learning
Course Description
Overview
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
- 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
- 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
- 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
- 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
- Next steps
Taught by
Joe Marini
Related Courses
Excel 2010Miríadax Pensamiento algorítmico
Tecnológico de Monterrey via Coursera Statistics for Business – I
Indian Institute of Management Bangalore via edX Excel 2010
Universitat Politècnica de València via EMMA Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera