YoVDO

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

Offered By: LinkedIn Learning

Tags

Data Analysis Courses Python Courses pandas Courses Data Manipulation Courses Spreadsheets Courses openpyxl Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Excel 2010
Miríadax
Intro to Data Science
Udacity
Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera
Statistical Computing with R - a gentle introduction
University College London via Independent
Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera