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 Mur
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
bo
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 2
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
(https://cran.r-project.org/web/
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.
https:
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:
"sqldf
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 post
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
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 agai
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 Dawson,
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:
https
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 in
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, sorte
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 yo
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
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 mani
Good Morning,
I am doing some research to develop a new course where I teach. I am
looking for a book to use in the course content to teach accomplishing
SQL in R.
Does anyone know of a book on this topic to recommend for consideration?
Thank You,
--
*Stephen Dawson, DSL*
/Executive Strate
17 matches
Mail list logo