问题:
在使用python将数据导出到csv文件中,发现一些有效信息由于位数过长,被显示为科学计数显示了
import csv
aaaa = 12345647784654541514
bbbb = 15645478746135446879
cccc = 12345786
csvfile = open('test.csv', 'w', newline='')
writer = csv.writer(csvfile, delimiter=',')
keys = ("key")
writer.writerow([keys])
writer.writerow([aaaa])
writer.writerow([bbbb])
writer.writerow([cccc])
csvfile.close()
解决办法:
把这个字段转变为字符串,并且在后面加上看不见的字符"\t"就可以了
import csv
aaaa = 12345647784654541514
bbbb = 15645478746135446879
cccc = 12345786
aaaa1 = str(aaaa)+"\t"
bbbb1 = str(bbbb)+"\t"
csvfile = open('test.csv', 'w', newline='')
writer = csv.writer(csvfile, delimiter=',')
keys = ("key")
writer.writerow([keys])
writer.writerow([aaaa1])
writer.writerow([bbbb1])
writer.writerow([cccc])
csvfile.close()