![]() Print(f"Conversion 100.000 rows completed successfully in seconds") JsonString = json.dumps(jsonArray, indent=4) With open(jsonFilePath, 'w', encoding='utf-8') as jsonf: #convert python jsonArray to JSON String and write to file ![]() #load csv file data using csv library's dictionary reader With open(csvFilePath, encoding='utf-8') as csvf: For the test I made 100.000 lines in a csv file with copy/paste, and the whole conversion takes about half a second with Apple's M1 Chip while the presented example took only 0.0005 seconds.ĭef csv_to_json(csvFilePath, jsonFilePath):.You may write the JSON String to a JSON file. ![]() Convert the Python List to JSON String using json.dumps().Add the dictionary to the Python List created in step 1. Read the lines of CSV file using csv.DictReader() function.How do I fix this.To convert CSV to JSON in Python, follow these steps: So, here I did got my answer but instead of printing it once, It is printing 7 times. Output userID,Is salary credited before 5th,Avg Salary of last 3 months,Avg Salary of last 6 months,Avg Balance before salary of last 3 months,Avg Balance before salary of last 6 monthsĦ79d3bad-155e-4b39-9ff7-7d564f408942,Yes,15453.33,15290.5,113.15,105.22 Following is my json file input Ĭode with open('/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.json', "r") as f:į = csv.writer(open("/Users/vrindabv/Documents/PycharmProjects/BankStatementEngine/test.csv", "w"))į.writerow()į.writerow(, x,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |