我想将3列Name_1、Name_2和Name_3合并为一个Name。
下面是新脚本：

import pandas as pd

# Load the CSV file into a Pandas DataFrame
df = pd.read_csv("Test.csv", sep=r'\\t', engine='python')

# Combine cells in a specific column
df['Name'] = df[['Name_1', 'Name_2', 'Name_3']].apply(' '.join, axis=1)

# Save the result to a new CSV file
df.to_csv("Test-new.csv", index=False)

CSV文件示例：https://filehorst.de/d/erbwxyuJ
CSV代码示例（以制表符分隔）：

LFNR    Name_1  Name_2  Name_3  Strasse Plz Ort Telefon Telefax
4       Wxxxxx.xe   KxxxxY- XxY XxxxxxxxxxxY    XxxxxxxxxxxxxxxxxY 25   11111   XxxxxxY 0123-1231230    0123-1231231
24  Fxxxx   Kxxxx Rxxxxxxxxxxxxxxxk xxY Hxxxxxxxxxxxf Xxxx X xx. XX Ix Xxxxxxh 5    0123    KxxxY   012312-12312    012312-123123
25          Bxxxxxxxxxx Kxxxxxx Sxxxxxxxxxxxx Sxxxxx 123    0123    Cxxxxxx 0123 123123 0123 1231231

当我启动脚本时，我得到这个错误：

C:\Users\s.123\Downloads\python>Test3.py
Traceback (most recent call last):
  File "C:\Users\s.123\Downloads\python\Test3.py", line 7, in <module>
    df['Name'] = df[['Name_1', 'Name_2', 'Name_3']].apply(' '.join, axis=1)
                 ~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\s.123\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\frame.py", line 3767, in __getitem__
    indexer = self.columns._get_indexer_strict(key, "columns")[1]
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\s.123\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 5876, in _get_indexer_strict
    self._raise_if_missing(keyarr, indexer, axis_name)
  File "C:\Users\s.123\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py", line 5935, in _raise_if_missing
    raise KeyError(f"None of [{key}] are in the [{axis_name}]")
KeyError: "None of [Index(['Name_1', 'Name_2', 'Name_3'], dtype='object')] are in the [columns]"

我能做些什么来弥补这一点？