Yes, I think that is a neat plan. I for one will gain a lot. I am keen to operate directly with the database and do analytics and graphs.
I have duplicated your example and it clearly works. However, if I read from my own .json local files, I cannot get things to work.
A real noob, so here is what is in the file:
[
{
"cap": "Algiers",
"imp": "31",
"iso": "DZ",
"lat": "28",
"long": "3",
"name": "Algeria",
"region": "Africa"
},
{
"cap": "Cairo",
"imp": "54",
"iso": "EG",
"lat": "27",
"long": "30",
"name": "Egypt",
"region": "Africa"
},
{
"cap": "Addis Ababa",
"imp": "62",
"iso": "ET",
"lat": "8",
"long": "-5",
"name": "Ethiopia",
"region": "Africa"
}
]
==> First off, I do not understand why the square brackets are required, because without them Mathematica gives an error.
mySt = Import["/Volumes/DATA_2TB 1/mathematicaAPPS/tes.json"];
stuffs = Dataset[mySt]
Delivers this:
SO: I do not seem to get the dataset right, my import does not work, and when I use the RawJSON parameter I get another error.
Any ideas very welcome.
I think a track with basic things, from reading .json files from disk into the nice datasets to eventually operating on a live data set will be awesome. Small steps, sort of thing. And then analytics and graphs etc. I can see it being visited quite a bit.
Henk
