search for: updaterow

Displaying 1 result from an estimated 1 matches for "updaterow".

Did you mean: updaterows
2007 Jun 05
2
Problems with Merge
...tExcel(UpdateFile) sqlTables(chn) UpdateData <- sqlFetch(chn,"MCap243") colnames(UpdateData) <- gsub("#",".",colnames(UpdateData)) close(chn) # specify just how many rows we need from the Update file. We'd only read five # rows at a time. UpdateRows = 20 UpdateData <- UpdateData[1:UpdateRows,] # Delete Unwanted stocks. UpdateData <- UpdateData[,!names(UpdateData) %in% ToBeDeleted] x <- tail(UpdateData[c("Date","ABAN.BO")],n=50) print(x) Gives x as: Date ABAN.BO 1 2007-04-30 96448.4...