How do I covert CSV to JSON in Python

See more:

Python

convert

JSON

CSV

I have this working code that works with JSON files:



from flask import Flask, jsonify, json

app = Flask(__name__)

with open('C:/test.json', encoding="latin-1") as f:
alldata = json.loads(f.read())

@app.route('/api/PDL/<string:dataset_accesslevel xmlns:string="#unknown">', methods=['GET'])
def get_task(dataset_accessLevel):
dataset = alldata['dataset'] # Gets the list of data objects from top level object
# data is a single object in that list, which should have an identifier key
# data_for_id is the list of objects passing the filter
data_for_id = [data for data in dataset if data['accessLevel'] == dataset_accessLevel]
if len(data_for_id) == 0:
raise CustomException('this is my custom message')
return jsonify({'dataset': data_for_id})

if __name__ == '__main__':
app.run(debug=True)



Any idea on how to import a CSV file but convert it to JSON first so my code would work even with CSV files?