Re: [R] Adding in Missing Data

Hi Hm, maybe you can first make a sequence of all required dates and ids, construct empty data frame with all possible dates, merge your existing data frame with empty one just to fill in all dates, get rid of duplicated dates and ids if necessary and finally use na.locf from zoo library to fi

Re: [R] Adding in Missing Data

Hey All, I have just recently thought of a completely different way to accomplish my analysis (requiring different type of coding) Instead of going in and filling in data, I could remove any dates not shared by ALL the id's. I was thinking about accomplishing this using merge(~~), do you think

Re: [R] Adding in Missing Data

Thanks, That thread talks about adding values to NA. However, the problem with my data is that the missing data points aren't even in the data.frame. The method I think of is using a loop to check ID by ID, if the date column contains all elements of unique(Returns.names$date_), and if not add t

Re: [R] Adding in Missing Data

Jeff08 wrote: Sample Data.Frame format Name is Returns.names X id ticker date_ adjClose totret RankStk 427225 427225 00174410AHS 2001-11-1321.661001235 "id" uniquely defines a row What I am trying to do is add missing data for each ID. Important Infor

[R] Adding in Missing Data

Sample Data.Frame format Name is Returns.names X id ticker date_ adjClose totret RankStk 427225 427225 00174410AHS 2001-11-1321.661001235 "id" uniquely defines a row What I am trying to do is add missing data for each ID. Important Information: Date is