r语言 - 错误:必须用有效的下标向量重命名列

Question

我正试图导入一个kaggle数据集来学习R，这简直是一场噩梦。

我正在尝试重命名我的数据框架中的列，但我一直得到错误。

library(tidyverse)
library(dplyr)
library(ggplot2)
library(tibble)
library(janitor)
food_advs<- read.csv("CAERS_ASCII_2004_2017Q2.csv")
food_df <- data.frame(food_advs)
food_df %>% rename(food_df, Product = PRI_Reported.Brand.Product.Name, Industry = PRI_FDA.Industry.Name, Person_age = CI_Age.at.Adverse.Event, Gender = CI_Gender, Outcomes = AEC_One.Row.Outcomes, Symptoms = SYM_One.Row.Coded.Symptoms)

> food_df %>% rename(food_df, "Product" = "PRI_Reported.Brand.Product.Name", "Industry" = "PRI_FDA.Industry.Name", "Person_age" = "CI_Age.at.Adverse.Event", "Gender" = "CI_Gender", "Outcomes" = "AEC_One.Row.Outcomes", "Symptoms" = "SYM_One.Row.Coded.Symptoms")
Error: Must rename columns with a valid subscript vector.
x Subscript has the wrong type `data.frame<
RA_Report..                    : integer
RA_CAERS.Created.Date          : character
AEC_Event.Start.Date           : character
PRI_Product.Role               : character
PRI_Reported.Brand.Product.Name: character
PRI_FDA.Industry.Code          : integer
PRI_FDA.Industry.Name          : character
CI_Age.at.Adverse.Event        : integer
CI_Age.Unit                    : character
CI_Gender                      : character
AEC_One.Row.Outcomes           : character
SYM_One.Row.Coded.Symptoms     : character
>`.
i It must be numeric or character.
Run `rlang::last_error()` to see where the error occurred.

Answer 1

尝试以下操作，

food_df %>% 
rename(Product = PRI_Reported.Brand.Product.Name,
Industry = PRI_FDA.Industry.Name, 
Person_age = CI_Age.at.Adverse.Event,
Gender = CI_Gender,
Outcomes = AEC_One.Row.Outcomes,
Symptoms = SYM_One.Row.Coded.Symptoms
)

你的错误在于你使用了%>%;当你在呼叫前已经有data %>%时，使用rename(data, ...)是很充足的。