Nan vs nat pandas

Count nan pandas

#Python, pandas
#Count missing values for each column of the dataframe df

df.isnull().sum()

Source: thispointer.com

Pandas nan values in column

df['your column name'].isnull()

Nan vs nat pandas

>>> import pandas as pd, datetime, numpy as np
>>> df = pd.DataFrame({'a': [datetime.datetime.now(), np.nan], 'b': [5, np.nan], 'c': [1, 2]})
>>> df
                           a    b  c
0 2019-02-17 18:06:15.231557  5.0  1
1                        NaT  NaN  2
>>> fill_dt = datetime.datetime.now()
>>> fill_value = 4
>>> dt_filled_df = df.select_dtypes('datetime').fillna(fill_dt)
>>> dt_filled_df
                           a
0 2019-02-17 18:06:15.231557
1 2019-02-17 18:06:36.040404
>>> value_filled_df = df.select_dtypes('int').fillna(fill_value)
>>> value_filled_df
   c
0  1
1  2
>>> dt_filled_df.columns = [col + '_notnull' for col in dt_filled_df]
>>> value_filled_df.columns = [col + '_notnull' for col in value_filled_df]
>>> df = df.join(value_filled_df)
>>> df = df.join(dt_filled_df)
>>> df
                           a    b  c  c_notnull                  a_notnull
0 2019-02-17 18:06:15.231557  5.0  1          1 2019-02-17 18:06:15.231557
1                        NaT  NaN  2          2 2019-02-17 18:06:36.040404

Source: stackoverflow.com

Similar codes

0 vote210 views1 answer
Matplotlib set dpi
Python
20 votes221 views4 answers
Python remove new line
Python
1 vote217 views2 answers
File C:\Users\7shal\PycharmProjects\Itsa Me Malario\main.py, line 2 from pygame.locals import import ^ SyntaxError: invalid syntax
Python
0 vote206 views1 answer
Sort values pandas ascending
Python
0 vote224 views1 answer
PHP echo multiple lines example Using escape sequences
Python
1 vote219 views2 answers
Python timedelta to seconds
Python
2 votes224 views4 answers
Python dict get random key
Python
7 votes171 views4 answers
'numpy.ndarray' object is not callable
Python
0 vote210 views1 answer
You will be provided a file path for input I, a file path for output O, a string S, and a string T.
Python
0 vote176 views1 answer
Off-by-one error in python
Python