Is there a way in pd.read_csv to replace NaN value with other character?

Question

I have some data in csv file. Because it is collected from machine,all lines should be number but some NaN values exists in some lines.And the machine can auto replace these NaN values with a string '-'.

My question is how to set params of pd.read_csv() to auto replace '-'values with zero from csv file?

Answer 1

You can try something like this :

import pandas

df = pandas.read_csv('somefile.txt')

df = df.fillna(0)

Hope that'll help !

Answer 2

while reading the csv file you can use the parameter na_values:

df = pd.read_csv('file.csv',na_values='-')

Edit: you can then convert nan to 0 by:

df.fillna(0,1,inplace=True)