Is there a cheat-sheet anywhere that describes how to do SQL-like manipulations on a data frame?
My knowledge of R is rather limited. But from my experience it seems as though one can think of data frames as being similar to tables in a database: there are rows, columns, and values. Also, one can perform similar manipulations on a data frame as one can on a table. For example: select * from foo where bar < 10 ; is similar to foo[foo["bar"] < 10,] I'm just wondering how many other SQL-like manipulations can be done on a data frame? As an extreme example, is it reasonable to assume there is an R equivalent to: select bar, bat, baz, baz*100 as 'pctbaz' from foo where bar like %xyz % order by bat, baz desc ; Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
