擅长:python、mysql、java
<p>你可以做:</p>
<pre><code>#creating a dictionary "x" to have all the unique parent-child relationships using comprehension
x={i:int(j) for i,j in zip(df['ID'],df['ParentID'].fillna(df['ID']))}
#assigning ID to the new column
df['OGParentID']=df['ID']
#loop to replace the dict items ,i.e, replacing all the childs with parents
#counter is limited to the length of unique elements in dict
i=0
while i<=len(x):
df['OGParentID']=df['OGParentID'].replace(x)
i+=1
Output:
ID IsCreated ParentID OGParentID
0 101 0 NaN 101
1 102 1 101.0 101
2 103 0 NaN 103
3 104 1 102.0 101
4 105 1 104.0 101
</code></pre>