Querying and Converting Data Types in R

Working with data is an obvious requirement from data science professionals. The building block of working with data is to understand the most common data types, and acquire the knowledge of processing, querying and converting them. In this guide, you will learn the techniques of querying and converting data types in R.

There are several data types in R, and the most integral ones are listed below:

1. Characters: Text (or string) values are called characters. Assigning a text value to a variable, 't', will make it a character, as is shown below. You can confirm its type with the class() or typeof() function.

Output:

1. Numerics: Decimal values like 3.5 are called numerics in R. It is the default computational data type.

Output:

The variable N is stored as a numeric value, and not an integer. This can be checked using the is.integer() function.

Output:

1. Integers: If you want to create an integer variable, you can use the as.integer() function. Also, all integers are numeric, but the reverse is not true.

Output:

1. Logical: Logical values are often created by comparing two or more variables. These are denoted by boolean values, TRUE or FALSE.

Output:

The most common data types are discussed above, but the most important data type is a data frame.

Data frame is the de-facto data type for most data science projects, as it's organized in tabular format. In simple terms, a data frame is a special type of list where all the elements are of equal length.

Data frames are normally created by read_csv() and read.table() functions when importing the data into R. You can also create a new data frame with the data.frame() function.

Output:

The most common method of dealing with a data frame is by importing the flat files--csv or Excel--into the R environment. The code below performs this task and loads the data that will be used in the subsequent sections.

Output:

The output shows there are 585 observations of 6 variables, described below.

1. UID: Unique identifier tag of the loan applicant.

2. Income: Annual income of the applicant (in US dollars).

3. Credit_score: Whether the applicant's credit score was satisfactory or not.

4. approval_status: Whether the loan application was approved ("1") or not ("0").

5. Age: The applicant’s age in years.

6. Purpose: The reason for the loan application.

For data science and machine learning, it's important for the variables to be in the right data type. To begin, you will use the str() function that prints the structure of the data.

Output:

From the output above, you can see that the data has six variables, three numerical and three categorical. You will start by understanding the levels of character variables.

Output:

The variable Credit_score has only two levels, so it can be converted to a factor variable with the as.factor() function.

Output:

Next, inspect the number of levels for the variable Purpose.

Output:

There are six levels in the variable Purpose which is converted to the factor data type with the code below.

Output:

The last conversion to make is for the variable approval_status. Start by examining the class of the variable.

Output:

The class of the variable approval_status is shown as integer, but it takes only two values, zero and one. In fact, this is a categorical variable and needs to be converted to factor.

Output:

The required conversions have been made, and this can be verified with the code below.

Output:

You have inspected and converted the variables in the section above, and will learn how to query some of the numerical variables. The summary() function provides key statistics about the variables.

Output:

From the output above, you can see that the variable, Age, has negative values. This is incorrect data and needs further querying. There are various ways to do it, one of which is to find out how many such values are there.

Output:

There are only three such records and deleting them won't make any difference. However, the other technique can be to create a new logical variable that will check the condition of age being negative.

The first line uses the ifelse() command to create a new variable AgeNegative, that returns a value TRUE if the expression is correct. Otherwise it returns a FALSE. The second line prints the first five values of the variable.

Output:

The output above shows that the first three values are TRUE, which indicates the three negative age values of the data. In the similar manner, you can inspect other variables in the data.

In this guide, you learned about the most common data types, and acquired the knowledge of querying and converting them. This will help you understand and transform data better to perform complex data science tasks.

To learn more about Data Science with R, please refer to the following guides:

1. Interpreting Data Using Descriptive Statistics with R

2. Interpreting Data Using Statistical Models with R

3. Time Series Forecasting Using R

4. Hypothesis Testing - Interpreting Data with Statistical Models

5. Machine Learning with Text Data Using R

6. Visualization of Text Data Using Word Cloud in R

7. Exploring Data Visually with R

8. Coping with Missing, Invalid and Duplicate Data in R

9. Reshaping Data with R

10. Working with Data Types in R

11. Splitting and Combining Data with R

12. Linear, Lasso, and Ridge Regression with R

13. Binomial Coefficient Analysis with R

14. Implementing Marketing Analytics in R: Part 1

15. Implementing Marketing Analytics in R: Part 2