Ctrl K
Data Analyst · Junior · Theory

How do you find and handle missing values in pandas?

~4 min by voice

How to approach it

The interviewer wants to see whether you can do more than call dropna and work with missing values thoughtfully: find them (including disguised ones), assess the scale and choose how to handle them based on what the data means.

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
Similar questionsThere are two pandas DataFrames: orders with columns order_id, user_id, and amount, and users with columns user_id and country. Write a function revenue_by_country that takes both DataFrames and returns a DataFrame with the country, the number of unique buyers, and the total revenue, sorted by revenue in descending order. JuniorYou have a pandas script that processes a table of several million rows; it takes half an hour and sometimes runs out of memory. How would you speed it up? Mid-levelYou have a pandas script that processes a 20 GB CSV file, and it runs out of memory on a machine with 32 GB of RAM. What would you do? Senior

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Sign in to answer

Best with headphones · ~4 min