Company: Rystad_MCQ_
Difficulty: medium
Which library is commonly used for creating plots in Python? matplotlib seaborn plotly All of the above Which attribute of a Pandas DataFrame returns its column labels? df.columns df.colnames df.labels df.column_names You need to find the rank of employees within each department based on their salary, but you want to account for ties (i.e., employees with the same salary should have the same rank). Which SQL query will achieve this? SELECT EmployeeID, Department, Salary, RANK() OVER (PARTITION BY Department ORDER BY Salary DESC) AS Rank FROM Employees SELECT EmployeeID, Department, Salary, DENSE_RANK() OVER (PARTITION BY Department ORDER BY Salary DESC) AS Rank FROM Employees SELECT EmployeeID, Department, Salary, ROW_NUMBER() OVER (PARTITION BY Department ORDER BY Salary DESC) AS Rank FROM Employees SELECT EmployeeID, Department, Salary, RANK() OVER (ORDER BY Salary DESC) AS Rank FROM Employees How do you group data by 'site_id' and calculate the mean of 'consumption' in a DataFrame c