[R] Database

[John Kane]

It all depends on what you are doing but R is pretty powerful.  I have never used Access so I don't know what it can do but I have played around with othe dbs at a very basic level and most things I did could be done quite easily in R  : Sheer data set size could be a problem but unless you have millions of data items you are probably okay in R.

For your example.  Assume nams1 is from dataset 1 and nams 2 is from dataset 2.
=================================
nams1 <- letters[1:5]
nams2 <- letters[3:7]

nams1 %in% nams2
=====================================
Done.

John Kane
Kingston ON Canada


> -----Original Message-----
> From: tryingtolearnagain at gmail.com
> Sent: Wed, 29 Feb 2012 00:06:08 +0100
> To: r-help at r-project.org
> Subject: [R] Database
> 
> Hi all,
> 
> I4m new using Access. I see that many things that you can do on Access
> you
> can do on CRAN R but not on contrary.
> 
> My question is: Is there any manual with examples comparing how to do
> data
> base analysis on access and making the same on CRAN R?
> 
> Imagine I want to compare two columns "Name" of two different data bases.
> I
> want to see if there are "identical" names on both files.
> 
> It is better to use Access? Or it is better to use cran r (importing data
> and work on CRAN R)?
> 
> This is only an example.
> 
> I know CRAN R is more specialized on statistics and data analysis but I
> 4m
> trying not to learn Access and SQL so on.
> 
> I cannot explain better I hope you comprehed me.
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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.

____________________________________________________________
Share photos & screenshots in seconds...
TRY FREE IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if1
Works in all emails, instant messengers, blogs, forums and social networks.