Chris Moffitt is a data analyst and Python educator who writes practical, experience-driven articles on pandas, Polars, Jupyter Notebooks, Excel automation, and modern data analysis workflows.
10 articles from this blog
A comparison of Polars and Pandas for data analysis in Python, focusing on Polars' API, performance benefits, and use cases.
A warning about a subtle pandas groupby issue that can lead to incorrect data aggregation sums if missing values are not handled properly.
A guide to embedding source notebook metadata in Excel reports using Python's pandas and xlsxwriter to simplify tracking and refreshing analyses.
Explores 16 advantages of using Visual Studio Code for Jupyter Notebook development, including better navigation, debugging, and integration.
A guide to efficiently cleaning and standardizing text data in large datasets using Python's pandas library, with a practical example.
A case study on automating Excel file creation and email distribution using Python's Pandas and Outlook integration.
A review of Python tools and libraries for visualizing and interactively exploring Pandas DataFrames, comparing them to Excel's graphical interface.
A guide to using pandas' groupby and aggregation functions for data analysis, covering basic to complex custom operations.
A guide to using pandas and openpyxl to read and clean poorly structured Excel files, focusing on the usecols and header parameters.
A case study on using Python to automate the collection, cleaning, and processing of gigabytes of historical weather data for analysis.
