I have a heavy DATA saved in dbf format. What I want is to bring that data to R with SQL statements. Like: I want columns 1, 4, 5 and only when column 4 > 30. Sorry asking it here instead of keep searching in manuals, but it seems that there are too many ways of doing it. So what's the appropriate package that I need to work it, considering also that im dealing with lots of gigas so the faster way, better. I would really appreciate helps Thanks since now -- View this message in context: http://www.nabble.com/Bringing-dbf-Data-With-SQL-tp25808277p25808277.html Sent from the R help mailing list archive at Nabble.com.
Try this:
RSiteSearch('dbf")
On Thu, Oct 8, 2009 at 4:17 PM, Michael Yutzi <abcddp at gmail.com>
wrote:>
> I have a heavy DATA saved in dbf format.
>
> What I want is to bring that data to R with SQL statements. Like: I want
> columns 1, 4, 5 and only when column 4 > 30.
>
> Sorry asking it here instead of keep searching in manuals, but it seems
that
> there are too many ways of doing it. So what's the appropriate package
that
> I need to work it, considering also that im dealing with lots of gigas so
> the faster way, better.
>
> I would really appreciate helps
> Thanks since now
> --
> View this message in context:
http://www.nabble.com/Bringing-dbf-Data-With-SQL-tp25808277p25808277.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
On 10/09/2009 07:17 AM, Michael Yutzi wrote:> I have a heavy DATA saved in dbf format. > > What I want is to bring that data to R with SQL statements. Like: I want > columns 1, 4, 5 and only when column 4> 30. > > Sorry asking it here instead of keep searching in manuals, but it seems that > there are too many ways of doing it. So what's the appropriate package that > I need to work it, considering also that im dealing with lots of gigas so > the faster way, better. > > I would really appreciate helps > Thanks since now >Hi Michael, Let's say your table is named "lotsadata" and the attributes are labeled "one", "two" and so on. Does: SELECT one four five FROM lotsadata WHERE four<30. do what you want? Jim