Could you please help me to solve the fifth question? by using the code in RStudio

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

Could you please help me to solve the fifth question? by using the code in RStudio

X DB2 4 Bpl
x Download
ادارة و تحليل *
X Assessmen >
X Microsoft
X Microsoft
luilg (9) O
أكاديمية فتر
x Videos on
X Mail - budoD
M إدارة و تحليل X
C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O
1.
Create a dataframe named employee using data.frame() function that consists of all
information in the table below:
Emp_id
Emp_name
Year_join
Salary
1001
John
2012
700.5
1002
Mary
2013
525.0
1003
Sara
2014
755.5
1004
Lynda
Thomas
2014
900.2
1005
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.
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.
ENG E A
م اكتب هنا ل لبحث
Transcribed Image Text:X DB2 4 Bpl x Download ادارة و تحليل * X Assessmen > X Microsoft X Microsoft luilg (9) O أكاديمية فتر x Videos on X Mail - budoD M إدارة و تحليل X C:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O 1. Create a dataframe named employee using data.frame() function that consists of all information in the table below: Emp_id Emp_name Year_join Salary 1001 John 2012 700.5 1002 Mary 2013 525.0 1003 Sara 2014 755.5 1004 Lynda Thomas 2014 900.2 1005 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. 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. ENG E A م اكتب هنا ل لبحث
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
InputStream
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
  • SEE MORE QUESTIONS
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