String "NA" conflict with pandas na type

Question

I have a csv file and it contains value "NA"(a string named a country), and when I use fillna() function it will recognize string "NA" as pandas na type, how could I do?

files like this

aa.csv
1,2,3,4,5
NA,BA,CA,EA,AA

import pandas as pd
df = pd.read_csv("aa.csv")
clean = df.fillna("")
print(clean) 
print(df)

result is:

  1   2   3   4   5
0    BA  CA  EA  AA

    1   2   3   4   5
0 NaN  BA  CA  EA  AA

https://stackoverflow.com/questions/33952142/prevent-pandas-from-interpreting-na-as-nan-in-a-string — Keatinge, Jan 29 '19 at 06:20

score 1 · Accepted Answer · answered Jan 29 '19 at 06:24

1

Set na_filter parameter as False

df = pd.read_csv("aa.csv", na_filter=False)

answered Jan 29 '19 at 06:24

Sociopath

13,068
19
47
75

1

Thank you very much, it's very useful for me – Saluton Jan 29 '19 at 06:28

String "NA" conflict with pandas na type

1 Answers1