python - Pandas dataframe: remove rows found in other dataframeseries - Stack Overflow

admin管理员组

文章数量:1345398

I have a pandas dataframe where i want to obtain the unique 'task type' (column) not executed by the 'users' (column) found in the 'leavers' list.

Right now i can identitfy the tasks carried out by the leavers, but i'm stuck at how to substrac those task types from the main dataframe.

df_leavers = df.loc[df['Assignee+'].isin(leavers)]

Some help would be much appriciated. Sorry if it is a dumb question but i' pretty new to pandas and i can not find the answer anywhere else.

I have a pandas dataframe where i want to obtain the unique 'task type' (column) not executed by the 'users' (column) found in the 'leavers' list.

Right now i can identitfy the tasks carried out by the leavers, but i'm stuck at how to substrac those task types from the main dataframe.

df_leavers = df.loc[df['Assignee+'].isin(leavers)]

Some help would be much appriciated. Sorry if it is a dumb question but i' pretty new to pandas and i can not find the answer anywhere else.

• python
• pandas
• dataframe

Share Improve this question Follow edited 18 hours ago psyduck14 asked 19 hours ago psyduck14psyduck14 1122 bronze badges 1

• 1 Please provide a minimal reproducible example of your data and the matching expected output. – mozway Commented 18 hours ago

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

If you could provide some sample data, it would help, as it is not quite enough information.

Meanwhile here is a sample code to calculate unique task types that were not executed by leavers.

import pandas as pd

data = {
    'task type': ['Development', 'Testing', 'Design', 'Development', 'Testing', 'Analysis'],
    'Assignee+': ['Alice', 'Bob', 'Charlie', 'Dave', 'Eve', 'Frank']
}
df = pd.DataFrame(data)

print(df)

leavers = ['Alice', 'Bob']

executed_by_leavers = df.loc[df['Assignee+'].isin(leavers), 'task type']
unique_executed_task_types = executed_by_leavers.unique()

print("Unique task types not executed by leavers:", unique_executed_task_types)

Original df:

     task type Assignee+
0  Development     Alice
1      Testing       Bob
2       Design   Charlie
3  Development      Dave
4      Testing       Eve
5     Analysis     Frank

So if Alice and Bob are the leavers then Development and Testing are the unique task not executed by leavers.

本文标签： pythonPandas dataframe remove rows found in other dataframeseriesStack Overflow