notebook.community

Edit and run



In [3]:

    
from pandas import DataFrame
import numpy as np



In [5]:

    
df = DataFrame(np.random.randn(7,5))



In [6]:

    
df.ix[:4,1] = np.nan
df.ix[:2,2] = np.nan



In [7]:

    
df



In [8]:

    
df.dropna(thresh=4)



In [9]:

    
df.fillna(1)



In [ ]:

	0	1	2	3	4
0	-0.105505	NaN	NaN	-0.547648	0.964099
1	0.573828	NaN	NaN	0.620230	0.650518
2	1.038727	NaN	NaN	1.340926	-0.466875
3	0.256469	NaN	0.723217	1.280437	-0.675725
4	-0.793178	NaN	0.251448	1.878540	0.356009
5	0.228679	0.791232	0.737897	0.277351	-0.635002
6	-1.009781	2.402353	0.151933	-1.494239	-0.170659

	0	1	2	3	4
3	0.256469	NaN	0.723217	1.280437	-0.675725
4	-0.793178	NaN	0.251448	1.878540	0.356009
5	0.228679	0.791232	0.737897	0.277351	-0.635002
6	-1.009781	2.402353	0.151933	-1.494239	-0.170659

	0	1	2	3	4
0	-0.105505	1.000000	1.000000	-0.547648	0.964099
1	0.573828	1.000000	1.000000	0.620230	0.650518
2	1.038727	1.000000	1.000000	1.340926	-0.466875
3	0.256469	1.000000	0.723217	1.280437	-0.675725
4	-0.793178	1.000000	0.251448	1.878540	0.356009
5	0.228679	0.791232	0.737897	0.277351	-0.635002
6	-1.009781	2.402353	0.151933	-1.494239	-0.170659