Parsing json and searching through it

by

ObjectPath is a library that provides ability to query JSON and nested structures of dicts and lists. For example, you can search for all attributes called “foo” regardless how deep they are by using $..foo.

While the documentation focuses on the command line interface, you can perform the queries programmatically by using the package’s Python internals. The example below assumes you’ve already loaded the data into Python data structures (dicts & lists). If you’re starting with a JSON file or string you just need to use load or loads from the json module first.

import objectpath

data = [
    {'foo': 1, 'bar': 'a'},
    {'foo': 2, 'bar': 'b'},
    {'NoFooHere': 2, 'bar': 'c'},
    {'foo': 3, 'bar': 'd'},
]

tree_obj = objectpath.Tree(data)

tuple(tree_obj.execute('$..foo'))
# returns: (1, 2, 3)

Notice that it just skipped elements that lacked a “foo” attribute, such as the third item in the list. You can also do much more complex queries, which makes ObjectPath handy for deeply nested structures (e.g. finding where x has y that has z: $.x.y.z). I refer you to the documentation and tutorial for more information.

More Related Contents:

  1. Convert JSON string to dict using Python
  2. String to Dictionary in Python [duplicate]
  3. How to merge two json string in Python?
  4. Check if a dictionary contain data true of false, then send a response back
  5. Pandas filtering for multiple substrings in series
  6. Why am I seeing “TypeError: string indices must be integers”?
  7. How to get a string after a specific substring?
  8. Is there a memory efficient and fast way to load big JSON files?
  9. Python: json.loads returns items prefixing with ‘u’
  10. How to convert an XML string to a dictionary?
  11. How do I format a string using a dictionary in python-3.x?
  12. How to split strings into text and number?
  13. ValueError: could not convert string to float: id
  14. How to load all entries in an infinite scroll at once to parse the HTML in python
  15. Find index of last occurrence of a substring in a string
  16. How do I convert a list into a string with spaces in Python?
  17. django-rest-framework 3.0 create or update in nested serializer
  18. Python code to remove HTML tags from a string [duplicate]
  19. How do I send a POST request as a JSON?
  20. Python: How to check a string for substrings from a list? [duplicate]
  21. What is faster – Loading a pickled dictionary object or Loading a JSON file – to a dictionary? [closed]
  22. How to parse a string and return a nested array?
  23. Should I avoid converting to a string if a value is already a string?
  24. How do I put a variable’s value inside a string (interpolate it into the string)?
  25. Getting values from JSON using Python
  26. Pandas read_csv dtype leading zeros
  27. OpenAI GPT-3 API error: “Cannot specify both model and engine”
  28. Python string to unicode [duplicate]
  29. Convert string into Date type on Python [duplicate]
  30. How to use str.contains() with multiple expressions in pandas dataframes

Leave a Comment