Dear Friends,
I'm trying to run a bunch of tasks in parallel using 'Future' package and
for some reason, it's not able to find the data frames that I want it to
find. I've created the below sample program to show what I'm doing. Should
I be exporting the Global data to each child process? I
Hello All, Is there any parameter to make read_excel() ignore the
case-sensitiveness of the worksheet? I'm using the below to ready in multiple
spreadsheets and it works perfectly fine if the worksheet is named 'Tables',
but fails when it's named ' TABLES'. Any thoughts?
lapply(1:nrow(SIS),
I’ve already tried that and doesn’t work
From: Erin Hodgess [mailto:erinm.hodg...@gmail.com]
Sent: Tuesday, May 26, 2020 10:55 PM
To: Ravi Jeyaraman
Cc: r-help@r-project.org
Subject: Re: [R] read_excel() ignore case of worksheet name?
Here’s a thought, please. Could you use the tolower
Ista, With few tweaks this worked beautifully. Thank you so much.
-Original Message-
From: Ista Zahn [mailto:istaz...@gmail.com]
Sent: Tuesday, May 26, 2020 11:38 PM
To: Ravi Jeyaraman
Cc: Erin Hodgess ; r-help@r-project.org
Subject: Re: [R] read_excel() ignore case of worksheet name
Assuming, I have a data frame like this ..
df <- data.frame(ID=1:3, FOO=c('A_B','A_B_C','A_B_C_D_E'))
I want to do a 'cumulative split' of the values in column FOO based on the
delimiter '_'. The end result should be like this ..
ID FOO FOO_SPLIT1 FOO_SPLIT2 FOO_SPLIT
How about something like this?
df <- data.frame(ID=1:3, DTVAL=c("2009-03-21","2010-05-11","2020-05-05"))
df <- df %>% mutate(YEAR = as.numeric(format(as.Date(DTVAL,'%Y-%m-%d'),
'%Y')))
-Original Message-
From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Charles Thuo
Sent:
Hello all, When I execute a SQL using SQLDF, how do I get the number of
records affected? I mean, if I run an UPDATE on a data frame, it doesn't
tell me if and how many records got updated. I've read through the
documentation and there don't seem to be a way to get this info unless it's
done on a
ldf()
sqldf(c("pragma count_changes = 1", "update con set V1 = 0 where V1 > 5 "))
ans <- sqldf("select * from main.con")
sqldf()
-Original Message-
From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com]
Sent: Thursday, June 11, 2020 9:12 AM
To: Ravi Je
V1 > 5 ")))
sqldf("select * from main.con")
sqldf()
-Original Message-
From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com]
Sent: Thursday, June 11, 2020 10:30 AM
To: Ravi Jeyaraman
Cc: r-help@r-project.org
Subject: Re: [R] sqldf and number of records affected
9 matches
Mail list logo
