Convert JSON to Table and Query Specific Value

46 次查看（过去 30 天）

Monkey Coder 2023-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2008867-convert-json-to-table-and-query-specific-value

评论： Monkey Coder 2023-8-16

I have the following JSON array:

{"views":[{"Name":"A","Conf":"High","View":"Negative"}, {"Name":"B","Conf":"Low","View":"Negative"}, {"Name":"C","Conf":"Low","View":"Negative"}]}

How can I convert it to Table? Also, how can I query a specific row of the table? (Example: Find value of "Conf" where Name is "C.)

So far I have:

jsonData = '{"views":[{"Name":"A","Conf":"High","View":"Negative"}, {"Name":"B","Conf":"Low","View":"Negative"}, {"Name":"C","Conf":"Low","View":"Negative"}]}'

structData = jsondecode(jsonData);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Florian Bidaud 2023-8-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2008867-convert-json-to-table-and-query-specific-value#answer_1287872

编辑：Florian Bidaud 2023-8-15

在 MATLAB Online 中打开

jsonData = '{"views":[{"Name":"A","Conf":"High","View":"Negative"}, {"Name":"B","Conf":"Low","View":"Negative"}, {"Name":"C","Conf":"Low","View":"Negative"}]}'
jsonData = '{"views":[{"Name":"A","Conf":"High","View":"Negative"}, {"Name":"B","Conf":"Low","View":"Negative"}, {"Name":"C","Conf":"Low","View":"Negative"}]}'
structData = jsondecode(jsonData)
structData = struct with fields:
    views: [3×1 struct]
structDataTable = struct2table(structData.views)
structDataTable = 3×3 table
    Name       Conf          View    
    _____    ________    ____________

    {'A'}    {'High'}    {'Negative'}
    {'B'}    {'Low' }    {'Negative'}
    {'C'}    {'Low' }    {'Negative'}
structDataTable.Name
ans = 3×1 cell array
    {'A'}
    {'B'}
    {'C'}
structDataTable.Conf{[structDataTable.Name{:}]=='C'}
ans = 'Low'

8 个评论
显示 6更早的评论隐藏 6更早的评论

Florian Bidaud 2023-8-16

编辑：Florian Bidaud 2023-8-16

在 MATLAB Online 中打开

when you affect your value, first check if it's empty or not:

if ~isempty(structDataTable.Conf{strcmp([structDataTable.Name(:)],'Cat')})
    value = structDataTable.Conf{strcmp([structDataTable.Name(:)],'Cat')};
else
    value = nan;
end