csv 格式化 json文件

csv转json

csv 文件示例

dishes_id,dish_name,早餐,中餐,晚餐,加餐,米饭,面食或面点,粗粮,热菜,凉菜,汤,点心,蒸,炒,烧,炖,烩,煨,煎,烤,卤,焖,炸,灼,鲁菜,川菜,粤菜,江苏菜,闽菜,浙江菜,湘菜,徽菜,东北菜,新疆菜,淮扬菜,晋菜,云南菜,西北菜,潮州菜,其他地区特色,酸,甜,苦,辣,咸,水果,乳制品,主食,坚果,面片与挂面,馄饨,蒸或煮的鸡蛋,可煮烂的肉菜,可滤渣的蔬菜汁,白色意大利面,精面做的面包和谷物,牛奶,豆浆,含蔗糖的食物,粥
969855,猪脚姜,0.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0
2350698,苹果醋泡藕片,1.0,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0
2396213,豉油鸡,0.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,1.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0
777765,橙蜜莲藕,1.0,1.0,1.0,1.0,0.0,0.0,0.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,1.0,0.0

json文件示例

{
   
    "total_count": 1000,
    "dishes_list": [{
   
        "dish_id": 3000281,
        "dish_name": "米饭",
        "早餐": 0,
        "中餐": 1,
        "晚餐": 1,
        "加餐": 0,
        "米饭": 1,
        "面食或面点": 0,
        "粗粮": 0,
        "热菜": 0,
        "凉菜": 0,
        "汤": 0,
        "点心": 0,
        "蒸": 0,
        ......
    }]
}

工程结构

完整代码

import json

data_file = "douguo_labels.csv"
target_file = "test.txt"
with open(data_file, 'r', encoding=