1

Data Preprocessing: Pandas Conditionals and Preprocessing

Unsolved
Data Wrangling

Difficulty: 2 | Problem written by peter.washington

Educational Resource: https://web.stanford.edu/class/cs102/readings/pandasreferences.htm


Problem reported in interviews at

Google

Given a pandas dataframe, run the following data preprocessing steps:

  1. If the value of col2 >= 1000, replace the value in col1 to 1000.
  2. Return a list of strings representing the values of col1.
Sample Input:
<class 'str'>
df: col1 col2 col3 0 1 2000 3 1 400 5 6 2 7 8 9

Expected Output:
<class 'pandas.core.frame.DataFrame'>
0 0 1000 1 400 2 7

This is a premium problem, to view more details of this problem please sign up for MLPro Premium. MLPro premium offers access to actual machine learning and data science interview questions and coding challenges commonly asked at tech companies all over the world

MLPro Premium also allows you to access all our high quality MCQs which are not available on the free tier.

Not able to solve a problem? MLPro premium brings you access to solutions for all problems available on MLPro

Get access to Premium only exclusive educational content available to only Premium users.

Have an issue, the MLPro support team is available 24X7 to Premium users.

This is a premium feature.
To access this and other such features, click on upgrade below.

Log in to post a comment

Comments
Jump to comment-90
rafi • 7¬†months, 2¬†weeks ago

0

Perform filtering

def data_preprocessing(df):
    df.loc[df['col2'] >= 1000, 'col1'] = 1000
    return [str(i) for i in df['col1']]
    

 

Ready.

Input Test Case

Please enter only one test case at a time
numpy has been already imported as np (import numpy as np)