Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Pandas: Remove Row Based on Applying Function

Tags:

python

pandas

I have a Pandas DataFrame, df, and it has a column called _text. I want to remove all rows where applying sentence_count to the value in _text column is not 0.

How would I go about this?

Normally with Pandas, I do something like:

result_df = result_df[result_df['_text'] != '']

But now I'm not just using the value in result_df['_text], I'm filtering based on the value calculated by a function...

Thoughts?

Thanks!

like image 268
anon_swe Avatar asked Jul 25 '17 22:07

anon_swe

People also ask

How do I delete a row based on conditions in Pandas?

Use pandas. DataFrame. drop() method to delete/remove rows with condition(s).

How do I delete rows in Pandas based on multiple conditions?

Pandas provide data analysts a way to delete and filter data frame using dataframe. drop() method. We can use this method to drop such rows that do not satisfy the given conditions.

1 Answers

If the function takes the sentence as its sole argument,

result_df[result_df['_text'].apply(sentence_count) != 0]
like image 184
ayhan Avatar answered Sep 22 '22 05:09

ayhan
Sign in to Comment

Related questions

how to get parse tree using python nltk?
Immutability in Python [duplicate]
Which one is more secure to use? uuid, binascii.hexlify(os.urandom()) or random.SystemRandom()?
Is overloading broken in cppclass Cython/C++ definitions?
Reset default matplotlib colormap values after using 'set_under' or 'set_over'
Virtualenv activate script won't run in bash script with set -euo
Wordcloud Python with generate_from_frequencies
Python to mysql 'Timestamp' object has no attribute 'translate'
Logistic Regression: How to find top three feature that have highest weights?
Python pandas load csv ANSI Format as UTF-8
Python Strings are immutable so why does s.split( ) return a list of new strings
Side Effects in Python
How can I jump to the cell currently being run in a Jupyter notebook?
Django - unavailable field of model while doing migration
How to perform cluster with weights/density in python? Something like kmeans with weights?
How to include library dependencies with a python project?
How to use lazy_attribute with Faker in Factory Boy
Tensorflow failed to create a newwriteablefile when retraining inception
Why keywords in tcl and c pop up when to call tag completion for python?
Python - Pandas - Convert YYYYMM to datetime

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!