Operation with pandas dataframe

Question

Considering the following dataframe, I need the df dataframe to have only id's not in df_inf and df_sup:

import pandas as pd

df = pd.DataFrame({'id':[1,2,3,4,5,6,7,8], 'name':['a','b','c','d','e','f','g','h']})
df_inf = pd.DataFrame({'id': [1,2,3]})
df_sup = pd.DataFrame({'id': [6,7,8]})

Is there any proper function of pandas that operates? I'm trying in a fairly trivial way and it's not giving back:

df = df['id'] - (df_inf['id'] + df_sup['id'])
df

df[~(df["id"].isin(df_inf["id"]) | df["id"].isin(df_sup["id"]))] — Fourier
– Fourier, Commented Dec 11, 2019 at 14:55

FBruzzesi · Accepted Answer · 2019-12-11 14:57:34Z

2

You can filter id as follows:

df = df[(~df['id'].isin(df_inf['id'])) & (~df['id'].isin(df_sup['id']))]

answered Dec 11, 2019 at 14:57

FBruzzesi

6,6143 gold badges19 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Operation with pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related