Loading JSONL file as JSON objects

by

Full steps including file operations for beginners like me

Assuming you have a .jsonl file like:

{"reviewerID": "A2IBPI20UZIR0U", "asin": "1384719342", "reviewerName": "cassandra tu \"Yeah, well, that's just like, u...", "helpful": [0, 0], "reviewText": "Not much to write about here, but it does exactly what it's supposed to. filters out the pop sounds. now my recordings are much more crisp. it is one of the lowest prices pop filters on amazon so might as well buy it, they honestly work the same despite their pricing,", "overall": 5.0, "summary": "good", "unixReviewTime": 1393545600, "reviewTime": "02 28, 2014"}
{"reviewerID": "A14VAT5EAX3D9S", "asin": "1384719342", "reviewerName": "Jake", "helpful": [13, 14], "reviewText": "The product does exactly as it should and is quite affordable.I did not realized it was double screened until it arrived, so it was even better than I had expected.As an added bonus, one of the screens carries a small hint of the smell of an old grape candy I used to buy, so for reminiscent's sake, I cannot stop putting the pop filter next to my nose and smelling it after recording. :DIf you needed a pop filter, this will work just as well as the expensive ones, and it may even come with a pleasing aroma like mine did!Buy this product! :]", "overall": 5.0, "summary": "Jake", "unixReviewTime": 1363392000, "reviewTime": "03 16, 2013"}

This code should work:

import json

with open('./data/my_filename.jsonl', 'r') as json_file:
    json_list = list(json_file)

for json_str in json_list:
    result = json.loads(json_str)
    print(f"result: {result}")
    print(isinstance(result, dict))

About .jsonl files:
http://jsonlines.org/

More Related Contents:

  1. Loading and parsing a JSON file with multiple JSON objects
  2. How to read a single object from a json file containing multiple objects using python? [closed]
  3. Why can’t Python parse this JSON data? [closed]
  4. Split / Explode a column of dictionaries into separate columns with pandas
  5. How do I write JSON data to a file?
  6. How to get string objects instead of Unicode from JSON?
  7. Single vs double quotes in JSON
  8. Reading rather large JSON files [duplicate]
  9. How to JSON serialize sets?
  10. Items in JSON object are out of order using “json.dumps”?
  11. json.dumps vs flask.jsonify
  12. Python/Json:Expecting property name enclosed in double quotes
  13. Python read JSON file and modify
  14. How to get JSON from webpage into Python script
  15. Python’s json module, converts int dictionary keys to strings
  16. Deserialize a json string to an object in python
  17. Why is json.loads an order of magnitude faster than ast.literal_eval?
  18. TypeError: the JSON object must be str, not ‘bytes’
  19. Why does my text file keep overwriting the data on it?
  20. Saving UTF-8 texts with json.dumps as UTF-8, not as a \u escape sequence
  21. How to parse somewhat wrong JSON with Python?
  22. Convert numpy type to python
  23. How to customise error response in FastAPI?
  24. Accessing dictionary by key in Django template
  25. Can json.loads ignore trailing commas?
  26. Displaying better error message than “No JSON object could be decoded”
  27. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  28. Create a Pandas DataFrame from deeply nested JSON
  29. SQLAlchemy: filtering on values stored in nested list of the JSONB field
  30. How to convert csv to json in python?

Leave a Comment