Python or R Analysis Libraries | Dataford Interview Questions

What libraries do you commonly use for data analysis in Python or R?

Assume each row records one library mention from a respondent. Write a SQL query that identifies the most commonly reported libraries for Python and R, counting each respondent only once per library.

Output

One row per language and library.
Columns: language, library_name, and respondent_count.
Include only Python and R records with a non-null library name.
Order by respondent count descending, then language and library name ascending.

Schema

library_usage

Column	Type	Description
usage_idPK	INT	Unique library usage record identifier
respondent_id	INT	Identifier for the respondent
language	VARCHAR(20)	Programming language associated with the library
library_name	VARCHAR(100)	Name of the data analysis library

Your question is Python or R Analysis Libraries. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem