How to Convert DataFrame Values Into Percentages

Python

In this snippet we convert the values in the dataframe to the percentage each value represent across the row the row.

First we create a 'total' column for each row and then use pipe and lambda to divide each value in the row by the 'total' column and format as a percentage.

 1|  
 2|  df['total'] = df['col_1'] + df['col_2']
 3|  df = df.pipe(lambda x: x.div(x['total'], axis='index')).applymap('{:.0%}'.format)
detro
Lambda | Percentages | Pipe
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

143
LightGBM Custom Loss Function
Python

LightGBM | Loss function

128
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

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

Scaler | Standard

87
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

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

Rmse

82
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

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

Catboost | Hyperparameter tuning

65
Overwriting a Python Logging File Instead of Appending
Python

Logging

62
Reading CSV Files from Amazon S3 into Pandas Dataframes
Python

Pandas | Python | S3

58