Create an extra column in a panda dataframe where, if one or more rows are missing then the extra column will contain the column names

Asked Mar 30 '22 at 08:05

Active Mar 30 '22 at 08:05

Viewed 26 times

I am trying to create a new column in df that contains a small description that says for each row these many columns are Nan.This is mainly for error logging purpose. I want to use the numpy.where condition to do that, but i don't want to specify the column names. if there a simple way to do that?

I did try using the np.where condition to do it but i am new to panda so i am getting errors.

asked Mar 30 '22 at 08:05

Ajith

Use `df['count na'] = df.isna().sum(axis=1)` – jezrael Mar 30 '22 at 08:09
Use isna() or isnull(). – Duca Mar 30 '22 at 08:19

Create an extra column in a panda dataframe where, if one or more rows are missing then the extra column will contain the column names

0 Answers0