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
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
dear members,
I am considering whether to set biasadj = TRUE in
auto.arima in forecast package. If TRUE, the mean is very nearly equal to the
original data. So there is no point in doing the transformation at all...
If FALSE, the point forecast is the median which is
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
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:
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
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,
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
Muy buenas, ¿alguien conoce algún paquete que permita calcular drop-column
importance para distintos tipos de algoritmos, como RF o GBM? Programarlo
yo sé, pero busco algún paquete que ya lo haga.
Gracias,
Manuel
[[alternative HTML version deleted]]
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
dear Eric,
Working...! thanks a lot!
THanking you,
Yours sincerely,
AKSHAY M KULKARNI
From: Eric Berger
Sent: Monday, August 28, 2023 8:37 PM
To: akshay kulkarni
Cc: R help Mailing list
Subject: Re: [R] lag.plot showing only lines
Hi
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
Hi Akshay,
I have never used this function before but according to ?lag.plot you
simply need to pass the argument do.lines=FALSE.
HTH,
Eric
On Mon, Aug 28, 2023 at 5:45 PM akshay kulkarni wrote:
>
> Dear members,
> I am using the following code:
>
>
Dear members,
I am using the following code:
lag.plot(ygrpch(OHLCData[[i]]),lags=4)
But instead of dots, it is showing lines, which I don't know how to interpret.
How to make it plot dots? This is working properly:
lag.plot(na_interpolation(OHLCData[[i]][,4]),lags=4)
(I mean pdavies)
On Mon, Aug 28, 2023, 7:52 AM Ben Bolker wrote:
> I would probably use the built in qdavies() function...
>
> On Mon, Aug 28, 2023, 7:48 AM Leonard Mada via R-help <
> r-help@r-project.org> wrote:
>
>> Dear R-Users,
>>
>> Just out of curiosity:
>> Which of the 2 methods is the
I would probably use the built in qdavies() function...
On Mon, Aug 28, 2023, 7:48 AM Leonard Mada via R-help
wrote:
> Dear R-Users,
>
> Just out of curiosity:
> Which of the 2 methods is the better one?
>
> The results seem to differ slightly.
>
>
> fun =
Dear R-Users,
Just out of curiosity:
Which of the 2 methods is the better one?
The results seem to differ slightly.
fun = function(u){((26104.50*u^0.03399381)/((1-u)^0.107)) - 28353.7}
uniroot(fun, c(0,1))
# 0.6048184
curve(fun(x), 0, 1)
abline(v=0.3952365, col="red")
19 matches
Mail list logo