Excel – Page 2 – Be on the Right Side of Change

Python Excel – Accessing Worksheet Data

April 10, 2022October 20, 2021 by Kat McKelvie

Part 2 of Working with Excel centers around accessing data from the Active Worksheet. This skill is one of the must-haves if you are interested in pursuing a career as a Data Scientist. Background After completing Part 1 of this series, you should be comfortable using Python to: create an Excel file, import a library, … Read more

How to Read and Write Excel files with Pandas

October 17, 2021 by Luis Bruemmer

The data we use in Pandas for real-world projects often comes from outside sources. One popular and repeatedly used source is Excel. In this tutorial, we will learn how to read files from Excel, how to modify these files, and how to write them to Excel. We will use several Pandas functions for these approaches. … Read more