df = cache.GetCache_Student()result = df.loc[(df.sex=='M') & (df.LEAVE_DATE.isnull())] #性别为男且在校的学生result = df.loc[(df.sex=='M') & (~df.LEAVE_DATE.isnull())] #性别为男且已经毕业的学生Enjoy