Ad
Delete 90% Of Random Rows By Condition Pandas
I have a pandas dataframe and want to delete 90% of data which satisfies condition.
The condition is very simple. If the value of the column "Parameter1" is greater than a threshold, then delete it.
My question is how to delete 90% of them, not 90% values in a row, but random
Ad
Answer
Use boolean indexing
with sample
:
df = pd.DataFrame({
'A': [5] * 20 + [1] * 2,
'B': list(range(22))
})
df = df.drop(df[df['A'] > 4].sample(frac=.9).index)
print (df)
A B
11 5 11
15 5 15
20 1 20
21 1 21
Ad
source: stackoverflow.com
Related Questions
- → What are the pluses/minuses of different ways to configure GPIOs on the Beaglebone Black?
- → Django, code inside <script> tag doesn't work in a template
- → React - Django webpack config with dynamic 'output'
- → GAE Python app - Does URL matter for SEO?
- → Put a Rendered Django Template in Json along with some other items
- → session disappears when request is sent from fetch
- → Python Shopify API output formatted datetime string in django template
- → Can't turn off Javascript using Selenium
- → WebDriver click() vs JavaScript click()
- → Shopify app: adding a new shipping address via webhook
- → Shopify + Python library: how to create new shipping address
- → shopify python api: how do add new assets to published theme?
- → Access 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT' with Python Shopify Module
Ad