python - 如何用 Pandas 替换每一列中的目录路径？

Question

我有一个 python 数据框，它有一个文件名列，如下所示:

Filename
/var/www/html/projects/Bundesliga/Match1/STAR_SPORTS_2-20170924-200043-210917-00001.jpg
/var/www/html/projects/Bundesliga/Match1/STAR_SPORTS_2-20170924-200043-210917-00001.jpg

我想用新的目标目录名称替换文件名列中的目录名称。

dst = "/home/mycomp/Images'

我尝试了以下方法:

df['Filename'] = df['Filename'].str.replace(os.path.dirname(df['Filename']), dst)

但我收到以下错误。

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/python2.7/posixpath.py", line 129, in dirname
    i = p.rfind('/') + 1
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 3614, in __getattr__
    return object.__getattribute__(self, name)
AttributeError: 'Series' object has no attribute 'rfind'

Answer 1

df['Filename'] = df['Filename'].apply(lambda x: x.replace(os.path.dirname(x), dst))