擅长:python、mysql、java
<pre><code>df = pd.merge(df1, df0,on='TableIndex')
for index, row in df.iterrows():
pidx = row.ParentIndex
table_names = [row.TableName,row.FieldName]
while pidx!=-1:
p_row = df0[df0['TableIndex']==pidx]
insert_name = p_row.TableName.iloc[0]
table_names.insert(0, insert_name)
pidx = p_row.ParentIndex.iloc[0]
df.at[index, "ConcatName"] = ".".join(table_names)
print(df[['TableIndex','ParentIndex','FieldIndex','FieldName','ConcatName']])
</code></pre>