Python Libraries
A free 6-lesson course. Every lesson has a video walkthrough and a Jupyter notebook you can download or open in Google Colab; 2 lessons include real datasets. Tools covered: python-docx, pypdf, XlsxWriter, OpenCV, NumPy, Matplotlib.
- Lessons6
- Videoabout 2 hours
- LevelBeginner to intermediate
- PriceFree
- Datasets2
About this course
Python Libraries is a short practical course on automating everyday office files with Python. You create and edit Word documents with python-docx, read and write Excel workbooks with openpyxl, xlrd and XlsxWriter, merge, split and extract text from PDFs with pypdf, and set up the OpenAI API from Python. Each lesson is a hands-on walkthrough you can reuse straight away to automate reports and paperwork.
Python Libraries is a free beginner to intermediate course with 6 video lessons (about 2 hours of video in total). It starts with “Comprehensive Guide to Automating Word Documents with python-docx in Python” and finishes with “Step-by-Step Guide to Setting Up the OpenAI API with Python for Beginners”. Every lesson comes with the exact Jupyter notebook used in the video, and 2 of them include the dataset, so you can follow along with the same data.
Along the way you'll use python-docx, pypdf, XlsxWriter, OpenCV, NumPy and Matplotlib.
It suits anyone who knows basic Python and spends time on repetitive Word, Excel or PDF tasks.
What you'll be able to do
- Generate and edit Word documents with python-docx
- Read, write and format Excel files with openpyxl, xlrd and XlsxWriter
- Merge, split and extract text from PDF files with pypdf
- Call the OpenAI API from Python
All 6 lessons
22 minComprehensive Guide to Automating Word Documents with python-docx in Python
14 minComprehensive openpyxl Tutorial for Automating Excel with Python
14 minHow to Read Excel Files in Python Using the xlrd Library: Step-by-Step Tutorial
17 minComprehensive Guide to Using pypdf for PDF File Management in Python
14 minComprehensive Guide to Using Python xlsxwriter for Excel File Creation and Automation
20 minStep-by-Step Guide to Setting Up the OpenAI API with Python for Beginners
Frequently asked questions
Is the Python Libraries course free?
Yes. All 6 videos, notebooks and datasets are free, with no sign-up.
Do I need to install anything?
No. You can open each notebook in Google Colab in your browser, or download it and run it in Jupyter or VS Code with Anaconda installed.
How long does the Python Libraries course take?
The videos add up to about 2 hours. Most learners take one to two lessons a day, so plan on 1 to 2 weeks if you code along.
What level is it?
Beginner to intermediate. It suits anyone who knows basic Python and spends time on repetitive Word, Excel or PDF tasks.