How to convert CSV file to JSON file using Pandas

0 votes

Hi Guys,

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

Jun 25, 2020 in Python by akhtar
• 38,220 points
4,428 views

1 answer to this question.

0 votes

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.

answered Jun 25, 2020 by MD
• 95,320 points

Related Questions In Python

+1 vote
1 answer

how to convert json to csv or to store in sql

You can convert JSON data to csv ...READ MORE

answered Jul 2, 2018 in Python by Nietzsche's daemon
• 4,260 points
741 views
0 votes
1 answer

How can I convert JSON to CSV?

I am not sure this question is ...READ MORE

answered Oct 1, 2018 in Python by aryya
• 7,440 points
10,265 views
0 votes
5 answers

How to read Pandas csv file with no header?

Use this logic, if header is present ...READ MORE

answered Mar 14, 2020 in Python by Shahabuddin
• 160 points
92,212 views
0 votes
1 answer

How to create blank csv file in pandas?

Try this code: open("User data.csv", 'w') Where User data.csv ...READ MORE

answered Apr 6, 2019 in Python by Will
3,322 views
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 2,483 views
0 votes
1 answer
+5 votes
6 answers

Lowercase in Python

You can simply the built-in function in ...READ MORE

answered Apr 11, 2018 in Python by hemant
• 5,810 points
1,861 views
0 votes
1 answer

How to ignore Headers in S3 bucket CSV file using python?

Hi@durgaraju, You can fetch only the body part. ...READ MORE

answered Dec 29, 2020 in Python by MD
• 95,320 points
493 views
0 votes
1 answer

How to convert sqlite format to CSV format?

Hi@akhtar, If you want to read SQLite format ...READ MORE

answered Feb 11, 2020 in Python by MD
• 95,320 points
1,939 views