Loading Excel spreadsheet as pandas DataFrame

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.

filter_none

edit
close

play_arrow

link
brightness_4
code

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)

chevron_right


Output:



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

filter_none

edit
close

play_arrow

link
brightness_4
code

# 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) 

chevron_right


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/



My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.