select(column, (contains()) not showing results

48 Views Asked by At
 chase_2021 = chase[c(143:1020),]
 
 paychecks = chase_2021 %>% 
     select(Posting.Date, Amount, Description, starts_with('CVS'), ends_with('PPD ID: 9953382345')) %>% 
     filter(Amount > 100, Amount < 1000)

I'm currently trying to find my paychecks from last year based on a dataset I downloaded from one of my bank accounts. If I subet for transactions that were more than $100, R displays money I earned through my employer, but also through investments and cash I received from people who owed me at the time. Paychecks from my employer are listed on CVS PAYROLL PPID under the Description column. The code above still displays the earnings I received from my employer and others. Also, I couldn't subset the columns by year with ends_with(2021) So I had to filter with column numbers.

0

There are 0 best solutions below