I have complex JSON data and I am creating a table from this data. I can get all values clearly.
But I want to remove or hide a row if all data is zero. In my case, if my counter is 5 then I should remove ‘title’ and ‘values’
I created a function for that but I cannot remove the line. How can I do it?
for data1 in financial_balance:
for data2,key in data1.items():
if isinstance(key, str) != True:
for k in key:
for l,d in k.items():
if isinstance(d, str) != True:
for x in d:
count1 = 0
counter = 0
for e in x["values"]:
count1 += 1
if e["value"] == 0:
counter += 1
if counter == 5:
# remove row
my data:
[
{
'name': 'Balance Sheet',
'dataList': [
{
'mainEntry': 'Assets',
'titles': [
{
'title': 'Trade',
'values': [
{
'yea r': 2020,
'value': 268057,
'colorCode': None
},
{
'year': 2019,
'value': 421621,
'colorCod e': None
},
{
'year': 'Year over year trends 2019 vs 2020',
'value': -0.36,
'colorCode': None
},
{
'year': 'Common Size Analysis 2020',
'value': 0.12,
'colorCode': None
},
{
'year': 'Common Size Analysis 2019',
'value': 0.14,
'colorCode': None
}
]
},
{
'title': 'Inventories ',
'values': [
{
'year': 2020,
'value': 0,
'colorCode': None
},
{
'year': 2019,
'value': 0,
'colorCode': None
},
{
'year': 'Year over year trends 2019 vs 2020',
'value': 0,
'colorCod e': None
},
{
'year': 'Common Size Analysis 2020',
'value': 0,
'colorCode': None
},
{
'year': 'Common Size Analysis 2019',
'value': 0,
'colorCode': None
}
]
}
},
>Solution :
You can use the del keyword to delete dictionary keys from a dictionary. For example, del x[e]["value"] .