Looks like an assignment question.
If so, do your homework yourself. Google is your friend
el
On 2024-12-11 15:16, akshay kulkarni wrote:
> dear Members, I have recently started studying SQL and MySQL. My
> question is, what exactly is SQL used for? That is, whatever can be
> done by SQL, like
I find QSV very helpful.
el
On 08/04/2024 22:21, Dave Dixon wrote:
> I solved the mystery, but not the problem. The problem is that
> there's an unclosed quote somewhere in those 5 additional records I'm
> trying to access. So read.csv is reading million-character fields.
> It's slow at that. Tha
Andy,
you can always open a public Dropbox or Google folder and post the link.
el
On 29/12/2023 22:37, Andy wrote:
> Thanks - I'll have a look at these options too.
>
> I'm happy to send over a sample document, but wasn't aware if
> attachments are allowed. The documents come Lexis+, so require
I would also look at https://pandoc.org perhaps which can
export a number of formats...
And for spreadsheets https://github.com/jqnatividad/qsv is my
goto weapon. Can also read and write XLSX and others.
A sample document or two would always be helpful...
el
On 29/12/2023 21:01, CALUM POLWART
Sublime Text.
On all platforms.
On 29/11/2023 17:57, Christofer Bogaso wrote:
> Hi,
>
> Currently I use VS-Code to write codes in R. While it is very good, it
> does not allow me to write Latex expressions in comments, which I am
> willing to have to write corresponding mathematical expressions a
There is at least one outliers package on CRAN.
el
On 20/04/2023 20:43, AbouEl-Makarim Aboueissa wrote:
> Dear All: *please discard my previous email*
>
>
>
> *Re:* detect and replace outliers by the average
>
>
>
> The dataset, please see attached, contains a group factoring column “
> *fa
Does it say what the new format is?
On 2022-10-09 13:01 , Nick Wray wrote:
[...]
> Up to 2010 everything's fine and dandy - the data is in nice neat columns
> and I can download it and filter out what I don't want. But after 2010 the
> format changes (The Met Office in fact say on their guideline
To me this file looks like a CSV with 15 fields (on each line) not 16,
the last field being empty with the exception of the one which has the
'B'. The 14th is always empty.
I also note that it does not seem to have a new line at the end.
I can strongly recommend QSV to manipulate CSV files and
Bui,
thanks, this what Avi suggested in an email to me as well and works.
It's so easy if you know it :-)-O
el
On 2022-07-13 23:40 , Rui Barradas wrote:
Hello,
Are you looking for mutate? In the example below I haven't included the
filter, since the tibble only has 2 rows. But the date co
Hi,
while all of the below work in a character vector, none works in
the tibble.
The following
DDATA %>%
add_column(as.tibble(lubridate::dmy_hm(DDATA$Date)),
.before = "Period") %>%
rename(NewDate=value) %>%
selec
Thanks.
Your method
mutate(
cases = ifelse(
country == 'Namibia'
& type == 'confirmed'
& date == '2021-10-23'
& cases == 357,
NA,
cases
)
)
works, as does Rui's
mutate(
cases = replace(
cases,
Thank you very much,
'which' does the trick :-)-O
greetings, el
On 2021-10-25 19:06 , Rui Barradas wrote:
Hello,
Here is a pipe to replace based on the composite condition.
It uses ?base::replace with an integer index vector.
[...]
library(dplyr)
data(coronavirus, package = "coronavirus
gt;)
>
>
>
> Can you post the pipe code you are running?
>
> Hope this helps,
>
> Rui Barradas
>
> Às 12:25 de 25/10/21, Dr Eberhard W Lisse escreveu:
>> Hi,
>>
>> I have data from JHU via the 'coronavirus' package which has a value f
Hi,
I have data from JHU via the 'coronavirus' package which has a value for
the confirmed cases for 2021-10-23 which differs drastically (357) from
what is reported in country (23).
# A tibble: 962 × 4
country date type cases
1 Namibi
l
On 2021-03-25 22:37 , Jeff Newmiller wrote:
> This is a very unclear question. Weeks don't line up with months..
> so you need to clarify how you would do this or at least give an
> explicit example of input data and result data.
>
> On March 25, 2021 11:34:15 AM PDT, Dr Eberh
know of
any leap hours.
On Sun, Mar 21, 2021 at 8:31 AM Dr Eberhard W Lisse wrote:
Hi,
I have minutes worked by day (with some more information)
which when using
library(tidyverse)
library(lubridate)
run through
CONSMINUTES %>%
select(datu
Hi,
I have minutes worked by day (with some more information)
which when using
library(tidyverse)
library(lubridate)
run through
CONSMINUTES %>%
select(datum, dauer) %>%
arrange(desc(datum))
look somewhat like
# A tibble: 142 x
L Carlson
>
> On Sun, Feb 28, 2021 at 9:06 AM Dr Eberhard W Lisse <mailto:e...@lisse.na>> wrote:
>
> On the Mac it is ~/.Rhistory
>
> el
>
> On 2021-02-28 15:39 , Mahmood Naderan-Tahan wrote:
> > Hi
> >
> > May I know
;
>
> Regards,
> Mahmood
[...]
--
Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist
e...@lisse.na / * | Telephone: +264 81 124 6733 (cell)
PO Box 8421 Bachbrecht \ / If this email is signed with GPG/PGP
10007, Namibia ;/ Sect 20 of
On the Mac it is ~/.Rhistory
el
On 2021-02-28 15:39 , Mahmood Naderan-Tahan wrote:
> Hi
>
> May I know where is the location of commands we used in R in the history?
>
>
> Regards,
> Mahmood--
Dr. Eberhard W. Lisse \ / Obstetrician & Gy
16:19, John Fox wrote:
> Dear Eberhard,
>
> On 2021-01-12 12:32 a.m., Dr Eberhard W Lisse wrote:
>> John,
>>
>> what is wrong with installing Xcode’s command lime tools (not Xcode
>> itself)?
>
> Nothing, and I did miss the distinction, but it should
John,
what is wrong with installing Xcode’s command lime tools (not Xcode itself)?
—
Sent from Dr Lisse’s iPhone
On 12 Jan 2021, 04:30 +0200, John Fox , wrote:
> Dear Stephane,
>
> I've taken yet another look at this and have an additional suggestion
> for your students to try:
>
> install.packa
Use RStudio.
But it can be that the command line tools are missing, which you (may) need to
compile packages (from source).Ask one of them to open a terminal window and
type the command ‘make —version’ without the ‘’) if that results in an error
they need to enter ‘sudo xcode-select —install’ a
PLEASE do read the posting guide
>>> http://www.R-project.org/posting-guide.html
>>> and provide commented, minimal, self-contained, reproducible code.
>>>
>>
>
> [[alternative HTML version deleted]]
>
> _
ere must be something more recent on the market. Any
>> suggestions will be much appreciated!
>>
>> Cheers,
>> Ben van den Anker
[...]
--
Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist
e...@lisse.na / * | Telephone: +264 81 124 6
Or rather
Rscript -e 'local({r <- getOption("repos");r["CRAN"] <-
"https://cloud.r-project.org/";options(repos =
r)});update.packages(dependencies = TRUE, ask=FALSE)'
as a one liner :-)-O
el
On 2020-12-23 17:59 , Dr Eberhard W Lis
Thank you,
but the RFTM suggestion helped me even more :-)-O
greetings, el
On 2020-12-23 17:06 , Sarah Goslee wrote:
> Does update.packages() meet your needs?
>
>
> Sarah
>
> On Wed, Dec 23, 2020 at 9:39 AM Dr Eberhard W Lisse wrote:
>>
>> Hi,
>>
>>
Thanks,
update.packages(dependencies = TRUE, ask=FALSE)
does what I want.
greetings, el
On 2020-12-23 17:30 , Deepayan Sarkar wrote:
> On Wed, Dec 23, 2020 at 8:09 PM Dr Eberhard W Lisse wrote:
>>
>> Hi,
>>
>> does anyone know how one would look which
)-O
greetings, el
--
Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist
e...@lisse.na / * | Telephone: +264 81 124 6733 (cell)
PO Box 8421 Bachbrecht \ / If this email is signed with GPG/PGP
10007, Namibia ;/ Sect 20 of Act No. 4 of 2019 ma
They let you guys go to the pup again? :-)-O
el
On 09/12/2020 10:06, Rolf Turner wrote:
[...]
> Is there any way to achieve, with plotmath, an effect like unto that
> produced by the LaTeX expression $\sigma^2_{11}$? Or should I just
> give up and go to the pub? :-)
[...]
--
Dr. E
Perhaps
?readr::write_delim()
el
On 20/10/2020 12:45, Dr Eberhard W Lisse wrote:
> Apologies,
>
> I meant
>
> ?write.table()
>
> el
>
> On 20/10/2020 12:38, Jinsong Zhao wrote:
>> On 2020/10/20 17:23, Dr Eberhard W Lisse wrote:
>>> ?file.write()
Apologies,
I meant
?write.table()
el
On 20/10/2020 12:38, Jinsong Zhao wrote:
> On 2020/10/20 17:23, Dr Eberhard W Lisse wrote:
>> ?file.write()
>>
>> look for fileEncoding?
>>
>> el
>>
>
> There is no file.write(). I have tried fileEncoding = &
nd more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
Dr. Eberhard W. Lisse \ / Obstetrician & Gynaecologist
e..
s :)
> __
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal
Rolf,
I hear you.
But, after reflection, ie I looked at my situation again, it is great :-)-O
el
Sent from Dr Lisse's iPad mini
> On Jun 30, 2014, at 0:48, Rolf Turner wrote:
>
>
>> On 30/06/14 10:32, Dr Eberhard W Lisse wrote:
>>
>> Thanks,
>>
Thank you very much.
el
On 2014-06-30, 00:48 , Rolf Turner wrote:
>
> On 30/06/14 10:32, Dr Eberhard W Lisse wrote:
>
>> Thanks,
>>
>> I then set NA to 0, and can do the sutraction,
>>
>> great.
>
> Not so great. I haven't gone through the is
Thanks,
I then set NA to 0, and can do the sutraction,
great.
el
On 2014-06-29, 22:32 , Michael Peng wrote:
> you can get a new data frame by
> merge(qpiso, qplegit, all.x = TRUE, all.y = TRUE, by = "iso" )
> Take the subtraction on the new data frame.
>
>
>
>
> 2014-06-29 11:24 GMT-05:00
Google Pressdram :-)-O
el
On 2014-05-03, 23:42 , Rolf Turner wrote:>
> On 04/05/14 00:05, Dr Eberhard W Lisse wrote:
>
>> Thank you very much, Mr Arkell.
>
> I don't get it. Can anyone explain the (joke? allusion?) ?
&
Thanks,
will try to figure this out :-)-O
el
On 2014-05-03, 06:40 , Carlos Ortega wrote:
> Hi,
>
> With the new package "dplyr" you can create equivalent SQL sintaxt
> queries like the one you need.
> You can find examples of how to apply it here:
>
> http://martinsbioblogg.wordpress.com/2014/
Thank you very much, Mr Arkell.
el
On 2014-05-03, 07:11 , Bert Gunter wrote:
> By making the effort to learn R?
>
> See e.g. the "Introduction to R" tutorial that ships with R.
>
> -- Bert
>
> Bert Gunter
> Genentech Nonclinical Biostatistics
> (650) 467-7374
>
> "Data is not information. Inf
Thank you, last post 2007.
el
On 2010-02-21 22:05 , David Winsemius wrote:
>
> You should check the R-Mac-SIG archives:
>
> http://dir.gmane.org/gmane.comp.lang.r.mac
>
> http://markmail.org/browse/org.r-project.r-sig-mac
>
> And if not found, then post on that list.
>
> David.
Hi,
I have nicely used RdbiPgSQL under 10.5 but now that I run 10.6
I can't get this to work.
I am quite sure I will not be the first to have this problem, so
can someone please point me somewhere where this has been described
or let me have a cookbook?
greetings, el
___
This is not a bug.
If you use a font that doesn't have a character which you want to use
it's an inconvenience :-)-O
el
On 18 Jan 2009, at 00:16 , Peter Dalgaard wrote:
Peter Dalgaard wrote:
Paul Johnson wrote:
Hey, everybody.
I am concluding that this Sweave wrecks quotation marks in
ty
When you type your question, it compares it to previously answered
questions. Answers can get voted up and down. Answers AND questions
can be
edited!
Regards
Roland Studer
On Fri, Jan 9, 2009 at 6:58 AM, Dr Eberhard W Lisse
wrote:
Robert,
go ahead, fix whatever bothers you, this is Open
have to develop a (convoluted) SQL statement first.
Would be nice if one could ratlle(convolutedSQL) :-)-O
greetings, el
--
Dr. Eberhard W. Lisse \/ Managing Member, |Ondis (cc)
accou...@ondis.co.na/ * | Telephone: +264 81 124 6733 (cell)
PO Box 98256 \
Robert,
go ahead, fix whatever bothers you, this is Open Sauce, not Jet-Engine
Science
:-)-O
el
On 09 Jan 2009, at 07:41 , Johannes Huesing wrote:
stephen sefick [Fri, Jan 09, 2009 at 03:16:11AM
CET]:
It has worked wonders for me over the last years.
On Thu, Jan 8, 2009 at 8:58 PM, Ro
Quite irritating to me as the Manager of .NA too, when I
used NA for .NA :-)-O
el
Peter Dalgaard wrote:
> Cliff Behrens wrote:
>> One of these permutations
>> is the character string "NA". It seems that when I try to name one of
>> the dataList levels "NA", using names(dataList)<- nameList, the
Yes, it does. Thanks.
el
On 25 Oct 2008, at 03:32 , Steven McKinney wrote:
If you are using regular R graphs
(i.e. not lattice or other library
graphics) try setting the margins
with the mar argument to par()
e.g.
par(mar = c(5, 10, 5, 1))
The four numbers specify the amount
of margin room o
Daniel,
the parameter all.x=TRUE is required.
greetings, el
On 24 Oct 2008, at 21:24 , Daniel Malter wrote:
?merge.
It looks though that your "iso" has no identifier variable whereas the
"rawdata" has, so you probably cannot merge it unless/until you have
an
identifier in "iso".
___
read will be fine, but so far I haven't found it :-)-O
el
On 24 Oct 2008, at 18:24 , Gabor Grothendieck wrote:
On Fri, Oct 24, 2008 at 11:37 AM, Dr Eberhard W Lisse <[EMAIL PROTECTED]>
wrote:
This looks very cool.
But I must still make a plan with regards to country = "
Gabor,
Thank you,
On 24 Oct 2008, at 17:16 , Gabor Grothendieck wrote:
Here are two solutions. The first uses the R merge command
and the second uses the R sqldf package. See ?merge
and http://sqldf.googlecode.com
Note that alter is an sql keyword so I have changed it
to alt for the second e
M Andorra, Principality of
2 52 M
3 39 F Namibia
...
And idea (where I can read up on this)?
el
--
Dr. Eberhard W. Lisse \/ Obstetrician & Gynaecologist (Saar)
[EMAIL PROTECTED] el108-ARIN / * | Telephone: +264 81 124 6733 (cell)
P
subkeys.pgp.net has 6 IP addresses, but all of them seem to
have the key now.
el
On 22 Oct 2008, at 17:05 , Martyn Plummer wrote:
Have you tried other keys? (mine is 97D3544E if you want to try).
If nothing works then it is probably a firewall problem. Ask your
network administrator if port
x27;d rather go the extra mile than risk
losing it.
--
Dr. Eberhard W. Lisse \/ Obstetrician & Gynaecologist (Saar)
[EMAIL PROTECTED] el108-ARIN / * | Telephone: +264 81 124 6733 (cell)
PO Box 8421 \ / Please send DNS/NA-NiC related e-mail
Bachbrec
ual character set.
On Sat, 11 Oct 2008, Dr Eberhard W Lisse wrote:
How do I put a copyright symbol (C) (or ©) into a plot?
title/sub or legend.
And/or somewhere to the bottom right of the image.
greetings, el
__
R-help@r-project.org mailing list
How do I put a copyright symbol (C) (or ©) into a plot?
title/sub or legend.
And/or somewhere to the bottom right of the image.
greetings, el
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting
cores. Quite impressive...
Does anyone know, off hand, how I set up the CRAN repository so it
updates from the latest packages (2.7.2)?
What happenend to the South African mirror by the way?
greetings, el
--
Dr. Eberhard W. Lisse \/ Obstetrician & Gynaecologist (Saar)
[EMAIL PROTE
Load the 2.7.2 mini DMBG and install over the top. Finish and klaar.
el
On 05 Oct 2008, at 11:28 , Fredrik Lundgren wrote:
Dear R-ers,
I'm using R 2.7.1 Mac OS. What is the best way for update
to 2.7.2 to keep my previous libraries?
Fredrik
--
Dr. Eberhard W.
ODBC,
didn't think of that, thanks.
el
On 18 Sep 2008, at 00:31 , David Winsemius wrote:
On Sep 17, 2008, at 6:00 PM, Dr Eberhard W Lisse wrote:
Hi,
is there a Rdbi or other package to use firebird in R?
I am reviewing options for my Practice software and might have
to switch
Hi,
is there a Rdbi or other package to use firebird in R?
I am reviewing options for my Practice software and might have
to switch to a firebird based package so I would of course like
to be able to do some stats in R.
greetings, el
__
R-help@r-proj
Adam,
I (or rather the kids and the wife) got two iMinis and one iBook
with G4. They all run 10.5.4 happily on their 1GB of RAM...
greetings, el
On 12 Sep 2008, at 23:43 , Adam D. I. Kramer wrote:
To Stephen's credit, Apple will no longer support PowerPC chips
(such as his
G4) in the next op
Yes, of course.
That's why the :-)-O was there
el
On 12 Sep 2008, at 23:01 , Doran, Harold wrote:
Are you aware that a BSD unix OS runs on the mac already?
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do
Yes,
I'd install the OS X Leopard (10.5.4) distribution on it :-)-O
el
On 12 Sep 2008, at 22:30 , stephen sefick wrote:
This is an operating system question, but it is with the intent of
using R on that operating system. I have an ibook G4 Power PC that I
am going to install linux on. Is th
Kann man das vielleicht mal auf Englisch fragen?
mfg, el
On 11 Sep 2008, at 23:42 , Ángel Orosa Rodríguez wrote:
Hola, me llamo Ángel y estoy haciendo una aplicación en Java que usa
funciones ya implementadas en R, siento molestarte para esta
tontería, pero
es que ya ni paso de la instalació
Brian,
open will call whatever program is defined for a certain extension.
You can
set this with a plug in to System Preferences called Default Apps for
example.
So on my Mac(s) Firefox is the default.
el
On 11 Sep 2008, at 08:33 , Prof Brian Ripley wrote:
If firefox is involved on a
Is this Month-Day or Day-Month or a mixture of both?
I still think using the Format -> Cell -> Date will work
much better...
el
On 09 Sep 2008, at 11:21 , David Scott wrote:
On Mon, 8 Sep 2008, Megh Dal wrote:
Hi,
I have following kind of dataset (all are dates) in my Excel sheet.
09/08/
I just CMD-C'd it and pasted it into OpenOffice with CMD-V.
el
On 07 Sep 2008, at 16:57 , John Kane wrote:
I think you need to save the plot and import it into Word. AFAIK
you can only copy and paste a plot in Windows.
Have a look at ?png (There are other formats available)
Oh, YES, thank you!
This weekend I'll try and figure out how to plot these events on
a 24 hour scale, i.e I'll aggregate the SQL query on the time
But not on the date) to see how many of those fall outside of
normal working hours :-)-O
greetings, el
On 05 Sep 2008, at 00:59 , Gabor Grothendieck
2008-01-01, end on 2008-12-31,
with tick marks for every month (ie month.abb[1:12] or something
similar)?
A pointer is enough, weekend is coming up and I am off :-)-O
I also need to add 2 lines statements, but I reckon I can figure that
out
by myself :-)-O
greetings, el
--
Dr. Eberhard W. L
count = 0, in other words
this is not a complete list of every day since 2008-01-01.
Now I want I plot this, with the sum on the Y axis and the months
on the X axis, preferably as a line drawing.
Any ideas?
el
--
Dr. Eberhard W. Lisse \/ Obstetrician & Gynaecologist (Saar)
[E
70 matches
Mail list logo
