search for: lastrow

..., I'm looking for some lines of code that does the following: I have a dataframe with 160 Columns and a number of rows (max 30): Col1 Col2 Col3 ... Col 159 Col 160 Row 1 0 0 LD ... 0 VD Row 2 HD 0 0 0 MD Row 3 0 HD HD 0 LD Row 4 LD HD HD 0 LD ... ... LastRow HD HD LD 0 MD Now I want a dataframe that looks like this. As you see all duplicates are removed. Can this dataframe be constructed in a fast way? Col1 Col2 Col3 ... Col 159 Col 160 Row 1 0 0 LD 0 VD Row 2 HD HD 0 0 MD Row 3 LD...

...to the range of a year column I have. The first year in the range is just simply the first row, referred to as data$year[1]. How can I find the last row in a similar way to set the last year in the range? What I want to accomplish is the following: "plot(....,xlim = c(data$year[1], data$data[lastrow]),...)", is this possible? -- View this message in context: http://r.789695.n4.nabble.com/referencing-last-row-in-a-column-tp2551645p2551645.html Sent from the R help mailing list archive at Nabble.com.

...ATE TABLE", "SELECT * FROM", "ALTER TABLE" and "INSERT" data work well. But, given the size of the data to be loaded, I had to opt for a bulk load like this: sqlQuery(channel, "BULK INSERT mytable FROM \\\\rhea\\users\\Risk\\Dump\\myfile.csv WITH (FIRSTROW=2, LASTROW=10);") The response is [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42000 170 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '\\'." Similar errors are produced by using the "/" slashes instead. Therefore, the first ques...

Hello Suppose I have a matrix mat=(1:16,2) [,1] [,2] [,3] [,4] [1,] 1 5 9 13 [2,] 2 6 10 14 [3,] 3 7 11 15 [4,] 4 8 12 16 I just want to use the "apply" function to the matrix partially there is a vector end=c(2,3,1,3) #sum the 1st 2 numbers of the 1st column #sum the 1st 3 numbers of the 2nd column #sum the 1st number of the 3rd column

Hi, I am trying to create Bid/Ask for each second from a high volume stock and the only way I have been able to solve this is using loops to create the target matrix from the source tick data matrix. Looping is too slow and not practical to use on multiple stocks. For example: Bids Matrix (a real one is 400,000++ length): Bid Time 10.03 11:05:03.124 10.04 11:05:03.348 10.05

..., contain many paragraphs: data processing functions, print statements, asciitobinary statements, etc.). If you've worked with lab data, you know lab data does not look so simplistic. I need a simple example. Vilno has a lot of functionality, many-to-many joins, adding columns, firstrow() and lastrow() flags, and so forth. A fair amount of complex data manipulations have already been tested with test programs ( in the tarball ). Of course a simple example cannot show you that, it's just a small taste. ********************************************* If you've never used SPSS or SAS befor...

Hi, I would like to extract the last row of each group in a data frame. The data frame is as follows Name Value A 1 A 2 A 3 B 4 B 8 C 2 D 3 I would like to get a data frame as Name Value A 3 B 8 C 2 D 3 Thank you for your suggestions in advance Jeff