I am a novice with MDB and json in general. I am receiving an output that is a heavily nested json. The structure is like the example schema below.
I am finding it very difficult to query and summarize the data for vizualization. Would you recommend to have the file structure completely reformatted or would a query be an effective way of “flattening” this data? There can be up to 100 objects nested within “articleBody_anno”.
I apologize if this question is incoherent. I do not have a computer science or data background and am learning as I go.
"items": [
{
"type": "object",
"properties": {
"algorithmVersion": {
"type": "string"
},
"article": {
"$ref": "#/definitions/article"
},
"articleBody_Description_summarized": {
"type": "array",
"items": {
"type": "string"
}
},
"articleBody_anno": {
"type": "array",
"items": [
{
"type": "object",
"properties": {
**"entities": {**
"type": "array",
"items": {
"type": "string"
}
},
"sentence": {
"type": "string"
},
"score": {
"$ref": "#/definitions/score"
}
}
},
{
"type": "object",
"properties": {
"entities": {
"type": "array",
"items": {
"type": "string"
}
},
"sentence": {
"type": "string"
},
"score": {
"$ref": "#/definitions/score-2"
}
}