I want to have NULL values in my data.frame (not NA). And the following doesn't seem to work.
> data.frame(x = c(1, 2, 3), y = c(NULL, NULL, NULL))
Error in data.frame(x = c(1, 2, 3), y = c(NULL, NULL, NULL)) :
arguments imply differing number of rows: 3, 0
My goal is to output my data.frame into a .csv file, and the cells with the NULL values should be blank.
You can get the dataframe with NULL entries using:
> data.frame(x = c(1, 2, 3), y = I(list(NULL, NULL, NULL))
Explanation:
If you want to use data.frame to include columns that are constantly NULL, you need to protect them using I.
You also have to input a list rather than a c of NULLs. That's because c(NULL, NULL, NULL) is identical to NULL -- NULLs can't be concatenated. Nor can they be elements of a vector, so every column that contains NULL values needs to be a list rather than a vector.
Using write.table and similar functions will call as.character on the column full of NULLs, writing the string "NULL" in the null cell. If you don't want that behaviour, it's probably best to use empty strings instead of NULLs.
data.frame(x = c(1, 2, 3), y = "").d <- data.frame(x=1:3); d$y <- replicate(3, NULL)y. I think it depends on what Adrian needs.write.table()allows you to control how those values are rendered:na = "NA"NULLvalues within a data.frame is really problematic. I think the more appropriate question to be asking (and you did) is "how to get empty values in a CSV".