基于DataFrame列的动态变量命名问题求助

Hey there! Let's work through this problem together. First, let's start with a realistic example of your data structure, then show you how to reshape it correctly, and break down why you might be seeing that "object not found" error.

第一步：模拟你的原始数据 #

Let's assume your data looks something like this (adjust the column names/values to match your actual data):

# 模拟含两个问题列和两个回答列的测试数据
test_data <- data.frame(
  Question1 = c("What's 2+2?", "What's the capital of France?"),
  Answer1 = c(4, "Paris"),
  Question2 = c("What's 3*5?", "What's the largest ocean?"),
  Answer2 = c(15, "Pacific Ocean")
)

方法1：用tidyverse（推荐，更直观） #

This approach uses pivot_longer to pair up questions and answers first, then pivot_wider to turn question text into column names.

# 先加载tidyverse包（如果没安装，先运行install.packages("tidyverse")）
library(tidyverse)

# 转为长格式，把Question/Answer配对
long_format <- test_data %>%
  pivot_longer(
    cols = everything(),
    names_to = c(".value", "pair"),
    names_pattern = "(Question|Answer)(\\d+)"
  )

# 把问题转为列名，回答作为对应值
final_data <- long_format %>%
  pivot_wider(
    names_from = Question,
    values_from = Answer
  )

方法2：Base R（无需额外包） #

If you prefer not to use tidyverse, here's a base R alternative:

# 提取所有问题和对应的回答
all_questions <- c(test_data$Question1, test_data$Question2)
all_answers <- c(test_data$Answer1, test_data$Answer2)

# 创建新数据框并设置列名
final_data_base <- as.data.frame(
  matrix(all_answers, nrow = nrow(test_data), byrow = FALSE)
)
colnames(final_data_base) <- all_questions

为什么会出现「对象未找到」错误？ #

That error usually pops up for a few common reasons:

• Column name typos: Double-check that the column names in your code match exactly what's in your data (capitalization, spaces, and punctuation matter! e.g., question1 vs Question1)
• Data frame name mistake: Make sure you're referencing the correct data frame (if your data is stored in my_test_data but you wrote test_data in your code, R won't find it)
• Missing package loading: If you tried using tidyverse functions without running library(tidyverse) first, R won't recognize the commands

If you're still stuck, share:

• The output of str(your_data_frame) (this shows your data's structure)
• The exact code you tried running before getting the error

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