Using mutate_at within for loop causing errors finding column
up vote
0
down vote
favorite
I have multiple dataframes with column name "province_name", and I wrote a function to change all columns except this columns to numeric, using mutate_at.
However, when I use the function within a for loop for multiple data frames, it returns an error saying
Error: Unknown column `province_name`
The first function is
make_numeric<-function(name_of_df) {
new_df = name_of_df %>% mutate_at(vars(-c("province_name")),funs(as.numeric(gsub(",", "", .))))
return(new_df)
}
Second is when df_names = c("df1","df2", ...)
for (f in df_names) {
df = get(f)
new_df = make_numeric(df)
}
for-loop mutate
asked 2 days ago
song0089
76631032
add a comment |
up vote
0
down vote
favorite
I have multiple dataframes with column name "province_name", and I wrote a function to change all columns except this columns to numeric, using mutate_at.
However, when I use the function within a for loop for multiple data frames, it returns an error saying
Error: Unknown column `province_name`
The first function is
make_numeric<-function(name_of_df) {
new_df = name_of_df %>% mutate_at(vars(-c("province_name")),funs(as.numeric(gsub(",", "", .))))
return(new_df)
}
Second is when df_names = c("df1","df2", ...)
for (f in df_names) {
df = get(f)
new_df = make_numeric(df)
}
for-loop mutate
asked 2 days ago
song0089
76631032
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have multiple dataframes with column name "province_name", and I wrote a function to change all columns except this columns to numeric, using mutate_at.
However, when I use the function within a for loop for multiple data frames, it returns an error saying
Error: Unknown column `province_name`
The first function is
make_numeric<-function(name_of_df) {
new_df = name_of_df %>% mutate_at(vars(-c("province_name")),funs(as.numeric(gsub(",", "", .))))
return(new_df)
}
Second is when df_names = c("df1","df2", ...)
for (f in df_names) {
df = get(f)
new_df = make_numeric(df)
}
for-loop mutate
asked 2 days ago
song0089
76631032
I have multiple dataframes with column name "province_name", and I wrote a function to change all columns except this columns to numeric, using mutate_at.
However, when I use the function within a for loop for multiple data frames, it returns an error saying
Error: Unknown column `province_name`
The first function is
make_numeric<-function(name_of_df) {
new_df = name_of_df %>% mutate_at(vars(-c("province_name")),funs(as.numeric(gsub(",", "", .))))
return(new_df)
}
Second is when df_names = c("df1","df2", ...)
for (f in df_names) {
df = get(f)
new_df = make_numeric(df)
}
for-loop mutate
for-loop mutate
asked 2 days ago
song0089
76631032
asked 2 days ago
song0089
76631032
asked 2 days ago
song0089
76631032
asked 2 days ago
song0089
76631032
asked 2 days ago
song0089
76631032
76631032
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53402401%2fusing-mutate-at-within-for-loop-causing-errors-finding-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
