Loading Excel spreadsheet as pandas DataFrame

Last Updated : 08 Jan, 2019

Pandas is a very powerful and scalable tool for data analysis. It supports multiple file format as we might get the data in any format. Pandas also have support for excel file format.

We first need to import Pandas and load excel file, and then parse excel file sheets as a Pandas dataframe.

import pandas as pd 
  
# Import the excel file and call it xls_file 
excel_file = pd.ExcelFile('pandasEx.xlsx') 
  
# View the excel_file's sheet names 
print(excel_file.sheet_names) 
  
# Load the excel_file's Sheet1 as a dataframe 
df = excel_file.parse('Sheet1') 
print(df) 

Output:

One can also read specific columns using ‘usecols‘ parameter of read_excel() method.

# import pandas lib as pd  
import pandas as pd  
    
require_cols = [0, 3]  
    
# only read specific columns from an excel file  
required_df = pd.read_excel('SampleWork2.xlsx', usecols = require_cols)  
    
print(required_df)  

Output:

        Name  Percentage
0      Ankit          95
1      Rahul          90
2    Shaurya          85
3  Aishwarya          80
4   Priyanka          75

For more examples, refer https://www.geeksforgeeks.org/creating-a-dataframe-using-excel-files/

Suggest improvement

Saving a Pandas Dataframe as a CSV

Creating a dataframe using Excel files

Share your thoughts in the comments

Introduction

Creating Objects

Viewing Data

Selection & Slicing

Operations

Manipulating Data

Grouping Data

Merging, Joining, Concatenating and Comparing

Working with Date and Time

Working With Text Data

Working with CSV and Excel files

Visualization

Applications and Projects