擅长:python、mysql、java
<p>您可以编写一个函数,然后将其应用于列</p>
<pre class="lang-py prettyprint-override"><code>def lookup(parent_id):
while True:
# find the row where ID is equal to the parent_id
temp = df[df[‘ID’]==parent_id]
# check if iscreated is 0, return the parent_id if it is 0
if temp[‘IsCreated’][0]==0:
return parent_id
# at this point, iscreated must be 1, so now we set parent_id to the ParentID in this row and do it again until we find iscreated is 0.
parent_id = temp[‘ParentID’]
df[‘OGParentID’] = df[‘ParentID’].apply(lookup)
</code></pre>
<p>此代码将获取每个ParentID并将其提供给函数<code>lookup</code></p>
<p>函数<code>lookup</code>根据OP的要求执行以下操作:</p>
<ol>
<li>查找ID等于给定父项ID的行</li>
<li>检查iscreated是否为0。如果是,则返回此行的ParentID</li>
<li>如果没有,请将parent_id设置为此行的ParentID,并重复步骤1</li>
</ol>