擅长:python、mysql、java
<p>我也找到了一种新的方法。你知道吗</p>
<pre class="lang-py prettyprint-override"><code>print(df)
>>>
Date Name Color
0 2019-07-18 Project1 blue
1 2019-07-18 Project2 blue
2 2019-07-18 Project3 red
3 2019-07-19 Project1 blue
4 2019-07-19 Project2 red
5 2019-07-19 Project3 red
</code></pre>
<p>首先确定日期:</p>
<pre class="lang-py prettyprint-override"><code>today = datetime.now()
yesterday = datetime.today() - timedelta(days=1)
Date = today.strftime("%Y-%m-%d")
yesterdayDate = yesterday.strftime("%Y-%m-%d")
</code></pre>
<p>然后查询:</p>
<pre class="lang-py prettyprint-override"><code>dfred = df.query("Color == 'red'")
dftoday = dfred.query("Date == @Date")
dfyesterday = dfred.query("Date == @yesterdayDate")
dfcombined = pd.concat([dfyesterday,dftoday])
dfnewfails = dfcombined.drop_duplicates(subset='Name', keep=False).query("Date == @Date")
</code></pre>
<p>结果</p>
<pre class="lang-py prettyprint-override"><code>print(dfnewfails)
>>>
Date Name Color
4 2019-07-19 Project2 red
</code></pre>