[R] Re ading from a Database
Hi all, I'm quite new to R and have limited experience. What Im trying to do is very important as it is part of my final year project; or more so the central idea behind it. I will be creating BibTex files to enter into a mySQL database. I then need to perform operations on this DB like 'return studies similar to x'. It's really just getting a start at this that I'm having trouble with and if anyone could offer any advice whatsoever I would be more than grateful. Many thanks. -- View this message in context: http://www.nabble.com/Reading-from-a-Database-tp22578072p22578072.html Sent from the R help mailing list archive at Nabble.com. __ 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] Re ading from a Database
DonkeyRhubarb michaeligoe at gmail.com writes: I'm quite new to R and have limited experience. What Im trying to do is very important as it is part of my final year project; or more so the central idea behind it. I will be creating BibTex files to enter into a mySQL database. I then need to perform operations on this DB like 'return studies similar to x'. It's really just getting a start at this that I'm having trouble with and if anyone could offer any advice whatsoever I would be more than grateful. Many thanks. Hmmm. This sounds much more like a database question than an R question. R has various interfaces (RmySQL, RODBC, etc) for interfaces to relational databases. Section 4 of the R data import/export manual gives quite a bit of detail. I think that if you need more information on SQL queries etc. you need to start with a local source (who is the advisor for your project?) good luck Ben Bolker __ 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] Re ading from a Database
Some of the simpler commands could surely be done using SQL-only queries, but thats too simple for my project. I need to create some more complex commands that would only be possible using R. Indeed if anyone has any suggestions for this, Id also appreciate that. Every little bit of information I get helps me finish college:-) Thanks for that info Ben and thanks to anyone else who shares some much needed insight with me. Ben Bolker wrote: DonkeyRhubarb michaeligoe at gmail.com writes: I'm quite new to R and have limited experience. What Im trying to do is very important as it is part of my final year project; or more so the central idea behind it. I will be creating BibTex files to enter into a mySQL database. I then need to perform operations on this DB like 'return studies similar to x'. It's really just getting a start at this that I'm having trouble with and if anyone could offer any advice whatsoever I would be more than grateful. Many thanks. Hmmm. This sounds much more like a database question than an R question. R has various interfaces (RmySQL, RODBC, etc) for interfaces to relational databases. Section 4 of the R data import/export manual gives quite a bit of detail. I think that if you need more information on SQL queries etc. you need to start with a local source (who is the advisor for your project?) good luck Ben Bolker __ 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. -- View this message in context: http://www.nabble.com/Reading-from-a-Database-tp22578072p22587990.html Sent from the R help mailing list archive at Nabble.com. __ 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] Re ading from a Database
can you show the list a more specific example of what you are trying to do? most of the database packages support writeTable commands. So, if you can represent the data you are trying to write in a dataframe, then you can probably send it to the database with R. -Whit On Wed, Mar 18, 2009 at 4:50 PM, DonkeyRhubarb michaeli...@gmail.com wrote: Some of the simpler commands could surely be done using SQL-only queries, but thats too simple for my project. I need to create some more complex commands that would only be possible using R. Indeed if anyone has any suggestions for this, Id also appreciate that. Every little bit of information I get helps me finish college:-) Thanks for that info Ben and thanks to anyone else who shares some much needed insight with me. Ben Bolker wrote: DonkeyRhubarb michaeligoe at gmail.com writes: I'm quite new to R and have limited experience. What Im trying to do is very important as it is part of my final year project; or more so the central idea behind it. I will be creating BibTex files to enter into a mySQL database. I then need to perform operations on this DB like 'return studies similar to x'. It's really just getting a start at this that I'm having trouble with and if anyone could offer any advice whatsoever I would be more than grateful. Many thanks. Hmmm. This sounds much more like a database question than an R question. R has various interfaces (RmySQL, RODBC, etc) for interfaces to relational databases. Section 4 of the R data import/export manual gives quite a bit of detail. I think that if you need more information on SQL queries etc. you need to start with a local source (who is the advisor for your project?) good luck Ben Bolker __ 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. -- View this message in context: http://www.nabble.com/Reading-from-a-Database-tp22578072p22587990.html Sent from the R help mailing list archive at Nabble.com. __ 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.