Python-科学计算-pandas-07-Df多条件筛选

import pandas as pd

dict_1 = {"value1": ["P1", "P2", "P3"],
          "value2": [0.5, 0.8, 1.0],
          "value3": [1, 5, 3]}

df_1 = pd.DataFrame(dict_1, columns=["value1", "value2", "value3"])
print(df_1)

print("\n两个条件同时满足")
df_2 = df_1[(df_1["value2"] > 0.6) & (df_1["value3"] < 5)]
print(df_2)

print("\n满足任一条件")
df_3 = df_1[(df_1["value2"] > 0.6) | (df_1["value3"] < 5)]
print(df_3)

print("\n两个条件同时满足")
list_1 = ["P1", "P2"]
df_4 = df_1[(df_1["value2"] > 0.6) & (df_1["value1"].isin(list_1))]
print(df_4)

print("\n满足任一条件")
list_1 = ["P1", "P2"]
df_5 = df_1[(df_1["value2"] > 0.6) | (df_1["value1"].isin(list_1))]
print(df_5)