How to Read a Particular Column in Excel Using Python

Python provides powerful tools to perform data analysis and manipulate spreadsheets. This tutorial will guide you on how to read a particular column in an Excel spreadsheet using Python. We will be using Python’s built-in library Pandas to read the Excel data.

Step 1: Install Necessary Libraries

In order to run our Python code smoothly, we need to have the necessary libraries installed. That includes pandas and openpyxl.

1
pip install pandas openpyxl

Step 2: Import the required library

To work with Excel files in Python, we need to import the pandas library.

1
import pandas as pd

Step 3: Read the Excel File

Firstly specify the location of the spreadsheet, then we will load the Excel file into a pandas DataFrame.

1
2
excel_file = 'sample.xlsx'
df = pd.read_excel(excel_file)

Step 4: Read a Particular Column from an Excel file

Now, we will read a specific column from the Excel file using the column’s name.

1
column = df['Name']

Step 5: Print the Selected Column

After reading the specific column, we will print its content.

1
print(column)

Output

Here is the output with the data:

0    Value1
1    Value2
.
.
.
n    ValueN
Name: Your Column Name, dtype: object

The Full Python Code

Here is the complete Python code:

1
2
3
4
5
6
7
8
import pandas as pd
 
excel_file = 'sample.xlsx'
df = pd.read_excel(excel_file)
 
column = df['Name']
 
print(column)

Conclusion

By utilizing the pandas library, Python makes it simple and efficient to read specific data from Excel files. With Python’s speed and readability, manipulating and analyzing spreadsheet data becomes an easy task.

As a result, Python has become a popular choice among data scientists and analysts for data analysis tasks. To explore more on how Python can handle Excel data, you can check Pandas official documentation.