You can strip()
Pandas 中的整个系列使用.str.strip() https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.strip.html:
df1['employee_id'] = df1['employee_id'].str.strip()
df2['employee_id'] = df2['employee_id'].str.strip()
这将删除前导/尾随空格employee_id
两者中的列df1
and df2
或者,修改read_csv https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html使用线路skipinitialspace=True https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html#:%7E:text=variants%20of%20%E2%80%9CFalse%E2%80%9D.-,skipinitialspace,-bool%2C%20default%20False
df1 = pd.read_csv('input1.csv', sep=',\s+', delimiter=',', encoding="utf-8", skipinitialspace=True)
df2 = pd.read_csv('input2.csv', sep=',\s,', delimiter=',', encoding="utf-8", skipinitialspace=True)
看起来您正在尝试删除包含数字的字符串中的空格,这可以通过以下方式完成pandas.Series.str.replace https://pandas.pydata.org/docs/reference/api/pandas.Series.str.replace.html:
df1['employee_id'] = df1['employee_id'].str.replace(" ", "")
df2['employee_id'] = df2['employee_id'].str.replace(" ", "")