des=fdf['dd_CONCAT_CHAR_ATP_TARGET'].unique() ddf=pd.DataFrame() for i in des: df1=fdf[fdf['dd_CONCAT_CHAR_ATP_TARGET']==i].reset_index() loop = True for k in range(len(df1)): date = df1.loc[k, 'dd_VALIDITY_DATE'] pathlist = df1.loc[k, 'path'] pathlist = pathlist.split('/') date2 = date pathlistn = pathlist[1:] pa = '/'.join(pathlistn) df1.loc[df1['path'] == pa, 'dd_VALIDITY_DATE'] = date ddf = ddf._append(df1) ddf=ddf.drop(['index'], axis=1)