python - 如何编写生成一列 csv 文件的 Python 代码？

Question

我有 500000 个数值的 txt 文件。几行

  -938.549927    
  -938.542419    
  -938.534912    
  -938.523621    
  -938.523621    
  -938.512329    
  -938.512329    
  -938.523621    
  -938.519836    
  -938.523621    
  -938.519836    
  -938.508606    
  -938.508606    
  -938.508606    
  -938.519836    
  -938.531128    
  -938.538635   

我想把它保存为 csv 文件。我已经试过了

import csv

lines = [line.rstrip('\n') for line in open('d500.txt')]

myfile = open('n500.csv', 'wb')
wr = csv.writer(myfile, quoting=csv.QUOTE_ALL)
wr.writerow(lines)

我明白了

wc -l n500.csv
1 n500.csv

只是文件的一部分

358337    ","  -938.362061    ","  -938.369568    ","  -938.369568    ","  -938.369568    ","  -938.380859    ","  -938.377075    ","  -938.380859    ","  -938.373352    ","  -938.347046    ","  -938.343262    ","  -938.339539    ","  -938.324524    ","  -938.313232    ","  -938.328247    ","  -938.320740    ","  -938.320740    ","  -938.328247    ","  -938.324524    ","  -938.324524    ","  -938.316956  

我真正想要的是这样的东西

 -938.316956   
 -938.316956   
 -938.313232  

如果我尝试

wr.writerows(lines)

格式很疯狂

" "," ","-","9","3","8",".","3","1","3","2","3","2"," "," "," "," "
" "," ","-","9","3","8",".","3","2","8","2","4","7"," "," "," "," "
" "," ","-","9","3","8",".","3","2","0","7","4","0"," "," "," "," "
" "," ","-","9","3","8",".","3","2","0","7","4","0"," "," "," "," "
" "," ","-","9","3","8",".","3","2","8","2","4","7"," "," "," "," "
" "," ","-","9","3","8",".","3","2","4","5","2","4"," "," "," "," "
" "," ","-","9","3","8",".","3","2","4","5","2","4"," "," "," "," "
" "," ","-","9","3","8",".","3","1","6","9","5","6"," "," "," "," "
" "," ","-","9","3","8",".","3","1","3","2","3","2"," "," "," "," "
" "," ","-","9","3","8",".","3","1","3","2","3","2"," "," "," "," "
" "," ","-","9","3","8",".","3","0","9","4","4","8"," "," "," "," "
" "," ","-","9","3","8",".","3","1","6","9","5","6"," "," "," "," "
" "," ","-","9","3","8",".","3","1","6","9","5","6"," "," "," "," "
" "," ","-","9","3","8",".","3","1","3","2","3","2"," "," "," "," "

我的新代码版本

import csv

lines = [[line.rstrip('\n')] for line in open('d500.txt')]

myfile = open('n500.csv', 'wb')
wr = csv.writer(myfile, quoting=csv.QUOTE_ALL)
wr.writerows(lines)

比我得到的

"  -938.324524    "
"  -938.313232    "
"  -938.328247    "
"  -938.320740    "
"  -938.320740    "
"  -938.328247    "
"  -938.324524    "
"  -938.324524    "
"  -938.316956    "
"  -938.313232    "
"  -938.313232    "
"  -938.309448    "
"  -938.316956    "
"  -938.316956    "
"  -938.313232    "

如何去除引号？

Answer 1

您只需将 .txt 重命名为 .csv(或复制到 .csv 文件)。

因为只有一列，所以不需要 (comma) s符。