Recognizing missing values

[jonathancallahan]

I have a csv file generated by R that uses NA as the missing value:

2022-11-11T23:00:00Z,1,4.4,-5,NA,NA,2.6,NA,5.3,-0.6,-4,2.9,11
2022-11-12T00:00:00Z,-5,23.8,24,NA,NA,0.9,NA,3,2.4,-0,9.2,11
2022-11-12T01:00:00Z,6,2.5,6,NA,NA,0.5,NA,2.7,9.7,-0,-3.8,19
2022-11-12T02:00:00Z,2,3.6,15,NA,NA,0.5,NA,-1.5,NA,-1,-7.9,28
2022-11-12T03:00:00Z,2,NA,9,NA,NA,0.5,NA,-2.4,NA,-1,-1.3,NA
2022-11-12T04:00:00Z,11,NA,13,NA,NA,-0.4,NA,-0.6,NA,6,4.7,NA
2022-11-12T05:00:00Z,12,NA,NA,NA,NA,-0.5,NA,NA,NA,2,1.2,NA
2022-11-12T06:00:00Z,16,NA,NA,NA,NA,-0.8,NA,NA,2.1,26,0,NA

It would be nice if the loadCSV() function could accept an argument identifying missing value strings. Right now, the loadCSV() function returns a table where any column that has a single NA values is parsed as a String. The should be all Number except for the first Date column.

In R, read::read.csv() has an argument for recognizing missing values: na = c("", "NA").