Divide Data Table Object Rows by Row Median in R

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:16:59

213 Views

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

Divide Data Table Rows by Maximum Value in R

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:15:26

194 Views

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

Replace Zero with First Non-Zero in R Data Frame Column

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:13:42

302 Views

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

Remove Scientific Notation from Base R Plot

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:11:14

7K+ Views

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

Merge Two Data Frames of Different Lengths in Python

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:06:54

493 Views

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

Display ID Column Values in a Scatterplot with ggplot2 in R

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:05:00

1K+ Views

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

Remove Rows from R Data Frame Based on Frequency of Values

Nizamuddin Siddiqui
Updated on 13-Aug-2021 10:02:53

875 Views

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

Combine Multiple R Data Frames with a Common Column

Nizamuddin Siddiqui
Updated on 13-Aug-2021 09:59:11

723 Views

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

Remove Row That Contains Maximum for Each Column in R Data Frame

Nizamuddin Siddiqui
Updated on 13-Aug-2021 09:56:01

1K+ Views

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

Change Order of Column in Data Frame Format in R

Nizamuddin Siddiqui
Updated on 13-Aug-2021 09:52:40

234 Views

To change the order of one column data frame and get the output in data frame format in R, we can follow the below steps −First of all, create a data frame.Then, use order function to change the order of column with drop argument set to FALSECreate 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  -0.13734270 2  -1.02796577 3   1.40171778 4  -0.45367796 5   0.06634050 6  -1.27974403 ... Read More

Advertisements