topic Re: JMP Import CSV - column with only "NA" values. in Discussions

JMP Import CSV - column with only "NA" values.

Anonymous — Tue, 12 May 2015 16:08:45 GMT

Hello,

This was more of an observation, and I was wondering if anyone could confirm that this is indeed intended functionality.

I noticed that if I import a CSV into JMP and a column only contains "NA" for every value in all rows, the column shows up with all missing values.

On the contrary, if at least one row has a different string value than "NA", all of the "NA" valued rows appear as "NA" and not missing.

Importing a CSV with a column that has a single value for all rows other than "NA" does not turn the values all to missing, so I am thinking "NA" is something JMP checks for.

Has anyone noticed this before?

Thanks,

Re: JMP Import CSV - column with only "NA" values.

Craige_Hales — Thu, 14 May 2015 16:50:43 GMT

Yes, the code that attempts to guess the column's data type (character or numeric) has some heuristics based on consistency of missing value representation and special cases like NA and NaN . If JMP guesses wrong, you can force the data type through the import wizard or through JSL. If you use the same CSV file a lot, you could grab the source script and set the column types the way you want. For very large CSV files, this could save a lot of time since JMP wouldn't need to read the file an extra time to figure out the column types.

Re: JMP Import CSV - column with only "NA" values.

Anonymous — Wed, 27 May 2015 03:50:49 GMT

Thank you, this helped.