Read to Lead

Data Manipulation and Transformation Tutorials

Create a Data Frame from Vectors in R

  • R-PROGRAMMING
Use the data.frame() function in R to create a data frame from vectors. The data frame in R is a two-dimensional array or table where each row contains the value of each column and the column contains the value for each variable. It can contain heterogeneous data. Vectors in R contain data of the same data type. In this example, we will discuss how to create a data frame from vectors, add a new column vector to a data frame.
3 min Read 1

Data frame Conditional Selection in R

  • R-PROGRAMMING
Using the square bracket with conditional selection in the data frame, you can subset the data frame in r and extract the observations you would like to keep or exclude. You can also subsetting the data frame in r using the subset() function in R. In this tutorial, we will discuss how to subset rows of data from the data frame using the logical expression in R. Subset Rows with Equal To condition Using the equal to (==) operator, you can subset the data frame.
3 min Read 2

Export a Data Frame to CSV file in R

  • R-PROGRAMMING
Using the write.csv function in base R, it can export a data frame to a CSV file. The write.csv function takes data frame and path of export to CSV file as the input parameters. Use the following syntax to write a data frame to the CSV file. write.csv(dataframe,"path of export data frame to csv file", row.names = FALSE) R language provides other methods like the write_csv function from the readr package and fwrite function of data.
4 min Read 3

How to Check if Object is Data Frame in R

  • R-PROGRAMMING
is.data.frame() function in R is used to check if the object is a data frame or not. is.data.frame() function in R returns TRUE if the object is data frame else returns FALSE. Data frame in R is very powerful to store data of different data types, data manipulation. data.frame() function is used to create a data frame in R. In this tutorial, we will discuss how to use is.data.frame() function in R to check the object is data frame in R or not.
2 min Read 1

How to Get Data Frame Row Names in R

  • R-PROGRAMMING
All the data frames have row names. Using the row.names() or row.names.data.frame() function in R, we can get the data frame row names. row.names() or row.names.data.frame() function gets the character vectors of the length of the rows in the data frame. In this tutorial, we will discuss about how to get data frame row names in R using row.names() and row.names.data.frame() function. Get R Data Frame Row Names using row.names Use the row.
3 min Read 1

How to Get Mean of Columns in Data Frame in R

  • R-PROGRAMMING
mean() function and colMeans() function of the R base package is used to get the mean of columns in the data frame. It accepts the data frame as input argument and column name to find the mean of the column in R. The function calculates the mean of a column by calculating the sum of the values and dividing by the number of rows in it. In this tutorial, we will discuss how to get the mean of columns in a data frame in R using mean(), colMeans(), and summarise() function of the dplyr package.
4 min Read 3

How to Merge Data Frames in R

  • R-PROGRAMMING
Merge data frames are quite useful when data is available in different data stores. The combining of data frames in R gives more insights to perform analysis of the dataset. Using merge() , rbind() functions, we can merge data frames in R. merge() is a built-in R function that merges data frames by one or more common column names. It merges the two data frames horizontally. rbind() function in R combines data frames vertically.
4 min Read 3

How to Remove Rows from Data Frame in R based on Condition

  • R-PROGRAMMING
Using the logical condition and operator in a data frame, we can remove rows in r based on conditions. In this tutorial, we will discuss how to remove a row from a data frame in R, remove multiple rows in R and how to remove rows from a data frame in R based on condition. How to remove a row from a data frame in R Using the logical condition in the data frame using the square bracket notation, we can remove the row from a data frame in R.
4 min Read 2

How to Remove Rows with NA in R

  • R-PROGRAMMING
rowsums() function along with is.na() and ncol() is used to remove all na rows in R. filter function of dplyr is also used to remove rows with na values. A data frame is passed as an argument to filter Function. Using the na.omit() function and is.na(), we can remove all rows with na in R. Data frame is passed as an argument, and these functions check for missing values of na values in rows of a data frame and remove na from a data frame.
5 min Read 4

How to Remove the First Row of a Data Frame in R

  • R-PROGRAMMING
Using the negative indexing into the data frame, we can remove the first row of a data frame in R. Syntax to remove the first row of the data frame is given below: df[-1,] where df = data frame Use negative indexing -1 to drop In this tutorial, we will discuss how to remove the first row of a data frame in R using negative indexing. Remove First Row of Data Frame using Negative Indexing Use the negative index into the data frame to delete the row of df.
3 min Read 2