How to delete specific values from a column in a dataset (Python)?

Question

I have a data set as below:

I want to remove 'Undecided' from my ['Grad Intention'] column. For this, I created a copy DataFrame and using the code as follows:

df_copy=df_copy.drop([df_copy['Grad Intention'] =='Undecided'], axis=1)

However, this is giving me an error.

How can I remove the row with 'Undecided'? Also, what's wrong with my code?

thanks this worked. But if i try to pass this data frame to construct a cross tab it shows error Code- pd.crosstab(df.copy['Gender'], df.copy['Grad Intention']) Error- TypeError: 'method' object is not subscriptable Can you let me know what is going wrong here? — Nikki
– Nikki, Commented Oct 5, 2021 at 7:02

PRIN · Accepted Answer · 2021-10-03 21:37:32Z

1

you could simply use:

df = df[df['Grad Intention'] != 'Undecided'] or df.drop(df[df['Grad Intention'] == 'Undecided'].index, inplace = True)

answered Oct 3, 2021 at 21:37

PRIN

3441 silver badge9 bronze badges

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

1 Comment

Nikki Over a year ago

Thanks this worked. But if i try to pass this data frame to construct a cross tab it shows error Code- pd.crosstab(df.copy['Gender'], df.copy['Grad Intention']) Error- TypeError: 'method' object is not subscriptable Can you let me know what is going wrong here?

Collectives™ on Stack Overflow

How to delete specific values from a column in a dataset (Python)?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related