Pandas根据配置文件中的动态条件集排除行

import pandas as pd
import json

# 假设这是我们的配置文件内容
config_json = """
{
    "filters": [
        {"column": "age", "operator": ">", "value": 30},
        {"column": "salary", "operator": "<=", "value": 50000}
    ]
}
"""

# 将配置文件内容加载为Python对象
config = json.loads(config_json)

# 创建一个示例DataFrame
data = {
    'name': ['Alice', 'Bob', 'Charlie', 'David'],
    'age': [25, 35, 45, 55],
    'salary': [40000, 55000, 60000, 45000]
}
df = pd.DataFrame(data)

# 应用过滤条件
for filter in config['filters']:
    column = filter['column']
    operator = filter['operator']
    value = filter['value']
    
    if operator == '>':
        df = df[df[column] > value]
    elif operator == '<=':
        df = df[df[column] <= value]
    # 可以继续添加其他操作符的处理逻辑

print(df)