PracHub
QuestionsPremiumCoachesLearningGuidesInterview Prep
|Home/Data Manipulation (SQL/Python)/Aeonea

Fill missing values with means

Last updated: Mar 29, 2026

Quick Overview

This question evaluates proficiency in missing-data imputation and pandas DataFrame manipulation, testing skills in column-wise aggregation, group-wise operations, and edge-case handling within the Data Manipulation (SQL/Python) domain.

  • Medium
  • Aeonea
  • Data Manipulation (SQL/Python)
  • Software Engineer

Fill missing values with means

Company: Aeonea

Role: Software Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: Medium

Interview Round: Technical Screen

You are given a pandas DataFrame df with missing values in multiple numeric columns. Write a concise pandas expression to replace NaNs in each numeric column with that column's mean while leaving non-numeric columns unchanged. Also explain how you would: (a) perform the operation in-place, (b) compute and apply per-group means based on a key column (e.g., 'group'), and (c) skip columns whose values are all NaN.

Quick Answer: This question evaluates proficiency in missing-data imputation and pandas DataFrame manipulation, testing skills in column-wise aggregation, group-wise operations, and edge-case handling within the Data Manipulation (SQL/Python) domain.

Aeonea logo
Aeonea
Sep 6, 2025, 12:00 AM
Software Engineer
Technical Screen
Data Manipulation (SQL/Python)
4
0

You are given a pandas DataFrame df with missing values in multiple numeric columns. Write a concise pandas expression to replace NaNs in each numeric column with that column's mean while leaving non-numeric columns unchanged. Also explain how you would: (a) perform the operation in-place, (b) compute and apply per-group means based on a key column (e.g., 'group'), and (c) skip columns whose values are all NaN.

Submit Your Answer to Earn 20XP

Sign in to leave a comment

Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More Aeonea•More Software Engineer•Aeonea Software Engineer•Aeonea Data Manipulation (SQL/Python)•Software Engineer Data Manipulation (SQL/Python)
PracHub

Master your tech interviews with 8,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.