Skip to main content
 首页 » 编程设计

python之如何从一行之间删除换行符而不从行尾删除换行符python

2025年05月04日12EasonJim

我的输入是一个大的 csv 文件,其中包含如下行:

"7807371008","Sat Jan 16 00:07:46 +0000 2010","@bigg_robb welcome to the party life of politics","T 33.417474,-86.705343","al","23845121","1381","502","Wed Mar 11 22:38:27 +0000 2009","2468" 

我想要的输出是一个新文件,其中第一列和第三列仅删除了所有特殊字符:

7807371008,  bigg robb welcome to the party life of politics 

但是在文本之间有一些换行符,即使从技术上讲它不是该行的结尾。在这种情况下,我收到错误:

IndexError: list index out of range 

此类行的示例是:

"7807376607","Sat Jan 16 00:07:57 +0000 2010","RT @CBS8News:The commander of Gov. Riley's task 
force on illegal gambling resigns after winning $2,300 at a MS casino. 
gt;#conflictofinterest","Montgomery, Alabama","al","33358058","84","164","Mon Apr 20 00:48:37 +0000 2009","4509" 

我的代码是:

import csv 
import sys 
import re 
 
with open('al.csv') as f: 
    for line in f: 
 
        j = next(csv.reader([line])) 
        id1 = j[0] 
        id2 = re.sub('[^A-Za-z0-9\.]+',' ',id1) 
        tt1 = j[2] 
        tt2 = re.sub('[^A-Za-z0-9\.]+',' ',tt1) 
        print id2.strip()+", "+tt2.lower() 

我该如何解决这个问题?请帮忙。

请您参考如下方法:

您应该将逗号 , 指定为您的 csv 文件分隔符(或基于您的文件的正确分隔符),而且 csv 阅读器对象没有您循环需要访问行的行通过遍历 reader 对象 (spamreader) :

>>> import csv 
>>> with open('al.csv', 'rb') as csvfile: 
...     spamreader = csv.reader(csvfile, delimiter=',') 
...     for row in spamreader: 
            print re.sub('[^A-Za-z0-9\.]+',' ',row[2]) + row[0]