Drop Rows with Blank Values from pandas DataFrame in Python (3 Examples) | replace() & NaN Missings

How to remove rows with empty cells from a pandas DataFrame in the Python programming language. More details: https://statisticsglobe.com/drop-rows-blank-values-from-pandas-dataframe-python
Python code of this video:

import pandas as pd # Load pandas

data = pd.DataFrame({'x1':[1, '', ' ', 2, 3, 4], # Create example DataFrame
'x2':['', '', 'a', 'b', 'c', 'd'],
'x3':[' ', 'a', 'b', 'c', 'd', '']})
print(data) # Print example DataFrame
# x1 x2 x3
# 0 1
# 1 a
# 2 a b
# 3 2 b c
# 4 3 c d
# 5 4 d

data_new1 = data.copy() # Create duplicate of data
data_new1 = data_new1.replace(r'^\s*$', float('NaN'), regex = True) # Replace blanks by NaN
print(data_new1) # Print updated data
# x1 x2 x3
# 0 1.0 NaN NaN
# 1 NaN NaN a
# 2 NaN a b
# 3 2.0 b c
# 4 3.0 c d
# 5 4.0 d NaN

data_new2 = data_new1.copy() # Create duplicate of data
data_new2.dropna(inplace = True) # Remove rows with NaN
print(data_new2) # Print updated data
# x1 x2 x3
# 3 2.0 b c
# 4 3.0 c d

data_new3 = data_new1.copy() # Create duplicate of data
data_new3.dropna(subset = ['x1'], inplace = True) # Remove rows with NaN
print(data_new3) # Print updated data
# x1 x2 x3
# 0 1.0 NaN NaN
# 3 2.0 b c
# 4 3.0 c d
# 5 4.0 d NaN

Follow me on Social Media:
Facebook – Statistics Globe Page: https://www.facebook.com/statisticsglobecom/
Facebook – R Programming Group for Discussions & Questions: https://www.facebook.com/groups/statisticsglobe
Facebook – Python Programming Group for Discussions & Questions: https://www.facebook.com/groups/statisticsglobepython
LinkedIn – Statistics Globe Page: https://www.linkedin.com/company/statisticsglobe/
LinkedIn – R Programming Group for Discussions & Questions: https://www.linkedin.com/groups/12555223/
LinkedIn – Python Programming Group for Discussions & Questions: https://www.linkedin.com/groups/12673534/
Twitter: https://twitter.com/JoachimSchork

Music by bensound.com