Find Row Median of Columns with Same Name in Data Table Object in R

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:29:47

144 Views

To find the row median of columns having same name in data.table object in R, we can follow the below steps −First of all, create a data.table with some columns having same name.Then, use tapply along with colnames and median function to find the row median of columns having same name.ExampleCreate the data.tableLet’s create a data.table as shown below −library(data.table) DT

Create Repeated Values Column with Random Selection in R Data Frame

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:25:00

1K+ Views

To generate a repeated values column with each value in output selected randomly in R data frame, we can use replicate function. The replicate function will repeat the vector values up to the number of times we want and each value will be randomly selected. To understand how it works, check out the below examples.Example 1Using replicate function to create a data frame df with normal random variable column of size 25 −x

Create a Vector of Matrices in R

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:24:13

550 Views

As of now it is not possible to create a vector of matrices in R. If we want to do it, we should prefer a list, hence we can create a list with matrices.For Example, if we have matrices say M1, M2, and M3 and we want to create a list of these matrices then we can use the below given command −list(M1,M2,M3)ExampleTo create a vector of matrices in R, use the following snippet −List

Find Index of Values in Data Table Column in R

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:23:00

1K+ Views

To find the index of values in data.table object column in R if they occur once, we can follow the below steps −First of all, create a data.table object.Then, use which function along with duplicated function and single square brackets for subsetting to find the index of values in a column if they occur once.Example 1Create the data.table objectLet’s create a data.table object as shown below −library(data.table) x

Find Exponent of Each Value in R Data Frame Columns

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:20:27

262 Views

To find the exponent of each value if some columns are categorical in R data frame, we can follow the below steps −First of all, create a data frame.Then, use numcolwise function from plyr package to find the exponent if some columns are categorical.ExampleCreate the data frameLet’s create a data frame as shown below −Level

Sort Numerical Factor Column in R Data Frame

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:17:24

2K+ Views

To sort a numerical factor column in an R data frame, we would need to column with as.character then as.numeric function and then order function will be used.For Example, if we have a data frame called df that contains a numerical factor column say F then we can use sort F by using the below mentioned command −df[order(as.numeric(as.character(df$F))),]Example 1Following snippet creates a sample data frame −Class

Convert First Letter to Capital in R Data Frame Column

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:16:52

1K+ Views

To convert first letter into capital in R data frame column, we can follow the below steps −First of all, create a data frame with string column.Then, use sub function to convert first letter into capital in string column.ExampleCreate the data frameLet’s create a data frame as shown below −Names

Create Column of Rounded Values in Data Frames Stored in R List

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:14:16

121 Views

To create a column of rounded values in data frames stored in R list, we can follow the below steps −First of all, create a list of data frames.Then, use lapply function to create a column of rounded valuesin data frames stored in the list.ExampleCreate the list of data framesUsing data.frame function to create data frames and list function to create the list of those data frames −df1

Create Column of Factorial Values in Data Frames Stored in R List

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:10:34

271 Views

To create a column of factorial values in data frames stored in R list, we can follow the below steps −First of all, create a list of data frames.Then, use lapply function to create a column of factorial values in data frames stored in the list.ExampleCreate the list of data framesUsing data.frame function to create data frames and list function to create the list of those data frames −df1

Count Unique Group Combinations in R Data Frame

Nizamuddin Siddiqui
Updated on 10-Nov-2021 06:08:44

3K+ Views

To find the count of unique group combinations in an R data frame, we can use count function of dplyr package along with ungroup function.For Example, if we have a data frame called df that contains three grouping columns say G1, G2, and G3 then we can count the unique group combinations in df by using the below given command −count(df,G1,G2,G3)%%ungroup()Example 1Following snippet creates a sample data frame −Grp1

Advertisements