python将一组数据排序_Python 数据处理（十一）—— 排序

11 排序

pandas 支持三种排序方式：

按索引排序

按指定列的值排序

按索引和列排序

11.1 按索引排序

Series.sort_index() 和 DataFrame.sort_index() 方法用于按其索引级别对 pandas 对象进行排序

In [300]: df = pd.DataFrame(

.....: {

.....: "one": pd.Series(np.random.randn(3), index=["a", "b", "c"]),

.....: "two": pd.Series(np.random.randn(4), index=["a", "b", "c", "d"]),

.....: "three": pd.Series(np.random.randn(3), index=["b", "c", "d"]),

.....: }

.....: )

.....:

In [301]: unsorted_df = df.reindex(

.....: index=["a", "d", "c", "b"], columns=["three", "two", "one"]

.....: )

.....:

In [302]: unsorted_df

Out[302]:

three two one

a NaN -1.152244 0.562973

d -0.252916 -0.109597 NaN

c 1.273388 -0.167123 0.640382

b -0.098217 0.009797 -1.299504

# DataFrame

In [303]: unsorted_df.sort_index()

Out[303]:

three two one

a NaN -1.152244 0.562973

b -0.098217 0.009797 -1.299504

c 1.273388 -0.167123 0.640382

d -0.252916 -0.109597 NaN

In [304]: unsorted_df.sort_index(ascending=False)

Out[304]:

three two one

d -0.252916 -0.109597 NaN

c 1.273388 -0.167123 0.640382

b -0.098217 0.009797 -1.299504

a NaN -1.152244 0.562973

In [305]: unsorted_df.sort_index(axis=1)

Out[305]:

one three two

a 0.562973 NaN -1.152244

d NaN -0.252916 -0.109597

c 0.640382 1.273388 -0.167123

b -1.299504 -0.098217 0.009797

# Series

In [306]: u