使用Python编辑CSV文件

Question

我对Python和编程很陌生，所以请简单解释一下。我试图更改CSV文件，但总是出现错误，如何修复？

代码：

import pandas as pd
with pd.read_csv ('D:  P  Python projects  correct CSV  test.csv') as file
if "\" in file:
betterfile = file.replace ("\", "/")
print (betterfile)```
Error:
Traceback (most recent call last):
File "C:  Users  Vinstand YT  AppData  Local  Programs  Python  Python39  lib  runpy.py", line 197, in _run_module_as_main
return _run_code (code, main_globals, None,
File "C:  Users  Vinstand YT  AppData  Local  Programs  Python  Python39  lib  runpy.py", line 87, in _run_code
exec (code, run_globals)
File "c:  Users  Vinstand YT  .vscode  extensions  ms-python.python-2021.6.944021595  pythonFiles  lib  python  debugpy  __ main__.py", line 45, in <module>
cli.main ()
File "c:  Users  Vinstand YT  .vscode  extensions  ms-python.python-2021.6.944021595  pythonFiles  lib  python  debugpy / ..  debugpy  server  cli.py", line 444, in main
run()
File "c:  Users  Vinstand YT  .vscode  extensions  ms-python.python-2021.6.944021595  pythonFiles  lib  python  debugpy / ..  debugpy  server  cli.py", line 285, in run_file
runpy.run_path (target_as_str, run_name = compat.force_str ("__ main__"))
File "C:  Users  Vinstand YT  AppData  Local  Programs  Python  Python39  lib  runpy.py", line 267, in run_path
code, fname = _get_code_from_file (run_name, path_name)
File "C:  Users  Vinstand YT  AppData  Local  Programs  Python  Python39  lib  runpy.py", line 242, in _get_code_from_file
code = compile (f.read (), fname, 'exec')
File "d:  P  Python Projects  Correct CSV  Project CSV corrector.py", line 3
with pd.read_csv ('D:  P  Python Projects  Correct CSV  test.csv') as file
^
SyntaxError: invalid syntax

Answer 1

您混淆了两种不同的读取csv文件的方法。

1. pd.read_csv
2. open

pd.read_csv用于将文件读取到pandas.DataFrame

出于您的目的，您可以坚持使用open:

with open('D:PPython projectscorrect CSV test.csv') as file:
contents = file.read()
if "\" in contents:
betterfile = file.replace("\", "/")