Python

Search

delete rows in a table that are present in another table pandas

print (pd.merge(a,b, indicator=True, how='outer')
         .query('_merge=="left_only"')
         .drop('_merge', axis=1))
   0   1
0  1  10
2  3  30

Comment

delete rows in a table that are present in another table pandas

print (pd.merge(a,b, indicator=True, how='outer')
         .query('_merge=="left_only"')
         .drop('_merge', axis=1))
   0   1
0  1  10
2  3  30

Comment

remove rows from a dataframe that are present in another dataframe?

df.loc[~((df.Product_Num.isin(df2['Product_Num']))&(df.Price.isin(df2['Price']))),:]
Out[246]: 
    Product_Num     Date  Description  Price
0            10   1-1-18  FruitSnacks   2.99
1            10   1-2-18  FruitSnacks   2.99
4            10  1-10-18  FruitSnacks   2.99
5            45   1-1-18       Apples   2.99
6            45   1-3-18       Apples   2.99
7            45   1-5-18       Apples   2.99
11           45  1-15-18       Apples   2.99

Comment

remove rows from a dataframe that are present in another dataframe?

df.loc[~((df.Product_Num.isin(df2['Product_Num']))&(df.Price.isin(df2['Price']))),:]
Out[246]: 
    Product_Num     Date  Description  Price
0            10   1-1-18  FruitSnacks   2.99
1            10   1-2-18  FruitSnacks   2.99
4            10  1-10-18  FruitSnacks   2.99
5            45   1-1-18       Apples   2.99
6            45   1-3-18       Apples   2.99
7            45   1-5-18       Apples   2.99
11           45  1-15-18       Apples   2.99

Comment

PREVIOUS	NEXT

Code Example
Python :: django oauth toolkit permanent access token
Python :: set environment variable flask app
Python :: Code of recursive binary search
Python :: python string cut first n characters
Python :: import stock data from yahoo finance
Python :: destroy label tkinter
Python :: pandas convert string column to int list column
Python :: how to add values to a list in python
Python :: beautifulsoup find element by partial text
Python :: pygame text wrapping
Python :: python 2.7 datetime to timestamp
Python :: run python script from repl
Python :: how to convert pandas series to 2d numpy array
Python :: select default option django form
Python :: python add comma each 3 digits format
Python :: python variable is not none
Python :: subprocess.popen no output
Python :: vscode in browser github
Python :: python pandas how to get the dataframe size
Python :: get output from transaction in brownie
Python :: prime number checking algorithm
Python :: HUNGRY CHEF codechef
Python :: django cleanup settings
Python :: python run code at the same time
Python :: dropna pandas
Python :: reversed python
Python :: install poetry on linux
Python :: python machine learning scale
Python :: fibinacci python
Python :: re.sub in python example

Search

PYTHON

delete rows in a table that are present in another table pandas

delete rows in a table that are present in another table pandas

remove rows from a dataframe that are present in another dataframe?

remove rows from a dataframe that are present in another dataframe?

ADD CONTENT