Azeez Aremu
Django way

Django way

CSV files to JSON

CSV files to JSON

Azeez Aremu's photo
Azeez Aremu

Published on Jul 1, 2021

1 min read

Subscribe to my newsletter and never miss my upcoming articles

Hey there, welcome, so you are not comfortable with your data being in .csv format due to the fact that

  • It can't present the data relationship very well merely looking at the data
  • It occupies high storage space
  • It is not so easy to work with at a high scale etc...

But you are told to use JSON as it takes away all the worries given to you by the CSV file. So here I will show you how you can convert your CSV file to a JSON file in python.

CSV File

Screenshot (125).png

import json
import csv


def csv_to_json(csv_file_path, json_file_path):
    jsonArray = []
    #open the csv file
    with open(csv_file_path, encoding='utf-8') as csvfile:

        #Use csv file reader to read it

        csv_reader = csv.DictReader(csvfile)

        #convert and store the file into python dictionary

        for row in csv_reader:
            jsonArray.append(row)

        #write to a json file
        with open(json_file_path, 'w', encoding='utf-8') as jsonfile:
            jsonGotten = json.dumps(jsonArray, indent = 4)
            jsonfile.write(jsonGotten)

        return jsonGotten

result = csv_to_json('put csv file path', 'put json file path')

Result JSON File

Screenshot (126).png

Enjoy!!!

 
Share this