read

我知道read_csv()使用逗号(,)作为分隔符，但是我有一个文件，其某些单元格的内容中包含逗号.

I know that read_csv() uses comma (,) as separator but I have a file which some of its cells has comma in their content.

在该文件中，作者使用反斜杠逗号(\,)表示此逗号不是分隔符.

In that file author used backslash comma (\,) to show that this comma is not a separator.

但是当我用read_csv()读取文件时，它将所有逗号都视为分隔符.这是csv文件中的示例行:

But when I read the file with read_csv(), it consider all commas as separator. Here is a sample row in csv file:

我知道应该有n列，因此我逐行读取csv文件并删除多余的逗号和反斜杠逗号.

I know that there should be n columns so I read csv file line by line and remove extra commas and backslash commas.

但是应该有更好的方法.

But there should be better way.

您需要将反斜杠配置为转义字符，并使用 escapechar选项:

You need to configure the backslash as an escape character, with the escapechar option:

演示:

read