亲宝软件园·资讯

展开

pandas按某列降序的实现

桂花很香,旭很美 人气:0

升序

import pandas as pd
import numpy as np

data = np.random.randint(low=2,high=10,size=(5,3))
data2 = np.random.randint(low=2,high=10,size=(5,3))

df1 = pd.DataFrame(data,columns=["a","b","c"],index=range(5))  
df2 = pd.DataFrame(data2,columns=["a","b","c"],index=range(5))

df1 = df1.sort_values(by=['a','b'])
print(df1)

运行结果:

在这里插入图片描述

降序

import pandas as pd
import numpy as np

data = np.random.randint(low=2,high=10,size=(5,3))
data2 = np.random.randint(low=2,high=10,size=(5,3))

df1 = pd.DataFrame(data,columns=["a","b","c"],index=range(5))  
df2 = pd.DataFrame(data2,columns=["a","b","c"],index=range(5))

df1 = df1.sort_values(by=['a','b'], ascending=[False, False])
print(df1)

运行结果:

在这里插入图片描述

PS: 先按a降序,再按b降序

加载全部内容

相关教程
猜你喜欢
用户评论