擅长:python、mysql、java
<p>因为整个字符串都要排序,所以我给anky的答案加了一个小改动</p>
<pre><code>Before
df_new = df.join(df.Snapshot.str.split("_",expand=True).drop(0,1)).sort_values(by=[1,2])
After
data_new = data.join(data.Snapshot.str.split("_",expand=True)).sort_values(by=[0,1,2])
</code></pre>
<p>它考虑了整个字符串</p>
<p>更有趣的是</p>
<pre><code>data.sort_values(['Snapshot'],ascending=True)
Also doing the perfect sorting..! it ignores underscores and dots
</code></pre>