Null Value

Create sample DataFrame

• Create sample CSV file

  data_with_nan.csv

  col1,col2,col3
  test1,13,
  test2,44,aaa
  test3,,
  ,,
  test5,,bbb
  ,,

• Read CSV as DataFrame

  

• Create a DataFrame with None in Python

  

• See what is different between these two DataFrame

  

• How to create NaN

  

Calculate on NaN

Why using NaN

Deal with NaN

• Create sample DataFrame first

  

• Check if values are NaN

  

• Check if values are not NaN

  

• Drop NaN

  

  

• Fill NaN