How can I convert JSON to CSV?

by

With the pandas library, this is as easy as using two commands!

df = pd.read_json()

read_json converts a JSON string to a pandas object (either a series or dataframe). Then:

df.to_csv()

Which can either return a string or write directly to a csv-file. See the docs for to_csv.

Based on the verbosity of previous answers, we should all thank pandas for the shortcut.

For unstructured JSON see this answer.

EDIT:
Someone asked for a working minimal example:

import pandas as pd

with open('jsonfile.json', encoding='utf-8') as inputfile:
    df = pd.read_json(inputfile)

df.to_csv('csvfile.csv', encoding='utf-8', index=False)

More Related Contents:

  1. Split / Explode a column of dictionaries into separate columns with pandas
  2. How to convert CSV file to multiline JSON?
  3. flattening nested Json in pandas data frame
  4. How to json_normalize a column with NaNs
  5. Convert nested JSON to CSV file in Python
  6. How to convert csv to json in python?
  7. How to read a single object from a json file containing multiple objects using python? [closed]
  8. How to prettyprint a JSON file?
  9. Load CSV file with Spark
  10. how to import csv data into django models
  11. How I can I lazily read multiple JSON values from a file/stream in Python?
  12. Creating a dictionary from a CSV file
  13. How to append data to a json file?
  14. How to dump a dict to a JSON file?
  15. Pickle or json?
  16. How to remove duplicates from a csv file
  17. selecting across multiple columns with python pandas?
  18. Streaming large training and test files into Tensorflow’s DNNClassifier
  19. Not able to parse a .csv file uploaded using Flask
  20. Python read csv – BOM embedded into the first key
  21. Saving UTF-8 texts with json.dumps as UTF-8, not as a \u escape sequence
  22. How to skip the headers when processing a csv file using Python?
  23. Convert numpy type to python
  24. Converting images to csv file in python
  25. How to customise error response in FastAPI?
  26. Accessing dictionary by key in Django template
  27. convert csv file to list of dictionaries
  28. Rendering JSON objects using a Django template after an Ajax call
  29. Single versus double quotes in json loads in Python
  30. Get data from Twitter using Tweepy and store in csv file

Leave a Comment