Re: [R] Confirming MySQL Alive

sudo in the background like that. On October 7, 2023 8:09:25 AM PDT, "Stephen H. Dawson, DSL via R-help" wrote: Hi, Getting some data from an older MySQL box. I had an event recently where the MySQL box went off-line for maintenance without a prior announcement of service disruption. I

[R] Confirming MySQL Alive

Hi, Getting some data from an older MySQL box. I had an event recently where the MySQL box went off-line for maintenance without a prior announcement of service disruption. I decided to add a line on my local version of MySQL as I considered how to handle this condition going forward.

Re: [R] Book Recommendation

rces, 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 wrote:

Re: [R] Book Recommendation

an.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 against a local db for the students. I prefer

Re: [R] Book Recommendation

ttps://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html On Mon, Aug 28, 2023, 22:12 Stephen H. Dawson, DSL via R-help wrote: 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 f

Re: [R] Book Recommendation

tably a post (circa 2013) from Patrick Burns: https://www.burns-stat.com/translating-r-sql-basics/ HTH, Bill. W. Michels, Ph.D. On Mon, Aug 28, 2023 at 8: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 l

Re: [R] Book Recommendation

n Mon, Aug 28, 2023 at 8: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 the course content to teach accomplishing SQL in R. Does anyone know of a book on

Re: [R] Book Recommendation

pful: 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 the course content to teach accomplishing SQL in R. Does anyone

Re: [R] Book Recommendation

st to your target audience.   Spencer Graves p.s.  DISCLAIMER:  I'm the lead author and maintainer of the sos package. On 8/28/23 1:48 PM, Hadley Wickham wrote: You might find this chapter of R for Data Science helpful: https://r4ds.hadley.nz/databases Hadley On Tue, Aug 29, 2023 at 3:4

[R] Book Recommendation

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

Re: [R] OFF TOPIC: chatGPT glibly produces a lot of wrong answers?

Thanks. https://www.wsj.com/articles/with-ai-hackers-can-simply-talk-computers-into-misbehaving-ad488686?mod=hp_lead_pos10 Ever heard of AI prompt injection? *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/13/23

Re: [R] Could not read time series data using read.zoo()

Agreed. Tab character is not comma character. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/3/23 11:04, Jeff Newmiller wrote: no commas? On August 3, 2023 7:53:07 AM PDT, Christofer Bogaso wrote: Hi, I have a

Re: [R] [R-pkgs] Retirement/archiving of rgdal, rgeos and maptools October 2023

Thank you, Roger. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 4/10/23 11:31, Roger Bivand wrote: The third report on the R-spatial evolution project has been published.

Re: [R] Question about Line Ending Choice

get==�Windows�) eol <- c(CR,LF) else if (target %in% c(�Unix�,�Mac�)) eol <- LF else if �. else stop(�Unexpected target.�) write.table(eol=eol, �.) Regards, Jorgen Harmse. Message: 7 Date: Tue, 27 Sep 2022 11:35:54 -0400 From: "Stephen H. Dawson, DSL" To: Bert Gunter

Re: [R] Question about Line Ending Choice

http://www.shdawson.com On 9/29/22 05:24, Enrico Schumann wrote: On Tue, 27 Sep 2022, Stephen H. Dawson, DSL via R-help writes: Hi All, I am writing with a question about choosing the line ending aspect of a file, please. I use write.csv and write.table to export work to CSV files and TXT files.

Re: [R] Question about Line Ending Choice

.table ? Bert On Tue, Sep 27, 2022 at 8:23 AM Stephen H. Dawson, DSL via R-help wrote: Hi All, I am writing with a question about choosing the line ending aspect of a file, please. I use write.csv and write.table to export work to CSV files and TXT files. I am plann

[R] Question about Line Ending Choice

Hi All, I am writing with a question about choosing the line ending aspect of a file, please. I use write.csv and write.table to export work to CSV files and TXT files. I am planning now on how to share my work with the Windows crowd beyond only sharing with the Linux crowd. I use my text

Re: [R] Error Running arules

I am running. I will remove all of R from my box and look to other repositories. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 9/2/22 12:50, Stephen H. Dawson, DSL via R-help wrote: Go it, thanks. *Stephen Da

Re: [R] Error Running arules

