Breaking News: Grepper is joining You.com. Read the official announcement!

pandas replace values with only whitespace to null

Add Answer

FishBrawler answered on November 17, 2021 Popularity 7/10 Helpfulness 6/10

Contents

answer pandas replace values with only whitespace to null

More Related Answers

pandas replace null with 0

replace all spacec column with underscore in pandas

pandas replace nonetype with empty string

Python function remove all whitespace from all character columns in dataframe

pandas empty dataframe with column names

pandas delete spaces

remove leading and lagging spaces dataframe python

pandas fill blanks with zero

replace space with _ in pandas

pandas replace nulls with zeros

pandas replace empty string with nan

blank dataframe with column names

pandas replace null values with values from another column

python pandas replace nan with null

How to remove blank cells from column and shift populated cells in pandas

pandas strips spaces in dataframe

pandas replace space with underscore in column names

pandas replace zero with blank

pandas delete spaces

pandas replce none with nan

pandas delete spaces

remove whitespace from data frame

removing whitespaces from pandas dataframe csv

pandas remove leading trailing spaces in dataframe

pandas whitespace to nan

replace empty numbers in dataframe

pandas remove whitespace

remove leading and lagging spaces dataframe python

pandas replace empty string with nan

pandas replace values with only whitespace to null

Comment

1

df = pd.DataFrame([
    [-0.532681, 'foo', 0],
    [1.490752, 'bar', 1],
    [-1.387326, 'foo', 2],
    [0.814772, 'baz', ' '],     
    [-0.222552, '   ', 4],
    [-1.176781,  'qux', '  '],         
], columns='A B C'.split(), index=pd.date_range('2000-01-01','2000-01-06'))

# replace field that's entirely space (or empty) with NaN
print(df.replace(r'^\s*$', np.nan, regex=True))
# Produces:
#                    A    B   C
# 2000-01-01 -0.532681  foo   0
# 2000-01-02  1.490752  bar   1
# 2000-01-03 -1.387326  foo   2
# 2000-01-04  0.814772  baz NaN
# 2000-01-05 -0.222552  NaN   4
# 2000-01-06 -1.176781  qux NaN

# NOTE: if you don't want an element containing space in the middle to be replaced with NaN 
# use df.replace(r'^\s+$', np.nan, regex=True)

Popularity 7/10 Helpfulness 6/10 Language python

Source: stackoverflow.com

Tags: null pandas python replace whitespace

Share

Link to this answer
Share Copy Link

FishBrawler

Contributed on Nov 17 2021

FishBrawler

0 Answers Avg Quality 2/10

X

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

X

Grepper Account Login Required

Oops, You will need to install Grepper and log-in to perform this action.

Install Grepper Here