擅长:python、mysql、java
<p>根据docs key func应获取并给出一个系列(顺便说一句,pd.read\u csv不需要打开),因此请尝试以下操作:</p>
<pre><code>import re
import pandas as pd
def natural_sort_key(S, _nsre=re.compile('([0-9]+)')):
return pd.Series([[int(text) if text.isdigit() else text.lower() for text in _nsre.split(s)] for s in S.values])
def main(path):
df = pd.read_csv(path, delimiter='\t')
a = df.sort_values('#mm10.kgXref.geneSymbol', key=natural_sort_key, na_position='first')
a.to_csv('mouse_conversion_by_gene_symbol', sep='\t')
if __name__ == '__main__':
main('mouse_conversion')
</code></pre>