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

سرفصل های دوره

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.

01 - Introduction

01 - Python and spreadsheets Made for each other

02 - Getting set up

02 - 1. Working with CSV Files

01 - The CSV format

02 - Reading CSV files into an array

03 - Reading CSV files into a dictionary

04 - Reading CSV files with a filter

05 - Writing a CSV file

06 - Writing a dictionary as CSV

07 - Challenge Modify CSV content

08 - Solution Modify CSV content

03 - 2. Manipulating Excel Files with openpyxl

01 - Overview of openpyxl

02 - Loading and exploring a workbook

03 - Creating a workbook

04 - Working with content

05 - Styling cells

06 - Applying conditional formatting

07 - Adding filters

08 - Challenge Split a workbook

09 - Solution Split a workbook

04 - 3. Creating Excel Files with XlsxWriter

01 - Introduction to XlsxWriter

02 - Creating a workbook

03 - Formatting worksheet content

04 - Creating an Excel table

05 - Applying conditional formatting

06 - Writing workbook properties

07 - Challenge Split a workbook

08 - Solution Split a workbook

05 - 4. Spreadsheets with pandas

01 - Introduction to pandas

02 - Reading CSV and Excel data

03 - Writing CSV and Excel data

04 - Exploring DataFrame content

05 - Manipulating DataFrame content

06 - Challenge Excel insight

07 - Solution Excel insight

06 - Conclusion

01 - Next steps

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)