对数据框的所有列进行排序 [英] Sort all columns of a dataframe
问题描述
我有一个2000行和500列的数据框.我想按升序对每一列进行排序.列没有名称,它们只是编号0-500.
I have a dataframe of 2000 rows and 500 columns. I want to sort every column in ascending order. The columns don't have names they're just numbered 0-500.
随机数据:
df = pandas.DataFrame(np.random.randint(0,100,size=(2000, 500)), columns=range(500))
使用
df.sort_values(by=0,axis=0)
按预期对第0列进行排序.但是,随后使用df.sort_values(by=1,axis=0)
对第一列进行排序,但再次对第0列进行重新排序.换句话说,我想要
Using
df.sort_values(by=0,axis=0)
sorts the 0th column, as expected. But then using df.sort_values(by=1,axis=0)
sorts the 1st column but shuffles the 0th column again. In other words, I want
index 0 1 2
1 5 5 5
2 6 7 5
3 7 9 8
但是我一次只能得到一列排序.我已经尝试过df.sort_values(by=df.columns[0:524],axis=0)
,但这会引发关键错误.
But I can only ever get one column sorted at a time. I've tried df.sort_values(by=df.columns[0:524],axis=0)
but that throws a key error.
推荐答案
我认为您可以使用 numpy.sort
或具有sort_values
,其中
I think you can use numpy.sort
with DataFrame
constructor or apply
with sort_values
with convert to numpy array
by values
:
df = pd.DataFrame(np.sort(df.values, axis=0), index=df.index, columns=df.columns)
另一种解决方案,速度较慢:
Another solution, slowier:
df = df.apply(lambda x: x.sort_values().values)
print (df)
0 1 2 3 4 5 6 7 8 9 ... 490 491 492 \
0 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
1 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
2 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
3 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
4 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
5 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
6 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
7 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
8 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
9 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
10 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
11 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
12 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
13 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
14 0 0 0 0 0 0 0 0 0 0 ... 0 0 0
15 0 0 0 0 0 1 0 0 0 0 ... 0 0 0
16 0 0 0 0 0 1 1 0 0 0 ... 0 0 0
17 0 0 0 0 0 1 1 0 0 0 ... 0 0 0
18 0 0 0 0 0 1 1 0 0 0 ... 0 0 0
19 0 0 0 0 0 1 1 1 1 0 ... 0 0 0
20 0 0 1 0 0 1 1 1 1 0 ... 0 0 0
21 0 0 1 0 0 1 1 1 1 1 ... 0 1 0
22 0 1 1 0 0 1 1 1 1 1 ... 0 1 0
23 1 1 1 0 0 1 1 1 1 1 ... 0 1 0
24 1 1 1 0 0 1 1 1 1 1 ... 0 1 0
25 1 1 1 1 0 1 1 1 1 1 ... 0 1 0
26 1 1 1 1 0 1 1 1 1 1 ... 1 1 1
27 1 1 1 1 0 1 1 1 1 1 ... 1 1 1
28 1 1 1 1 0 1 1 1 1 1 ... 1 1 1
29 1 1 1 1 0 1 1 1 1 1 ... 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1970 97 98 98 98 98 98 99 98 98 98 ... 98 98 98
1971 97 98 98 98 98 98 99 98 98 98 ... 98 98 98
1972 98 98 98 98 98 98 99 98 98 98 ... 98 98 98
1973 98 98 98 99 98 98 99 98 98 98 ... 98 98 98
1974 98 98 98 99 98 98 99 98 98 98 ... 98 98 98
1975 98 98 98 99 98 98 99 98 98 98 ... 98 98 98
1976 98 98 98 99 98 98 99 98 99 99 ... 98 98 98
1977 98 98 98 99 98 98 99 98 99 99 ... 98 98 99
1978 98 98 98 99 98 98 99 98 99 99 ... 98 98 99
1979 98 98 98 99 99 99 99 98 99 99 ... 98 98 99
1980 98 98 98 99 99 99 99 98 99 99 ... 98 98 99
1981 99 99 98 99 99 99 99 98 99 99 ... 99 98 99
1982 99 99 98 99 99 99 99 98 99 99 ... 99 98 99
1983 99 99 98 99 99 99 99 98 99 99 ... 99 98 99
1984 99 99 98 99 99 99 99 99 99 99 ... 99 99 99
1985 99 99 98 99 99 99 99 99 99 99 ... 99 99 99
1986 99 99 98 99 99 99 99 99 99 99 ... 99 99 99
1987 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1988 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1989 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1990 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1991 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1992 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1993 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1994 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1995 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1996 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1997 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1998 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
1999 99 99 99 99 99 99 99 99 99 99 ... 99 99 99
493 494 495 496 497 498 499
0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0
5 0 0 0 0 0 0 0
6 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0
8 0 0 0 0 0 0 0
9 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0
12 0 0 0 0 0 0 0
13 0 0 0 0 0 0 0
14 0 0 0 0 0 0 0
15 0 0 0 0 1 0 0
16 0 1 0 0 1 0 0
17 0 1 0 0 1 0 0
18 1 1 0 0 1 0 0
19 1 1 1 0 1 0 0
20 1 1 1 0 1 0 1
21 1 1 1 0 1 0 1
22 1 1 1 0 1 0 1
23 1 1 1 0 1 0 1
24 1 1 1 0 1 0 1
25 1 1 1 0 1 0 1
26 1 1 1 0 1 0 1
27 1 1 1 1 1 0 1
28 1 1 1 1 1 0 1
29 1 1 1 1 1 0 1
... ... ... ... ... ... ... ...
1970 98 98 98 98 98 98 98
1971 98 98 98 98 98 98 98
1972 98 98 98 98 98 98 98
1973 98 98 98 98 98 98 98
1974 98 98 98 99 98 98 98
1975 98 98 98 99 98 98 98
1976 99 98 98 99 98 98 98
1977 99 98 98 99 98 98 98
1978 99 98 98 99 99 98 98
1979 99 99 98 99 99 98 98
1980 99 99 98 99 99 99 99
1981 99 99 98 99 99 99 99
1982 99 99 98 99 99 99 99
1983 99 99 99 99 99 99 99
1984 99 99 99 99 99 99 99
1985 99 99 99 99 99 99 99
1986 99 99 99 99 99 99 99
1987 99 99 99 99 99 99 99
1988 99 99 99 99 99 99 99
1989 99 99 99 99 99 99 99
1990 99 99 99 99 99 99 99
1991 99 99 99 99 99 99 99
1992 99 99 99 99 99 99 99
1993 99 99 99 99 99 99 99
1994 99 99 99 99 99 99 99
1995 99 99 99 99 99 99 99
1996 99 99 99 99 99 99 99
1997 99 99 99 99 99 99 99
1998 99 99 99 99 99 99 99
1999 99 99 99 99 99 99 99
这篇关于对数据框的所有列进行排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!