Category: Python & Data

The Python articles on this blog are the ones people actually arrive at from search, and they share a shape: a specific job, the code that does it, and the output it produces. Heatmaps in Seaborn, joining two DataFrames in Pandas, reading and writing Excel, building a PDF report with ReportLab, pulling text and tables back out of a PDF with PyMuPDF, sending mail from a script. Visualisation is the largest group, and the Seaborn and Matplotlib guides go past the usual first example into the parameters you reach for once a chart has to be readable by someone else. The reporting group covers the other half of the same problem: getting a result out of Python and into a file a colleague will open. Between them sit the database articles, which connect Python to PostgreSQL and MySQL without an ORM tutorial detour. If you are setting up from scratch, the environment articles cover installing Python on Windows and running and debugging scripts in VS Code — worth ten minutes before the first real script, because most early frustration is environment, not language. These pages also feed the RAG and AI sections: document parsing, dataframes and chart generation are the same tools, used further down the pipeline.