Could you please help me to solve this assessment the codes will be by using RStudio X DB2 4 8plX Downloadادارة و تحليل *X Assessmen >X MicrosoftX Microsoft0 )A( واتسابأكاديمية قجرx Videos onX Mail - budoM1 إدارة و تحليلC:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo OLAB ASSESSMENT 1Create a dataframe named employee using data.frame() function that consists of allinformation in the table below:1.Emp_idEmp_nameYear_joinSalary1001John2012700.51002Mary2013525.01003Sara2014755.51004Lynda2014900.21005Thomas2015875.81006Dan2015500.71007Jenny20151000.01008Sam2015655.81009Ryan2016800.51010Rick2016977.52.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 Bplux Downloadادارة و تحليل *X AssessmenX MicrosoftX Microsoftyluilg (A) Oأكاديمية قجرx Videos onX Mail - budoDM1 إدارة و تحليلC:/Users/bebo2/Downloads/Lab%20Assessment%201.pdf | alo O5.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 bysalary 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 ofSubmit 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 2020oull lia SI p

Since you have asked multiple questions in a single request, we will be answering only the first…

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

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

See similar textbooks

Similar questions

You are invited to design a national identification number system for U.S. citizens. The ID number should: reflect the state, county, and city the person lives in; reflect the person’s date of birth; take into account the possibility of multiple individuals sharing identical birthday in the same city. Please also EXPLAIN your design of this ID number system with appropriate examples. Merely providing an example is not sufficient.
Is there a specific technique for processing data? (Please provide specifications.)
What precisely do you mean when you refer to "the objectives of the authentication procedure"? Please elaborate on the benefits and drawbacks of different authentication methods.
Please detail the processes involved in converting and switching over the data.
What is the first thing that has to be done when fixing corrupted data?
Determine which passwords are flawed and how to correct them.
Q: Explain the major diferences between FA and TG using examples.
What is the most effective way to backup user data? Your solution has to be proficient, quick, and economical.
Salesforce Please describe the details when we receive the SOQL 201 Issue in the code. Salesforce Development
SAGA (The South African Golf players Association) is hosting a virtual golf competition. Both professional as well as amateur golf players can register to take part in the competition. A professional golf player is defined as a person who is a member of the SAGA and is ranked on the professional list of golf players. Amateur golf players are divided into two categories for the competition, viz.1 - student (university or college) and 2 - adult.On registration the participants need to provide their ID-number and name. Professional golf players also need to indicate the number of years that they have been members of SAGA and their position on the professional golf players’ list. Amateur golf players need to provide the category they will participant in (1 or 2 – see previous paragraph). The information of a number of participants has been captured in the text file players.txt. The text file is provided. Example of the first 4 lines of text in the text file:A registration code must be…
What is the purpose of using the data, and why?
Suppose it is 4:00 p.m., September 29, 2008. Fitter Snacker’s CEO sends this e-mail message to the accounting manager: “I need to meet with the Board of Directors tomorrow morning. The Board members are concerned about the current sales of our energy bars. They would like to see sales data for today, 9/29, as a typical day. Please complete the attached report and have it on my desk by 9:00 a.m. tomorrow, September 30.” The blank table shown in Figure 1 is attached to the memo. Given the company’s sales order data-processing practices, why won’t the accountants be able to easily accomplish this task? Cite the practices that cause difficulty, and explain. If FS had an ERP system, why would this task be easy to complete?