Replace Blank Values by NaN in pandas DataFrame in Python (Example) | Empty Cell | replace Function

Published: 21 October 2022
on channel: Statistics Globe

1,496

How to substitute empty cells in a pandas DataFrame by NaN values in the Python programming language. More details: https://statisticsglobe.com/replace-b...
Python code of this video:

import pandas as pd # Import pandas library

data = pd.DataFrame({'x1':[1, '', ' ', 2, 3], # Create example DataFrame
'x2':['', '', 'a', 'b', 'c'],
'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

data_new = data.copy() # Create duplicate of example data
data_new = data_new.replace(r'^\s*$', float('NaN'), regex = True) # Replace blanks by NaN
print(data_new) # 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

Follow me on Social Media:
Facebook – Statistics Globe Page:   / statisticsglobecom
Facebook – R Programming Group for Discussions & Questions:   / statisticsglobe
Facebook – Python Programming Group for Discussions & Questions:   / statisticsglobepython
LinkedIn – Statistics Globe Page:   / statisticsglobe
LinkedIn – R Programming Group for Discussions & Questions:   / 12555223
LinkedIn – Python Programming Group for Discussions & Questions:   / 12673534
Twitter:   / joachimschork

Music by bensound.com

On this page of the site you can watch the video online Replace Blank Values by NaN in pandas DataFrame in Python (Example) | Empty Cell | replace Function with a duration of hours minute second in good quality, which was uploaded by the user Statistics Globe 21 October 2022, share the link with friends and acquaintances, this video has already been watched 1,496 times on youtube and it was liked by 21 viewers. Enjoy your viewing!

54,509