I have the dataset of a distribution company. The actual result that I am looking for is to get the response efficiency when I divide Response over the Billed Population. The challenge here is that the data set there's no billed population as a variable, so I'll have to convert the individual billed energy to represent the billed population and then divide by the Response. How do I go about it?
Response <- df %>%
mutate(Char = nchar(Payment.Efficiency....))%>%
filter(!Char == "NotBilled")%>%
group_by(Zone) %>%
summarise(BilledPop = count(Char >0),
Response = count(Resp >0),
Efficiency = Response/Char)
#> Error in df %>% mutate(Char = nchar(Payment.Efficiency....)) %>% filter(!Char == : could not find function "%>%"
Response
#> Error in eval(expr, envir, enclos): object 'Response' not found
Created on 2020-05-19 by the reprex package (v0.3.0)