使用pandas对列表进行排序和排列

import pandas as pd

# 创建一个列表
data = {'Name': ['Tom', 'Nick', 'John', 'Amy'],
        'Age': [20, 25, 30, 35],
        'Score': [90, 80, 70, 60]}

df = pd.DataFrame(data)

# 按照Age列的值进行升序排序
df_sorted = df.sort_values('Age')

print(df_sorted)

   Name  Age  Score
0   Tom   20     90
1  Nick   25     80
2  John   30     70
3   Amy   35     60

import pandas as pd

# 创建一个列表
data = {'Name': ['Tom', 'Nick', 'John', 'Amy'],
        'Age': [20, 25, 30, 35],
        'Score': [90, 80, 70, 60]}

df = pd.DataFrame(data)

# 按照索引的值进行降序排序
df_sorted = df.sort_index(ascending=False)

print(df_sorted)

   Name  Age  Score
3   Amy   35     60
2  John   30     70
1  Nick   25     80
0   Tom   20     90

import pandas as pd

# 创建一个列表
data = {'Name': ['Tom', 'Nick', 'John', 'Amy'],
        'Age': [20, 25, 30, 35],
        'Score': [90, 80, 70, 60]}

df = pd.DataFrame(data)

# 按照Score列的值进行排名
df_ranked = df['Score'].rank()

print(df_ranked)

0    4.0
1    3.0
2    2.0
3    1.0
Name: Score, dtype: float64