How To Set First Row of a Pandas Dataframe as Column Headers

Python

 1|  # Step 1: Get the first row of the Pandas dataframe and 
 2|  # assign to new_header variable
 3|  new_header = df.iloc[0]
 4|  
 5|  # Step 2: Update the dataframe to only include rows after th
 6|  # the first row
 7|  df = df[1:]
 8|  
 9|  # Step 3: Set the dataframe column names as the new header variabe
10|  df.columns = new_header
Greg He
Headers
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

150
LightGBM Custom Loss Function
Python

LightGBM | Loss function

133
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

128
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

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

Scaler | Standard

93
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

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

Rmse

87
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

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

Catboost | Hyperparameter tuning

68
Overwriting a Python Logging File Instead of Appending
Python

Logging

66