Python DataFrame同时过滤和排序

import pandas as pd

data = {
    'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eva'],
    'Age': [20, 22, 21, 23, 24],
    'Score': [85, 90, 78, 92, 88]
}

df = pd.DataFrame(data)

filtered_df = df[df['Age'] > 21]
print(filtered_df)

sorted_df = df.sort_values(by='Score', ascending=False)
print(sorted_df)

result_df = df[(df['Age'] > 21)].sort_values(by='Score', ascending=False)
print(result_df)

# 确保年龄列是整数类型
df['Age'] = df['Age'].astype(int)

# 正确的过滤条件
filtered_and_sorted_df = df[(df['Age'] > 21)].sort_values(by='Score', ascending=False)
print(filtered_and_sorted_df)

# 填充缺失值
df['Score'].fillna(0, inplace=True)

# 或者删除包含 NaN 的行
df.dropna(subset=['Score'], inplace=True)

# 然后进行过滤和排序
filtered_and_sorted_df = df[(df['Age'] > 21)].sort_values(by='Score', ascending=False)
print(filtered_and_sorted_df)