In this tutorial I will show you how to convert csv to json in python.
To convert csv to json:
we have to import csv and json packages. Use csv.DictReader() to read the lines of the csv file and then add to the array. To convert object to the JSON string using json.dumps() and write to JSON String to json file.
CODE:
import csvimport jsonjsonArr = []with open('shampoo_sales.csv', encoding='utf-8') as csvfile:csvReader = csv.DictReader(csvfile)for row in csvReader:jsonArr.append(row)with open('shampoo_sales.json', 'w', encoding='utf-8') as jsonfile:jsonString = json.dumps(jsonArr, indent=4)jsonfile.write(jsonString)
OUTPUT:
Post your comments / questions
Recent Article
- 'ionic' is not recognized as an internal or external command
- OSError: cannot open resource - Python
- Python read file line count
- How to Encode & Decode using Base64 in Python?
- Unspecified error-The function is not implemented. Rebuild the library with Windows, GTK+ 2.x or Cocoa support.
- How to generate a Captcha verification code image with Python?
- How to show an image using path python PIL?
- How to remove Background from the images using Python?
Related Article