应用多个条件选择当前行和上一行- Pandas

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'City': ['New York', 'London', 'Paris', 'Tokyo', 'Sydney']}
df = pd.DataFrame(data)

# 选择满足多个条件的行
condition1 = df['Age'] > 30
condition2 = df['City'] == 'Paris'
selected_rows = df[condition1 & condition2]

# 选择当前行和上一行的数据
selected_rows_with_previous = pd.concat([selected_rows, selected_rows.shift(1)], axis=1)

print(selected_rows_with_previous)