In [1]:
import pandas as pd
import numpy as np
from pandas import DataFrame, Series
In [2]:
data = Series(['one', 'two', np.nan, 'four'])
In [3]:
data
Out[3]:
In [4]:
data.isnull()
Out[4]:
In [5]:
data.dropna
Out[5]:
In [6]:
data
Out[6]:
In [8]:
dframe = DataFrame([[1,2,3],[np.nan, 5,6], [7,np.nan,9], [np.nan,np.nan,np.nan]])
In [9]:
dframe
Out[9]:
In [10]:
clean_dframe = dframe.dropna()
In [11]:
clean_dframe
Out[11]:
In [12]:
dframe.dropna(how='all')
Out[12]:
In [13]:
npn = np.nan
dframe2 = DataFrame([[1,2,3, npn], [2, npn, 5,6], [npn,7,npn,9], [1,npn,npn,npn]])
dframe2
Out[13]:
In [14]:
dframe2.dropna(thresh=2)
Out[14]:
In [15]:
dframe2.dropna(thresh=3)
Out[15]:
In [16]:
dframe.fillna(1)
Out[16]:
In [17]:
dframe2.fillna({0:0, 1:1, 2:2, 3:3})
Out[17]:
In [18]:
dframe2.fillna(0, inplace=True)
In [19]:
dframe2
Out[19]:
In [ ]: