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

Focused View

Joe Marini

2:45:46

21 View

01 - Introduction

01 - Python and spreadsheets Made for each other.mp4

00:45

02 - Getting set up.mp4

03:21

02 - 1. Working with CSV Files

01 - The CSV format.mp4

01:20

02 - Reading CSV files into an array.mp4

04:22

03 - Reading CSV files into a dictionary.mp4

07:14

04 - Reading CSV files with a filter.mp4

02:54

05 - Writing a CSV file.mp4

02:34

06 - Writing a dictionary as CSV.mp4

04:08

07 - Challenge Modify CSV content.mp4

02:03

08 - Solution Modify CSV content.mp4

02:59

03 - 2. Manipulating Excel Files with openpyxl

01 - Overview of openpyxl.mp4

01:39

02 - Loading and exploring a workbook.mp4

09:09

03 - Creating a workbook.mp4

06:50

04 - Working with content.mp4

08:10

05 - Styling cells.mp4

10:18

06 - Applying conditional formatting.mp4

07:07

07 - Adding filters.mp4

02:56

08 - Challenge Split a workbook.mp4

01:51

09 - Solution Split a workbook.mp4

06:10

04 - 3. Creating Excel Files with XlsxWriter

01 - Introduction to XlsxWriter.mp4

01:53

02 - Creating a workbook.mp4

07:02

03 - Formatting worksheet content.mp4

05:39

04 - Creating an Excel table.mp4

06:23

05 - Applying conditional formatting.mp4

08:16

06 - Writing workbook properties.mp4

05:39

07 - Challenge Split a workbook.mp4

02:07

08 - Solution Split a workbook.mp4

02:58

05 - 4. Spreadsheets with pandas

01 - Introduction to pandas.mp4

02:20

02 - Reading CSV and Excel data.mp4

06:50

03 - Writing CSV and Excel data.mp4

06:36

04 - Exploring DataFrame content.mp4

12:03

05 - Manipulating DataFrame content.mp4

07:46

06 - Challenge Excel insight.mp4

02:01

07 - Solution Excel insight.mp4

02:00

06 - Conclusion

01 - Next steps.mp4

00:23

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Joe Marini

Instructor's Courses

Seasoned software industry veteran with 30 years of experience creating developer platforms and APIs, managing strategic partners, leading high-performing teams, driving developer-focused initiatives, crafting product strategy, and advocating for great technology. Deep experience delivering both technical and business presentations to large audiences. Senior Author for LinkedIn Learning with over 50 published titles, covering subjects such as Python programming, Android Development, XML and JSON data processing, Mobile Development, jQuery, and HTML5. Specialties: Strategic Partner Management; Mobile Applications; Web standards, architecture, and development; product strategy; program management; partner marketing; SDK development; writing and speaking; developer platform API development

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.