[R] Getting data from Table in RStudio

[Nordlund, Dan (DSHS/RDA)]

I haven't done much in this area, but you might take a look at the Task Views at

http://cran.r-project.org/

In particular, look at the Natural Language Processing task view.  It lists a number of packages that are useful for text mining using frequency counts and content analysis.  You might also google "sentiment analysis".

Hope this is helpful,

Dan

Daniel J. Nordlund
Research and Data Analysis Division
Services & Enterprise Support Administration
Washington State Department of Social and Health Services


> -----Original Message-----
> From: Shanae Clarke [mailto:gayonclarke at yahoo.com]
> Sent: Wednesday, July 02, 2014 7:05 AM
> To: Nordlund, Dan (DSHS/RDA); R. Mailing List
> Subject: Re: [R] Getting data from Table in RStudio
> 
> This was very helpful. I think my problem is actually knowing which
> function to use when and where.
> This was a big help. Thank you again Dan.
> 
> By the way, if I am not asking too much could you recommend a technique
> that could be use to analyze a patterns, do a frequency count on
> recurring text or phrases. Basically Content Analysis. I was reading up
> on
> The help would be really appreciated.
> 
> 
> 
> 
> 
> 
> On Monday, June 30, 2014 7:06 PM, "Nordlund, Dan (DSHS/RDA)"
> <NordlDJ at dshs.wa.gov> wrote:
> 
> 
> 
> > -----Original Message-----
> 
> > From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> > project.org] On Behalf Of Shanae Clarke
> > Sent: Monday, June 30, 2014 1:58 PM
> > To: r-help at r-project.org
> > Subject: [R] Getting data from Table in RStudio
> >
> > Hello,
> >
> > I am new to R progaming and have just started using this program
> since
> > last week. What i want to achieve is to use R to determine patterns
> in
> > sales/ customer complaint etc. information located in a mysql
> database.
> > I am not sure how to approach this or which technique i should use to
> > do so. However, i had proceeded to add a dataset to RStudio using the
> > following code:
> > library(RODBC)
> > dsn.name <- "MySQLlocal"
> > user.name <- "orange"
> > pwd <- ""
> > ch <- odbcConnect(dsn=dsn.name,uid=user.name,pwd = pwd)
> > res <- sqlFetch(ch, "<my_table_name>")
> > odbcQuery(ch, "Select * from <my_table_name>")
> > odbcClose(ch)
> >
> > When the code is run all that is returned is
> > > library (RODBC)
> > > dsn.name <- "MySQLlocal"
> >  > user.name <- "orange"
> > > pwd <- ""
> > > ch <- odbcConnect(dsn=dsn.name,uid=user.name,pwd = pwd)
> > > res <- sqlFetch(ch, "<my_table_name>")
> > > odbcQuery(ch, "Select * from <my_table_name>")
> >  [1] 1
> > > odbcClose(ch)
> >
> > No other results.
> > I was expecting to see the table values or some other data. Not that.
> > Maybe I am misunderstanding the whole concept of how R works.
> > If so could someone please help me to clarify what the problem is and
> > perhaps point me to a tutorial or somewhere i can get a information
> and
> > get a better understanding.
> >
> > Thank you. Your Help will be greatly appreciated.
> >
> > Gayon Clarke
> >     [[alternative HTML version deleted]]
> 
> 1. For future reference, you should read the posting guide linked at
> the bottom of each email, and post only in plain text (no HTML).
> 
> 2. You should read the help files for each of the functions you are
> trying use.
> 
> 3. Did you try to look at the object, res, that you created?  That
> should have contained the table that you fetched from the MySQL
> database.  You could have typed res and the table would have printed
> out.  You also could have used head(res) to look at the first few
> records, or used str(res) to examine the structure of res.
> 
> There is also an R-sig-DB list where you can get more specific help
> with database connectivity questions.
>     https://stat.ethz.ch/mailman/listinfo/r-sig-db
> 
> 
> Hope this is helpful,
> 
> Dan
> 
> Daniel J. Nordlund
> Research and Data Analysis Division
> Services & Enterprise Support Administration
> Washington State Department of Social and Health Services
> 
> 
> ______________________________________________
> 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.