如何在Python中将CSV转换为JSON [英] How do I covert CSV to JSON in Python
问题描述
我有这个适用于JSON文件的工作代码:
来自烧瓶导入烧瓶的
,jsonify,json
app = Flask(__ name__)
打开('C:/ test .json',encoding =latin-1)为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']#从顶级对象获取数据对象列表
#data是该列表中的单个对象,该对象应具有标识符键
#data_for_id是通过过滤器的对象列表
data_for_id = [数据集中数据的数据如果数据['accessLevel'] == dataset_accessLevel] >
if len(data_for_id)== 0:
引发CustomException('这是我的自定义消息')
返回jsoni fy({'dataset':data_for_id})
如果__name__ =='__ main__':
app.run(debug = True)
关于如何导入CSV文件但首先将其转换为JSON的任何想法,以便我的代码甚至可以使用CSV文件吗?
不,但Google有一些: https://www.google.com/search?q=CSV+file+but+convert+it+to+JSON+python 一> [ ^ ]。
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?
No, but Google has a few: https://www.google.com/search?q=CSV+file+but+convert+it+to+JSON+python[^].
这篇关于如何在Python中将CSV转换为JSON的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!