Batch Data Analysis with Pandas and NumPy | Dataford Interview Questions

How would you use pandas and NumPy to compute medians and perform basic data analysis?

For this PostgreSQL exercise, calculate equivalent descriptive statistics from the measurements table. Include only valid records and ignore missing measurement values.

Output

One row per segment.
Return segment, measurement_median, measurement_count, measurement_average, measurement_minimum, and measurement_maximum.
Sort by segment in ascending order.

Schema

measurements

Column	Type	Description
measurement_idPK	INT	Unique measurement identifier
segment	VARCHAR(50)	Analysis segment
measurement	DECIMAL(10,2)	Numeric value used for analysis
status	VARCHAR(20)	Whether the measurement is valid

Your question is Batch Data Analysis with Pandas and NumPy. 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