python - 如何找到大于平均值/中位数的平均工资

Question

如何找到大于平均值/中位数的平均工资。如何不使用pandasql直接在pandas中执行

import pandas as pd
import pandasql as ps
df1 = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv")  
df1.head(3) 
q5 = """SELECT Name,Salary FROM df1 WHERE Salary > (SELECT AVG(Salary) FROM df1) limit 2 """
print(ps.sqldf(q5, locals()))

我的出局和预期出局

         Name     Salary
0  Avery Bradley  7730337.0
1    Jae Crowder  6796117.0

标签： pythonpandas

Answer 1

尝试这个：

 df1=df1[(df1.salary>np.mean(df1.salary))|(df1.salary>np.median(df1.salary)))