日常笔记之 txt文件转csv文件

0719 txt文件转csv

method1

 a=list(csv.reader(open('a.txt', 'r'), delimiter='\t'))
 df=pd.DataFrame(a)
df.to_csv("res.csv")

method2

 with open('a.txt', 'r') as infile, open('t.csv', 'w') as outfile:
            stripped = (line.strip() for line in infile)
            lines = (line.split(",") for line in stripped if line)
            writer = csv.writer(outfile)
            writer.writerows(lines)
        df=pd.read_csv("t.csv",sep='\t',header=None)
        df=df.fillna("")
        print(df)

method3

  in_txt = csv.reader(open('a.txt', "r"), delimiter='\t')
  out_csv = csv.writer(open('ttt.csv', 'w'))
out_csv.writerows(in_txt)