I have the following condensed data set:
a<-as.data.frame(c(2000:2005)) a$Col1<-c(1:6) a$Col2<-seq(2,12,2) colnames(a)<-c("year","Col1","Col2") for (i in 1:2){ a[[paste("Var_", i, sep="")]]<-i*a[[paste("Col", i, sep="")]] }
I would like to sum the columns Var1 and Var2, which I use:
a$sum<-a$Var_1 + a$Var_2
In reality my data set is much larger – I would like to sum from Var_1 to Var_n (n can be upto 20). There must be a more efficient way to do this than:
a$sum<-a$Var_1 + ... + a$Var_n
Related Posts:
- Poker hand range chart visualization in R
- ggplot wrong color assignment
- How to rename a single column in a data.frame?
- Critical t values in R
- What does %>% function mean in R?
- t-stat for feature selection
- Reasons for using the set.seed function
- R on MacOS Error: vector memory exhausted (limit reached?)
- Remove legend ggplot 2.2
- How do I replace NA values with zeros in an R dataframe?
- How to change legend title in ggplot
- Changing column names of a data frame
- R: Using equation with natural logarithm in nls
- How to change legend title in ggplot
- Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
- R on MacOS Error: vector memory exhausted (limit reached?)
- kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
- R issue “object not found”
- Error in Confusion Matrix : the data and reference factors must have the same number of levels
- Why do I get “number of items to replace is not a multiple of replacement length”
- Having trouble setting working directory
- SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
- R ggplot2 scale_y_continuous : Combining breaks & limits
- Add color to boxplot – “Continuous value supplied to discrete scale” error
- “Error: Mapping should be created with `aes()` or `aes_()`.”
- Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
- Error in plot.window(…) : need finite ‘xlim’ valuescc
- Longer object length is not a multiple of shorter object length?
- rmarkdown error “attempt to use zero-length variable name”
- cannot coerce type ‘closure’ to vector of type ‘character’
- Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
- Logistic regression – eval(family$initialize) : y values must be 0 <= y <= 1
- R – longer object length is not a multiple of shorter object length
- Opposite of %in%: exclude rows with values specified in a vector
- Arcsine transformation of percentage data
- R loop that adds following numbers to each element in list
- R: Using equation with natural logarithm in nls
- remove legend title in ggplot
- scale_color_manual() not working
- Can I calculate z-score with R?
- Clear R environment of all objetcs & packages
- Function to clear the console in R and RStudio
- “replace” function examples
- R: need finite ‘ylim’ values in function
- Convert a list to a data frame
- Manually colouring plots with `scale_fill_manual` in ggplot2 not working
- Why I get this error writing data to a file
- Correlation between multiple variables of a data frame
- Adding a regression line on a ggplot
- Remove grid, background color, and top and right borders from ggplot2
- R: “Unary operator error” from multiline ggplot2 command
- What does the double percentage sign (%%) mean?
- invalid type (list) for variable
- not a Stata version 5-12 .dta file
- How to subset a Data frame column wise using column names?
- Mean of a column in a data frame, given the column’s name
- No non-missing arguments warning when using min or max in reshape2
- How to convert a factor to integer\numeric without loss of information?
- Having trouble setting working directory
- Custom legend for multiple layer ggplot
- Understanding `scale` in R
- file.path function in R
- How to move or position a legend in ggplot2
- Rotating and spacing axis labels in ggplot2
- Plot multiple lines (data series) each with unique color in R
- Error: invalid subscript type ‘list’ in R
- “non-numeric argument to binary operator” error in R
- How to sum a variable by group
- readOGR() cannot open file
- What does “The following object is masked from ‘package:xxx'” mean?
- R error in unique.default(x) unique() applies only to vectors
- Combine two data frames by rows (rbind) when they have different sets of columns
- Boxplot dplyr: Error: non-numeric argument to binary operator
- Function to calculate R2 (R-squared) in R
- How do I install an R package from source?
- Getting invalid model formula in ExtractVars when using rpart function in R
- Too few periods for decompose()
- Aggregate multiple columns at once
- Error in match.fun(FUN)
- Error in file(filename, “r”, encoding = encoding) : cannot open the connection
- installing data.table results in “there is no package”
- R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
- changing title in multiplot ggplot2 using grid.arrange
- Correct syntax for mutate_if
- Plotting data in R; error: default method not implemented for type ‘list’
- Error:attempt to apply non-function
- Changing fonts in ggplot2
- Error in xj[i] : invalid subscript type ‘list’
- How do you specifically order ggplot2 x axis instead of alphabetical order?
- Sample random rows in dataframe
- Batch convert columns to numeric type
- Error in eval(predvars, data, env) : object ‘Rm’ not found
- How to initialize a vector with fixed length in R
- How can I make a list of lists in R?
- Error in x[[i]] : recursive indexing failed at level 2
- How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
- Warning: non-integer #successes in a binomial glm! (survey packages)
- Remove columns from dataframe where some of values are NA
- Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
- How to deal with “data of class uneval” error from ggplot2?