Could not find Rename function or Mutate Function

Trying to combine two data sets into a single file. When I run the script R studio gives me the error "could not find the rename function" same thing when I try to mutate; "could not find the mutate function" any help would be greatly appreciated:

#====================================================

STEP 2: WRANGLE DATA AND COMBINE INTO A SINGLE FILE

#====================================================

Compare column names each of the files

While the names don't have to be in the same order, they DO need to match perfectly before we can use a command to join them into one file

colnames(q3_2019)
colnames(q4_2019)
colnames(q2_2019)
colnames(q1_2020)

Rename columns to make them consistent with q1_2020 (as this will be the supposed going-forward table design for Divvy)

(q4_2019 <- rename(q4_2019
,ride_id = trip_id
,rideable_type = bikeid
,started_at = start_time
,ended_at = end_time
,start_station_name = from_station_name
,start_station_id = from_station_id
,end_station_name = to_station_name
,end_station_id = to_station_id
,member_casual = usertype))

(q3_2019 <- rename(q3_2019
,ride_id = trip_id
,rideable_type = bikeid
,started_at = start_time
,ended_at = end_time
,start_station_name = from_station_name
,start_station_id = from_station_id
,end_station_name = to_station_name
,end_station_id = to_station_id
,member_casual = usertype))

(q2_2019 <- rename(q2_2019
,ride_id = "01 - Rental Details Rental ID"
,rideable_type = "01 - Rental Details Bike ID"
,started_at = "01 - Rental Details Local Start Time"
,ended_at = "01 - Rental Details Local End Time"
,start_station_name = "03 - Rental Start Station Name"
,start_station_id = "03 - Rental Start Station ID"
,end_station_name = "02 - Rental End Station Name"
,end_station_id = "02 - Rental End Station ID"
,member_casual = "User Type"))

Inspect the dataframes and look for incongruencies

str(q1_2020)
str(q4_2019)
str(q3_2019)
str(q2_2019)

Convert ride_id and rideable_type to character so that they can stack correctly

q4_2019 <- mutate(q4_2019, ride_id = as.character(ride_id)
,rideable_type = as.character(rideable_type))
q3_2019 <- mutate(q3_2019, ride_id = as.character(ride_id)
,rideable_type = as.character(rideable_type))
q2_2019 <- mutate(q2_2019, ride_id = as.character(ride_id)
,rideable_type = as.character(rideable_type))

Welcome to the community!

Both if the functions you mentioned are from dplyr, and not from base R. In order to use functions outside base R, you have to ensure that the relevant packages are installed and loaded.

Installation is required just once, and the relevant function is install.packages

Loading is required in every new R session. The function to load a package is the library function.

Hopefully, you'll be able to figure out the issue given these information. Ensure that you actually installed dplyr on your system, and loaded it before executing your codes. That should solve the mentioned issue.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.