similar to: 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 28, 2023 at 9:47?AM Stephen H. Dawson, DSL via R-help <r-help at r-project.org> wrote: > >

The third report on the R-spatial evolution project has been published. https://r-spatial.org/r/2023/04/10/evolution3.html It links back to earlier blogs and presentations, and focuses on work that maintainers of R packages and workflows using rgdal, rgeos and maptools need to put in train now before the packages are archived on CRAN. The first changes will occur in June 2023, and the

The third report on the R-spatial evolution project has been published. https://r-spatial.org/r/2023/04/10/evolution3.html It links back to earlier blogs and presentations, and focuses on work that maintainers of R packages and workflows using rgdal, rgeos and maptools need to put in train now before the packages are archived on CRAN. The first changes will occur in June 2023, and the

**OFF TOPIC** but perhaps of interest to some on this list. I apologize in advance to those who may be offended. The byline: ******************************** "ChatGPT's odds of getting code questions correct are worse than a coin flip But its suggestions are so annoyingly plausible" ************************************* from here:

Hello, thanks for bringing this topic up, and it would be excellent if we could come of with a generic solution for this in base R. It is one of the top frequently asked questions and requested features in parallel processing, but also in sequential processing. We have also seen lots of variants on how to attack the problem of reporting on progress when running in parallel. As the author

Hi, consider the following two dataframes: x1=c("232","3454","3455","342","13") x2=c("1","1","1","0","0") data1=data.frame(x1,x2) y1=c("232","232","3454","3454","3455","342","13","13","13","13")

Surely someone out there knows how to notify their Windows users that access to their samba server is going to be terminated.... Any help will be *greatly* appreciated. ------ Original Message ------- I would like to shut down samba before I begin my backup routine. Before I do this, I would like to send a message to the users who are logged in on their Windows machines, asking them to log

I am having a problem with the Samba server that I run. Simply, new users added to the system cannot log on to the PC's that are controlled from the Samba server's domain. Users that are already on the system and have been working for some time seem to be unaffected. I suspect that the problem may well be related to the 'minor' problem we experienced with the server the other

Has anyone got any Internet Explorer to install (and then hopefully run) with Wine under Debian Sarge? I tried all the methods I could find and have not been able to successfully do this. I even tried wiping out the old ~/.wine dir and starting fresh, but to no avail. I would appreciate info on this. Thanks -- ...Dave Dawson "If you wrestle in the mud with a pig, you both get dirty, and

Tried to compile the lastest wine and gcc choked up on it as follows: gcc -c -I. -I. -I../../include -I../../include -I/usr/X11R6/include -D__WINESRC__ -D_REENTRANT -fPIC -Wall -pipe -fno-strict-aliasing -gstabs+ -Wpointer-arith -g -O2 -o baseshader.o baseshader.c baseshader.c: In function `print_glsl_info_log': baseshader.c:688: error: `GL_OBJECT_INFO_LOG_LENGTH_ARB' undeclared (first

Dear All, Is sqldf equipped with delete queries? I have tried delete queries but with no success. Thanks in advance, Paul

On Feb 28, 2014, at 7:49 PM, Tim Dawson wrote: > I just noted that I got my outputs reversed in my posting - the git version is the .26, with 2.7.1 being .28, which still seems odd . . . The "-3857M" suffix on the "0.26 (2.6.5-3857M)" version was generated from SVN. Is it possible that the driver is left over from another package? -- Charles Lepple clepple at gmail

Hi all, I am attempting to learn SQL through sqldf... One task I am particularly interested in is merging separate (presumably large) files into a single table without loading these files into R as an intermediate step (by loading them into SQLite and merging them there). Taking a step back, I've considered these alternatives: 1) I know if I use straight SQLite commands I might use the

Hello, I'm having trouble discovering what's going wrong with my use of natural joins via sqldf. Following the instructions under 4i at http://code.google.com/p/sqldf/, which discusses creating indices to speed joins, I have been only unreliably able to get natural joins to work. For example, > Tid <- c('AES 01-01-02 10:58:00', 'AES 01-01-02 11:53:00', 'AES

Hola Carlos: Gracias por responder! Ayer caí en esta página al buscar el problema con google, pero no conseguir entender y implementar lo que sugiere. Sin entender nada, lo que hice fue: ======================== > library(MASS) > library (sqldf) # Per SQL > data(Aids2, package="MASS") > SQL_PROVA = function (XDADES, XWHE) + { + XDADES_SQL = sqldf ("select * from

Hi, I am having a problem with automating the download of printer drivers from a Samba 2.2.8 server. We used to use the server with he following options set: use client driver = yes disable spoolss = yes However these options have now been removed from smb.conf. Following the instructions available in printer_driver2.htm (supplied in docs/htmldocs in the source), I can add a printer driver to

sqldf is an R package for running SQL select statements on one or more R data frames. It is optimized for convenience making it useful for ad hoc queries against R data frames. Given an SQL select statement whose tables are the names of R data frames it: - sets up the database (by default it transparently sets up an in memory SQLite database using RSQLite; however, MySQL via RMySQL, can be

sqldf is an R package for running SQL select statements on one or more R data frames. It is optimized for convenience making it useful for ad hoc queries against R data frames. Given an SQL select statement whose tables are the names of R data frames it: - sets up the database (by default it transparently sets up an in memory SQLite database using RSQLite; however, MySQL via RMySQL, can be

Hola: No consigo que la función sqldf () funcione dentro de una función. Alguien puede echarme una mano. En resumen, el problema es que cuando lo ejecuto fuera de una función no tengo ningún problema: ========================== > # install.packages("sqldf") > library(MASS) > library (sqldf) > data(Aids2, package="MASS") > options(digits=3) > table

Fellow R programmers, I'd like to submit SQLDF statements with R objects as column names. For example, I want to assign "X" to "var1" (var1<-"X") and then refer to "var1" in the SQLDF statement. SQLDF needs to understand that when I reference "var1", it should look for "X" in the dataframe. This is necessary because my SQLDF