Removing data rows depending on another dataframe

Asked Feb 19 '18 at 15:25

Active Feb 19 '18 at 15:28

Viewed 27 times

I have a dataframe called subjects_to_exclude which looks something like this:

and another dataframe cleaned_bp:

    STUDY_ID    SBP     DBP     VISITCODE
0   1          145.0    91.0    1
1   2          139.0    92.0    2
2   3          141.0    88.0    3
3   4          135.0    92.0    6

And I want to remove the rows which have STUDY_ID values that are in subjects_to_exclude. Should I iterate through the all cleaned_bp multiple times and find a match in STUDY_ID values? (which would be an insufficient way to solve it) Is there a better solution?

edited Feb 19 '18 at 15:28

braaterAfrikaaner

1,072
10
20

asked Feb 19 '18 at 15:25

Huzo

1,652
1
21
52

1

Use `cleaned_bp = cleaned_bp[~cleaned_bp.STUDY_IDisin(subjects_to_exclude.STUDY_ID)]`, it is dupe :( – jezrael Feb 19 '18 at 15:27
@jezrael oh thanks. Couldnt find that question since I did not know about `.isin()` – Huzo Feb 19 '18 at 15:30
1

No problem, good luck! – jezrael Feb 19 '18 at 15:30

Removing data rows depending on another dataframe

0 Answers0