df1 = pd.read_excel("E10EXAMPLE.xlsx", sheet_name=0)
df1
|
Name |
Mark |
Age |
| 0 |
Louis |
100 |
34.5 |
| 1 |
Harvey |
100 |
61.4 |
| 2 |
G-dragon |
89 |
62.5 |
| 3 |
Lola |
76 |
60.3 |
| 4 |
Jorge |
62 |
20.5 |
| 5 |
Piona |
79 |
64.2 |
| 6 |
Mitchy |
69 |
37.8 |
| 7 |
Fibio |
78 |
49.8 |
| 8 |
Kim |
71 |
48.9 |
| 9 |
Stacy |
74 |
22.9 |
| 10 |
Grace |
88 |
30.4 |
| 11 |
TL |
67 |
63.1 |
| 12 |
Sanchez |
68 |
57.2 |
| 13 |
Zhen |
71 |
42.2 |
| 14 |
James |
89 |
28.8 |
| 15 |
Coline |
98 |
22.2 |
| 16 |
Gorila |
87 |
67.7 |
| 17 |
Sunny |
96 |
46.1 |
| 18 |
Conner |
61 |
54.2 |
| 19 |
Sally |
95 |
55.4 |
| 20 |
Marry |
70 |
36.4 |
| 21 |
Katy |
80 |
23.4 |
| 22 |
Gerge |
84 |
68.8 |
| 23 |
kipling |
74 |
58.8 |
| 24 |
Guggi |
99 |
28.4 |
| 25 |
Phil |
97 |
40.2 |
| 26 |
CoolJ |
83 |
30.5 |
| 27 |
Kara |
93 |
47.5 |
| 28 |
Tiara |
61 |
25.9 |
| 29 |
Kolon |
99 |
27.2 |
| 30 |
SungGil |
71 |
53.5 |
df1["Sort"] = df1["Age"].mask(df1["Age"]<60,0)
df1 = df1.sort_values(["Mark", "Sort", "Age"], ascending=[0, 0,1])
df1.drop("Sort", axis=1).to_clipboard(index=False)
Total Code
import pandas as pd
df1 = pd.read_excel("E10EXAMPLE.xlsx")
df1["Sort"] = df1["Age"].mask(df1["Age"] < 60, 0)
df1 = df1.sort_values(["Mark", "Sort", "Age"], ascending= [0,0,1])
df1.drop("Sort", axis=1).to_clipboard(index=False)
