How to remove rows in a dataframe by a specific id number?

Question

I have a dataframe (et5) with many columns and observations. One of the columns is "MRN" which is a code unique to each observation/patient in the dataframe, another is "Age". First, how can I display all of the MRNS and ages side by side? Second, how can I then remove certain observations/patients specifically by MRN.

What my dataframe (et5) looks like

    mrn    Patient's Aneurysm   Age
    12345   Aortic              34
    12344   Iliac               94
    29339   Aortic              49

score 2 · Accepted Answer · answered Apr 11 '20 at 20:53

2

Using dplyr, select mrn and Age:

et5 %>%
select(mrn, Age)

Remove cases:

et5 %>%
filter(!mrn == 12345)

answered Apr 11 '20 at 20:53

Tur

604
4
9

how would I select multiple MRNs to delete – bdg67 Apr 11 '20 at 20:59
also is there a way to sort by descending age (largest to smallest)? – bdg67 Apr 11 '20 at 21:02
2

i. filter(!mrn == c(12345, 13333, 15365)) – Tur Apr 11 '20 at 21:03
1

ii. et5[sort(et5$Age, decreasing = T), ] – Tur Apr 11 '20 at 21:04

How to remove rows in a dataframe by a specific id number?

1 Answers1