Create Plots Using Pandas Crosstab() in Python

pandas crosstab

When I was working on a data analysis project, I needed to visualize the relationship between two categorical variables in my dataset. The challenge was finding an efficient way to both tabulate and visualize this relationship in one go. That’s when pandas’ crosstab() function came to my rescue. In this article, I’ll show you how … Read more >>

How to Write a Pandas DataFrame to Excel in Python

pandas write DataFrame to Excel: Q1 2026 sales workbook in Excel with USD formatting, a total row and a column chart

Every quarter, a sales manager I work with asks for the same thing: the numbers from my pandas script, but as a workbook she can open, filter and forward. That’s the job of a pandas write DataFrame to Excel step. Renaming a CSV to .xlsx doesn’t work; Excel warns that the format and extension don’t … Read more >>