回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想筛选在以前的数据中不存在的<code> customer_id's</code>,因此所有<code> new_customer_ids</code>都是2020-01-10上新增的,而在2020-01-01上不存在</p>
<p>主楼</p>
<pre><code>date customer_id amount_spent
2020-01-01 24 123
2020-01-10 24 145
2020-01-01 58 89
2020-01-10 58 67
2020-01-01 98 34
2020-01-10 99 86
2020-01-10 67 140
2020-01-10 32 321
2020-01-10 75 76
</code></pre>
<p>输出功率</p>
<pre><code>new_customer_id amount_spent
32 321
75 76
67 140
</code></pre>
<p>我曾尝试在Pandas中使用shift功能,但这对我不起作用</p>
<p><strong>编辑</strong></p>
<pre><code>df = pd.DataFrame([["2020-01-01",24,123],
["2020-01-10",24,145],
["2020-01-01",58,89],
["2020-01-10",58,67],
["2020-01-01",98,34],
["2020-01-10",98,86],
["2020-01-10",67,140],
["2020-01-10",32,321],
["2020-01-10",75,76]],columns = ["date","customer_id","amount_spent" ])
</code></pre>