在R语言中如何将读取的数据框存为列表及生成table1式命名数据框？

Hey there! I see the issue with your current code—each loop iteration overwrites the table variable, leaving you with only the last file’s data. Let’s fix this with two practical approaches: one to create individual named data frames (like table1, table2), and a more efficient, recommended method using a list for better dataset management.

1. Creating Individual Named Data Frames #

You can use the assign() function to dynamically generate variables with your desired naming pattern. Here’s how to adjust your loop:

sampleFiles <- list.files(directory)
for (i in 1:length(sampleFiles)) {
  # Generate the variable name (e.g., "table1", "table2")
  var_name <- paste0("table", i)
  # Read the file and assign it to the new variable
  assign(var_name, read.table(sampleFiles[i], header = TRUE))
}

After running this, you’ll be able to access each dataset directly using table1, table2, ..., tablen (matching the number of .txt files in your directory).

2. Storing Data Frames in a List (Highly Recommended!) #

While individual variables work, using a list is a cleaner, more scalable approach for managing multiple datasets. Lists let you keep all your data in one place, use intuitive names, and perform bulk operations with ease. Here’s how to implement it:

sampleFiles <- list.files(directory)
# Initialize an empty list to hold your data frames
table_list <- list()

for (i in 1:length(sampleFiles)) {
  # Add each data frame to the list
  table_list[[i]] <- read.table(sampleFiles[i], header = TRUE)
  # Optional: Name list elements after the file (without .txt extension) for clarity
  names(table_list)[i] <- tools::file_path_sans_ext(sampleFiles[i])
}

Now you can access your data in two convenient ways:

• By index: table_list[[1]] for the first file, table_list[[2]] for the second, etc.
• By file name (if you added the optional names): If your first file is sales_data.txt, you can use table_list$sales_data to access it directly.

The biggest advantage of using a list? If you need to run the same operation on all datasets (like filtering rows or adding a new column), you can use functions like lapply() to do it in one go—no need to repeat code for each individual tableX variable.

内容的提问来源于stack exchange，提问作者Achal Neupane