;
;

Practical Business Python

Taking care of business, one python script at a time

Website

Introduction to Polars

After a hiatus from the blog, I’m back with a new post. While I’ve still been using Python and Pandas, I wanted to explore some new technologies. I...
Posted on 14 January 2024 | 10:25 pm

Pandas Groupby Warning

One of the reasons I like using pandas instead of Excel for data analysis is that it is easier to avoid certain types of copy-paste Excel errors. A...
Posted on 26 September 2022 | 12:25 pm

Using Document Properties to Track Your Excel Reports

When doing analysis with Jupyter Notebooks, you will frequently find yourself generating ad-hoc Excel reports to distribute to your end-users. Afte...
Posted on 13 June 2022 | 7:25 pm

16 Reasons to Use VS Code for Developing Jupyter Notebooks

Visual Studio Code is one of the most popular text editors with a track record of continual improvements. One area where VS Code has been recently ...
Posted on 15 November 2021 | 1:55 pm

Efficiently Cleaning Text with Pandas

It’s no secret that data cleaning is a large portion of the data analysis process. When using pandas, there are multiple techniques for cleaning te...
Posted on 16 February 2021 | 1:25 pm

Case Study: Automating Excel File Creation and Distribution with Pandas and Outlook

I enjoy hearing from readers that have used concepts from this blog to solve their own problems. It always amazes me when I see examples where only...
Posted on 18 January 2021 | 1:25 pm

Pandas DataFrame Visualization Tools

I have talked quite a bit about how pandas is a great alternative to Excel for many tasks. One of Excel’s benefits is that it offers an intuitive a...
Posted on 11 January 2021 | 1:25 pm

Comprehensive Guide to Grouping and Aggregating with Pandas

One of the most basic analysis functions is grouping and aggregating data. In some cases, this level of analysis may be sufficient to answer busine...
Posted on 9 November 2020 | 1:25 pm

Reading Poorly Structured Excel Files with Pandas

With pandas it is easy to read Excel files and convert the data into a DataFrame. Unfortunately Excel files in the real world are often poorly cons...
Posted on 19 October 2020 | 12:25 pm

Case Study: Processing Historical Weather Pattern Data

The main purpose of this blog is to show people how to use Python to solve real world problems. Over the years, I have been fortunate enough to hea...
Posted on 12 October 2020 | 12:25 pm