How to convert CSV file to JSON file using Pandas

Question

Hi Guys,

I have one CSV file. I want to convert this file into JSON format. How can I do this?

Answer 1

Hi@akhtar,

You can convert your CSV file to JSON format using Pandas. In Pandas, you can find the to_json function. It will help you to do your task. I have attached one example for your reference.

import pandas as pd
data = pd.read_csv('my.csv')

Place,State
Kolkata,WestBengal
Delhi,Delhi
Bangalore,Karnataka
Kolkata,WestBengal
Delhi,Delhi

data.to_json(path_or_buf='my.json',orient='records',lines=True)

{"Place":"Kolkata","State":"WestBengal"}
{"Place":"Delhi","State":"Delhi"}
{"Place":"Bangalore","State":"Karnataka"}
{"Place":"Kolkata","State":"WestBengal"}
{"Place":"Delhi","State":"Delhi"}

I hope this will help you.