I am new here , need some help with writing to json file:
I have a dataframe with below values, which is created by reading a excel file
need to write this to json file with object as column dtls
Output :
-
If you have a specific issue while solving this yourself you can ask here with your code.Michael Butscher– Michael Butscher2023-02-14 09:18:00 +00:00Commented Feb 14, 2023 at 9:18
-
Show JSON and other textual information as properly formatted text in the question, not as comment, image or external link.Michael Butscher– Michael Butscher2023-02-14 09:19:53 +00:00Commented Feb 14, 2023 at 9:19
Add a comment
|
2 Answers
A similar task is considered in the question:
Converting Excel into JSON using Python
Different approaches are possible to solve this problem.
Comments
I hope, it works for your solution.
import pandas as pd
import json
df = pd.read_excel('./TfidfVectorizer_sklearn.xlsx')
df.to_json('new_file1.json', orient='records') # excel to json
# read json and then append details to it
with open('./new_file1.json', 'r') as json_file:
a = {}
data = json.load(json_file)
a['details'] = data
# write new json with details in it
with open("./new_file1.json", "w") as jsonFile:
json.dump(a, jsonFile)
JSON Output:
2 Comments
Techie
i am not able to get an object name in the output .for example "Details" is missing in the final output
Muhammad Ali
Kindly look at my updated code