Do you know the RSQLite package? It uses the DBI package which gives a
common interface to various DB engines.
With it, you can explicitely treat data.frames as tables, and execute SQL
querys on them.
Antonio, Fabio Di Narzo.
2006/5/5, Robert Citek [EMAIL PROTECTED]:
Is there a cheat-sheet
: 37
Date: Fri, 5 May 2006 14:43:00 -0400
From: bogdan romocea [EMAIL PROTECTED]
Subject: Re: [R] SQL like manipulations on data frames
To: [EMAIL PROTECTED]
Cc: r-help R-help@stat.math.ethz.ch
Message-ID:
[EMAIL PROTECTED]
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
This goes
Subject: [R] SQL like manipulations on data frames
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
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.