How to convert CSV file to multiline JSON?

by

The problem with your desired output is that it is not valid json document,; it’s a stream of json documents!

That’s okay, if its what you need, but that means that for each document you want in your output, you’ll have to call json.dumps.

Since the newline you want separating your documents is not contained in those documents, you’re on the hook for supplying it yourself. So we just need to pull the loop out of the call to json.dump and interpose newlines for each document written.

import csv
import json

csvfile = open('file.csv', 'r')
jsonfile = open('file.json', 'w')

fieldnames = ("FirstName","LastName","IDNumber","Message")
reader = csv.DictReader( csvfile, fieldnames)
for row in reader:
    json.dump(row, jsonfile)
    jsonfile.write('\n')

More Related Contents:

  1. How can I convert JSON to CSV?
  2. Convert nested JSON to CSV file in Python
  3. How to convert csv to json in python?
  4. Check if a dictionary contain data true of false, then send a response back
  5. How to add pandas data to an existing csv file?
  6. How to ignore the first line of data when processing CSV data?
  7. Convert JSON string to dict using Python
  8. Is there a memory efficient and fast way to load big JSON files?
  9. Python: json.loads returns items prefixing with ‘u’
  10. Change specific value in CSV file via Python
  11. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  12. How to convert an XML string to a dictionary?
  13. Pandas split column into multiple columns by comma
  14. Remove file after Flask serves it
  15. Loading initial data with Django 1.7 and data migrations
  16. Python load json file with UTF-8 BOM header
  17. Loading JSONL file as JSON objects
  18. What is the difference between json.load() and json.loads() functions
  19. TypeError: unhashable type: ‘dict’, when dict used as a key for another dict [duplicate]
  20. Python Pandas read_csv skip rows but keep header
  21. Loading UTF-8 file in Python 3 using numpy.genfromtxt
  22. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  23. How do I check if a string is valid JSON in Python?
  24. Pandas ParserError EOF character when reading multiple csv files to HDF5
  25. Python Pandas – Read csv file containing multiple tables
  26. Rendering JSON objects using a Django template after an Ajax call
  27. Single versus double quotes in json loads in Python
  28. Get data from Twitter using Tweepy and store in csv file
  29. How to add a new column to the beginning of the rows of a CSV file?
  30. start index at 1 for Pandas DataFrame

Leave a Comment