undefined column selected error

[BirenN]

Error in [.data.frame(data, , model.list$variables) :
undefined columns selected

has anyone has this issue??? me and a classmate cannot figure out what/where the errors are. We even went as far as taking out dummy variables and placing them back in again (among also looking at everything line-by-line)

[nirgrahamuk]

what does

sort(names(EmployeeData_train))

show ?

please provide your answer as text , formatted as code; rather than a screenshot.

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[BirenN]

undefined columns selected

sort(names(EmployeeData_train))
[1] "as.factor(left_company_Yes)"
[2] "business_travel_None"
[3] "business_travel_Rarely"
[4] "department_IT and Analytics"
[5] "department_Marketing"
[6] "department_Product Development"
[7] "department_Research"
[8] "department_Sales"
[9] "job_level_Director"
[10] "job_level_Manager"
[11] "job_level_Senior Manager"
[12] "job_level_Vice President"
[13] "job_satisfaction_Low"
[14] "job_satisfaction_Medium"
[15] "job_satisfaction_Very High"
[16] "left_company_Yes"
[17] "marital_status_Married"
[18] "marital_status_Single"
[19] "miles_from_home"
[20] "performance_rating_Exceptional"
[21] "performance_rating_Meets Expectations"
[22] "performance_rating_Minimally Effective"
[23] "performance_rating_Not Effective"
[24] "previous_companies"
[25] "salary"
[26] "weekly_hours"
[27] "yrs_at_company"
[28] "yrs_since_promotion" Preformatted text

[nirgrahamuk]

the neuralnet function you chose to use wants the variables in the data.frames you give it to have syntactically valid names for R :

A syntactically valid name consists of letters, numbers and the dot or underline characters and starts with a letter or the dot not followed by a number. Names such as ".2way" are not valid, and neither are the reserved words.

in the following I demonstrate how neuralnet can be flumoxed by poisoning a variable name.
While you can use normal methods to rename variables manually and fix in a targetted way; I also show an example of using make.names() which is a function that tries to reconstruct names to be valid

library(neuralnet)

# Binary classification
nn <- neuralnet(Species == "setosa" ~.,
                iris,
                linear.output = FALSE)

badiris <- iris
names(badiris)[[1]] <- "fdgf 4tt ! ( .) "
nn <- neuralnet(Species == "setosa" ~ .,
                badiris,
                linear.output = FALSE)

betteriris <- badiris 
names(betteriris) <- make.names(names(badiris))

nn <- neuralnet(Species == "setosa" ~ .,
                betteriris,
                linear.output = FALSE)