Important: Read this before posting to this forum

  1. This forum is for questions related to the use of Apollo. We will answer some general choice modelling questions too, where appropriate, and time permitting. We cannot answer questions about how to estimate choice models with other software packages.
  2. There is a very detailed manual for Apollo available at http://www.ApolloChoiceModelling.com/manual.html. This contains detailed descriptions of the various Apollo functions, and numerous examples are available at http://www.ApolloChoiceModelling.com/examples.html. In addition, help files are available for all functions, using e.g. ?apollo_mnl
  3. Before asking a question on the forum, users are kindly requested to follow these steps:
    1. Check that the same issue has not already been addressed in the forum - there is a search tool.
    2. Ensure that the correct syntax has been used. For any function, detailed instructions are available directly in Apollo, e.g. by using ?apollo_mnl for apollo_mnl
    3. Check the frequently asked questions section on the Apollo website, which discusses some common issues/failures. Please see http://www.apollochoicemodelling.com/faq.html
    4. Make sure that R is using the latest official release of Apollo.
  4. If the above steps do not resolve the issue, then users should follow these steps when posting a question:
    1. provide full details on the issue, including the entire code and output, including any error messages
    2. posts will not immediately appear on the forum, but will be checked by a moderator first. This may take a day or two at busy times. There is no need to submit the post multiple times.

error "undefined columns selected"

Ask questions about errors you encouunter. Please make sure to include full details about your model specifications, and ideally your model file.
Post Reply
lemontree
Posts: 4
Joined: 21 Jun 2023, 14:03

error "undefined columns selected"

Post by lemontree »

Hi,

I have transformed the data for analyzing using the MDCEV model. I received the error Error in `[.data.frame`(database, , apollo_control$indivID) :
undefined columns selected
.

Could you please help me to look at it?


# Set working directory
> setwd(".....")
>
> # Initialise code
> apollo_initialise()
Apollo ignition sequence completed
>
> ### Set core controls
> apollo_control = list(
+ modelName = "MDCEV_no_outside_good",
+ modelDescr = "MDCEV model on time use data, alpha-gamma profile, no outside good and constants only in utilities",
+ indivID = "indivID",
+ outputDirectory = "output"
+ )
>
> database = read.csv("data/derived/meatce_model.csv",header=TRUE)
>
> # ################################################################# #
> #### DEFINE MODEL PARAMETERS ####
> # ################################################################# #
>
> ### Vector of parameters, including any that are kept fixed in estimation
> apollo_beta = c(alpha_base = 0,
+ gamma_beef = 1,
+ gamma_pork = 1,
+ gamma_chicken = 1,
+ gamma_fish = 1,
+ gamma_plant = 1,
+ delta_beef = 1,
+ delta_pork = 1,
+ delta_chicken = 1,
+ delta_fish = 1,
+ delta_plant = 1,
+ sig = 1)
>
> ### Vector with names (in quotes) of parameters to be kept fixed at their starting value in apollo_beta, use apollo_beta_fixed = c() if none
> apollo_fixed = c("delta_beef", "sig")
>
> # ################################################################# #
> #### GROUP AND VALIDATE INPUTS ####
> # ################################################################# #
>
> apollo_inputs = apollo_validateInputs()
Error in `[.data.frame`(database, , apollo_control$indivID) :
undefined columns selected

>
Attachments
dataset
dataset
Screenshot 2023-10-31 at 16.00.21.png (159.05 KiB) Viewed 7471 times
stephanehess
Site Admin
Posts: 998
Joined: 24 Apr 2020, 16:29

Re: error "undefined columns selected"

Post by stephanehess »

Hi

does the column indivID exist in your data? You need to use the ID column from your data, which might be a different name

Stephane
--------------------------------
Stephane Hess
www.stephanehess.me.uk
lemontree
Posts: 4
Joined: 21 Jun 2023, 14:03

Re: error "undefined columns selected"

Post by lemontree »

Many thanks, that solves the problem!
Post Reply