English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 2h 45m | 484 MB
In this hands-on course, technology industry veteran Joe Marini guides you through a variety of practical ways that you can leverage Python to work more effectively with data from spreadsheets and Excel. Find out how to read and write CSV data, as well as how to convert data to and from CSV. Learn how Python can help you in creating, reading, and writing Excel workbooks. Plus, explore ways you can use Python when you’re working with Excel sheet data and formulas.
Table of Contents
Introduction
1 Python and spreadsheets Made for each other
2 Getting set up
Working with CSV Files
3 The CSV format
4 Reading CSV files into an array
5 Reading CSV files into a dictionary
6 Reading CSV files with a filter
7 Writing a CSV file
8 Writing a dictionary as CSV
9 Challenge Modify CSV content
10 Solution Modify CSV content
Manipulating Excel Files with openpyxl
11 Overview of openpyxl
12 Loading and exploring a workbook
13 Creating a workbook
14 Working with content
15 Styling cells
16 Applying conditional formatting
17 Adding filters
18 Challenge Split a workbook
19 Solution Split a workbook
Creating Excel Files with XlsxWriter
20 Introduction to XlsxWriter
21 Creating a workbook
22 Formatting worksheet content
23 Creating an Excel table
24 Applying conditional formatting
25 Writing workbook properties
26 Challenge Split a workbook
27 Solution Split a workbook
Spreadsheets with pandas
28 Introduction to pandas
29 Reading CSV and Excel data
30 Writing CSV and Excel data
31 Exploring DataFrame content
32 Manipulating DataFrame content
33 Challenge Excel insight
34 Solution Excel insight
Conclusion
35 Next steps
Resolve the captcha to access the links!