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
-
Economics & Finance
Articles by Nizamuddin Siddiqui
Page 148 of 196
How to find the sum of a column values up to a value in another column in R?
To find the sum of a column values up to a particular value in another column, we can use cumsum function with sum function.For example, if we have a data frame called df that contains two columns say x and y and we want to find the sum of x values until y is equal to 2 then we can use the following command −sum(df$x[cumsum(df$y==2)==0])Example 1Following snippet creates a sample data frame −x1
Read MoreHow to create sample of rows using ID column in R?
To create sample of rows using ID column, we can use sample function. We would need to apply the sample function on ID column and take the subset of rows with the help of single square brackets.For example, if we have a data frame called df that contains an ID column say ID then we can sample 4 rows of df using ID column as follows −df[sample(df$ID,4),]Example 1Following snippet creates a sample data frame −Emp_ID
Read MoreHow to find the combination of matrix values in R?
To find the combination of matrix values in R, we can use expand.grid function with split function.For example, if we have a matrix called M then to create the combination of matrix values we can use the code mentioned below −do.call(expand.grid,split(M,rep(1:nrow(M),ncol(M))))Check out the examples given below to understand how it works.Example 1Following snippet creates a matrix −M1
Read MoreHow to round values in proportion table in R?
To round values in proportion table in R, we can first save the proportion table in an object and then use the round function.For example, if we have a vector say X then we can create a proportion table for data in X using prop.table(table(X)) and store it in an object called Tab and then round the values to two decimal places by using the below given command −round(Tab,2)Example 1Following snippet creates a sample data frame −x1
Read MoreHow to convert matrices stored in a list into data frames in R?
A list may contain vectors, data frames, matrices, lists etc. If a list contains matrices and we want to convert those matrices into data frames then lapply function can be used along with as.data.frame function.For example, if we have a list called LIST that contains matrices then we can convert those matrices into data frames by using the below command −lapply(LIST,function(x) as.data.frame(x))ExampleFollowing snippet creates a list of matrices −M1
Read MoreHow to find the mean of a column grouped by date in R?
To find the mean of a column grouped by date, we can simply use aggregate function. For Example, if we have a data frame called df that contains a date column say Date and numerical column say Num then we can find the mean of Num by dates in the Date column by using the below command −aggregate(Num~Date,df,mean)Example 1Following snippet creates a sample data frame −Date
Read MoreHow to rotate a ggplot2 graph in R?
To rotate a ggplot2 graph, we can save it in an object and then use the print function by defining the angle with viewport.For example, if we have a graph saved in an object called PLOT then we can rotate it to 180 degrees by using the below mentioned command −print(PLOT,vp=viewport(angle=180))ExampleFollowing snippet creates a sample data frame −x
Read MoreHow to find the frequency for all columns based on a condition in R?
To find the conditional frequency for all columns based on a condition, we can use for loop where we will define the length of each column with condition for which we want to find the frequency.For example, if we have a data frame called df and we want to find the number of values in each column that are greater than 5 then we can use the below given command − Columns
Read MoreHow to add row percentages to contingency table in R?
To add row percentage to contingency table in R, we can use rowSums and sum function with table values and combine them with cbind function.For Example, if we have a table called TAB then we can add row percentages to TAB by using the below command −cbind(TAB,rowSums(TAB),rowSums(TAB)/sum(TAB))Example 1Following snippet creates a sample data frame −Grp1
Read MoreHow to extract data.table columns using a vector of column numbers in R?
When we have large number of columns and only few of them are useful for analysis then extraction of such columns becomes helpful.If we have a vector that contains column numbers and we want to extract the columns from a data.table object then we can use the single square brackets for subsetting of columns as shown in the below given examples.Example 1Following snippet creates data.table object and Vector1 −x1
Read More