Basic Data Management with R | Data Science

There are many methods to import data into R. However, importing data into a matrix or data frame is only a mere step into the preparation. Within this R tutorial, we will create a data.frame instead of importing the data.

Many organizations perform employee yearly performance ratings within a few weeks into the new year and based on the employee ratings, employees may be able to be put up for promotion if they hit a certain rank.

Employee Promotion Rankings

1. Rank range between 19-25 are eligible for promotion
2. Rank range between 14-18 are not eligible for promotion
3. Rank range lower than or equal to 13 must perform a performance probationary period.

Employee Performance Rankings

1. Rating of 1 – Needs Improvement
2. Rating of 2 – Not Meeting Expectations
3. Rating of 3 – Meeting Expectations
4. Rating of 4 – Exceeding Expectations
5. Rating of 5 – Strongly Exceeding Expectations

Below is a table with the ratings for each of the five employees.

As you can see, each of the employees is rated by their boss in five separate areas of work to distinguish the task rating for each employee.

With the given above data, we can create the employee data frame. We will complete these by using the c() function which returns a vector (a one-dimensional array).

Input:

Now that the vectors are created, let’s move onto creating the data.frame with the data.

Input:

Creating the data.matrix is very simple as we only added the vectors that were created for each employee and will return a matrix.

Input:

Output:

Before we move to the next step, it’s a good idea to be familiar with the arithmetic and logical operators in R.

Arithmetic Operators

Logical Operators

Learning the above arithmetic and logical operators will help a great deal in solving the next few tasks for this R tutorial.

With the above employee data and operators, we can now create an additional column in the empratings data.frame to sum the five employees ratings.

Input:

As you will see below, the total column is added to the end of the total five rankings.

Output:

Before moving forward, let’s find the average rank of each individual’s ranks. We can accomplish this by taking the total of the ranks and dividing by the count of ranks.

Input:

Output:

As you can see above, the mean column is now added to the empratings data matrix for each employee. Could this have any impact on the employee promotion? Promotions will most likely l be based on the total ranks and not the employee ranking average.

Now that we have the total of the rankings for each employee, let’s create an additional variable to categorize the three performance rankings.

Input:

Output:

Now with the additional performance column, we can select observations by only pulling the employees that are Promotion Eligible, Not Promotion Eligible and Performance Probation.

Below are a few data.matrix created for selection to group each level() that we created:

Promotion Eligible Employees

Input:

Output:

Not Promotion Eligible Employees

Input:

Output:

Performance Probation Employees

Input:

Output:

Now with the given data above, a manager will be able to meet with each employee and discuss what actions need to be taken to increase employee performance throughout the new year.

With the newly added data for each employee, the manager could possibly want only data that’s necessary for the promotion. With this information given, the only data that would technically be needed is empid, date(ensure it’s the correct year), total and performance. We will be able to pull this data by using a subset().

Promotion Eligible subset()

Input:

Output:

Subsets are a great function to only pull data that’s necessary and exclude all filler data that has no means for an outcome.