擅长:python、mysql、java
<p>您可以从“类”列表创建一个字典,其中key是类,value是索引(它用作秩,因为列表从大到小)</p>
<p>然后您可以创建两个列组列,其中包含列组(0到n0更大)。最后,比较等级,取等级较高的等级(即值较小的等级)</p>
<pre><code>classes = ['A','B','C','D']
classes_dict = {val: index for index,val in enumerate(classes)}
df['Seg 2019 Rank'] = df['Seg 2019'].map(classes_dict)
df['Seg 2020 Rank'] = df['Seg 2020'].map(classes_dict)
df['greater'] = df.apply(lambda x: x['Seg 2019'] if x['Seg 2019 Rank'] < x['Seg 2020 Rank'] else x['Seg 2020'] if x['Seg 2020 Rank'] < x['Seg 2019 Rank'] else "equal" , axis=1)
</code></pre>
<p>输出:</p>
<pre><code>Seg 2019 Seg 2020 Seg 2019 Rank Seg 2020 Rank greater
B A 1 0 A
B A 1 0 A
A B 0 1 A
C C 2 2 equal
B D 1 3 B
</code></pre>
<p>如果您添加了一个新类(VIP),您只需将其添加到a之前的列表中,它将被视为一个更大的类</p>