how to find null values in a dataset code example

Example 1: how to find rows with missing data in pandas

null_data = df[df.isnull().any(axis=1)]

Example 2: knowing the sum null values in a specific row in pandas dataframe

note:df is syour dataframe 

print(df['emp_title'].isnull().sum())

Example 3: python if column is null then

df['real_lastName'] = np.where(df['LastName'].isnull(), df['Middle'], df['LastName'] )

print (df)
  FirstName Middle LastName real_lastName
0       Tom     Ju      NaN            Ju
1      Kity    NaN      Rob           Rob

Tags:

Sql Example

Related