Selecting Columns to Import from Excel Using Pandas

Python

To select which columns to import from an Excel sheet into a Pandas dataframe, simply pass a list of the required columns to the "usecols" parameter of read_excel.

In the example below we only want to import the "OrderNo" and "ProductID" columns from the Returns sheet.

 1|  import pandas pd
 2|  
 3|  df = pd.read_excel('Returns.xlsx', 
 4|  		   sheet_name='Returns', 
 5|  		   usecols=['OrderNo','ProductID'])
analyseup
Read_excel | Excel
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

116
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

104
LightGBM Custom Loss Function
Python

LightGBM | Loss function

103
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

97
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

67
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

65
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

62
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

54
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

52
Overwriting a Python Logging File Instead of Appending
Python

Logging

47