Fields are filled in with (unknown) after importing csv using fread in pydatatable

Asked Feb 16 '22 at 05:44

Active Feb 16 '22 at 05:53

Viewed 71 times

I have a csv with about 15 columns, this file is imported using fread from pydatatable.

dt.fread('temp_sample.csv')

Here some of columns are contained empty values i.e NAN's and partial entries and some other columns are completely NAN's.

Here country column is filled with (unknown) as it has no entries and whereas SSN has got NAs and entries existed.

Why (unknown) is filled in in this type of cases? Why it is not as NA's?

edited Feb 16 '22 at 05:53

asked Feb 16 '22 at 05:44

myamulla_ciencia

Do you have the same issue when you read it in pandas? If you open d file in a notepad, do the columns show? – sammywemmy Feb 16 '22 at 20:24
No. Pandas reads it correclty and country column is filled in with NA only. – myamulla_ciencia Feb 17 '22 at 01:38
A sample.csv file would be helpful so one can download and test locally. You can change d contents of d sample to not match d actual data – sammywemmy Feb 17 '22 at 01:40

0 Answers0