script to join multiple csv file which have different rows length can be join by columns

library(dplyr)
library(readr)

# Path to the directory containing the CSV files
csv_directory <- "path_to_directory"

# List all CSV files in the directory
csv_files <- list.files(csv_directory, pattern = "*.csv", full.names = TRUE)

# Create an empty dataframe to store the merged data
merged_data <- data.frame()

# Iterate over each CSV file
for (csv_file in csv_files) {
  # Read the CSV file into a dataframe
  df <- read_csv(csv_file)
 
  # Merge the dataframe with the merged_data dataframe
  if (is.null(merged_data)) {
    merged_data <- df
  } else {
    merged_data <- full_join(merged_data, df, by = "common_column")
  }
}

# Save the merged data to a new CSV file
write_csv(merged_data, file = "merged_data.csv")