pandas按某列降序的实现

桂花很香,旭很美 2023-02-03 我要评论

升序

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)

运行结果：

在这里插入图片描述