擅长:python、mysql、java
<p>您需要有一个<code>dict</code>,将字符串值映射到<code>int</code>,然后按整数值排序:</p>
<pre><code>In [301]: vars_map = {'First': 1, 'Second': 2, 'Third': 3, 'Fourth':4, 'Fifth':5, 'Sixth':6, 'Seventh': 7, 'Eigth':8, 'Ninth':9, 'Tenth':10}
In [305]: df1 = df.assign(vals=df.Event_name.map(vars_map)).sort_values('vals').drop('vals', 1)
In [306]: df1
Out[306]:
Event_name Event_Ids Previous_Event_Ids
1 First QXT364 NaN
3 Second YKD306 QXT364
5 Third GJJ60 YKD306
7 Fourth RSK547 GJJ60
9 Fifth GNN259 RSK547
2 Sixth DKW368 GNN259
8 Seventh OAN385 DKW368
0 Eigth PGF213 OAN385
6 Ninth NGJ285 PGF213
4 Tenth OLG594 NGJ285
</code></pre>