使用带escapechar的Pandas将csv转换为tsv

Question

我有一个示例csv文件包含

col1
"hello \n
world"
"the quick \njump
\n \r \t brown fox"

转换为tsv的示例代码

import pandas as pd
df = read_csv(r'a.csv')

df.to_csv('data.tsv', sep='\t', encoding='utf-8', escapechar='\n')

预期结果将是

col1
"hello \n world"
"the quick \njump \n \r \t brown fox"

但结果是

col1
"hello \n
world"
"the quick \njump
\n \r \t brown fox"

Answer 1

在阅读csv时使用escapechar对我来说很有效。但它在转换为tsv时跳过了双引号

df = pd.read_csv(r'a.csv', escapechar='\n')

df.to_csv('data.tsv', sep='\t', encoding='utf-8', index=False)

输出：

col1
hello \nworld
the quick \njump\n \r \t brown fox