SELECT MIN(salary) AS Min_Salary
FROM employee;
EVALUATE
SUMMARIZECOLUMNS (
"Min_Salary",
CALCULATE (
MIN(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 minimum salary
min_salary = df['salary'].min()
# Result in list of lists
result = [['Min_Salary', min_salary]]
print(result)
| Min_Salary | 50000 |
CALCULATE(MIN(employee[salary])): This calculates the minimum salary from the employee table. SUMMARIZECOLUMNS: Creates a table with a single column named Min_Salary that contains the minimum salary.
Leave a Comment