Write R programing to perform the following: Q1 Read voter.xlsx file and store all data in a data frame. a. Using filter function, find all female voters whose age is between 30 and 40 (both inclusive). b. Using filter function, find all voters whose district code and zip code are odd numbers. c. Using filter and arrange functions, sort all voters in 77002 by age in descending order. d. Using filter, arrange, and select functions, sort all male voters by name in ascending order and display only their names, voter IDs, and ages. e. Using filter and select functions, display only the name and gender of the voters whose district ID is less than 10 and zip code is greater than 77010. f. Using mutate function, add Voting Day column by getting the remainder of District ID divided by 7 and adding 1 to the remainder. Therefore, voting day of each voter will be a number from 1 to 7. For instance, the voting day of Heather will be 2 since her district ID is 92 and the remainder of 92/7 is 1. g. Using mutate function, add a new column showing the age percentile of each voter. h. Using summarise and group_by functions, compute the average age in each district. i. Using summarise and group_by functions, compute the number of voters in each zip code.
Write R programing to perform the following:
Q1 Read voter.xlsx file and store all data in a data frame.
a. Using filter function, find all female voters whose age is between 30 and 40 (both
inclusive).
b. Using filter function, find all voters whose district code and zip code are odd numbers.
c. Using filter and arrange functions, sort all voters in 77002 by age in descending order.
d. Using filter, arrange, and select functions, sort all male voters by name in ascending
order and display only their names, voter IDs, and ages.
e. Using filter and select functions, display only the name and gender of the voters
whose district ID is less than 10 and zip code is greater than 77010.
f. Using mutate function, add Voting Day column by getting the remainder of District ID
divided by 7 and adding 1 to the remainder. Therefore, voting day of each voter will be a
number from 1 to 7. For instance, the voting day of Heather will be 2 since her district ID is 92
and the remainder of 92/7 is 1.
g. Using mutate function, add a new column showing the age percentile of each voter.
h. Using summarise and group_by functions, compute the average age in each district.
i. Using summarise and group_by functions, compute the number of voters in each zip
code.
Step by step
Solved in 3 steps
