dataframe 条件取非_dataframe设置两个条件取值的实例

如下所示：

>>> import pandas as pd

>>> import numpy as np

>>> from pandas import Series, DataFrame

>>> df = DataFrame({'name':['a','a','b','b'],'classes':[1,2,3,4],'price':[11,22,33,44]})

>>> df

classes name price

0 1 a 11

1 2 a 22

2 3 b 33

3 4 b 44

>>>

根据index和columns取值

>>> s = df.loc[0,'price']

>>> s

11

根据同行的columns的值取同行的另一个columns的值

>>> sex = df.loc[(df.classes==1)&(df.name=='a'),'price']

>>> sex

0 11

Name: price, dtype: int64

>>> sex = df.loc[(df.classes==1)&(df.name=='a'),'price'].values[0]

>>>