Ali_T
December 7, 2020, 4:16am
1
Hello!
I'm trying to graph quarterly job losses in a number of different fields, but I want to add up the number of job losses for all the fields together for each quarter, that way i can graph yearly quarters versus jobs lost.
The first column of my table is Quarters (with 17 total rows), but then the rest of the columns are number of job losses. How do I add the rest of the columns together for each quarter? That way I have clear X and Y variables.
FJCC
December 7, 2020, 4:57am
2
Is this the sort of thing you are trying to do?
library(dplyr)
#>
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#>
#> filter, lag
#> The following objects are masked from 'package:base':
#>
#> intersect, setdiff, setequal, union
DF <- data.frame(Quarter=c("Q1","Q2","Q3"),
V1=c(123,213,333),V2=c(495,372,528),V3=c(45,72,44))
DF
#> Quarter V1 V2 V3
#> 1 Q1 123 495 45
#> 2 Q2 213 372 72
#> 3 Q3 333 528 44
#Sum across rows
DF <- DF %>% rowwise() %>% mutate(Total=sum(c_across(V1:V3)))
DF
#> # A tibble: 3 x 5
#> # Rowwise:
#> Quarter V1 V2 V3 Total
#> <chr> <dbl> <dbl> <dbl> <dbl>
#> 1 Q1 123 495 45 663
#> 2 Q2 213 372 72 657
#> 3 Q3 333 528 44 905
Created on 2020-12-06 by the reprex package (v0.3.0)
Ali_T
December 7, 2020, 5:06am
3
Yeah, exactly. When I try to use that code, it gives me this error:
Error: Problem with mutate()
input Total
.
x Can't combine Quarter
and 3
.
Input Total
is sum(c_across(1:16))
.
The error occurred in row 1.
FJCC
December 7, 2020, 5:36am
5
Ali_T:
sum(c_across(1:16))
If the first column is the quarter you should not include it int the sum. Do you mean
sum(c_across(2:16))
1 Like
system
Closed
December 28, 2020, 5:36am
6
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed. If you have a query related to it or one of the replies, start a new topic and refer back with a link.