Python多列筛选案例

    import pandas as pd
    data = {'name': ['apple', 'apple','egg', 'watermelon'], 'color': ['red','green' ,'yellow', 'green'], 'num': [30, 40, 50,31]}
    df = pd.DataFrame(data)
    print(df)
    print(df.loc[df['name'] == 'apple', 'color'].values[0])
    print(df[(df['name'] == 'apple') & (df['color'] == 'green')]['num'].values[0])