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) nord...@dshs.wa.gov wrote: -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of Shanae Clarke Sent: Monday, June 30, 2014 1:58 PM To: r-help@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@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. __ R-help@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.
Re: [R] Getting data from Table in RStudio
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:gayoncla...@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) nord...@dshs.wa.gov wrote: -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of Shanae Clarke Sent: Monday, June 30, 2014 1:58 PM To: r-help@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@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. __ R-help@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.
Re: [R] Getting data from Table in RStudio
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of Shanae Clarke Sent: Monday, June 30, 2014 1:58 PM To: r-help@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@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.
