Your code has like a sub header. For anyone who wants to get rid of it, use this code: import csv, json csvFilePath = "data.csv" jsonFilePath = "data.js" # Read the CSV and add the data to dictionary ... with open(csvFilePath) as f: reader = csv.DictReader(f) rows = list(reader) # Write data to a JSON file ... with open(jsonFilePath, "w") as f: json.dump(rows, f, indent=4)
Hi... Great coding on conversion of csv to json format.. Well i have a doubt on the output you have got in json format.. Here the numbers cannot be in " ".. also value "True" should be in boolean true, and if there are any cel in your csv file which dosent have any value it should be null. kindly check on this and let me know.. As i used your code to convert my CSV file to Json format. The O/P what i got was not what i was expecting.. My csv file has numbers, boolens, and empty cells... Kindly need help in this regard
Yo, 1. You're so easy to keep up with with a good voice. hah. 2. They add the shebang operator at top which handles which version of Python you want to use. In your case, it will be v3. can add a 2.7 for older versions, but don't use that.
Thanks for watching! Yes, you can access any column via the column name, like: csvRow["column-name"]. So if you want to build out your JSON with only certain columns, then just set those specific properties in your "data" object.
But if I for example have three cols: ID, First Name, Last Name and my for loop Looks as follows: for csvRow in csvReader: ID = csvRow["ID"] csvRow["ID"] = int(csvRow["ID"]) csvRow["Last Name"] = csvRow["Last Name"] data.append(csvRow) It will still insert also the "First Name" column into my "data" object. I`m not really sure where exactly I Need to use the specific properties. Sorry, I´m really struggling with this one. Thanks a lot!
Thank you for watching! Well, the reverse is a bit more tricky and the reason is because CSV data is required to be in a table-like format. Like a 2D array. But JSON data can be any kind of object. So some JSON files simply cannot be converted to CSVs. But if you have a JSON file that CAN definitely be converted to CSV, you would do something like this: 1) Read the JSON file: with open('file.json') as jsonFile: jsonData = json.load(jsonFile) 2) Write the CSV using csv.writer You should be able to access the data from jsonData. You might want to convert it to a 2D array. Then you can write it out using the csv writer. More details here: docs.python.org/3/library/csv.html Hope that helps! Sorry I don't have a specific tutorial video, but I'll consider doing one in the future.
with my program, only the first entry in data is written into the json file. however, the csv file has hundreds of entries. i strictly followed the instructions in vieo. what could be the reason?
Hi, there could be several reasons, but it's difficult to tell without knowing more information. It could be the CSV file is in a format that the script is unable to handle - for example, maybe the line breaks are different than expected, or maybe there are some delimiters getting mixed up. Try stepping through the code as it's reading the file and this may help you identify what's going on.
Hi, good question! In this case, what you should do is first create an array with all of the property names. Then, when you create the csv.DictReader, pass in the property names as the "fieldnames" argument. So, for this video example, you would do this: fieldnames = ["hmid","wid","reflection_period","original_hm","cleaned_hm","modified","num_sentence","ground_truth_category","predicted_category"] with open(csvFilePath) as csvFile: csvReader = csv.DictReader(csvFile, fieldnames=fieldnames) Then everything else should work the same!
😂😂 this guy put a random comment at the top of his python script, from memory no less, which has some random path off somebody's tutorial from years ago probably
