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/
<!–
–>
Python Script to Automate Refreshing an Excel Spreadsheet
Python for Spreadsheet Users
Combine Multiple Excel Worksheets Into a Single Pandas Dataframe
How to read all excel files under a directory as a Pandas DataFrame ?
Exporting a Pandas DataFrame to an Excel file
Python | Pandas DataFrame.fillna() to replace Null values in dataframe
Difference Between Spark DataFrame and Pandas DataFrame
Pandas Dataframe.to_numpy() – Convert dataframe to Numpy array
Convert given Pandas series into a dataframe with its index as another column on the dataframe
How to Convert Wide Dataframe to Tidy Dataframe with Pandas stack()?
Please Login to comment…