使用python可以很方便的将数据写入到csv文件中。
import csv
file = open('bigGramMatrixWashed.csv', 'w+')
writer = csv.writer(file)
writer.writerow(['id', 'word1', 'word2', 'num'])
biGramMatirxTextFilePath = "/biGramMatrix.txt"
biGramMatrixText = open(biGramMatirxTextFilePath,'r')
lines = biGramMatrixText.readlines();
for line in lines:
try:
linedata = line.split("-")
# print id, linedata[0], linedata[1]
data = ([id, linedata[0], linedata[1].split("\r\n")[0]])
except Exception, e:
print e
file.close()
biGramMatrixText.close()
python 读取csv文件忽略第一行。
from itertools import islice
input_file = open("C:\\Python34\\test.csv")
for line in islice(input_file, 1, None):
do_readline()