python:在csv中使用单反斜杠路径的字符串行

Question

如何使用双反斜杠转换字符串行：

myColumn =
['hot\\gas\\substance\\1',
'hot\\gas\\substance\\2',
'hot\\gas\\substance\\3']

用单反斜杠插入一行字符串：

myColumn=
['hot\gas\substance\1',
'hot\gas\substance\2',
'hot\gas\substance\3']

并将myColumn保存为csv：

myColumn.to_csv(exportPath +'/myColumnNEW.csv', index=False)

谢谢

备注如果我将myColumn保存在.csv中并使用.csv打开它，则在列：这是输出的屏幕截图中会看到双反斜杠

Answer 1

给定的

import csv
import pathlib


my_column = [
    "hot\\\\gas\\\\substance\\\\1",
    "hot\\\\gas\\\\substance\\\\2",
    "hot\\\\gas\\\\substance\\\\3"
]

filepath = "test.csv"

码

with open(filepath, "w", newline="\n") as f:
    writer = csv.writer(f)
    header = ["Count", "Subfolder"]
    writer.writerow(header)
    for i, s in enumerate(my_column):
        writer.writerow((i, s.replace("\\\\", "\\")))

或者，使用pathlib模块：

with open(filepath, "w", newline="\n") as f:
    writer = csv.writer(f)
    header = ["Count", "Subfolder"]
    writer.writerow(header)
    for i, s in enumerate(my_column):
        path = pathlib.PureWindowsPath(s)
        writer.writerow((i, path))

输出

​

​

Answer 2

试试myColumn = [s.replace('\\\\', '\\') for s in myColumn]。这应该将双反斜杠(4个反斜杠文字)替换为单个反斜杠(2个反斜杠文本)。