To divide the row values by row median in R’s data.table object, we can follow the below steps −First of all, create a data.table object.Then, use apply function to divide the data.table object row values by row median.Create the data.table objectLet's create a data frame as shown below −> library(data.table) > x y z DT DTOn executing, the above script generates the below output(this output will vary on your system due to randomization) −    x y  z 1:  5 3  2 2:  1 3  7 3:  6 0 13 4:  6 2 10 5:  8 1  9 6:  9 ... Read More

To divide the row values by row maximum excluding 0 in R’s data.table object, we can follow the below steps −First of all, create a data.table object.Then, use apply function and if else function to divide the data.table object row values by row maximum excluding 0.Create the data.table objectLet’s create a data.table object as shown below −> library(data.table) > x y z DT DTOn executing, the above script generates the below output(this output will vary on your system due to randomization) −    x y z 1:  2 0 3 2:  2 3 2 3:  0 1 3 4:  0 ... Read More

To replace zero with first non-zero occurring at the next position in an R data frame column, we can follow the below steps −First of all, create a data frame.Then, use na.locf function of zoo package to replace zero with first non-zero occurring at the next position in the data frame column.Create the data frameLet's create a data frame as shown below − Live Demo> x df dfOn executing, the above script generates the below output(this output will vary on your system due to randomization) −   x 1  5 2  4 3  2 4  2 5  5 6  4 7  1 ... Read More

To remove scientific notation form base R plot, we can follow the below steps −First of all, create a vector and its plot using plot function.Then, use options(scipen=999) to remove scientific notation from the plot.Create the vector and plotUsing sample function to create a vector and plot the vector with plot function − Live Demo> x plot(x)OutputRemove the scientific notation from the plotUse options(scipen=999) function and again create the same plot − Live Demo> x options(scipen=999) > plot(x)Output

To find the sum of numerical columns based on the combination of values in categorical columns in R data frame, we can follow the below steps −First of all, create a data frame.Then, find the sum of numerical columns based on the combination of values in categorical columns by using recast function of reshape2 package with sum function.Create the data frameExampleLet's create a data frame as shown below − Live Demo> x1 x2 x3 x4 f1 f2 df dfOn executing, the above script generates the below output(this output will vary on your system due to randomization) −Output  x1 x2 x3 x4 ... Read More

To merge two data frames of different length having same values in all columns but at different positions, we can follow the below steps −First of all, create two data frames.Then, merge them using merge function with all argument set to FALSE.Create the data frameLet's create a data frame as shown below − Live Demo> x y z df1 df1On executing, the above script generates the below output(this output will vary on your system due to randomization) −Output   x y z 1  2 3 5 2  3 3 2 3  5 3 1 4  1 2 3 5  1 3 2 ... Read More

To display ID column values in a scatterplot created with ggplot2 in R, we can follow the below steps −First of all, create a data frame.Then, create the scatterplot using ggplot2.After that, create the same plot with label argument inside aes and add the geom_text function.Create the data frameLet's create a data frame as shown below − Live Demo> ID x y df dfOn executing, the above script generates the below output(this output will vary on your system due to randomization) −  ID     x         y 1 1   -0.6980655  0.4815529 2 2    1.0943027  0.2476090 ... Read More

To remove rows from an R data frame based on frequency of values in grouping column, we can follow the below steps −First of all, create a data frame.Then, remove rows based on frequency of values in grouping column using filter and group_by function of dplyr package.Create the data frameLet's create a data frame as shown below − Live Demo> Group Rank df dfOn executing, the above script generates the below output(this output will vary on your system due to randomization) −  Group  Rank 1    IV 7 2     I 8 3    IV 2 4     I ... Read More

To combine multiple R data frames that contains one common column, we can follow the below steps −First of all, create a number of data frames.Then, use join_all function from plyr package to combine the data frames.Create the data frameLet's create a data frame as shown below − Live Demo> x y1 df1 df1On executing, the above script generates the below output(this output will vary on your system due to randomization) −   x y1 1  A  6 2  B 10 3  A  4 4  C  5 5  C  3 6  C  6   7  B  2 8  B 10 9  D ... Read More

To remove row that contains maximum for each column in R data frame, we can follow the below steps −First of all, create a data frame.Then, remove the rows having maximum for each column using lapply and which.max function.Create the data frameLet's create a data frame as shown below − Live Demo> x1 x2 df dfOn executing, the above script generates the below output(this output will vary on your system due to randomization) −   x1 x2 1  9  10 2  1  9 3  8  9 4  7  6 5  4 10 6  4  7 7  8  8 8  5 13 9 ... Read More