# -*- coding: utf-8 -*-
"""
Created on Sat May  8 11:19:06 2021

@author: Administrator
"""

import os
import pandas as pd


path = 'd:/5G竞赛题库/'
os.chdir(path)

files = os.listdir()
for file in files:
    with open(file) as f:
        content = f.read()
        dict_tmp = eval(content)
        df_tmp = pd.DataFrame(dict_tmp)
        with pd.ExcelWriter(file.replace('.txt','.xlsx')) as f:
            df_tmp.to_excel(f, index =False)