How to filter a dataframe using multiple inputs from an user

Question

I am trying to filter this dataframe based on some inputs from a user. This is my original dataframe -

I have created a function that takes 3 arguments and creates a subset of this dataframe. This is the function I created -

def subset(posting_type, level, job_category):
  df_subset = df_filtered[(df_filtered['posting_type'] == 'posting_type') & (df_filtered['level'] == 'level') & (df_filtered['job_category'] == 'job_category')]
  return df_subset

I am calling this function and passing 3 parameters and am expecting to get the values which meet this filter.

subset('Internal', '01' ,'Administration & Human Resources')

But I am not getting any result. I am getting only this output. How can I get the desired value?

Laggs · Accepted Answer · 2020-12-09 21:44:54Z

1

Your looking for equality to a string literal not to the variable e.g. 'posting_type' versus posting_type

def subset(posting_type, level, job_category):
  df_subset = df_filtered[(df_filtered['posting_type'] == posting_type) & (df_filtered['level'] == level) & (df_filtered['job_category'] == job_category)]
  return df_subset

answered Dec 9, 2020 at 21:44

Laggs

3861 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to filter a dataframe using multiple inputs from an user

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related