Counting the Number of Preceding Non-NA Rows in a Pandas Dataframe

Python

 1|  INPUT:
 2|  
 3|  	col_1	col_2
 4|  0	NaN	NaN
 5|  1	25.0	NaN
 6|  2	67.0	19.0
 7|  3	86.0	34.0
 8|  
 9|  CODE:
10|  
11|  df = df.notna().cumsum()
12|  
13|  OUTPUT:
14|  
15|  	col_1	col_2
16|  0	0	0
17|  1	1	0
18|  2	2	1
19|  3	3	2
20|
detro
Pandas | Cumsum | Na
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

133
LightGBM Custom Loss Function
Python

LightGBM | Loss function

121
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

117
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

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

Scaler | Standard

79
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

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

Rmse

77
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

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

Catboost | Hyperparameter tuning

60
Overwriting a Python Logging File Instead of Appending
Python

Logging

55