Read to Lead

Data Manipulation and Transformation Tutorials

How to Select Columns from the Data Frame in R

  • R-PROGRAMMING
Selecting columns from the data frame in R is very important when we have to analyze large data set. Using the dplyr package select() function, we can select specific columns by column name or column index. Using the base R, we can select specific columns from the data frame using their column name or column index as given below: # Select column 1 and column 2 from data frame by column name df[c('col1','col2')] # Select column 2 and column 3 from data frame by column index df[c(2,3)] In this tutorial, we will discuss different ways of selecting columns in R from the data frame.
4 min Read 3

How to Select Rows by Condition in R

  • R-PROGRAMMING
Using the subset() function in R, we can select rows by conditions specified in the square bracket notation for the data frame. We can specify the logical condition with operators to select rows by the condition in R. The Subsetting data frame returns a subset of the data frame which meets the condition. subset syntax: subset(x, ...) where x = data frame object to be subsetted. In this tutorial, we will discuss how to select rows by the condition in R, subset rows with filter in R.
3 min Read 2

How to Subset Data Frame by Column Value in R

  • R-PROGRAMMING
subset() function in R returns the subset of the data frame which meets the condition. Subsetting data frame in R extracts the variables and observations from the data frame which meets the specified condition. subset() function accepts three parameters as data frame to be subsetted, logical expression to keep row or elements to keep and select indicates columns to select from the data frame. subset(x, subset, select, drop = FALSE, …) In this R subset data frame by column value tutorial, we will discuss how to subset data frame by column value in R with examples.
4 min Read 2

How to Convert a Data Frame to Data Table in R

  • R-PROGRAMMING
Using the data.table package setDT() function in R, we can convert data frame to a data table. The data.table package in R provides an enhanced version of a data frame. setDT() function converts the data frame to the data table. setDT() syntax: setDT(x, keep.rownames=FALSE, key=NULL, check.names=FALSE) where, x = data frame, data table or named or unnamed list In this tutorial, we will discuss how to convert a data frame to a data table using the setDT() function and as.
4 min Read 3

How to Convert a Data Frame to Matrix in R

  • R-PROGRAMMING
data.matrix() and as.matrix() functions in R is used to convert a data frame to matrix. The data.matrix() function converts all data frame variables to numeric and displays them as columns of the matrix. The as.matrix() is a generic function and returns a character matrix. In this tutorial, we will discuss how to convert a data frame to a matrix using the data.matrix and as.matrix method. Convert a Data Frame to Matrix using as.
3 min Read 2

Export Data Frame to Excel File in R

  • R-PROGRAMMING
The write_xlsx() from writexl library used to export data frame to excel file. The following method shows how you can do it with syntax. Method: Use write_xlsx() From writexl Package library("writexl") write_xlsx(dataframe,"file_path") The following example shows how to use write_xlsx() function in R. Export Data Frame to Excel File Using write_xlsx() Function in R To use write_xlsx() function you need to follow below steps: Step 1: Create a Data Frame Let’s first start with creating data frame:
1 min Read 0