Read to Lead

Data Manipulation and Transformation Tutorials

How to Create Relative Frequency Tables in R

  • R-PROGRAMMING
To create relative frequency tables in R, you can use two different ways prop.table() function and dplyr package. The following methods show how you can do it with syntax. Method 1: Use prop.table() Function frequency_table <- table(data) prop.table(frequency_table) Method 2: Use dplyr Package library(dplyr) df %>% group_by(data) %>% summarise(count = n()) %>% mutate(relative_frequency = count / sum(count)) The following examples show how to create relative frequency table in R. Using prop.
2 min Read 0

How to Delete a File in R

  • R-PROGRAMMING
To delete file in R, you can use file.remove() or unlink() function. The following methods show how you can do it with syntax. Method 1: Use file.remove() Function file.remove("file_path") Method 2: Use unlink() Function unlink("file_path") The following examples show how we remove file in R using two different functions. Using file.remove() Function Let’s see how we can use file.remove() function to delete file in R: # Define file to delete file1 <- "sample.
1 min Read 0

How to Export Data Frames to Multiple Excel Sheets

  • R-PROGRAMMING
To export multiple dataframes to multiple excel sheets, you can use write.xlsx() function from openxlsx library. The following method shows how you can do it with syntax. Method: Use write.xlsx() Function library(openxlsx) dataset_ <- list('Sheet1' = df1, 'Sheet2' = df2, 'Sheet3' = df3,...) # Export each data frame to separate sheets in same Excel file openxlsx::write.xlsx(dataset_, file = 'file.xlsx') The following example shows how export dataframes to multiple excel sheets in R.
1 min Read 0

How to Export List to a File in R

  • R-PROGRAMMING
To export list to a file in R, you can use sink() function. Using this function we can create connection with file then using print() you can write list to file. The following method shows how you can do it with syntax. Method: Use sink() Function sink('sample.txt') print(list_) sink() The following example shows how to export list to file in R using sink() function. Using sink() Function Let’s see how we can use sink() function to export list to file in R:
1 min Read 0

How to Export Multiple Plots to PDF in R

  • R-PROGRAMMING
To export multiple plots to PDF in R, you can use pdf() function and dev.off() function. The pdf() function opens a graphics device to save plots to a PDF file, while dev.off() closes the graphics device and saves the file. The following method shows how you can do it with syntax. Method 1: Use pdf() and dev.off() Function pdf(file) for (i in data) { x=rnorm(i) y=rnorm(i) plot(x, y) } dev.off() The following example shows how to export multiple plots to pdf in R using pdf() and dev.
1 min Read 0

How to Find All Unique Combinations of Two Vectors in R

  • R-PROGRAMMING
To find all unique combinations of two vectors in R, you can use two different functions expand.grid() and crossing() function from tidyr package. The following methods show how you can do it with syntax. Method 1: Use expand.grid() Function expand.grid(vector1, vector2) Method 2: Use crossing() Function library(tidyr) crossing(Temperature, Humidity) The following examples show how to find all unique combination of two vector using expand.grid() and crossing() function in R. Using expand.
2 min Read 1

How to Find the Range in R

  • R-PROGRAMMING
To find the range in R, you can use two different function range() function or difference between minimum and maximum value of dataset. The following methods show how you can do it with syntax. Method 1: Use range() Function range(data) Method 2: Use min() and max() Function max(data) - min(data) The following examples show to find range in R using different functions. Using range() Function Let’s see how we can use range() function to find range in R:
1 min Read 0

How to Find the Size of a Data Frame in R

  • R-PROGRAMMING
To find the size of data frame in R, you can use different function depending on you requirement. The following methods show how you can do it with syntax. Method 1: Use nrow() Function nrow(df) Method 2: Use ncol() Function ncol(df) Method 3: Use dim() Function dim(df) Method 4: Use object.size() Function object.size(df) The following examples show how to find size of data frame using different function in R. Using nrow() Function Let’s see how we can use nrow() function to find number of rows in data frame:
2 min Read 1

How to Find Unique Values in a Column

  • R-PROGRAMMING
To find the unique values from column of dataframe, you can use unique() function. The following method shows how you can do it with syntax. Method 1: Use unique() Function unique(df$column_name) The following example shows how to find unique values from column of dataframe in R. Using unique() Function Let’s see how we can use unique() function in R: # Create data frame df <- data.frame(Machine_name=c("A","D","B","C","B","D","C","A"), Pressure=c(78.2, 81.21, 71.7, 80.21, 71.
1 min Read 0

How to Merge two Data Frames in R

  • R-PROGRAMMING
To merge two dataframes in R, you can use merge() function or *_join() function from dplyr package. The following methods show how you can do it with syntax. Method 1: Use merge() Function merge(df1,df2,by="common_column") Method 2: Use join() Function library(dplyr) *_join(df1, df2, by = "common_column") Using join() function you can perform inner_join, right_join, left_join and outer_join operations on dataframe. The following examples show how to merge two dataframes using merge and join function in R.
3 min Read 2

How to Perform Element-Wise Multiplication in R

  • R-PROGRAMMING
To peform element-wise multiplication in R, you can use “*” operator. The following method shows how you can do it with syntax. Method 1: Use * Operator vector1*vector2 The following example shows how to perform element-wise multiplication in R. Using * Operator Suppose we have two vectors and want to perform multiplication between them: # Declare two vectors x <- c(78,89,85,74,56) y <- c(12,13,14,56.21,85) # Perform element wise multiplication m <- x*y # Print multiplication output print(m) Output:
1 min Read 0