Answers for "pandas remove blank rows"

1

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
Posted by: Guest on July-29-2021

Python Answers by Framework

Browse Popular Code Answers by Language