txt文件转换为csv文件 :使用两种方法(代码如下)
import jsonimport pandas as pdimport csvdef json_to_dict(content_str):'''txt文件读取的字符串,使用json加载,占用内存少:param txt_path::return:'''content_dict = json.loads(content_str)return content_dictdef dict_to_csv_fir(content_dict):'''字典文件转换为csv文件(方法1:pandas 直接转) 假设字典为{"a":1,"v":2}:param content_dict::return:'''df_list = []for key in content_dict:df_list.append((key, content_dict[key]))df = pd.DataFrame(df_list, columns=['colA', 'colB'])df.to_csv('aa.csv', index=False)def dict_to_csv_sec(content_dict):'''字典文件转换为csv文件(方法二:使用Python自带的csv函数生成csv文件):param content_dict::return:'''with open('aa.csv', 'w+', newline='', encoding='utf-8') as csvfile:writer = csv.writer(csvfile)for content in content_dict:writer.writerow([content,content_dict[content]])if __name__ == "__main__":txt_path = ""f = open(txt_path, 'r')content_str = f.read()#字符串转换为字典content_dict = json_to_dict(content_str)#方法1dict_to_csv_fir(content_dict)#方法2dict_to_csv_sec(content_dict)