import – How to set empty fields in a csv file on Missing when importing as a dataset?


When importing a csv file with empty fields Dataset, empty fields are defined on zero-length strings (""). There is an option, Empty field, which replaces the zero-length string with an arbitrary string, but I do not see any way to set empty fields on Missing[] or another value indicating missing data.

The import code is:

data = Import["file.csv",{"CSV","Dataset"},"HeaderLines"->1, "EmptyField"->""]

The result is the same as leaving Empty field out since "" is the default. However, all attempts to adjust Empty field at Missing[], No, or No fail. For example:

enter the description of the image here

Is it possible to define empty fields on Missing[]?