Replace nan with empty string in python

Question

My requirement: I want to replace nan with ""(empty string)

Example

data = """{"name":"siva","id":"111","grade":"12","job_id":nan,"location":"ananb"}"""

If you see above example, i just want to replace nan(Not a Number) not the string consists of nan(ananb)

Can any one suggest a solution for this?

David Triger · Accepted Answer · 2020-10-03 11:03:55Z

2

A non generic solution for your specific example could be

data.replace(":nan",":")

This wouldn't replace actual values of the dictionary

answered Oct 3, 2020 at 11:03

David Triger

362 bronze badges

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

Comments

roo1989 · Accepted Answer · 2020-10-03 11:00:57Z

1

You can use the string.replace method.

data.replace("nan","")

Hope this solves your problem.

answered Oct 3, 2020 at 11:00

roo1989

1064 bronze badges

4 Comments

siva Over a year ago

it will replace ananb as well, but i just want to replace only nan not other strings conatins nan in it

Yossi Levi Over a year ago

Think that this will replace any appearance of "nan" in the entire string, and for example will also replace "ananb", can use regex replace and replace every nan sorrounded by \bs

siva Over a year ago

i don't want to replace ananb. i just want to replace nan.

roo1989 Over a year ago

If you know that the nan is always going to be at that specific value in the string, you can use data.replace('nan', '', 1) -> Will only replace the first instance. Otherwise, you have to use regex I'm afraid.

Yossi Levi · Accepted Answer · 2020-10-03 11:14:10Z

0

Better one would be to replace any match of nan which not sorrounded by other letters using regex ike so:

import re

print(re.sub("\Wnan\W", "", data))

answered Oct 3, 2020 at 11:14

Yossi Levi

1,2681 gold badge7 silver badges7 bronze badges

Collectives™ on Stack Overflow

Replace nan with empty string in python

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related