在Python中,可以使用列表推导式和多个条件组合来筛选JSON结果。以下是一个示例代码:
import json
# 假设有一个JSON数据
data = [
{"name": "Alice", "age": 25, "city": "New York"},
{"name": "Bob", "age": 30, "city": "Los Angeles"},
{"name": "Charlie", "age": 35, "city": "San Francisco"},
{"name": "David", "age": 40, "city": "Chicago"},
{"name": "Eve", "age": 45, "city": "Boston"}
]
# 按多个条件筛选JSON结果
filtered_data = [d for d in data if d["age"] > 30 and d["city"] == "San Francisco"]
# 打印筛选结果
print(json.dumps(filtered_data, indent=4))
运行以上代码,输出结果为:
[
{
"name": "Charlie",
"age": 35,
"city": "San Francisco"
}
]
在上面的代码中,使用了列表推导式 [d for d in data if d["age"] > 30 and d["city"] == "San Francisco"]
来筛选满足多个条件的JSON结果。条件包括 d["age"] > 30
和 d["city"] == "San Francisco"
。
上一篇:按多个条件排序MySQL