Re: [R] Book Recommendation

This is a great find for those of us lurking on this thread. Thanks for sharing Greg (and of course Paul). On 8/30/2023 3:52 PM, Greg Snow wrote: Stephen, I see lots of answers with packages and resources, but not book recommendations. I have used Introduction to Data Technologies by Paul

Re: [R] Book Recommendation

Thanks, Greg. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/30/23 16:52, Greg Snow wrote: Stephen, I see lots of answers with packages and resources, but not

Re: [R] Book Recommendation

Stephen, I see lots of answers with packages and resources, but not book recommendations. I have used Introduction to Data Technologies by Paul Murrell (https://www.stat.auckland.ac.nz/~paul/ItDT/) to teach SQL and database design and would recommend looking at it as a possibility. On Mon, Aug

Re: [R] Book Recommendation

Thanks, Hadley. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/28/23 18:00, Hadley Wickham wrote: These days I'd recommend duckdb

Re: [R] Book Recommendation

Thanks, Martin. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/28/23 17:14, Martin Møller Skarbiniks Pedersen wrote: The SQLite is a good database to use.

Re: [R] Book Recommendation

Thanks, Bill. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/29/23 00:07, William Michels wrote: I'm a big fan of the sqldf package by Gabor Grothendieck:

Re: [R] Book Recommendation

I'm a big fan of the sqldf package by Gabor Grothendieck: "sqldf: Manipulate R Data Frames Using SQL" https://CRAN.R-project.org/package=sqldf The sqldf "README.html" converts to a 42 page PDF: https://cran.r-project.org/web/packages/sqldf/readme/README.html You can also find favorable blog

Re: [R] Book Recommendation

These days I'd recommend duckdb (https://cran.r-project.org/web/packages/duckdb/index.html) instead. It's a similar design to RSQLite (i.e. you don't need a separate server) but it's designed for the needs of data science. Hadley On Tue, Aug 29, 2023 at 9:22 AM Martin Møller Skarbiniks Pedersen

Re: [R] Book Recommendation

The SQLite is a good database to use. https://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html On Mon, Aug 28, 2023, 22:12 Stephen H. Dawson, DSL via R-help < r-help@r-project.org> wrote: > > This is an academic course. The effort now is to nail down the former. I > am pushing

Re: [R] Book Recommendation

Thanks, Bert. I appreciate your helpful assistance. This is an academic course. The effort now is to nail down the former. I am pushing against a local db for the students. I prefer they focus on the get-and-analyze efforts and not db administration efforts. Kindest Regards, *Stephen

Re: [R] Book Recommendation

Thanks, Hadley. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/28/23 14:48, Hadley Wickham wrote: You might find this chapter of R for Data Science helpful:

Re: [R] Book Recommendation

Thanks, Spencer. I appreciate your helpful assistance. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/28/23 15:42, Spencer Graves wrote: library(sos) (sql <- findFn('SQL')) # This opened two tabs

Re: [R] Book Recommendation

library(sos) (sql <- findFn('SQL')) # This opened two tabs in the default browser on my computer just now. The second tab lists 298 different packages with help pages containing "SQL", sorted to put the package with the most matches first. The first tab lists 1900 different help pages,

Re: [R] Book Recommendation

On 8/28/23 12:47 PM, Bert Gunter wrote: I presume you are familiar with the RSQL and RSQLite packages and their vignettes. Can't offer any help, but a point of clarification: When you say, "teach accomplishing SQL in R," do you explicitly mean using SQL syntax in R to manipulate data or do

Re: [R] Book Recommendation

You might find this chapter of R for Data Science helpful: https://r4ds.hadley.nz/databases Hadley On Tue, Aug 29, 2023 at 3:47 AM Stephen H. Dawson, DSL via R-help wrote: > > Good Morning, > > > I am doing some research to develop a new course where I teach. I am > looking for a book to use in

Re: [R] Book Recommendation

I presume you are familiar with the RSQL and RSQLite packages and their vignettes. Can't offer any help, but a point of clarification: When you say, "teach accomplishing SQL in R," do you explicitly mean using SQL syntax in R to manipulate data or do you mean just doing SQL-like types of data