Reaplce_na in all columns starting with "CPA" R

Asked Dec 13 '19 at 09:29

Active Dec 13 '19 at 09:30

Viewed 23 times

I have a table with columns like CPA_A to CPA_U. I want to create a new column X as the sum of CPA_A to CPA_U in DPLYR. I tried something like

 mutate(sum_onCPA = rowSums(.SD), .SDcols = grep("CPA", names(M_bridge)))

but it does not work. Any clue?

edited Dec 13 '19 at 09:30

Wiktor Stribiżew

asked Dec 13 '19 at 09:29

IRT

I think you mixed `dplyr` with `data.table` – Sotos Dec 13 '19 at 09:31
1

You can just do `data %>% mutate(sum_onCPA = rowSums(select(., starts_with("CPA"))))`. – tmfmnk Dec 13 '19 at 09:32
Why do you have `replace_na` in your title ? What it has to do here ? – Ronak Shah Dec 13 '19 at 09:35

0 Answers0