excel multi-dimensional file to json-stat

[Savioz Stéphane]

I have the following table in Excel (see pic). Is it possible to import that json-stat ?

[Xavier Badosa]

It is possible to express the contents of your table in JSON-stat. Besides, the structure of this table is compatible with JSON-stat, so if such a structure (label columns and label rows are dimensions) is preserved, it would be technically possible to convert automatically this kind of tables into JSON-stat, although additional semantics would be convenient, otherwise it would be impossible to know what's been measured (metric) and dimensions would end up having meaningless names like "row dimension 1" (area?), "row dimension 2" (frequency?), "col dimension 1" (sex?) and "col dimension 2" (year?).

Importing the data would be trivial:

value: [

0.095, 0.083, 0.822, 0.092, 0.113, 0.795,

0.166, ...

]

so the only tricky part is the definition and order of the dimensions.

X.