擅长:python、mysql、java
<p>或者,考虑到您的“评论问题”(如果您不一定要像n1colas.m的回答那样使用pandas),使用字符串替换和
只需使用以下命令循环您的文件:</p>
<pre><code>with open("modified_file.csv","w") as of:
with open("report.csv", "r") as inf:
for line in inf:
if "#" not in line: # in the case your csv file has a comment marker somewhere and it is called #, the line is skipped, which means you get a clean comma separated value file as the outfile- if you do want to keep such lines simply remove the if condition
mystring=line.replace(", ,","not_found").replace("data","input") # in case it is not only one blank space you can also use the regex for n times blank space here
print(mystring, file=of, end=""); # prints the replaced line to outfile and writes no newline
</code></pre>
<p>我知道这不是最有效的方法,但可能是一种你很容易理解你在做什么,并且能够根据你内心的愿望修改的方法。
对于任何大小合理的csv文件,它仍然应该几乎在瞬间工作。
此外,出于测试目的,始终使用单独的文件(of)进行替换,而不是像您的问题所述的那样写入填充文件。检查它是否符合你的要求。然后才覆盖你的填充。一开始这似乎不必要,但会发生错误</p>