Read a nested json file.
15 ビュー (過去 30 日間)
古いコメントを表示
I have a nested json file with lines of this type:
{"results":{"whatever_name":{"id":77},"another_name":{"id":89},"another_name":{"id":60}},"timestamp":123456}
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 results.whatever_name.id 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 件のコメント
Rik
2018 年 5 月 19 日
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.
回答 (1 件)
Jan
2018 年 5 月 19 日
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 件のコメント
Jan
2018 年 5 月 19 日
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.
参考
カテゴリ
Help Center および File Exchange で JSON Format についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!