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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education