擅长:python、mysql、java
<p><strong>给定的</strong></p>
<pre><code>import csv
import pathlib
my_column = [
"hot\\\\gas\\\\substance\\\\1",
"hot\\\\gas\\\\substance\\\\2",
"hot\\\\gas\\\\substance\\\\3"
]
filepath = "test.csv"
</code></pre>
<p><strong>代码</strong></p>
<pre><code>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("\\\\", "\\")))
</code></pre>
<p>或者,使用<a href="https://docs.python.org/3/library/pathlib.html" rel="nofollow noreferrer">^{<cd1>}</a>模块:</p>
<pre><code>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))
</code></pre>
<p>输出</p>
<p><a href="https://i.stack.imgur.com/EandS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EandS.png" alt="enter image description here"/></a></p>