Are you interested in building interactive dashboards with Python? How about a project that takes a flat data file all the way to a web-hosted interactive dashboard? This week on the show, David Amos is back, and he’s brought another batch of PyCoder’s Weekly articles and projects.

Along with the Real Python article about data visualizations using Dash, David covers an article designed to help Python developers understand the fundamentals of C. We discuss a couple of articles about Excel and using Python with Microsoft Office.

We also cover several other articles and projects from the Python community including, out-of-memory crashes in Python, updating all packages with pip-review, data science notebooks for teams, and a command-line tool for looking up colors, shades, and palettes.

Course Spotlight: Command Line Interfaces in Python

Command line arguments are the key to converting your programs into useful and enticing tools that are ready to be used in the terminal of your operating system. In this course, you’ll learn their origins, standards, and basics, and how to implement them in your program.

Topics:

• 00:00:00 – Introduction
• 00:01:36 – CPython Internals Book
• 00:03:18 – C for Python Programmers
• 00:06:11 – Dying, Fast and Slow: Out-Of-Memory Crashes in Python
• 00:13:29 – Automating Excel File Creation and Distribution With Pandas And Outlook
• 00:18:33 – Update All Packages With pip-review
• 00:23:49 – Video Course Spotlight
• 00:25:04 – Ditching Excel for Python: Lessons Learned From a Legacy Industry
• 00:30:20 – Develop Data Visualization Interfaces in Python With Dash
• 00:38:11 – Deepnote: Data Science Notebook for Teams
• 00:41:25 – colorpedia: Command-Line Tool for Looking Up Colors, Shades and Palettes
• 00:43:45 – Thanks and goodbye

Show Links:

C for Python Programmers – In this tutorial, you’ll learn the basics of the C language, which is used in the source code for CPython, the most popular Python implementation. Learning C is important for Python programmers interested in contributing to CPython.

Dying, Fast and Slow: Out-Of-Memory Crashes in Python – Learn about the different ways that memory issues can manifest in your Python programs, and how you can debug and fix them.

Automating Excel File Creation and Distribution With Pandas And Outlook – See how a little bit of Python can go a long way to automating manual processes and save businesses valuable time.

Update All Packages With pip-review – Keeping track of Python dependencies and updates can be tricky. The pip-review tool automates a lot of this process in a convenient command-line interface.

Ditching Excel for Python: Lessons Learned From a Legacy Industry – Learn how Python is revolutionizing an industry that’s notoriously resistant to change and fraught with every programmer’s most dreaded tool: Excel spreadsheets.

Develop Data Visualization Interfaces in Python With Dash – Learn how to build a dashboard using Python and Dash. Dash is a framework for building data visualization interfaces. It helps data scientists build fully interactive web applications quickly.

Projects:

• Deepnote: Data Science Notebook for Teams
• colorpedia: Command-Line Tool for Looking Up Colors, Shades and Palettes

Additional Links:

• CPython Internals Book: Your Guide to the Python 3 Interpreter
• E27: Preparing for an Interview With Python Practice Problems - Guest Jim Anderson
• E24: Options for Packaging Your Python Application: Wheels, Docker, and More - Guest Itamar Turner-Trauring
• Fil: A New Python Memory Profiler for Data Scientists and Scientists
• pip-review: A Tool to Keep Track of Your Python Package Updates
• pip-tools: Keeps Your Pinned Dependencies Fresh
• E29: Resolving Package Dependencies With the New Version of Pip
• pip - The Python Package Installer
• pyxll: Write Excel Add-Ins in Python
• Introduction to Dash: Plotly
• Dash App Gallery

Support the podcast & join our community of Pythonistas