擅长:python、mysql、java
<p>不要进行字符串比较您可以直接使用<code>pd.groupby()</code>函数,如下所示:</p>
<pre><code>import pandas as pd
import numpy as np
listt = [['VW','blue',2014,20000],
['Audi','red',2015,30000],
['BMW','black',2019,90000],
['Audi','white',2011,70000]]
my_df = pd.DataFrame(listt)
my_df.columns=(['Car','Color','Year','Price'])
grouped_data = my_df.groupby('Car')
grouped_data.get_group("Audi")
</code></pre>
<p>输出:</p>
<pre><code> Car Color Year Price
1 Audi red 2015 30000
3 Audi white 2011 70000
</code></pre>