Author name: Erik Marsja

PhD in Psychology, Linköping University. Main interest is experimental and cognitive psychology. Enjoy programming in Python and R.

reading xlsx files in python

Your Guide to Reading Excel (xlsx) Files in Python

Do you ever spend hours sifting through Excel files, trying to make sense of the data? Openpyxl can help! In this tutorial, we’ve covered everything you need to know about using Openpyxl in Python to read and manipulate Excel files. You will learn to import the necessary modules, set the file path, and read the file and its active sheet. We’ll also dive deeper into manipulating the sheet, including creating a dictionary from an Excel file and reading multiple Excel files in a directory.

By mastering these techniques, you can streamline your data processing workflow and gain valuable insights from your data in a fraction of the time. Whether you are a data analyst or someone looking to make sense of complex data sets, Openpyxl is a powerful tool to help you achieve your goals. So, grab your favorite beverage, fire up your Python IDE, and let’s get started!

Your Guide to Reading Excel (xlsx) Files in Python Read More »

get pandas column names

How to Get the Column Names from a Pandas Dataframe – Print and List

In this short post, you will learn 6 methods to get the column names from Pandas dataframe. One of the nice things about Pandas dataframes is that each column will have a name (i.e., the variables in the dataset). Now, we can use these names to access specific columns by name without having to know which column number it is.

How to Get the Column Names from a Pandas Dataframe – Print and List Read More »

Scroll to Top