How do I practice coding and algorithm questions?

Use PracHub's coding console to write, test, and debug your solutions in Python or JavaScript. View hints, test against sample inputs, and compare with official solutions.

What difficulty level is this coding question?

This is a easy difficulty Coding & Algorithms question, commonly asked during Technical Screen rounds at Microsoft.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Microsoft during technical interviews.

Write an average-income function | Microsoft Coding Question

Quick Overview

This question evaluates proficiency in data manipulation and basic statistical aggregation, particularly handling missing values and computing averages in Python. Commonly asked in technical interviews for Data Scientist roles within the Coding & Algorithms domain, it gauges practical application and robustness in data cleaning and edge-case handling rather than purely conceptual theory.

easy
Microsoft
Coding & Algorithms
Data Scientist

Write an average-income function

Company: Microsoft

Role: Data Scientist

Category: Coding & Algorithms

Difficulty: easy

Interview Round: Technical Screen

Given a Python list of dictionaries such as: `records = [{"name": "a", "income": 100}, {"name": "b", "income": None}, {"name": "a", "income": 200}]` Write a function that returns the average of all non-missing `income` values. Requirements: - Ignore any record where `income` is `None`. - The `name` field does not affect the calculation. - If there are no valid income values, return `None`.

Quick Answer: This question evaluates proficiency in data manipulation and basic statistical aggregation, particularly handling missing values and computing averages in Python. Commonly asked in technical interviews for Data Scientist roles within the Coding & Algorithms domain, it gauges practical application and robustness in data cleaning and edge-case handling rather than purely conceptual theory.

Given a Python list of dictionaries, return the average of all non-missing `income` values. Ignore any record where `income` is `None`. The `name` field does not affect the calculation. If there are no valid income values, return `None`.

Constraints

0 <= len(records) <= 100000
Each record is a dictionary with keys `name` and `income`
`income` is either an int, a float, or `None`

Examples

Input: [{"name": "a", "income": 100}, {"name": "b", "income": None}, {"name": "a", "income": 200}]

Expected Output: 150.0

Explanation: Only 100 and 200 are included, so the average is (100 + 200) / 2 = 150.0.

Input: [{"name": "x", "income": None}, {"name": "y", "income": None}]

Expected Output: None

Explanation: There are no valid income values, so the function should return None.

Input: []

Expected Output: None

Explanation: An empty list contains no valid income values.

Input: [{"name": "u", "income": -50}, {"name": "v", "income": 150}, {"name": "w", "income": 50}]

Expected Output: 50.0

Explanation: The average is (-50 + 150 + 50) / 3 = 50.0.

Input: [{"name": "solo", "income": 0}]

Expected Output: 0.0

Explanation: A single valid income of 0 gives an average of 0.0.

Hints

Keep two running values: the sum of valid incomes and the count of valid records.

Loading coding console...