Read to Lead

Data Manipulation and Transformation Tutorials

How to Use fread() in R to Import Files Faster

  • R-PROGRAMMING
The fread() function from data.table package used to read large data files in R. The following method shows how you can do it with syntax. Method: Use fread() Function library(data.table) fread("file_name") The following example shows how to use fread() function in R. Use fread() Function From data.table Package Let’s see how we can use fread() function to read data from CSV file: # Import library library(data.table) # Import CSV file data <- fread("product.
1 min Read 0

How to Use list.files() Function in R

  • R-PROGRAMMING
The list.files() function in R used to list out every file in specific folder. The following methods show how you can do it with syntax. Method 1: List All Files Using list.files() Function list.files(path_of_folder) Method 2: List Files With Specific Extension list.files(file_path,pattern="csv") Method 3: List First N Files in Folder list.files(file_path)[1:n] The following examples show how to use list.files() function in R. List All Files in Folder If I want to list all the files in the CSV_data folder, we can achieve this using the list.
2 min Read 1

How to Use pivot_longer() on All Columns

  • R-PROGRAMMING
The pivot_longer() function from tidyr package is used to pivot dataframe from wide format to a long format. The following method shows how you can do it with syntax. Method 1: Use pivot_longer() Function pivot_longer(df, cols = everything()) The following example shows how to use pivot_longer() function in R to create dataframe from wide format to long format. Using pivot_longer() Function Let’s see how we can use pivot_longer() Function in R:
1 min Read 0

How to Use pivot_wider() with Multiple Columns

  • R-PROGRAMMING
The pivot_wider() function from reshape2 package is used to reshape dataframe from longer to wider format. When you want to pivot multiple columns, you can specify the columns you want to pivot using the values_from argument. The following method shows how you can do it with syntax. Method 1: Use pivot_wider() Function library(tidyr) pivot_wider(df, names_from=group, values_from=c(column1, column2)) The following example shows how to use pivot_wider() function to reshape data frame from longer to wider format.
1 min Read 0

How to Use read.table in R

  • R-PROGRAMMING
The read.table() function used to read data from file or text into data frame. The following method shows how you can do it with syntax. Method 1: Use read.table() Function read.table(file_path) The following example shows how to use read.table() function in R. Use read.table() Function to Read Text Data from File Suppose we want to read text data from sample.txt file which stored in current working directory: # Read file into data frame df <- read.
1 min Read 0

How to Use seq Function in R

  • R-PROGRAMMING
The seq() function used to generate sequence of numbers with specified increment or decrement between values. The following method shows how you can do it with syntax. Method 1: Use seq() Function seq(from=x, to=y, by=n, length.out=a) from: Used to specify the starting point of sequence to: Used to specify the ending point of sequence by: Used to add increment or decrement between values length.out: Used to specify length of sequence
2 min Read 1

How to Use sprintf Function in R to Print Formatted Strings

  • R-PROGRAMMING
The sprintf() function is used to print formatted strings in R. The following method shows how you can do it with syntax. Method 1: Use sprintf() Function sprintf(format,string) The following example show how to use sprintf() method in R: Use sprintf() Function to Print Formatted String Let’s see how we can use sprintf() function in R to print formatted string: # Declare string str <- "I am %s. I am %d years old and having experience of %0.
1 min Read 0