es'. 3. Search on "masking in R" Bert On Fri, Sep 2, 2022 at 9:01 AM Stephen H. Dawson, DSL wrote: Bert, Thanks for the guidance. Do you have a documentation URL I can review to research your suggestion? Ivan, Thanks for the guidance. The traceback() revealed the same results

[R] Error Running arules

Hi Everyone, I upgraded my box recently. I am now running R at version 4.2. I attempted to do association rules today using arules. I am getting two errors. My first guess is there is something in the build of the arules that is not found in r-base. My second guess is the script syntax

Re: [R] Circular Graph Recommendation Request

strip ) On Sat, May 28, 2022 at 8:39 AM Stephen H. Dawson, DSL via R-help wrote: https://www.visualcapitalist.com/us-goods-exports-by-state/ Visualizing U.S. Exports by State Good Morning, https://www.visualcapitalist.com/wp-content/uploads/2022/05/us-exports-by-state-infographic.jpg Saw

Re: [R] Circular Graph Recommendation Request

From: Stephen H. Dawson, DSL Sent: Saturday, May 28, 2022 3:37 PM To: Lucas Heber Mariano Dos Santos ; Bert Gunter Cc: r-help Subject: Re: [R] Circular Graph Recommendation Request Thank you, Lucas! Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Techn

[R] Recommended Statistics Papers and Packages

Good Morning, I have been doing some further reading on the topic of statistics lately. I enjoyed reading the following material. I am writing to share the material with the list as recommended reading on the respective topics. Estimating the number of clusters in a data set via the gap

Re: [R] tidying up

Hi Avi, I thought about your question over the past few days. A new email list may help, but I doubt the help will suffice to solve the problem of forming emails as the existing list prefers. Here is where I see the source of the problem with using R by way of getting questions answers.

Re: [R] (Off-Topic) Time for a companion mailing list for R packages?

Good comments, Ivan. I also have found StackOverflow to not be too helpful in a structured conversation. I have had it and miss success with GitHub interactions. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com

Re: [R] (Off-Topic) Time for a companion mailing list for R packages?

Great discussion thread. The problem is not a mailing list. The problem is the inability to segment questions. Segment, by keyword or sub-directory (loose word) or any other compartmentalization. QUESTION What other technology options are available here beyond a mailing list? *Stephen

Re: [R] splitting data matrix into submatrices

Hi, Please post the data structure so it is more clear what data is being massaged. Thanks, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 1/4/22 10:52 PM, Faheem Jan via R-help wrote: I

Re: [R] Error Awareness

if things do happen, then your code is not robust enough. -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Thursday, December 23, 2021 11:17 AM To: Bert Gunter Cc: R-help Subject: Re: [R] Error Awareness Hi Bert, Thanks for the reply. The use case I

Re: [R] Script Run Output Capturing

Thank you, Rasmus. I appreciate the reply. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 12/23/21 10:00 AM, Rasmus Liland wrote: sink and capture.output seem useful, but I have not used them.

Re: [R] Adding SORT to UNIQUE

2/21 12:12 PM, Duncan Murdoch wrote: On 22/12/2021 12:01 p.m., Stephen H. Dawson, DSL wrote: Data <- read.csv("./input/Source.csv", header=T) v1 <- sort(unique(Data[, 1])) cat(format(v1, justify = "right"), sep = "\n") OK, working with the options you p

Re: [R] Adding SORT to UNIQUE

be interested in what is the canonical or best way and by now, you may note there are very often MANY ways and some programmers prefer one or another. And, I note, after enough questions of a fairly basic or even naïve nature, some responders in these groups stop responding for some reason. -Origi

Re: [R] Script Run Output Capturing

quested? If not, why not? Have you tried it to see? Bert Gunter On Thu, Dec 23, 2021 at 5:28 AM Stephen H. Dawson, DSL via R-help wrote: Nice! Thanks for the reply. I will research over the next few days. https://www.ssc.wisc.edu/~hemken/Rworkshops/interface/savingoutput.html How about the sink(

Re: [R] Error Awareness

