similar to: combining data from different datasets

Hi, I am getting accumulated data from PostgreSQL, ie for every day in which a condition is true I get the number (count) of cases. Starting date is 2008-01-01 and end day the last day for which the condition is true (which is not necessarily today). I obviously do not get records (dates) with count = 0, in other words this is not a complete list of every day since 2008-01-01. Now I want I plot

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 ######################## Fredrik Lundgren fredrik.bg.lundgren at gmail.com Obs! Ny adress och mail Engelbrektsgatan 31 582 21 Link?ping 013 - 47 30 117 0706 - 86 39 29 Sommarhus: Ljungn?s 158 380 30 Rockneby 0480 - 650 98

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 = "utf8" and "latin1" in write.csv(). However, it does not have effect. The output is is <U+00C5>land or <c5>land. Best, Jinsong > On 20/10/2020 11:13, Jinsong Zhao wrote: >> Hi

Hi, I noticed the temperature of my laptop rises sharply during execution of a long R script that generates several hundred plots, all of them saved to files. No screen output. Temps reached above 90 Celsius degrees in the box and above 80 C deg in the processor. The machine turns on cooler at maximum speed and exhaled air is really hot. Tried similar operations (batch graphic and music

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 = "utf8" and > "latin1" in write.csv(). However, it does not have effect. The

Graham, nice package this :-)-O. It was easy to set up MySQL but I struggled immensely to get the stock ODBC working with PostgreSQL (8.3), which has been discussed on the mailing list before (Prof Brian): Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing

Hi All, Trying to get familiar with dplyr so I have a basic question: How to summarise sum(Values) per species, maintaining Code column (each species has a Code): Species Values Code 1 Acanthocybium solandri 33 LC 2 Makaira nigricans 20 VU 3 Makaira nigricans 20 VU 4. Makaira nigricans

Hi there, I tried to export the names of country to a csv file with write.csv(). In the resulted file, ?land was coverted to <c5>land. Is there any way could prevent this happening? Thanks! > abc [1] "?land" > write.table(abc, file = "") "x" "1" "<c5>land" Best, Jinsong

?file.write() look for fileEncoding? el On 20/10/2020 11:13, Jinsong Zhao wrote: > Hi there, > > I tried to export the names of country to a csv file with write.csv(). In the resulted file, ?land was coverted to <c5>land. Is there any way could prevent this happening? Thanks! > >> abc > [1] "?land" >> write.table(abc, file = "") >

Hi, I have following kind of dataset (all are dates) in my Excel sheet. 09/08/08 09/05/08 09/04/08 09/02/08 09/01/08 29/08/2008 28/08/2008 27/08/2008 26/08/2008 25/08/2008 22/08/2008 21/08/2008 20/08/2008 18/08/2008 14/08/2008 13/08/2008 08/12/08 08/11/08 08/08/08 08/07/08 However I want to use R to compile those data to make all dates in same format. Can anyone please tell me any automated way

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

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 there a better, worse, or perhaps easier (I am a linux newby migrating from mac) distribution that I should look at. I appreciate your help. I didn't post this in the sig-mac because I don't know if it fits there better

I've rolled up R-1.7.0.tgz a short while ago. This is a new version with major changes in the methods/class area and with namespaces used much more widely than before. Several routines now use the faster and more modern LAPACK library. Also notice that the underscore is now strongly deprecated as an assignment operator. There are also a bunch of new functions and an assortment of bugs have

I've rolled up R-1.7.0.tgz a short while ago. This is a new version with major changes in the methods/class area and with namespaces used much more widely than before. Several routines now use the faster and more modern LAPACK library. Also notice that the underscore is now strongly deprecated as an assignment operator. There are also a bunch of new functions and an assortment of bugs have

I've rolled up R-1.5.1.tgz a short while ago. This is a patch upgrade, fixing the most important bugs that cropped up after the 1.5.0 release. A set of recommended packages which have been tested with R-1.5.1 has been bundled up. Binary distributions should include these packages. You can get the files from the developer site ftp://cvs.r-project.org/pub/CRAN/src/base/R-1.5.1.tgz

I've rolled up R-1.5.1.tgz a short while ago. This is a patch upgrade, fixing the most important bugs that cropped up after the 1.5.0 release. A set of recommended packages which have been tested with R-1.5.1 has been bundled up. Binary distributions should include these packages. You can get the files from the developer site ftp://cvs.r-project.org/pub/CRAN/src/base/R-1.5.1.tgz

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

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 user > credentials to log in, but I could upload the file somewhere if

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 wrote: > It sounded like he looked at officeR but I would agree > > content <-

Dear R-users, When i try - Data1<-read.table("/Users/kama/Analysis/GDP10.csv",header=TRUE,sep=";") i am getting this error: Warning message: In scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : number of items read is not a multiple of the number of columns I wonder what Iam doing wrong. i guess it is something simple, however, i do not understand