Python 生成json

import json
import os
import pandas as pd

dict_color = {'Key1':"#ff0000", 'Key2':"#ff0000", 'Key3':"#ff0000"
            }
dict_name = {'Key1':"name1", 'Key2':"name2",'Key3':"name3"
            }
def generate_list(work_path):
    '''
    params work_path: files path that needs to be converted
    to do           : generate dataframe from all stl files
    return          : pd 
    '''
    record = pd.DataFrame(columns = ['color', 'title', 'stl'])
    stl_list = os.listdir(work_path)
    for stl in stl_list:
        if stl.split('.')[-1] == 'stl':
            df = pd.DataFrame({
                'color': dict_color[stl.split('.')[0]], 
                'title': dict_name[stl.split('.')[0]],
                'stl': stl,
            },index=[0])
        record = record.append(df)
    # record.to_csv(os.path.join(work_path, 'json.csv'))
    return record

def generate_json(work_path):
    '''
    params work_path: files path that needs to be converted
    to do           : save pd to json as rules
    return          : None
    '''
    jsontext = {'Myjson_file':[]}
    record = generate_list(work_path)
    for index,row in record.iterrows():
        jsontext['Myjson_file'].append({'color':row['color'], 'title':row['title'], 'stl':row['stl']})
    jsondata = json.dumps(jsontext,indent=4,separators=(',', ': '))
    f = open(os.path.join(work_path, 'MyFirst.json'), 'w')
    f.write(jsondata)
    f.close()

if __name__ == '__main__':
    root_path = r'D:\xx\model'
    generate_json(root_path)
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值