如何在某些条件下选择特定的行

import pandas as pd

# 创建一个示例DataFrame
data = {
    'Name': ['Alice', 'Bob', 'Charlie', 'David'],
    'Age': [24, 27, 22, 32],
    'City': ['New York', 'Los Angeles', 'Chicago', 'Houston']
}
df = pd.DataFrame(data)

# 单条件筛选
filtered_df = df[df['Age'] > 25]
print(filtered_df)

# 多条件筛选
filtered_df = df[(df['Age'] > 25) & (df['City'] == 'Los Angeles')]
print(filtered_df)

-- 创建一个示例表
CREATE TABLE Employees (
    ID INT PRIMARY KEY,
    Name VARCHAR(50),
    Age INT,
    City VARCHAR(50)
);

-- 插入示例数据
INSERT INTO Employees (ID, Name, Age, City) VALUES
(1, 'Alice', 24, 'New York'),
(2, 'Bob', 27, 'Los Angeles'),
(3, 'Charlie', 22, 'Chicago'),
(4, 'David', 32, 'Houston');

-- 单条件筛选
SELECT * FROM Employees WHERE Age > 25;

-- 多条件筛选
SELECT * FROM Employees WHERE Age > 25 AND City = 'Los Angeles';