Replace NaN by Empty String in pandas DataFrame in Python (Example) | Substitute by Blank Character

Published: 02 December 2022
on channel: Statistics Globe

1,133

How to set NaN values to blank character strings in a pandas DataFrame in the Python programming language. More details: https://statisticsglobe.com/replace-n...
Python code of this video:

import pandas as pd # Load pandas

data = pd.DataFrame({'x1':[6, 7, 3, 7, float('NaN'), 9], # Create example DataFrame
'x2':[3, float('NaN'), float('NaN'), 4, 1, 3],
'x3':range(7, 1, - 1)})
print(data) # Print example DataFrame

data_new = data.copy() # Duplicate data
data_new = data_new.fillna('') # Fill NaN with blanks
print(data_new) # Print new data

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 NaN by Empty String in pandas DataFrame in Python (Example) | Substitute by Blank Character with a duration of hours minute second in good quality, which was uploaded by the user Statistics Globe 02 December 2022, share the link with friends and acquaintances, this video has already been watched 1,133 times on youtube and it was liked by 0 viewers. Enjoy your viewing!

312