Skip to main content

How to read an Excel file in Python

How to read an Excel file in Python.

Here is a step-by-step tutorial on how to read an Excel file in Python.

Step 1: Install Required Libraries​

First, you need to install the required libraries to work with Excel files in Python. Open your terminal or command prompt and run the following command:

pip install pandas openpyxl xlrd

Step 2: Import Libraries​

Once the libraries are installed, you need to import them into your Python script. Add the following lines at the beginning of your code:

import pandas as pd

Step 3: Load Excel File​

The next step is to load the Excel file into your Python script. You can use the read_excel() function from the pandas library to do this. Here's an example:

data = pd.read_excel('filename.xlsx')

Replace 'filename.xlsx' with the path to your Excel file. If the Excel file is in the same directory as your Python script, you can simply provide the filename.

Step 4: Explore the Data​

Once the Excel file is loaded, you can explore its contents. The data will be stored in a pandas DataFrame object. You can print the data or perform various operations on it. For example, to print the first few rows of the data, use the head() function:

print(data.head())

Step 5: Access Specific Data​

You can access specific rows or columns of the Excel file using the pandas DataFrame. Here are a few examples:

To access a specific column, use the column name as an index:

column_data = data['Column Name']

To access a specific row, use the loc attribute and provide the row index:

row_data = data.loc[row_index]

To access a specific cell, combine the above two methods:

cell_data = data.loc[row_index, 'Column Name']

Step 6: Iterate through Rows​

If you want to iterate through each row in the Excel file, you can use a for loop. Here's an example:

for index, row in data.iterrows():
    print(row['Column Name'])

Replace 'Column Name' with the name of the column you want to access.

Step 7: Save Data to a New Excel File​

If you want to save the data to a new Excel file, you can use the to_excel() function. Here's an example:

data.to_excel('new_filename.xlsx', index=False)

Replace 'new_filename.xlsx' with the desired name and path of the new Excel file.

That's it! You now know how to read an Excel file in Python using the pandas library. Feel free to explore more features and functions offered by pandas to manipulate and analyze Excel data.