The below example code demonstrates how to convert a CSV file to a JSON file in Python using the Dataframe.to_json() method. Since the Dataframe.to_json() method takes a DataFrame as input, we will use the pandas.readcsv() method to first read the CSV file as DataFrame.

The orient argument is useful to specify how we want our JSON string to be formatted, and there are various options for both Series and DataFrame input.

If no path is provided, the method returns the JSON string as output and returns nothing if the path is provided. The Dataframe.to_json(path, orient) method of the Pandas module, takes DataFrame and path as input and converts it into a JSON string, and saves it at the provided path. Note that we use the 'w' mode to open the file for writing, which will create a new file if it doesn’t exist or overwrite the contents of an existing file. Finally, we write the JSON data to a file using the jsonfile.write() method. With open( 'myfile.json', 'w') as file_json:Ĭonvert CSV File to JSON File in Python Using the Dataframe.to_json() Method in Python We then use the json.dumps() function to convert this list of dictionaries into a JSON-formatted string. Output: data.json Conversion 100.000 rows completed successfully in 0.Reader = csv. 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.To convert CSV to JSON in Python, follow these steps:

Convert csv to json python