How to set values as empty in dataframe using python

Question

I tried to set some values in a dataframe to empty based on a condition in python. The code is something like this,

df.loc[df['Col1'] > 0.5, 'Col2'] = np.nan

However, in output file (.csv), it's "nan" there. So wondering if there are any ways to make it empty? Thanks.

sander · Accepted Answer · 2022-09-27 16:04:25Z

4

df.loc[df['Col1'] > 0.5, 'Col2'] = ""

... will give you an empty value of type string. If you export your DataFrame to a .csv file, you will get an empty value.

answered Sep 27, 2022 at 16:04

sander

1,4901 gold badge13 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

This will change the data type of the columns

@the_ordinary_guy true, but most likely won't matter if OP exports it to CSV. If it does, then don't use this solution.

s510 · Accepted Answer · 2022-09-27 16:05:04Z

0

After your step:

df = df.loc[df['Col1'] > 0.5, 'Col2'] = np.nan

fill NaNs with empty string and write to csv

df = df.fillna("")

answered Sep 27, 2022 at 16:05

s510

2,88219 silver badges25 bronze badges