一,将文件写入excel
参考:http://www.cnblogs.com/liutongqing/p/6892099.html
import csv
import pandas as pd
#未遇到空行问题,没见newline参数 csvFile2
=
open
(
'csvFile2.csv'
,
'w'
, newline
=
'')
# 设置newline,否则两行之间会空一行
with open("log.csv",'w') as wf2:
wf2.write(codecs.BOM_UTF8) #涉及到输出汉字编码问题需要用到这一句,不涉及汉字的话,一般不需要
spamwriter = csv.writer(wf2)
sort_value=sorted(word_dict,key=word_dict.get,reverse=True) #对字典按值进行排序,返回的是排好序的键的列表
for key in sort_value:
spamwriter.writerow([key,(word_dict[key])]) #将数据写入csv文件
m
=
len
(data)
for
i
in
range
(m):
spanwriter
.writerow(data[i])
'''
二,将多个csv合并到一个excel
参考:http://blog.csdn.net/u012063773/article/details/73882508
basedir ='.' #搜索所在目录下的csv文件
writer =pd.ExcelWriter('test.xlsx') #创建输出文件
filenames=os.listdir(basedir)
print filenames
for filename in filenames:
flist = filename.strip().split('.')
if flist[-1] == 'csv':
fn=flist[0]
data=pd.read_table(filename,sep=',')
data.to_excel(writer,fn,index=False)
writer.save()