[R] Data Manipulations and SQL

2008-07-14 Thread Willa Wei
Greetings, I am new to R and have some background knowledge about SQL. I'd like to know whether there is a way to manipulate the R datasets (or data frames) using SQL statements. For example, I have two data frames and both of them have a column called "id", then I want to join this two data fr

[R] Convert data set to data frame

2008-07-14 Thread Willa Wei
Greetings, I have a data set look like this: > print(MyResult) 259 10 1113 mean6.108394 3.272211e+01 3.951703e+02 2.086217e+03 79.838867 2.592272e+04 median 1.29 2.743511e+00 4.061491e+00 4.943710e+01 -2.821667