JSON TO CSV

Prathap Reddy

I everyone , i have one quetion regarding python.

" we have to get the Json file from other sources and that json file has to update on python and that will be converted in the CSV format"

note that, that code must be run successfully.

i need source code , will you please help me anyone.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain3y ago

Accepted answer

import json
import csv

# Read the JSON file
with open('input.json', 'r') as json_file:
    json_data = json.load(json_file)

# Update the JSON data as needed
# For example, let's add a new key-value pair
json_data['new_key'] = 'new_value'

# Convert JSON to CSV
csv_data = []
for item in json_data:
    csv_data.append([item, json_data[item]])

# Write CSV data to a file
with open('output.csv', 'w', newline='') as csv_file:
    writer = csv.writer(csv_file)
    writer.writerows(csv_data)

print("Conversion successful. JSON file is converted to CSV.")

Subarta Ray2y ago
Use the requests library to fetch the JSON file. Then, manipulate and update the data in Python. Finally, leverage the csv module to convert and save the updated data as a CSV file. Ensure proper error handling and dependencies:

import requests
import json
import csv

response = requests.get('your_json_url')
data = response.json()

# Update and manipulate data as needed

with open('output.csv', 'w', newline='') as csv_file:
writer = csv.writer(csv_file)
writer.writerows(data)

Replace 'your_json_url' with the actual URL of the JSON file.
+1

Deepak Rawat3y ago

import json
import csv
import requests

# Step 1: Retrieve the JSON file from an external source
url = "https://example.com/data.json"  # Replace with the actual URL of your JSON file
response = requests.get(url)
data = response.json()

# Step 2: Update the JSON data (modify as per your requirements)
data["new_key"] = "new_value"  # Example of updating the JSON data

# Step 3: Convert JSON to CSV format
csv_filename = "data.csv"  # Replace with the desired name for your CSV file

with open(csv_filename, "w", newline="") as csvfile:
    writer = csv.writer(csvfile)
    
    # Write CSV header based on the JSON keys
    writer.writerow(data.keys())
    
    # Write CSV rows based on the JSON values
    writer.writerow(data.values())

print("JSON file successfully converted.")

Janarthanan S3y ago

Using Pandas package

# Convert a JSON File to a CSV File

import pandas as pd
df= pd.read_json('sample.json')
df.to_csv('file.csv')

Second method

# Convert a JSON String to CSV Using Python

import csv
import json
json_string = '[{"Name": "Nik", "Age": 30, "Active": true}, {"Name": "Kate", "Age": 32, "Active": true}, {"Name": "Evan", "Age": 45, "Active": false}, {"Name": "Kyra", "Age": 43, "Active": true}]'
data = json.loads(json_string)
headers = data[0].keys()
with open('file.csv', 'w') as f:
writer = csv.DictWriter(f, fieldnames=headers)
writer.writeheader()
writer.writerows(data)