SELECT MAX(salary) AS Max_Salary
FROM employee;
EVALUATE
SUMMARIZECOLUMNS (
"Max_Salary",
CALCULATE (
MAX(employee[salary])
)
)
import pandas as pd
# Sample DataFrame
data = {
'employee_id': [1, 2, 3, 4, 5],
'job_desc': ['Manager', 'Clerk', 'Manager', 'Analyst', 'Analyst'],
'salary': [70000, 50000, 80000, 60000, 120000]
}
df = pd.DataFrame(data)
# Calculate the maximum salary
max_salary = df['salary'].max()
# Result in list of lists
result = [['Max_Salary', max_salary]]
print(result)
| Max_Salary | 120000 |
CALCULATE(MAX(employee[salary])): This calculates the maximum salary from the employee table. SUMMARIZECOLUMNS: Creates a table with a single column named Max_Salary that contains the maximum salary.
Leave a Comment