hat sort of help you can expect (and have already received here. Cheers, Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Thu, Dec 23, 2021 at 3

Re: [R] Script Run Output Capturing

Nice! Thanks for the reply. I will research over the next few days. https://www.ssc.wisc.edu/~hemken/Rworkshops/interface/savingoutput.html How about the sink() and capture.output() functions? Have you ever used them? *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business &

[R] Error Awareness

Hi, I am thinking about awareness of errors when an R script runs. My concern is I have an error-free script. I run it for months on end without problems. Then, something changes somewhere causing an error. My wonderment is how R will tell me I had an error in the script, but the rest of

[R] Script Run Output Capturing

Hi, I need to capture the output in a physical file when I run an R script. I would like to capture the output as a TXT file. I am thinking something along the line of the tee command is what I am after, but I am not certain what I am after here. https://en.wikipedia.org/wiki/Tee_(command)

Re: [R] Adding SORT to UNIQUE

where the error is, in these cases try to read the instruction more carefully, typos can be hard to find.) Hope this helps, Rui Barradas Às 17:59 de 22/12/21, Stephen H. Dawson, DSL via R-help escreveu: Thanks. I am pondering label names, not set on one as of yet. I like your recommendatio

Re: [R] Adding SORT to UNIQUE

to have that name, this would do it: cat(format(names(Data[,1]). "\n", v1, justify = "right"), sep = "\n") -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Wednesday, December 22, 2021 12:02 PM To: Duncan Murdoch ; R

Re: [R] Adding SORT to UNIQUE

