pd.DataFrame( sorted(df.values, key=lambda x: int(x[0].split('-')[1])), columns=df.columns ) 注意,这里的lambda函数是获取ID中“-”后面的字符,将其转换为整数,然后进行排序。这样可以实现“自然”排序。 ID Time oneMissing singleValue empty oneEmpty 0 CS1-1 1 10000.0 NaN None 0.0 1 CS1...
df = pd.DataFrame(data=d) 我所尝试的: def sorted_alphanumeric(data): convert = lambda text: int(text) if text.isdigit() else text.lower() alphanum_key = lambda key: [ convert(c) for c in re.split('([0-9]+)', key) ] return sorted(data, key=alphanum_key) df['col1'].appl...
Python program to sort columns and selecting top n rows in each group pandas dataframe# Importing pandas package import pandas as pd # Creating two dictionaries d1 = { 'Subject':['phy','che','mat','eng','com','hin','pe'], 'Marks':[78,82,73,84,75,60,96], 'Max_marks'...