Python for Project Managers

I am not a software engineer. I am a project manager who learned enough Python to be dangerous — and it has been one of the best investments I have made in my career.

Why Python

Python is the right language for PMs because the ecosystem is built for data manipulation and automation. With pandas, you can slice through CSV exports from Jira in seconds. With matplotlib or plotly, you can build dashboards that actually tell a story. With requests, you can pull data from any API. The learning curve is gentle and the payoff is immediate.

What I Automate

My most-used script pulls sprint data from Jira's REST API, calculates velocity trends, and generates a PDF report that I share with stakeholders every two weeks. What used to take me 90 minutes of manual work in Excel now runs in 15 seconds.

I also built a capacity planning tool. It reads team allocation from a Google Sheet, cross-references it with upcoming sprint commitments, and flags potential overallocation. Nothing fancy — just 200 lines of Python that saves me from surprises.

The Dashboard I Am Most Proud Of

Last month I built a simple Streamlit dashboard that visualizes defect trends across three projects. My engineering leads now check it daily instead of waiting for my weekly status email. That shift — from push reporting to pull reporting — changes the dynamic entirely. People trust data they can access on their own terms.

Getting Started

If you are a PM considering Python, start with one pain point. Pick the most tedious report you produce and automate it. You will learn pandas, file I/O, and basic API calls in the process. That is enough to transform your workflow.

I used free resources: the official Python tutorial, Automate the Boring Stuff, and a lot of Claude 3.5 Sonnet for debugging. You do not need a bootcamp. You need a problem worth solving and the patience to iterate.