How to Filter Data from an Excel File in Python with Pandas

Problem Formulation and Solution Overview This article will show different ways to read and filter an Excel file in Python. To make it more interesting, we have the following scenario: Sven is a Senior Coder at K-Paddles. K-Paddles manufactures Kayak Paddles made of Kevlar for the White Water Rafting Community. Sven has been asked to … Read more

Python Excel – Styling Your Worksheets

Part 6 in Working with Excel focuses on styling. Impress your customers by styling the Worksheet to match their brand by: adding in their unique logo, using their color scheme, using their preferred font style, formatting the Worksheet using their preferred report style. Taking the time to do this makes you stand above the crowd. … Read more

Python Excel – Sum, Average, Max, and Date Formulas

Part 5 in the Working with Excel series focuses on formulas.   Background After completing Part 4 of this series, you should be comfortable using Python and openpyxl to: add worksheets rename worksheets reorder worksheets delete Worksheets The j-greats.xlsx file should exist on your system.  If you do not have this particular file, click here … Read more

Python Excel – Basic Worksheet Operations

Part 4 in the Working with Excel series focuses on Worksheet(s) manipulation.   Background After completing Part 3 of this series, you should be comfortable using Python and openpyxl to: append row(s), modify data, insert column(s), delete row(s) and column(s) The j-greats.xlsx file should exist on your system. If you do not have this particular … Read more