Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Nizamuddin Siddiqui
Page 100 of 196
How to find the number of unique values in comma separated strings stored in an R data frame column?
If we have comma separated values that contains duplicate and unique values then we might want to find the number of unique values within each comma separated value. To find the unique values in comma separated strings stored in an R data frame column, we can use stri_extract_all_regex function of stringi package along with sapply function.Check out the below examples to understand how it can be done.Example 1Following snippet creates a sample data frame −x
Read MoreHow to combine columns by excluding missing values in R?
If we have a data set that contains missing values at alternate places for each column then we might want to combine the columns by excluding those missing values, this will reduce the data set and the analysis is likely to become easier.For this purpose, we can use na.exclude function along with apply function as shown in the below given examples.Example 1Following snippet creates a sample data frame −x1
Read MoreHow to create a matrix in R by filling the data with predefined values in loop?
If we know the total number of rows we want in our matrix and the number of columns then we can use matrix function to create a matrix by filling the data with predefined values. These values must be equal to the multiplication of number of rows and columns.Check out the below given examples to understand how it works.Example 1Following snippet creates a matrix in R by filling the data with predefined values in loop −n=20 k=2 data=rpois(n*k, 5) M1=matrix(data, nrow=n, ncol=k) M1If you execute the above given snippet, it generates the following output − [, 1] [, 2] ...
Read MoreHow to convert character column of a matrix into numeric in R?
If we have a matrix that contains character columns and we want to convert a single column to numeric then we first need to convert the matrix into a data frame using as.data.frame function after that as.numeric function can be used to change the particular column to numeric type as shown in the below examples.Example 1Following snippet creates a matrix −M1
Read MoreHow to find the average of a particular column in R data frame?
To find the average of a particular column in R data frame, we can take the help of delta ($) operator.For example, if we have a data frame called df that contains a column x then we can find the average of column x by using the command given below −mean(df$x)Example 1Following snippet creates a sample data frame −x1
Read MoreHow to find the mean of all matrices stored in an R list?
To find the mean of all matrices stored in an R list, we can use sapply function along with mean function. For example, if we have a list called LIST that contains some matrices then the mean of each matrix can be found by using the command given below −sapply(LIST,mean)Check out the below given example to understand how it works.ExampleFollowing snippet creates a list of matrices −M1
Read MoreHow to update single value in an R data frame?
To update single value in an R data frame, we can use row and column indices with single square brackets.For example, if we have a data frame called df that contains two columns and ten rows and if we want to change the fifth value in second column to 10 then we can use the command given below −df[5,2]
Read MoreHow to find the coordinate of a value in an R matrix?
The coordinate of a value in an R matrix is the row and column intersection that is the row and column index for that particular value. This can be found by using which function.For example, if we have a matrix called M that contains value starting from 1 to 20 then we can find the coordinate of value 5 by using the command given below − which(M==5,arr.ind=TRUE)ExampleFollowing snippet creates a matrix −M1
Read MoreHow to fill missing values after merging the data frames with another value than NA in R?
To fill missing values after merging the data frames with another value than NA in R, we can follow the below steps −First of all, create two data frames.Then, merge the data frames by a common column between the two.After that, replace the NAs with another value.ExampleCreate the first data frameLet’s create a data frame as shown below −ID
Read MoreHow to use top_n function from dplyr to extract rows based on one column ordered in descending order in R?
To use top_n function from dplyr to extract rows based on one column ordered indescending order in R, we can follow the below steps −First of all, create a data frame.Then, use top_n function dplyr package along with arrange and desc function to extract rows based on one column ordered in descending order.ExampleCreate the data frameLet’s create a data frame as shown below −x
Read More