Re: Ignore missing data
- To: mathgroup at smc.vnet.net
- Subject: [mg119001] Re: Ignore missing data
- From: Sseziwa Mukasa <mukasa at gmail.com>
- Date: Thu, 19 May 2011 07:43:08 -0400 (EDT)
On May 18, 2011, at 7:15 AM, dim wrote:
> Hello everybody!
>
> I would like to know how to ignore missing data and to be more specific I'll give an example.
>
> his = {1,2,3,4,5,6,7,,9};
> simcs1 = RandomReal[10, 9];
> simcs2 = RandomReal[10, 9];
>
> simcsi = a1*simcs1 + a2*simcs2;
> (his - simcsi)^2;
> er = Plus @@ %
> Minimize[{er, 0 <= a1 <= 1 && 0 <= a2 <= 1 && a1 + a2== 1}, {a1, a2}]
>
>
> It doesn't work, since the 8th value of "his" is missing. Do you know how i could make Mathematica ignore also the corresponding values of simcs1 and simcs2? Namely, in my example how to ignore the 8th value of simcs1 and simcs2.
>
> Please note that i don't want to delete the missing data, neither to make them equal to 0.
>
> Thank you in advance!
One way to do this is to check for Null when computing the squared difference:
MapThread[If[#===Null,0,#-#2]&,{his,simcsi}]^2
Regards,
Sseziwa