Getting Warning: ” ‘newdata’ had 1 row but variables found have 32 rows” on predict.lm

by

This is a problem of using different names between your data and your newdata and not a problem between using vectors or dataframes.

When you fit a model with the lm function and then use predict to make predictions, predict tries to find the same names on your newdata. In your first case name x conflicts with mtcars$wt and hence you get the warning.

See here an illustration of what I say:

This is what you did and didn’t get an error:

a <- mtcars$mpg
x <- mtcars$wt

#here you use x as a name
fitCar <- lm(a ~ x) 
#here you use x again as a name in newdata.
predict(fitCar, data.frame(x = mean(x)), interval = "confidence") 

       fit      lwr      upr
1 20.09062 18.99098 21.19027

See that in this case you fit your model using the name x and also predict using the name x in your newdata. This way you get no warnings and it is what you expect.

Let’s see what happens when I change the name to something else when I fit the model:

a <- mtcars$mpg
#name it b this time
b <- mtcars$wt 

fitCar <- lm(a ~ b) 
#here I am using name x as previously
predict(fitCar, data.frame(x = mean(x)), interval = "confidence") 

         fit       lwr      upr
1  23.282611 21.988668 24.57655
2  21.919770 20.752751 23.08679
3  24.885952 23.383008 26.38890
4  20.102650 19.003004 21.20230
5  18.900144 17.771469 20.02882
Warning message:
'newdata' had 1 row but variables found have 32 rows

The only thing I did now was to change the name x when fitting the model to b and then predict using the name x in the newdata. As you can see I got the same error as in your question.

Hope this is clear now!

More Related Contents:

  1. How does predict.lm() compute confidence interval and prediction interval?
  2. how to debug “factor has new levels” error for linear model and prediction [duplicate]
  3. How to create a loop that will make regression models in R? [closed]
  4. How to debug “contrasts can be applied only to factors with 2 or more levels” error?
  5. Linear Regression and group by in R
  6. Predict() – Maybe I’m not understanding it
  7. How to succinctly write a formula with many variables from a data frame?
  8. Fitting a linear model with multiple LHS
  9. `lm` summary not display all factor levels
  10. Extract regression coefficient values
  11. Pass a vector of variables into lm() formula
  12. Fast pairwise simple linear regression between variables in a data frame
  13. Why is using update on a lm inside a grouped data.table losing its model data?
  14. Plot polynomial regression curve in R
  15. Linear Regression with a known fixed intercept in R
  16. How do I create a “macro” for regressors in R?
  17. Extract prediction band from lme fit
  18. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  19. R: lm() result differs when using `weights` argument and when using manually reweighted data
  20. How `poly()` generates orthogonal polynomials? How to understand the “coefs” returned?
  21. lm function in R does not give coefficients for all factor levels in categorical data
  22. Is there a faster lm function
  23. Showing string in formula and not as variable in lm fit
  24. predict.lm() with an unknown factor level in test data
  25. Set one or more of coefficients to a specific integer
  26. Working with neuralnet in R for the first time: get “requires numeric/complex matrix/vector arguments”
  27. R error which says “Models were not all fitted to the same size of dataset”
  28. Messy plot when plotting predictions of a polynomial regression using lm() in R
  29. Linear model function lm() error: NA/NaN/Inf in foreign function call (arg 1)
  30. Finding where two linear fits intersect in R

Leave a Comment