Python

How to convert csv file to Json file in Python?

How to convert csv file to Json file in Python?, someone asked me to explain?
By:

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 csv
import json

jsonArr = []

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:


json file generated

Related Article

Post your comments / questions



Recent Article