Python、pandas读取和存储json、xlsx、csv文件速度比较

利用原有装饰器函数 @timeit_test(number=3, repeat=3) 进行测试，源代码如下：

    @timeit_test(number=3, repeat=3)
    def t1():
        with open(r'.\stock\stock_pool.json', 'r', encoding='utf-8') as f:
            stock_dict = json.load(f)
        # print(stock_dict['华银电力'], stock_dict['商络电子'])

    with open(r'.\stock\stock_pool.json', 'r', encoding='utf-8') as f:
        stock_dict = json.load(f)        
    @timeit_test(number=3, repeat=3)
    def t2():
        with open(r'.\stock\stock_pool.json', 'w', encoding='utf-8') as f:
            json.dump(stock_dict, f, ensure_ascii=False, indent=4)


    @timeit_test(number=3, repeat=3)
    def t3():
        df = pd.read_excel(r'.\stock\stock_all_code_and_name.xlsx')


    df = pd.read_excel(r'.\stock\stock_all_code_and_name.xlsx')
    &