DataFrame格式数据排序

tech2025-11-17  1

简单说 关于排序 若只需要按索引、列名排序,如下(True从小到大,False反之)

#.sort_index(axis = 0,ascending = True) #axis: 轴方向,默认0 #ascending: 默认True从小到大,Fasle从大到小 #如 import pandas as pd a = [[1,2,3],[2,3,4],[4,6,9],[3,1,5]] b = pd.DataFrame(a, columns = ['b','c','a']) b = b.set_index('b') print(b,'\n-----------') d = b.sort_index(axis = 0,ascending = True) print(d)

axis决定是按行名还是列名排序,举例按行axis = 0 按列axis = 1

若需要指定按照某一行/列大小排序

#.sort_values(by, axis = 0,ascending = True) #如`在这里插入代码片` import pandas as pd a = [[1,2,3],[2,3,4],[4,6,9],[3,5,1]] b = pd.DataFrame(a, columns = ['b','c','a']) b = b.set_index('b') print(b,'\n-----------') # c = b.sort_values(by = 3,axis = 1,ascending = True) c = b.sort_values(by = 'c',axis = 0,ascending = True) print(c) # d = b.sort_index(axis = 1,ascending = True) # print(d)

按某一列 按某一行

最新回复(0)