Basic R Data Manipulation | Dataford Interview Questions

What R data manipulation techniques have you used?

Demonstrate equivalent data manipulation skills by writing a PostgreSQL query against the provided table. Include only active records and summarize their amounts by category.

Output

One row per category, including records with a missing category.
Columns: category, record_count, and total_amount.
Sort by record_count descending, then category ascending with missing categories last.

Schema

data_records

Column	Type	Description
record_idPK	INT	Unique record identifier
category	VARCHAR(50)	Category assigned to the record
status	VARCHAR(20)	Current record status
amount	DECIMAL(10,2)	Numeric amount associated with the record

Your question is Basic R Data Manipulation. 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