擅长:python、mysql、java
<p>使用<code>loc</code>和<code>at</code>的组合来查找目标命中的日期,然后减去日期。你知道吗</p>
<pre><code>df['TargetDate'] = 'NA'
for i, row in df.iterrows():
t = row['Target1']
d = row['Date']
targdf = df.loc[df['Close'] >= t]
if len(targdf)>0:
targdt = targdf.at[0,'Date']
df.at[i,'TargetDate'] = targdt
else:
df.at[i,'TargetDate'] = '0'
df['Diff'] = df['Date'].sub(df['TargetDate'], axis=0)
</code></pre>