LAB ASSESSMENT 1 1 Create a datatrame named employee using dataframeg tunction that consists of all nformation in the table below Emp name John Mary Sara Lynda Thomas Dan Benny Sam Ryan Eng id 1001...


Please help me with solving point 7 in R


LAB ASSESSMENT 1<br>1 Create a datatrame named employee using dataframeg tunction that consists of all<br>nformation in the table below<br>Emp name<br>John<br>Mary<br>Sara<br>Lynda<br>Thomas<br>Dan<br>Benny<br>Sam<br>Ryan<br>Eng id<br>1001<br>1002<br>Tear join<br>Salary<br>2012<br>7005<br>2013<br>5250<br>2014<br>2014<br>2015<br>1008<br>755.5<br>1004<br>9002<br>1005<br>8758<br>1006<br>2015<br>500.7<br>1007<br>2015<br>1000.0<br>6558<br>FOOS<br>1009<br>1010<br>2015<br>2016<br>2016<br>8005<br>9775<br>2 Print the firstS rows of the employee datatrame.<br>* Prirt al records that contain employee name and salary.<br>4 Prine the employee name ther join after year 2014 by using subscrigt<br>* Prent al records that contain employee id, vear join and salary by using subserpt.<br>6 Pint records from row 3to 7that contain employee id and salary by using subscript.<br>1. Prine empioyee id, vear join and salary for employee thar joined before year 2006.<br>& Show the emplove deratrame after sorting by year join in descending order and by<br>salary in ascendng order.<br>* Print the summary statistics of the contert of the employee dataframe.<br>10. Summarice the salaryby year join by showing the mean value<br>NOTES:<br>• Run all your codes using Rinudio.<br>• Work ina group of3. Submt only one solution.<br>• Write your names and IDs.<br>• Submit your solution (codes and outputs) in paf format via Blackboard.<br>• Due date 16 October 2021<br>

Extracted text: LAB ASSESSMENT 1 1 Create a datatrame named employee using dataframeg tunction that consists of all nformation in the table below Emp name John Mary Sara Lynda Thomas Dan Benny Sam Ryan Eng id 1001 1002 Tear join Salary 2012 7005 2013 5250 2014 2014 2015 1008 755.5 1004 9002 1005 8758 1006 2015 500.7 1007 2015 1000.0 6558 FOOS 1009 1010 2015 2016 2016 8005 9775 2 Print the firstS rows of the employee datatrame. * Prirt al records that contain employee name and salary. 4 Prine the employee name ther join after year 2014 by using subscrigt * Prent al records that contain employee id, vear join and salary by using subserpt. 6 Pint records from row 3to 7that contain employee id and salary by using subscript. 1. Prine empioyee id, vear join and salary for employee thar joined before year 2006. & Show the emplove deratrame after sorting by year join in descending order and by salary in ascendng order. * Print the summary statistics of the contert of the employee dataframe. 10. Summarice the salaryby year join by showing the mean value NOTES: • Run all your codes using Rinudio. • Work ina group of3. Submt only one solution. • Write your names and IDs. • Submit your solution (codes and outputs) in paf format via Blackboard. • Due date 16 October 2021

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here