[R] Trying to make Nas 0
Dumblauskas, Jerry
jerry.dumblauskas at credit-suisse.com
Wed Aug 26 20:55:10 CEST 2009
I have an lm object called mro
A summary gives
> summary(mro)
Call:
lm(formula = REGRESSIONSTRING, data = wData)
Residuals:
Min 1Q Median 3Q Max
-8.18077 -1.06867 -0.09387 1.03153 11.20201
Coefficients: (1 not defined because of singularities)
Estimate Std. Error t value Pr(>|t|)
(Intercept) 7.2096 1.0345 6.969 5.37e-11 ***
log(H2403_P1) -0.3113 0.1305 -2.386 0.0180 *
I(LEVDSCRT/100) 3.4425 0.7818 4.403 1.79e-05 ***
REG_UTIL_FLAG_P1 NA NA NA NA
REALESTATE_ROI 0.2413 0.6211 0.389 0.6980
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 2.116 on 186 degrees of freedom
Multiple R-squared: 0.1455, Adjusted R-squared: 0.1317
F-statistic: 10.56 on 3 and 186 DF, p-value: 1.917e-06
Now, I know my REG_UTIL_FLAG_P1 var is NA because it is missing/constant
in the data frame.
What I am trying to do is this
tring(summary(mro)$coef[,3])
[1] "6.96900610837729, -2.38577388980627, 4.403441093625,
0.388556365853674"
>
I'd really like the NA to not be omitted, but cast to 0 (I am going to
load this into a DB)
So I'd like to see
[1] "6.96900610837729, -2.38577388980627, 4.403441093625, 0,
0.388556365853674"
I was able to do that with the coefficients via
mro$coef[is.na(mro$coef)]<-0
mro$coef
I can do this in a brute force way by by getting a vector of aliased
columns and iterating thru it -- but was hoping for a more elegant
solution.
Thx!
===============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
More information about the R-help
mailing list