lt;- function(x, ...){   n <- max(lengths(x))   y <- lapply(x, \(.x) c(.x, rep("", n - length(.x   y <- do.call(cbind.data.frame, y)   names(y) <- names(x)   print(y)   invisible(x) } # Test the functions above Data2 <- sort_unique(Data) class(Data2) Data2 print(Data2)

Re: [R] Adding SORT to UNIQUE

v1 to the vertical output of this syntax, please? *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com <http://www.shdawson.com> On 12/22/21 11:13 AM, Stephen H. Dawson, DSL via R-help wrote: OK, now I get what you ar

Re: [R] Adding SORT to UNIQUE

10:55 a.m., Stephen H. Dawson, DSL wrote: I see. So, we are talking taking the output into a new dataframe. I was hoping to have the output rendered on screen without another dataframe, but I can live with this option it if must occur. Am I correct the desired vertical output must first go to a

Re: [R] Adding SORT to UNIQUE

* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com <http://www.shdawson.com> On 12/22/21 10:47 AM, Duncan Murdoch wrote: On 22/12/2021 10:20 a.m., Stephen H. Dawson, DSL wrote: Thanks for the reply. Both syntax options work to render the corre

Re: [R] Adding SORT to UNIQUE

then setting each shorter vector to be longer with code like: length(a) <- longest You can then patch together all the results into a data.frame with trailing NA values on some columns. I quickly cobbled together a few lines that can do that and can be placed inside a function to return

Re: [R] Adding SORT to UNIQUE

n Tue, Dec 21, 2021 at 7:16 AM Stephen H. Dawson, DSL via R-help wrote: Thanks everyone for the replies. It is clear one either needs to write a function or put the unique entries into another dataframe. It seems odd R cannot sort a list of unique column entries with ease. Python

Re: [R] Adding SORT to UNIQUE

804-3454 http://www.shdawson.com <http://www.shdawson.com> On 12/21/21 11:38 AM, Duncan Murdoch wrote: On 21/12/2021 11:31 a.m., Duncan Murdoch wrote: On 21/12/2021 11:20 a.m., Stephen H. Dawson, DSL wrote: Thanks for the reply. sort(unique(Data[1])) Error in `[.data.frame`(x, order(

Re: [R] Adding SORT to UNIQUE

On 21/12/2021 10:16 a.m., Stephen H. Dawson, DSL via R-help wrote: Thanks everyone for the replies. It is clear one either needs to write a function or put the unique entries into another dataframe. It seems odd R cannot sort a list of unique column entries with ease. Python and SQL can do it

Re: [R] Adding SORT to UNIQUE

1:18 de 20/12/21, Stephen H. Dawson, DSL via R-help escreveu: Thanks. sort(unique(Data[[1]])) This syntax provides row numbers, not column values. This is not right. The syntax Data[1] extracts a sub-data.frame, the syntax Data[[1]] extracts the column vector. As for my previ

Re: [R] Adding SORT to UNIQUE

s of Data you may want to do them all at once using something like: lapply(Data[1:4], unisort) As you note, the sort ordering depends on the data and perhaps on options you specify. -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Monday, December 20,

Re: [R] Adding SORT to UNIQUE

Thanks. sort(unique(Data[[1]])) This syntax provides row numbers, not column values. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com <http://www.shdawson.com> On 12/20/21 11:58 AM, Stephen H. Dawson, DSL via R-

Re: [R] Adding SORT to UNIQUE

Data you may want to do them all at once using something like: lapply(Data[1:4], unisort) As you note, the sort ordering depends on the data and perhaps on options you specify. -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Monday, December 20,

[R] Adding SORT to UNIQUE

Hi, Running a simple syntax set to review entries in dataframe columns. Here is the working code. Data <- read.csv("./input/Source.csv", header=T) describe(Data) summary(Data) unique(Data[1]) unique(Data[2]) unique(Data[3]) unique(Data[4]) I would like to add sort the unique entries. The

Re: [R] Question about Rfast colMins and colMaxs

s(v) <- colnames(some.data.frame)     v } On Wed, 1 Dec 2021 at 07:55, Stephen H. Dawson, DSL via R-help mailto:r-help@r-project.org>> wrote: Hi, I am working to understand the Rfast functions of colMins and colMaxs. I worked through the example listed on page 54 of the PDF. h

Re: [R] Question about Rfast colMins and colMaxs

So a bit more complex one-liner removes any non-numeric columns like this: mycolMins(df[, sapply(df, is.numeric)]) $i [1] 1 $f [1] 1.2 $i2 [1] 3 Clearly converting that to a matrix while whole would result in everything being converted to character and a minimum may be elusive. -Origin

Re: [R] Question about Rfast colMins and colMaxs

minimum may be elusive. -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Tuesday, November 30, 2021 5:37 PM To: Bert Gunter Cc: r-help@r-project.org Subject: Re: [R] Question about Rfast colMins and colMaxs Oh, you are segmenting standard R from the rest of

Re: [R] Question about Rfast colMins and colMaxs

-Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Wednesday, December 1, 2021 5:11 PM To: r-help@r-project.org Subject: Re: [R] Question about Rfast colMins and colMaxs Jeff, Can you use max and min evaluations on any other data type then numeric? If so,

Re: [R] Question about Rfast colMins and colMaxs

1 $f [1] 1.2 $i2 [1] 3 Clearly converting that to a matrix while whole would result in everything being converted to character and a minimum may be elusive. -Original Message- From: R-help On Behalf Of Stephen H. Dawson, DSL via R-help Sent: Tuesday, November 30, 2021 5:37 PM To: Bert Gu

Re: [R] Question about Rfast colMins and colMaxs

http://www.shdawson.com <http://www.shdawson.com> On 11/30/21 5:23 PM, Stephen H. Dawson, DSL via R-help wrote: Well, no it is not. The email list stripped off the attachment. The data is numeric, happens to be all whole numbers. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant

Re: [R] Question about Rfast colMins and colMaxs

they think the best practice should be for their package. As has been pointed out already, it appears to differ from the usual "read it in as a data frame" procedure. Bert On Tue, Nov 30, 2021 at 2:11 PM Stephen H. Dawson, DSL wrote: Right, R Studio is not R. However, the Rfast package

Re: [R] Question about Rfast colMins and colMaxs

11/30/21 5:14 PM, Stephen H. Dawson, DSL via R-help wrote: Hi Jeff, Thanks for the data review offer. Attached is the CSV. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com <http://www.shdawson.com> On 11/30/21 3:2

Re: [R] Question about Rfast colMins and colMaxs

ould write to the maintainer of the package to ask that data.frames be directly supported.  In the meantime you could use    vapply(yourDataFrame, which.min, FUN.VALUE=NA_real_) or     vapply(yourDataFrame, min, FUN.VALUE=NA_real_) instead of colMins. -Bill On Tue, Nov 30, 2021 at 10:55 AM Stephen H. Dawso

Re: [R] Question about Rfast colMins and colMaxs

ing useful about the data, it is up to you to inspect your data and figure out what to do with it. On November 30, 2021 10:55:13 AM PST, "Stephen H. Dawson, DSL via R-help" wrote: Hi, I am working to understand the Rfast functions of colMins and colMaxs. I worked through the examp

Re: [R] Question about Rfast colMins and colMaxs

an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Tue, Nov 30, 2021 at 10:55 AM Stephen H. Dawson, DSL via R-help wrote: Hi, I am working to understand the Rfast functions of colMins

[R] Question about Rfast colMins and colMaxs

Hi, I am working to understand the Rfast functions of colMins and colMaxs. I worked through the example listed on page 54 of the PDF. https://cran.r-project.org/web/packages/Rfast/index.html https://cran.r-project.org/web/packages/Rfast/Rfast.pdf My data is in a CSV file. So, I bring it

Re: [R] Defining Parameters in arules

https://rattle.togaware.com/ https://journal.r-project.org/archive/2009/RJ-2009-016/index.html Thank you, Tom. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 11/23/21 5:55 AM, Tom Woolman

Re: [R] Defining Parameters in arules

Thank, Ivan. *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 11/23/21 5:17 AM, Ivan Krylov wrote: Hello, If you don't get an answer here, consider asking the package maintainer: Michael Hahsler

[R] Defining Parameters in arules

Hi, New to the list, first post. I have reviewed the file: https://cran.r-project.org/web/packages/arules/arules.pdf I am unable to find what I am after, so I am asking the mailing list for assistance, please. I am using arules to accomplish apriori for reviewing some association rules

Re: [R] Problem with plotmat package

On 09/16/2021 09:26 PM, H wrote: > On 09/16/2021 09:00 PM, Jim Lemon wrote: >> Okay, that was just my reading of the help page. I hope that I haven't >> added to the confusion. >> >> Jim >> >> On Fri, Sep 17, 2021 at 10:50 AM H wrote: >>> On 09/15

Re: [R] Problem with plotmat package

On 09/16/2021 09:00 PM, Jim Lemon wrote: > Okay, that was just my reading of the help page. I hope that I haven't > added to the confusion. > > Jim > > On Fri, Sep 17, 2021 at 10:50 AM H wrote: >> On 09/15/2021 09:40 PM, Jim Lemon wrote: >>> Oops, your plot >

Re: [R] Problem with plotmat package

On 09/15/2021 09:40 PM, Jim Lemon wrote: > Oops, your plot > > On Thu, Sep 16, 2021 at 11:39 AM Jim Lemon wrote: >> Hi H, >> Looking at your example and the help page, it looks to me as though >> the plot is consistent with the "A" matrix: >> >> O

[R] Problem with plotmat package

I am using plotmat 1.6.5 (part of the diagram package) in R 3.6 to plot Markov transition charts but have run into an issue that I was hoping someone could shed light on here. I did e-mail the maintainer over a month ago but have not received a reply. The issue is that the directional arrows

Re: [R] Markov modeling using msm

ed-with-markov-chains/ > > > Hope this helps, > > Rui Barradas > > Às 02:21 de 08/08/21, H escreveu: >> I would like to use R and msm to replicate the results from a published >> study where the authors used Tree Age Pro 2011 for their Markov modeling. I >> am

[R] Markov modeling using msm

I would like to use R and msm to replicate the results from a published study where the authors used Tree Age Pro 2011 for their Markov modeling. I am new to Markov modeling and while I have tried to read up, my understanding is still quite limited... The papers contains the the state

Re: [R] FREDR and R 3.6

On 10/30/2020 03:52 AM, Enrico Schumann wrote: > On Thu, 29 Oct 2020, H writes: > >> I tried to install the fredr package yesterday to >> access the data series hosted by the St. Louis Fed but >> my installation of R, version 3.6, tells me it is not >> available f

Re: [R] FREDR and R 3.6

On 10/29/2020 07:20 PM, Marc Schwartz wrote: >> On Oct 29, 2020, at 6:35 PM, H wrote: >> >> On 10/29/2020 01:49 PM, Marc Schwartz wrote: >>>> On Oct 29, 2020, at 1:29 PM, H wrote: >>>> >>>> I tried to install the fredr package yesterday to ac

Re: [R] FREDR and R 3.6

On 10/29/2020 01:49 PM, Marc Schwartz wrote: >> On Oct 29, 2020, at 1:29 PM, H wrote: >> >> I tried to install the fredr package yesterday to access the data series >> hosted by the St. Louis Fed but my installation of R, version 3.6, tells me >> it is not av

[R] FREDR and R 3.6

I tried to install the fredr package yesterday to access the data series hosted by the St. Louis Fed but my installation of R, version 3.6, tells me it is not available from a cran repository. I could not find any information on this on the fredr information package and was wondering if anyone

Re: [R] Mapping 2D to 3D

On 09/19/2020 04:33 PM, Abby Spurdle wrote: >> Understood > I'd recommend you try to be more precise. > >> I just began looking at the volcano dataset which uses geom_contour. > The volcano dataset does *not* use geom_contour. > However, the help file for the volcano dataset, does use the >

Re: [R] Mapping 2D to 3D

> theory of kernel density estimates, which is off topic here. (Technically > contributed packages like ggplot2 are off topic here also, though sometimes > people will answer questions about them anyway.) > > On September 18, 2020 6:34:43 PM PDT, H wrote: >> On 09/18/2020

Re: [R] Mapping 2D to 3D

ions/32206623/what-does-level-mean-in-ggplotstat-density2d > > Kind Regards, > Carlos. > > > On Fri, Sep 18, 2020 at 4:17 AM H <mailto:age...@meddatainc.com>> wrote: > > I am trying to understand how to map 2D to 3D using ggplot() and > eventually plot_gg(). I am

Re: [R] Mapping 2D to 3D

On 09/18/2020 02:26 AM, Jeff Newmiller wrote: > No, but fortunately you are off in the weeds. Density has an > internally-computed "z" coordinate... you should be looking at ?geom_contour. > > On September 17, 2020 7:17:33 PM PDT, H wrote: >> I am trying to understa

[R] Mapping 2D to 3D

I am trying to understand how to map 2D to 3D using ggplot() and eventually plot_gg(). I am, however, stuck on understanding how to express the third variable to be mapped. This example: ggdiamonds = ggplot(diamonds, aes(x, depth)) + stat_density_2d(aes(fill = stat(nlevel)), geom = "polygon", n

Re: [R] [R-pkgs] salesforcer v0.2.2: An Implementation of Salesforce APIs Using Tidy Principles

On September 13, 2020 6:42:18 AM EDT, "Steven M. Mortimer" wrote: >The {salesforcer} package allows users to query and analyze Salesforce >data >and administer their Org's records and object metadata (fields, >triggers, >layouts). It has been three years in the making to map multiple >Salesforce

Re: [R] Help with read.csv.sql()

416.0 > 5 515.6 > 6 719.8 > > On Fri, Jul 17, 2020 at 9:28 PM H wrote: >> I have created a dataframe with columns that are characters, integers and >> numeric and with column names assigned by me. I am using read.csv.sql() to >> read portions

Re: [R] Arranging ggplot2 objects with ggplotGrob()

to resort to the underlying grid framework rather >> than the ggplot2 interface. >> >> Bert Gunter >> >> "The trouble with having an open mind is that people keep coming along and >> sticking things into it." >> -- Opus (aka Berkeley Breathed in his "Blo

Re: [R] Arranging ggplot2 objects with ggplotGrob()

On 07/25/2020 03:05 PM, H wrote: > On 07/25/2020 03:01 PM, Rui Barradas wrote: >> Hello, >> >> OK, now it's reproducible, thanks. >> align = "hv" works like I had suggested. >> >> The full code is now >> >> library(ggplot2) >

Re: [R] Modifying dataframe with mutate()

gt;> >>> If you want your df variable to reflect changes made then you need >> to >>> assign your result back into it. >>> >>> df <- df %>% mutate(v1 = as.double(v1)) >>> >>> (Note that the data.table package violates this

[R] Modifying dataframe with mutate()

In a statement like: df %>% mutate(v1 = as.double(v1)) I expect the variable v1 in dataframe df to have been converted into a double. However, when I do: str(df) v1 still shows as int. Do I need to save the modified dataframe after mutating a variable?

Re: [R] Arranging ggplot2 objects with ggplotGrob()

.6 fansi_0.4.1 >  [9] tools_4.0.2  grid_4.0.2   gtable_0.3.0 utf8_1.1.4 > [13] cli_2.0.2    withr_2.2.0  ellipsis_0.3.1 digest_0.6.25 > [17] assertthat_0.2.1 tibble_3.0.1 lifecycle_0.2.0 crayon_1.3.4 > [21] farver_2.0.3 purrr_0.3.4  vctrs_0.3.1 glue_1.4.1 > [25] labeling_0

Re: [R] Arranging ggplot2 objects with ggplotGrob()

On 07/25/2020 12:36 PM, Rui Barradas wrote: > Hello, > > Inline. > > Às 16:54 de 25/07/2020, H escreveu: >> On 07/24/2020 05:56 PM, Rui Barradas wrote: >>> Hello, >>> >>> I've just tried it. >>> >>> library(ggplot2) >>>

Re: [R] Arranging ggplot2 objects with ggplotGrob()

(data = subset(iris, Species == 'setosa'), aes(Sepal.Length, > Sepal.Width)) + geom_point() > > #g2 <- ggplotGrob(s) > #g3 <- ggplotGrob(v) > #g <- rbind(g2, g3, size = "first") > > cowplot::plot_grid(s, v, align = "h", nrow = 2, rel_heights = 2:1)

Re: [R] Arranging ggplot2 objects with ggplotGrob()

On 07/24/2020 02:50 PM, H wrote: > On 07/24/2020 02:03 PM, Jeff Newmiller wrote: >> The set of people interested in helping when you supply a minimal >> reproducible example is rather larger than the set of people willing to read >> the documentation for you (hint)

Re: [R] Arranging ggplot2 objects with ggplotGrob()

ving trouble with. > > On July 24, 2020 10:46:57 AM PDT, H wrote: >> On 07/24/2020 01:14 PM, John Kane wrote: >>> Well, I am not looking for help debugging my code but for >> information to better understand arranging plots vertically. The code >> above aligns them horizon

Re: [R] Arranging ggplot2 objects with ggplotGrob()

what the plots are   and we > cannot play around with them to see if we can help you if we have nothing to > work with. > > On Fri, 24 Jul 2020 at 12:12, H <mailto:age...@meddatainc.com>> wrote: > > On 07/24/2020 05:29 AM, Erich Subscriptions wrote: > >

Re: [R] Arranging ggplot2 objects with ggplotGrob()

On 07/24/2020 05:29 AM, Erich Subscriptions wrote: > Hav a look at the packages cowplot and patchwork > >> On 24.07.2020, at 02:36, H wrote: >> >> I am trying to arrange two plots vertically, ie plot 2 below plot 1, where I >> want the plots to align columnwise but

Re: [R] Arranging ggplot2 objects with ggplotGrob()

-great-r-reproducible-example > > On Fri, 24 Jul 2020 at 01:16, H <mailto:age...@meddatainc.com>> wrote: > > I am trying to arrange two plots vertically, ie plot 2 below plot 1, > where I want the plots to align columnwise but have a height ratio of eg 3:1. > > M

[R] Arranging ggplot2 objects with ggplotGrob()

I am trying to arrange two plots vertically, ie plot 2 below plot 1, where I want the plots to align columnwise but have a height ratio of eg 3:1. My attempts so far after consulting various webpages is that the following code aligns them columnwise correctly but I have, so far, failed in

Re: [R] Help with read.csv.sql()

On 07/18/2020 11:42 PM, Rasmus Liland wrote: > On 2020-07-18 18:09 +0100, Rui Barradas wrote: > | �s 17:59 de 18/07/2020, H escreveu: > | | On Fri, Jul 17, 2020 at 6:28 PM H wrote: > | | | > | | | The problem I am having is that > | | | the csv files have header rows > |

Re: [R] Help with read.csv.sql()

quot-NA-quot-for-missing-td4642327.html > > Otherwise you can try reading through the FAQ on Github: > > https://github.com/ggrothendieck/sqldf > > HTH, Bill. > > W. Michels, Ph.D. > > > > On Sat, Jul 18, 2020 at 9:59 AM H wrote: >> On 07/18/2020 11:54 AM,

Re: [R] [External] Re: read.csv fails in R console in Ubuntu terminal but works in RStudio after R 3.6.3 upgrade to R 4.0.2?

This issue was now solved in TTR::stockSymbols() by package author https://github.com/joshuaulrich/TTR/commit/98dec2b5aa68c3cee750397c7d11b164895e0140 Thanks for all the help and ideas. Best, Sam On Fri, Jul 17, 2020, 13:54 Sam H wrote: > Hello, > > Thank you very much to you al

Re: [R] Help with read.csv.sql()

gt; need to change. > Then the function would return this final object. > > Rui Barradas > > Às 16:43 de 18/07/2020, H escreveu: > >> On 07/17/2020 09:49 PM, Bert Gunter wrote: >>> Is there some reason that you can't make the changes to the data frame >>> (colum

  1   2   3   >