11
$\begingroup$

A Dataset seems perfect to represent structured data.

Has anyone already thought about how to convert as efficiently/elegantly as possible an XML or JSON file to a Dataset in Mathematica 10 ?

Improve this question
$\endgroup$
1
  • 2
    $\begingroup$ An example of converting XML to a dataset can be found here. $\endgroup$
    – WReach
    Aug 31, 2014 at 14:17

1 Answer 1

Reset to default
13
$\begingroup$

To convert JSON to Dataset we can use GeneralUtilities`ToAsssociations as was first mentioned by rm-rf here.

Example using the Stackexchange API (the ten most up voted posts, questions and answers, on this site):

json = Import["http://api.stackexchange.com/2.2/posts?pagesize=10&order=desc&sort=votes&site=mathematica&filter=!LH22RQM95veNmsOfuhD0xa", "JSON"]
Needs["GeneralUtilities`"]
dataset = Dataset[ToAssociations@json]["items"]

enter image description here

For the record, doing it without ToAssociation isn't that hard either:

Dataset[Map[Association, "items" /. json]]
Improve this answer
$\endgroup$
2
  • $\begingroup$ Have you tried more structured hierarchical data? $\endgroup$
    – alancalvitti
    Jan 30, 2015 at 21:31
  • $\begingroup$ @alancalvitti The other part of the OP's question (XML) is answered by WReach (see his comment). I'm taking a stab at HTML here, but I don't go as far as putting the data into Association. $\endgroup$
    – C. E.
    Jan 30, 2015 at 21:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.