Ad
Remove First N-1 Zeros From Pandas Dataframe Column
df_in
is the sample dataframe and df_out
is the expected output.
How do I remove the first 5 zeros so that I have one zero and all other elements.
import pandas as pd
df_in = pd.DataFrame({'a':[0,0,0,0,0,0,1,2]})
df_out=pd.DataFrame({'a':[0,1,2]})
Thanks in advance.
Ad
Answer
find the value and remove duplicates then concat with others
pd.concat([df_in.loc[df_in.a == 0, :].drop_duplicates(), df_in.loc[df_in.a != 0,:]])
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