compute sum for space string column

Question

I have dataframe that contains space in the column name

df <- data.frame("a 1"=c("jan","jan" , "feb"),"t t" =c(10,10,1))
colnames(df) <- c("a 1","t t")

I want to sum the "t t" column on the basis of "a 1" I tried this

df %>% group_by("a 1") %>% summarise(tx = sum("t t"))

the expected result is a dataframe having

  a 1    t t
  jan     20
  feb     1

Use backticks : `df %>% group_by(\`a 1\`) %>% summarise(tx = sum(\`t t\`))` — Ronak Shah, Jun 29 '20 at 11:59
Don't use quotes when piping, use backticks (because you have space in your names). i.e. ```df %>% group_by(`a 1`) %>% summarise(tx = sum(`t t`))``` — Sotos, Jun 29 '20 at 12:00

score 1 · Accepted Answer · answered Jun 29 '20 at 11:59

1

Does this work?

df %>% group_by(`a 1`) %>% summarise(tx = sum(`t t`))

answered Jun 29 '20 at 11:59

Georgery

1 Answers1