To extract a data frame column values as a vector by matching a vector in R, we can use subsetting with %in% operator.For Example, if we have a data frame called df having a column say C and a vector V and we want to extract values in C if ... Read More

To change the name of single column using setNames, we would need to specify the column name that needs to be changed.For example, if we have a data frame called df that contains three columns say Var1, var2, and Var3 and we want to change var2 to Var2 then we ... Read More

To add single quotes to strings in an R data frame column, we can use paste0 function. This will cover the strings with single quotes from both the sides but we can add them at the initial or only at the last position.To add them on both the sides, we ... Read More

When we write a long number in R, by default the printed output of that number is in scientific notation. To stop this printing behavior we can use sprint function.For example, if we have a data frame called df that contains a column say X having long numbers then we ... Read More

Sometimes a variable has a character associated with the numerical values such as variable name etc. If we want to associate a character to numbers then paste0 function can be used.For example, if we have a data frame called df that contains a column say X then we can associate ... Read More

To remove only the first duplicate row by group, we can use filter function of dplyr package with duplicated function.For example, if we have a data frame called df that contains a grouping column say Grp then removal of only first duplicate row by group can be done by using ... Read More

If we have string data stored in R data frame columns then we might want to sort the data frame rows in alphabetical order. This can be done with the help of apply and sort function inside transpose function.For example, if we have a data frame called df that contains ... Read More

To find the percentage of missing values in each column of an R data frame, we can use colMeans function with is.na function. This will find the mean of missing values in each column. After that we can multiply the output with 100 to get the percentage.Check out the below ... Read More

To count the number of times a value occurs in a column of an R data frame, we can use table function for that particular column.For example, if we have a data frame called df that contains a column say Response then finding the number of times a value occurs ... Read More

To add columns with square of each column in R data frame, we can use setNames function and cbind function for squaring each value. This might be required when we want to use squared form of variables in the data analysis.Check out the below given examples to understand how it ... Read More