Read a nested json file.

27 Ansichten (letzte 30 Tage)
DuckDuck am 19 Mai 2018
Kommentiert: Jan am 19 Mai 2018
I have a nested json file with lines of this type:
the number of observations for each line is different, it might be 3 or whatever. I use loadjson to read these lines but i get structures value. What i want to achieve is a table with four columns: name, id, value, timestamp.
Can anyone help me to flatten these kind of json?
  1 Kommentar
Rik am 19 Mai 2018
If people want to find this loadjson function: it's on the FEX.
If your file contains lines with a regular pattern, you can simply read the file yourself and get the parameters with textscan. If your file is not so regular, you can always try some recursive function with fieldnames.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Jan am 19 Mai 2018
Do you know jsondecode?
str = '{"results":{"whatever_name":{"id":77},"another_name":{"id":89},"another_name":{"id":60}},"timestamp":123456}';
M = jsondecode(str);
It is not trivial to extrapolate the wanted output from an example of a single line only. So please post a meaningful example of the input data.
  2 Kommentare
Jan am 19 Mai 2018
The structure of the JSON string is clearly defined as list of two variables, while the first is a list of 3 variables. This is not equivalent to a "table with 4 fields". You cannot expect that a JSON parse reorganize the data magically, because this is not the job of parsing. But of course you can convert the data afterwards. Unfortunately I cannot imagine, what the "4 fields" should be. I assume the 1st field is the name: "whatever_name", "another_name", "another_name", the 2nd is the id: 77, 89, 60, and the 3rd field is 3 times the timestamp 123456, 123456, 123456. But what could be the 4th field?
It would be useful, if you explain exactly, what you want as output. Neither the json parser nor the members of the forum can guess this.

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by