1. Create a dataframe named employee using data.frame() function that consists of all information in the table below: Emp id Salary 700.5 Emp_name Year_join 1001 John 2012 1002 Mary 2013 525.0 1003 Sara 2014 755.5 1004 Lynda 2014 900.2 1005 Thomas 2015 875.8 1006 Dan 2015 500.7 1007 Jenny 2015 1000.0 1008 Sam 2015 655.8 1009 Ryan 2016 800.5 1010 Rick 2016 977.5

Principles of Information Security (MindTap Course List)
6th Edition
ISBN:9781337102063
Author:Michael E. Whitman, Herbert J. Mattord
Publisher:Michael E. Whitman, Herbert J. Mattord
Chapter8: Cryptography
Section: Chapter Questions
Problem 3E
icon
Related questions
Question
100%

Could you please help me to solve this assessment the codes will be by using RStudio

X DB2 4 8pl
X Download
ادارة و تحليل *
X Assessmen >
X Microsoft
X Microsoft
0 )A( واتساب
أكاديمية قجر
x Videos on
X Mail - budo
M1 إدارة و تحليل
C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O
LAB ASSESSMENT 1
Create a dataframe named employee using data.frame() function that consists of all
information in the table below:
1.
Emp_id
Emp_name
Year_join
Salary
1001
John
2012
700.5
1002
Mary
2013
525.0
1003
Sara
2014
755.5
1004
Lynda
2014
900.2
1005
Thomas
2015
875.8
1006
Dan
2015
500.7
1007
Jenny
2015
1000.0
1008
Sam
2015
655.8
1009
Ryan
2016
800.5
1010
Rick
2016
977.5
2.
Print the first 3 rows of the employee dataframe.
3.
Print all records that contain employee name and salary.
4.
Print the employee name that join after year 2014 by using subscript.
5.
Print all records that contain employee id, year join and salary by using subscript.
6.
Print records from row 3 to 7 that contain employee id and salary by using subscript.
7.
Print employee id, year join and salary for employee that joined before year 2016.
ull lia sI P
Transcribed Image Text:X DB2 4 8pl X Download ادارة و تحليل * X Assessmen > X Microsoft X Microsoft 0 )A( واتساب أكاديمية قجر x Videos on X Mail - budo M1 إدارة و تحليل C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O LAB ASSESSMENT 1 Create a dataframe named employee using data.frame() function that consists of all information in the table below: 1. Emp_id Emp_name Year_join Salary 1001 John 2012 700.5 1002 Mary 2013 525.0 1003 Sara 2014 755.5 1004 Lynda 2014 900.2 1005 Thomas 2015 875.8 1006 Dan 2015 500.7 1007 Jenny 2015 1000.0 1008 Sam 2015 655.8 1009 Ryan 2016 800.5 1010 Rick 2016 977.5 2. Print the first 3 rows of the employee dataframe. 3. Print all records that contain employee name and salary. 4. Print the employee name that join after year 2014 by using subscript. 5. Print all records that contain employee id, year join and salary by using subscript. 6. Print records from row 3 to 7 that contain employee id and salary by using subscript. 7. Print employee id, year join and salary for employee that joined before year 2016. ull lia sI P
X DB2 4 Bplu
x Download
ادارة و تحليل *
X Assessmen
X Microsoft
X Microsoft
yluilg (A) O
أكاديمية قجر
x Videos on
X Mail - budoD
M1 إدارة و تحليل
C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O
5.
Print all records that contain employee id, year join and salary by using subscript.
6.
Print records from row 3 to 7 that contain employee id and salary by using subscript.
7.
Print employee id, year join and salary for employee that joined before year 2016.
Show the employee dataframe after sorting by year join in descending order and by
salary in ascending order.
8.
9.
Print the summary statistics of the content of the employee dataframe.
10. Summarize the salary by year join by showing the mean value.
NOTES:
Run all your codes using RStudio.
Work in a group of
Submit only one solution.
Write your names and IDs in comment of the code.
#Name:
#ID:
Submit your solution in R format via Blackboard.
Due date: 5 October 2020
oull lia SI p
Transcribed Image Text:X DB2 4 Bplu x Download ادارة و تحليل * X Assessmen X Microsoft X Microsoft yluilg (A) O أكاديمية قجر x Videos on X Mail - budoD M1 إدارة و تحليل C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O 5. Print all records that contain employee id, year join and salary by using subscript. 6. Print records from row 3 to 7 that contain employee id and salary by using subscript. 7. Print employee id, year join and salary for employee that joined before year 2016. Show the employee dataframe after sorting by year join in descending order and by salary in ascending order. 8. 9. Print the summary statistics of the content of the employee dataframe. 10. Summarize the salary by year join by showing the mean value. NOTES: Run all your codes using RStudio. Work in a group of Submit only one solution. Write your names and IDs in comment of the code. #Name: #ID: Submit your solution in R format via Blackboard. Due date: 5 October 2020 oull lia SI p
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Requirement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Principles of Information Security (MindTap Cours…
Principles of Information Security (MindTap Cours…
Computer Science
ISBN:
9781337102063
Author:
Michael E. Whitman, Herbert J. Mattord
Publisher:
Cengage Learning
A+ Guide To It Technical Support
A+ Guide To It Technical Support
Computer Science
ISBN:
9780357108291
Author:
ANDREWS, Jean.
Publisher:
Cengage,