Remove JSON block based on a condition

Question

I am trying to remove a block based on key - value in json file in python. A snippet of the JSON file is as follow:

[
  {
    "endTime" : "2021-01-21 07:44",
    "artistName" : "Edward Sharpe & The Magnetic Zeros",
    "trackName" : "Home",
    "msPlayed" : 241536
  },
  {
    "endTime" : "2021-01-21 08:48",
    "artistName" : "t.A.T.u.",
    "trackName" : "All The Things She Said",
    "msPlayed" : 186644
  },
  ...
]

What I can't do is remove the "entry" between 2 { } if msPlayed is < 30000 mS. Any suggestions?

Edit: what I tried so far is

import json

obj  = json.load(open("StreamingHistory0.json", encoding= 'utf-8' ))

# Iterate through the objects in the JSON and pop (remove)
# the obj once we find it.
for i in range(len(obj)):
    if obj[i]["msPlayed"] < 29999:
        obj.pop(i)
        break

# Output the updated file with pretty JSON
open("updated-file.json", "w").write(
    json.dumps(obj, sort_keys=True, indent=4, separators=(',', ': '))
)

How about creating a new list and adding all the dicts which don't satisfy the condition? — dumbPotato21, Jan 29 '22 at 16:07
load the json, iterate over list and filter out the elements you don't want to keep. — buran, Jan 29 '22 at 16:07
Please, check [ask]. Edit your question to include all the relevant information. Don't post it in the comments. — buran, Jan 29 '22 at 16:14
Also, I suggest you check https://stackoverflow.com/q/1207406/4046632 — buran, Jan 29 '22 at 16:15

A l w a y s S u n n y · Accepted Answer · 2022-01-29T16:28:09.987

4

A single line with list comprehension should do the trick for you. See https://rextester.com/YNAO67705

expected = [element for element in data if element['msPlayed'] < 30000 ]

Full Code:

import json
data  = json.load(open("StreamingHistory0.json", encoding= 'utf-8' ))

# Iterate through the objects in the JSON and filter                     
expected = [element for element in data if element['msPlayed'] < 30000 ]

# Output the updated file with pretty JSON                                      
open("updated-file.json", "w").write(
    json.dumps(expected, sort_keys=True, indent=4, separators=(',', ': '))
)

edited Jan 29 '22 at 16:28

answered Jan 29 '22 at 16:18

A l w a y s S u n n y

36,497
8
60
103

yes, but if i load the json from disk... how could i solve this? – Shadows1996 Jan 29 '22 at 16:24
Added full working code that reads from disk, filter and write back to disk on another file. – A l w a y s S u n n y Jan 29 '22 at 16:27

Remove JSON block based on a condition

1 Answers1