R Percentage by Group Calculation, The usage of this syntax in practice is demonstrated by the example that follows.
R Percentage by Group Calculation
droplevels in R with examples – Data Science Tutorials
Consider the following data frame, which displays the number of points different basketball players on different teams have scored:
Let’s create a data frame
df <- data.frame(team=c('A', 'A', 'A', 'A', 'A', 'B', 'B', 'B', 'B', 'B'),
points=c(112, 229, 234, 104, 100, 111, 77, 136, 134, 122))
Now we can view the data frame
df
team points 1 A 112 2 A 229 3 A 234 4 A 104 5 A 100 6 B 111 7 B 77 8 B 136 9 B 134 10 B 122
The team percentage of all points scored can be displayed in a new column in the data frame by using the following code.
Arrange Data by Month in R with example – Data Science Tutorials
library(dplyr)
Now we can calculate the percentage of points scored, grouped by team
df1<-data.frame(df %>% group_by(team) %>% mutate(percent = points/sum(points)))
df1
team points percent 1 A 112 0.1437741 2 A 229 0.2939666 3 A 234 0.3003851 4 A 104 0.1335045 5 A 100 0.1283697 6 B 111 0.1913793 7 B 77 0.1327586 8 B 136 0.2344828 9 B 134 0.2310345 10 B 122 0.2103448
The percentage column displays the player’s share of the team’s total points scored.
For example, players on team A scored a total of 773 points.
As a result, the individual in the first row of the data frame, who scored 112 points, accounted for 112/773 = 14% of all the points achieved by team A.
Separate a data frame column into multiple columns-tidyr Part3 (datasciencetut.com)
And so forth.
