擅长:python、mysql、java
<p>尝试:</p>
<pre><code>df["First_date"] = pd.to_datetime(df["First_date"])
df["Second_date"] = pd.to_datetime(df["Second_date"])
df['diff'] = df.apply(lambda x: len(pd.bdate_range(x['Second_date'], x['First_date'], freq="C", weekmask="Mon Tue Wed Thu Fri Sat", closed='right')), axis=1)
print(df)
</code></pre>
<p>输出:</p>
<pre><code> First_date Second_date diff
0 2021-09-18 2021-09-17 1
1 2021-09-22 2021-09-17 4
2 2021-09-27 2021-09-17 8
</code></pre>