pandas remove blank rows
In [27]: df
Out[27]:
A B C
0 -0.120211 -0.540679 -0.680481
1 NaN -2.027325 1.533582
2 NaN NaN 0.461821
3 -0.788073 NaN NaN
4 -0.916080 -0.612343 NaN
5 -0.887858 1.033826 NaN
6 1.948430 1.025011 -2.982224
7 0.019698 -0.795876 -0.046431
#The "subset" argument is used to select columns for which you want the NaN values to be dropped
#Set "inplace=True" if you want the new table to overwrite the old table.
In [28]: df.dropna(subset=['A', 'B'], inplace=True)
Out[28]:
A B C
0 -0.120211 -0.540679 -0.680481
1 -0.916080 -0.612343 NaN
2 -0.887858 1.033826 NaN
3 1.948430 1.025011 -2.982224
4 0.019698 -0.795876 -0.046431