从CSV文件的字段中删除嵌入的换行符

Question

我有一个CSV文件，其中一行被拆分为多行

源文件内容包括：

"ID","BotName"
"1","ABC"
"2","CDEF"
"3","AAA
XYZ"
"4",
"ABCD"

正如我们所看到的，id 3和4被拆分为多行。那么，Python中有没有办法将这些行与前一行连接起来

期望输出：

"ID","BotName"
"1","ABC"
"2","CDEF"
"3","AAAXYZ"
"4","ABCD"

这是我的代码：

data = open(r"C:\Users\suksengupta\Downloads\BotReport_V01.csv","r")

Answer 1

看起来CSV文件的内容字段中嵌入了控制字符。如果是这种情况，则需要将它们去掉，以便将每个字段内容打印在一起

考虑到这一点，类似这样的方法可以解决问题：

import re

src = r'C:\Users\suksengupta\Downloads\BotReport_V01.csv'

with open(src) as f:
    data = re.sub(r'([\w|,])\s+', r'\1', f.read())

print(data)

上述代码将导致以下输出打印到控制台：

"ID","BotName"
"1","ABC"
"2","CDEF"
"3","AAAXYZ"
"4","ABCD"