Nizamuddin Siddiqui has Published 2307 Articles

How to remove dollar sign from a column of a data.table object in R?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 07:01:14

320 Views

To remove dollar sign in data.table object in R, we can follow the below steps −First of all, create a data.table object.Then, use gsub function along with lapply function to remove dollar sign.ExampleCreate the data.table objectLet’s create a data.table object as shown below −library(data.table) Sale_PriceRead More

How to multiply vector values in sequence with columns of a data.table object in R?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:58:11

449 Views

To multiply vector values in sequence with data.table object columns in R, we can follow the below steps:−First of all, create a data.table.Then, create a vector.After that, use t function for transpose and multiplication sign * to multiply vector values in sequence with data.table object columns.Example 1Create the data.table objectLet’s ... Read More

How to find the column totals if some columns are categorical in R data frame?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:51:05

105 Views

To find the column totals 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 column totals if some columns are categorical.Example 1Create the data frameLet’s create a data ... Read More

How to add rows in an R data frame?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:47:21

232 Views

To add rows in an R data frame, we can follow the below steps −First of all, create a data frame.Then, use rbind function and the vectors that will be added as rows to the data frame.ExampleCreate the data frameLet’s create a data frame as shown below −xRead More

How to create a column of first non-zero value in each row of a data.table object in R?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:44:54

256 Views

To create a column of first non-zero value in each row of a data.table object in R, we can follow the below steps −First of all, create a data.table object with some zero values.Then, use apply function and a custom function to find the first non-zero in each row of ... Read More

How to find the percent of zeros in each row of an R data frame?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:39:22

332 Views

To find the percent of zeros in each row of an R data frame, we can follow the below steps −First of all, create a data frame.Then, use rowSums function along with ncol function to find the percent of zeros in each row of the data frame.ExampleCreate the data frameLet’s ... Read More

How to subset an R data frame by ignoring a value in one of the columns?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:37:20

571 Views

To subset an R data frame by ignoring a value in one of the columns, we can follow the below steps −First of all, create a data frame.Then, use single square brackets to subset the data frame by ignoring a value in one of the columns.ExampleCreate the data frameLet’s create ... Read More

How to remove percentage sign at last position from every value in R data frame column?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:33:28

2K+ Views

To remove percentage sign at last position from every value in R data frame column, we can follow the below steps −First of all, create a data frame with a column having percent sign at last position in every value.Then, use gsub function to remove the percent sign at last ... Read More

How to find the absolute maximum of each group in R data frame?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:30:07

881 Views

To find the absolute maximum of each group in R data frame, we can follow the below steps −First of all, create a data frame.Then, use summarise_each function of dplyr package along with which.max and abs function to find the absolute maximum of each group after grouping with group_by.Example 1Create ... Read More

How to find the rank of each value in columns if some columns are categorical in R data frame?

Nizamuddin Siddiqui

Nizamuddin Siddiqui

Updated on 12-Nov-2021 06:25:33

54 Views

To find the rank of each value in columns 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 rank of each value in columns if some columns are ... Read More

Advertisements