Hey Marco, I saw you profile and it seems that you also work with data. I have used Mathematica since version 4 for symbolics and for simple data analysis using matrices but now I feel outdated with respect of these new objects that Mathematica has introduced in the newer versions. I wanted to ask you if you know of any tutorial on Mathematica data analysis using these new objects.

Oh, I see where the problem is. You might want to try the two column data set and Import it like so:

dataset = SemanticImport["~/Desktop/cleandata.csv", {"Real", "Real"}, "Dataset", HeaderLines -> 1, Delimiters -> ",", MissingDataRules -> {"." -> Missing[], "" -> Missing[]}];

or alternatively like so:

dataset = SemanticImport["~/Desktop/cleandata.csv", Automatic, "Dataset", HeaderLines -> 1, Delimiters -> ",", MissingDataRules -> {"." -> Missing[], "" -> Missing[]}];

Cheers,

Marco

Hi Miguel,

this seems to work fine on my system (OS X, MMA10.0.2).

I generate some test data and export that:

data = RandomReal[1, 100];
Export["~/Desktop/cleandata.csv", Join[{"Test Data"}, data]]

Running your command:

dataset = SemanticImport["~/Desktop/cleandata.csv", "Real", "Dataset", HeaderLines -> 1, Delimiters -> ",", 
   MissingDataRules -> {"." -> Missing[], "" -> Missing[]}];

gives:

What happens when you execute your command?

Cheers,

Marco