Problem Statement

Which of these Python libraries is typically used to build data plots? matplotlib seaborn plotly All of the above In a Pandas DataFrame, which attribute reports the labels of its columns? df.columns df.colnames df.labels df.column_names You need to rank employees within each department by salary, and employees sharing a salary should also share a rank. Which SQL query accomplishes 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 In a DataFrame called df, how would you group rows by 'site_id' and compute the mean of 'consumption'? df.groupby('site_id')['consumption'