[R] Integration between R and Microsoft SQL Server?

Oracle has its own R integration called Oracle R Enterprise: http://www.oracle.com/technetwork/database/options/advanced-analytics/r-enterprise/index.html Is there a same kind of integration available for Microsoft SQL Server? If there is not, does MS have any plans to integrate R and SQL Server

Re: [R] What makes R different from other programming languages?

plot2 > (including the famous facebook world map) and statistical modelling > (both base and in contributed packages) > > What are your developers interested in and we can be more specific? > > Michael > > On Mon, Aug 20, 2012 at 1:02 PM, johannes rara wrote: >>

[R] What makes R different from other programming languages?

My intention is to give a presentation about R programming language for software developers. I would like to ask, what are the things that make R different from other programming languages? What are the specific cases where Java/C#/Python developer might say "Wow, that was neat!"? What are the thin

[R] How to remove rows representing concurrent sessions from data.frame?

I have a dataset like this (dput for this below) which represents user computer sessions: username machine start end 1 user1 D5599.domain.com 2011-01-03 09:44:18 2011-01-03 09:47:27 2 user1 D5599.domain.com 2011-01-03 09:46:29 2011-01-03 10:09:16 3

Re: [R] How to read data sequentially into R (line by line)?

d 14M lines in the file and you were > generating 14M files, then there is something wrong with your code is > that it is not recognizing the breaks.  How many lines did each file > have in it? > > On Tue, Oct 18, 2011 at 9:36 AM, johannes rara wrote: >> Thanks Jim for you

Re: [R] How to read data sequentially into R (line by line)?

iles, each of which can then > be read in using 'read.table'.  My solution assumes that you have used > readLines.  Trying to do this with data frames gets messy.  Keep it > simple and do it in two phases; makes it easier to debug and to see > what is going on. > > >

Re: [R] How to read data sequentially into R (line by line)?

if (length(input) == 0) break  # done >    buffer <- c(buffer, input) >    # find separator >    repeat{ >        indx <- which(grepl("^GG!KK!KK!", buffer))[1] >        if (is.na(indx)) break  # not found yet; read more >        writeLines(buffer[1:(indx - 1L)] >            

[R] How to read data sequentially into R (line by line)?

I have a data set like this in one .txt file (cols separated by !): APE!KKU!684! APE!VAL!! APE!UASU!! APE!PLA!1! APE!E!10! APE!TPVA!17122009! APE!STAP!1! GG!KK!KK! APE!KKU!684! APE!VAL!! APE!UASU!! APE!PLA!1! APE!E!10! APE!TPVA!17122009! APE!STAP!1! GG!KK!KK! APE!KKU!684! APE!VAL!! APE!UASU!! APE!

Re: [R] Regexp question

Thank you all! 2011/5/4 David Wolfskill : > On Wed, May 04, 2011 at 10:41:36PM +0300, johannes rara wrote: >> I have a string like this >> >> st <- "SELECT COUNT(empid), COUNT(mgrid), COUNT(empname), >> COUNT(salary), FROM Employees" >> >> How c

[R] Regexp question

I have a string like this st <- "SELECT COUNT(empid), COUNT(mgrid), COUNT(empname), COUNT(salary), FROM Employees" How can I remove the last comma before the FROM statement? -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo

[R] A new IDE for R: RStudio

Hi, This is not an official announcement, I just discovered that a new IDE for R named RStudio was released today. Looks very very promising to me! http://www.rstudio.org -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-

[R] What's wrong with Omegahat?

Omegahat project page seems to be down or registeration of omegahat domain has ended? http://www.omegahat.org/ Where I can find the RCurl package? -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the

Re: [R] Regexp question

Great, thanks! 2010/11/17 Henrique Dallazuanna : > Try this: > > Reduce(union, strsplit(gsub("([A-Z])", ";\\1", a), ";")) > > On Wed, Nov 17, 2010 at 5:59 PM, johannes rara > wrote: >> >> I have a vector like this: >> >>

[R] Regexp question

I have a vector like this: a <- c("thisIsName", "thisIsAlsoName", "andThisName") How to break this into pieces and produce a vector with unique parts: this Is Name Also and This -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/lis

Re: [R] How to rbind list of vectors with unequal vector lengths?

I have tried it, but it does not seem to work with vectors, only data.frames > do.call(rbind.fill, l) NULL > -J 2010/11/8 Erik Iverson : > Then one solution is to use > rbind.fill from the plyr package. > > johannes rara wrote: >> >> This is the ideal resu

Re: [R] How to rbind list of vectors with unequal vector lengths?

This is the ideal result (data.frame): > result names X1 X2 X3 1 a 1 2 NA 2 b 1 2 3 > 2010/11/8 Erik Iverson : > So what do you want the matrix to > look like, since the number of columns > will be different between the two rows? > > > > johann

Re: [R] How to rbind list of vectors with unequal vector lengths?

Thanks, data.frame or matrix. -J 2010/11/8 Erik Iverson : > What class of object / structure do you exactly want > in the end?  A matrix, a data.frame, a vector? > > johannes rara wrote: >> >> Hi, >> >> How to rbind these vectors from a list?: >> >&g

[R] How to rbind list of vectors with unequal vector lengths?

Hi, How to rbind these vectors from a list?: > l <- list(a = c(1, 2), b = c(1, 2, 3)) > l $a [1] 1 2 $b [1] 1 2 3 > do.call(rbind, l) [,1] [,2] [,3] a121 b123 Warning message: In function (..., deparse.level = 1) : number of columns of result is not a multiple of ve

Re: [R] How to read only ten rows from a SAS dataset (read.ssd)?

I have previously tried to use Hmisc's sas.get function, but I have had problems with it. I think I go with your last suggestion. -J 2010/10/19 David Winsemius : > > On Oct 19, 2010, at 1:31 PM, johannes rara wrote: > >> Thanks David, >> >> Yes, my code really

Re: [R] How to read only ten rows from a SAS dataset (read.ssd)?

ld not find a possibility to get limited amount of rows from a dataset when importing data to R. -J 2010/10/19 David Winsemius : > > On Oct 19, 2010, at 6:47 AM, johannes rara wrote: > >> I'm trying to read SAS datasets on Windows: >> >> sashome <- "C:/Progra

[R] readLines: how to make a data.frame?

I have a text file containing data: Som text :: asdf @ 1 ds $ 5. /*Edmp */ @ 8 asu $ 3. /*daf*/ @ 8 asdala $ 2. /*asdfa*/ @ 13 astun $ 11. /*daf */ @ 26 dft $ 3. /*asdf */ @ 31 dsfp $ 2. /*asdf */ asjk asdfö My intention is to create a dataframe from this data (only rows

[R] How to read only ten rows from a SAS dataset (read.ssd)?

I'm trying to read SAS datasets on Windows: sashome <- "C:/Program Files/SAS/SAS 9.1" fold <- "C:/temp" g <- read.ssd(fold, "sasfile", sascmd = file.path(sashome, "sas.exe")) How to get only e.g first ten rows into R? -J __ R-help@r-project.org mailin

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

hat creates the CREATE > TABLE statement for a given a data.frame. I think other db related > packages for MySQL and PostgreSQL also have such a function. > > Michael > > > On 10 October 2010 00:39, Gabor Grothendieck wrote: >> On Sat, Oct 9, 2010 at 9:02 AM, johannes rara

Re: [R] Package for converting R datasets into SQL Server (create table and insert statements)?

H, > > Eric > > > 2010/10/3 johannes rara >> >> Hi, >> >> R contains many good datasets which would be valuable in other >> platforms as well. My intention is to use R datasets on SQL Server as >> a sample tables. Is there a package that would d

[R] Package for converting R datasets into SQL Server (create table and insert statements)?

Hi, R contains many good datasets which would be valuable in other platforms as well. My intention is to use R datasets on SQL Server as a sample tables. Is there a package that would do automatic conversion from the dataset "schema" into a SQL Server CREATE TABLE statement (and INSERT INTO statem

Re: [R] How to make flowchart in R?

gt; > On Aug 16, 2010, at 12:59 PM, johannes rara wrote: > >> I have a large dataset and I would like to make some kind of flowchart >> from this dataset. The idea is to show rowcounts from data subsets: >> >>            

[R] How to make flowchart in R?

I have a large dataset and I would like to make some kind of flowchart from this dataset. The idea is to show rowcounts from data subsets: data1 rows= 10 | / \ / \ males females, rows=

[R] RODBC: AD authentication when accessing database?

Hi, I'm trying to fetch data from SQL Server database using RODBC. Is there a way to use AD authentication method when accessing data via R? I'm using R 2.10.1 and Windows XP. -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinf

Re: [R] data.table error

ble) > cr <- data.table(cars) > cr[speed == 20] speed dist [1,]20 32 [2,]20 48 [3,]20 52 [4,]20 56 [5,]20 64 > -J 2010/4/29 David Winsemius : > > On Apr 29, 2010, at 3:49 PM, johannes rara wrote: > >> Thanks for the quick response. I tri

Re: [R] data.table error

ope to have that to CRAN > reasonably soon. > > To install, use: > >  install.packages("data.table",repos="http://R-Forge.R-project.org";) > > - Tom > > Tom Short > > On Thu, Apr 29, 2010 at 3:40 PM, johannes rara wrote: >> I'm trying

[R] data.table error

I'm trying to learn data.table package but I get a following annoying error message: > install.packages("data.table") trying URL 'http://www.freestatistics.org/cran/bin/macosx/universal/contrib/2.10/data.table_1.2.tgz' Content type 'application/x-gzip' length 66823 bytes (65 Kb) opened URL ==

Re: [R] Image into Excel file from R

See: https://stat.ethz.ch/pipermail/r-help/2010-January/225841.html -J __ R-help@r-project.org mailing list 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,

Re: [R] How to recode variables using base R

Thanks, you're a lifesaver. -J 2010/3/30 Henrique Dallazuanna : > Using lapply: > > as.data.frame(lapply(df, cut, breaks = c(-Inf, 3, 8, 16), labels = > c('x', 'y', 'z'))) > > > On Tue, Mar 30, 2010 at 10:14 AM, johannes rara > wrote:

Re: [R] How to recode variables using base R

gt; > On Tue, Mar 30, 2010 at 8:30 AM, johannes rara wrote: >> Hi, >> >> Is there an efficient way recoding variables in a data.frame using >> base R? My purpose is to create >> new variables and attach them into old data.frame. The basic idea is >> shown

[R] How to recode variables using base R

Hi, Is there an efficient way recoding variables in a data.frame using base R? My purpose is to create new variables and attach them into old data.frame. The basic idea is shown below, but how to create recoding for A, B and C and assing them into new variables? df <- data.frame(A = c(1:5), B = c

Re: [R] How to format dates (with no century)?

Actually I found it: > as.Date(strptime(dates, "%d.%m.%y"), "%Y-%m-%d") [1] "2007-04-06" "1998-12-29" "1991-10-19" "1992-06-20" "2003-09-02" "2003-06-23" "1993-07-13" "2007-03-23" "1995-

[R] How to format dates (with no century)?

Hi, I have dates in this kind of format (day, month, year): > dput(head(dates, 10)) c("6.4.7", "29.12.98", "19.10.91", "20.6.92", "2.9.3", "23.6.3", "13.7.93", "23.3.7", "26.6.95", "15.2.10") So, as you can see, there is no century. How can I change this character data into dates? Any help would

Re: [R] For loop into a vectorized form?

Exactly, thanks! -jrara 2010/1/30 David Winsemius : > > On Jan 29, 2010, at 9:31 AM, johannes rara wrote: > >> How to vectorize this for loop and how can I assign result to vector >> instead of using print function? > >> as.vector( sapply(mylist$a, function(x) >

[R] For loop into a vectorized form?

How to vectorize this for loop and how can I assign result to vector instead of using print function? mylist <- list(a = letters[1:3], b = LETTERS[1:3], c = c("1", "2", "3")) for (i in seq_along(mylist[[1]])) { for (j in seq_along(mylist[[2]])) { print(mylist[[1]][i]) print(m

[R] How to convert timestamps?

I have timestamps from mysql database: > dput(tstamp) c(1225221868L, 1225221906L, 1225221906L, 1225230997L, 1225231000L, 1225231003L, 1225231152L, 1225231348L, 1225231351L, 1225231400L ) How to convert these into normal dates? Thanks, jrara __ R-help@

[R] How to attach chart to excel file?

Hi, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/lis

Re: [R] Rscript: how to suppress all output

2010/1/3 Prof Brian Ripley : > On Sat, 2 Jan 2010, johannes rara wrote: > >> How can I suppress ALL output when running Rscript in Terminal? >> >> ~/Documents>Rscript test.r > > Rscript test.r >& /dev/null > > or equivalent in your shell.  But note that Rscr

[R] Rscript: how to suppress all output

How can I suppress ALL output when running Rscript in Terminal? ~/Documents>Rscript test.r I tried options --slave, --vanilla with no success. I get these Loading required package: methods ..etc.. and other output as well. -J > sessionInfo() R version 2.9.2 (2009-08-24) i386-apple-darwin8.11.

Re: [R] Regexp: extract first occurrence of date in string

perl=T) > substr(txt, l, l+9) [1] "05.12.2009" > But your examples are more generic. I'll have to look gsubfn more closely. -J 2010/1/2 Gabor Grothendieck : > Use regexpr to get the offset into the string and its length and then > use substr to pick extract it. > >

Re: [R] Regexp: extract first occurrence of date in string

tracting all the dates and then picking > off the first: > >> strapply(txt, "\\d{1,2}\\.\\d{1,2}\\.\\d{4}")[[1]][1] > [1] "05.12.2009" > > On Sat, Jan 2, 2010 at 10:08 AM, johannes rara wrote: >> I would like to extract first date from a string: &

[R] Regexp: extract first occurrence of date in string

I would like to extract first date from a string: > txt <- "first date is 05.12.2009. Second date is 06.12.2009." > txt [1] "first date is 05.12.2009. Second date is 06.12.2009." I tried: > sub("^.*?\\s(\\d{1,2}\\.\\d{1,2}\\.\\d{4})", "\\1", txt, extended=T, perl=T) [1] "05.12.2009. Second date

Re: [R] Stripchart: way to get different colour for each group

)), mydata$val1, col=ifelse(mydata$group == 0, "red", "yellow"), pch=15) points(rep(1.75, nrow(mydata)), mydata$val2, col=ifelse(mydata$group == 0, "red", "yellow"), pch=15) Thanks, - J 2009/12/1 johannes rara : > I was probably too vague. I meant that th

Re: [R] Stripchart: way to get different colour for each group

5.3 0 6 5.3 6.2 1 7 4.5 7.7 0 8 2.2 4.8 1 9 4.7 3.4 0 10 2.7 2.1 1 So, I want to color the points of those groups using different colour. - J 2009/12/1 David Winsemius : > > On Dec 1, 2009, at 12:42 AM, johannes rara wrote: > >> Hi, >>

[R] Stripchart: way to get different colour for each group

Hi, Is there a way to get different colour based on group when plotting stripchart? mydata <- data.frame(val1 = c(1.1, 3.2, 4.1, 2.5, 6.2, 5.3, 4.5, 2.2, 4.7, 2.7), val2 = c(4.2, 5.3, 3.4, 2.6, 5.3, 6.2, 7.7, 4.8, 3.4, 2.1), group = rep(0:1, 5)) mydata.stack <- stack(mydata, select=-group) strip

[R] How to strip everything after second whitespace?

How to split everything after second whitespace char using regular expression? I want to remove A, B, C and D from these names: nam <- c("Smith John A", "Smith David B C", "Smith Ryan C D") Thanks, Johannes __ R-help@r-project.org mailing list https://

Re: [R] Problems importing Unix SAS .ssd04 file to R (Win)

S v8? Dan Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204 2009/10/20 johannes rara : > Hello, > > I'm trying to import a SAS file made using SAS on Unix. C

[R] Problems importing Unix SAS .ssd04 file to R (Win)

Hello, I'm trying to import a SAS file made using SAS on Unix. Currently I'm using SAS on Windows and I'm trying to import that .ssd04 file to R. The file name of the file is testfile.ssd04 and it is located in 'M:\sasuser'. I'm using Windows XP and R 2.91. Basically what I'm doing is ###

[R] How to get "last status change", ctime on Windows?

Hi, file.info is producing data.frame with ctime variable. Help file says that on Unix this is 'last status change' and on Windows 'creation time'. Is there a way to get 'last status change' on Windows using some R function? Thanks, Johannes __ R-help@

[R] Export to Excel

I spotted quite nice blog post by learning r blog http://learnr.wordpress.com/2009/10/06/export-data-frames-to-multi-worksheet-excel-file/ very good summary how to export data from R to multiple Excel sheets. - Johannes __ R-help@r-project.org mailing

[R] AsciiDoc and R

I would like to learn AsciiDoc. Is there any good examples how to use AsciiDoc with R? I know that there is packages called ascii to do this, but it would be nice to see some examples how AsciiDoc works with R. Is there an AsciiDoc distribution for Max OS X? -Johannes

Re: [R] some simple questions regarding survival analysis

2) See packages Epi and epitools -Johannes 2009/9/29 Dmitry Gospodaryov : > I have two types of survival data for Drosophila > cohort. For example: > > uncensored > >> age <- c (0, 2, 4, 6, 8, 10) >> alive1 <- c(10, 9, 6, 3, 1, 0) >> alive 2 <- c(10, 9, 4, 1, 1, 0) > > and censored > >> age <- c(

Re: [R] Sweave, TEXINPUTS problem

Yes! I found the solution. The problem was in my export line in .bash_profile. The correct line is here export TEXINPUTS=.:/Library/Frameworks/R.framework/Resources/share/texmf:$TEXINPUTS -Johannes 2009/9/28 Charles C. Berry : > On Mon, 28 Sep 2009, johannes rara wrote: > >> H

Re: [R] Sweave, TEXINPUTS problem

Thanks. I'm using Aquamacs. I think that it uses pdflatex to typeset .tex-files. I can find pdflatex from my computer using ~ > locate pdflatex Johannes 2009/9/28 Charles C. Berry : > On Mon, 28 Sep 2009, johannes rara wrote: > >> Hi, >> >> I'm trying to

[R] Sweave, TEXINPUTS problem

Hi, I'm trying to use Sweave in my .tex-documents using \usepackage{Sweave} notation. I have this line in my .bash_profile export TEXINPUT=.:/Users/jrara/Library/Frameworks/R.framework/Resources/share/texmf:$TEXINPUTS When trying to typeset this .tex document, I get an error message saying E

Re: [R] cut and re-factor data

Try e.g. function recode from package car. 2009/9/22 Chris Hane : > Hello R-users, > I have a data frame with a factor of ages in 5 year increments, and various > count data for each age group. I only have this summary information in R at > the moment. > > I want to create a new factor that aggreg

Re: [R] microarray analysis in R without replicates

Try asking bioconductor list http://www.bioconductor.org/docs/postingGuide.html -Johannes 2009/9/22 Rainer Tischler : > Dear all, > > I have received a microarray data set in standard Affymetrix CEL-format > consisting of only six samples  without any replicates (same organism and > cell type,

Re: [R] weird "vector size cannot be NA/NaN" problem

This is probably a describe function from Hmisc-package. 2009/9/21 Petr PIKAL : > Hi > > I tried but > >> describe(c(5,3,76,4/0)) > Error: could not find function "describe" >> > > What shall I do? Quick search did not find function on CRAN and I do not > have enough time to dig it from somewhere.

Re: [R] Plot factors with a loop

Why do you need to do this using loop? Is this what you want? a <- rep(c("a", "b", "c"), 6) df <- data.frame(f=a, d=rnorm(18)) df boxplot(df$d ~ df$f) 2009/9/20 Sam Player : > # I have a dataframe with a factor and data: > > a <- rep(c("a", "b"), c(6,6)) > df <- data.frame(f=a, d=rnorm(12)) > df

Re: [R] How to avoid copy-paste when copying code from this list

lt;- grep("^[[:blank:]]*[^>+[:blank:]]*[>+]", L, value = TRUE) >>   L <- sub("^[[:blank:]]*[^>+[:blank:]]*[>+] ?", "", L) >>   source(textConnection(L), echo = echo, >>      max.deparse.length = max.deparse.length, ...) >> } >>

Re: [R] How to avoid copy-paste when copying code from this list

Thanks for the responses. I think that the best way to avoid lots of hassle is that people copy-paste their solutions from their code editor, NOT from R console. For example, I usually save those solutions for my code archive, and if I want to run these later on (using Tinn-R), I have to parse ">"

Re: [R] How to avoid copy-paste when copying code from this list

27;vim' in a Linux xterm. Removal of the "> " > prompts (or "+ " continuation prompts) from a long series of commands > is relatively easy: Just higlight a column-block of the first two > columns, then press "d" to delete them. But you would first need

[R] How to avoid copy-paste when copying code from this list?

Hi, How do you people avoid copy-pasting and manual editing of the code posted in this list? I mean that if some one post a solution for an answer like this: > a <- 1:10 > a [1] 1 2 3 4 5 6 7 8 9 10 > a[1:5] [1] 1 2 3 4 5 > I have to copy-paste it to e.g. Tinn-R and remove "> " part of

Re: [R] merging data frames with matrix objects when missing cases

This has something to do with your data.frame structure see > str(df1) 'data.frame': 3 obs. of 2 variables: $ a : int 1 2 3 $ X1: 'AsIs' int [1:3, 1:2] 1 2 3 4 5 6 > str(df2) 'data.frame': 2 obs. of 2 variables: $ a : int 1 2 $ X2: 'AsIs' int [1:2, 1:2] 11 12 13 14 This seems to work

Re: [R] How to convert numbers to words?

See this post from the past (by John Fox): http://finzi.psych.upenn.edu/R/Rhelp02a/archive/46843.html -Johannes 2009/9/14 Derek Norton > I am trying to convert numbers to English words, e.g. 123 -> One > hundred twenty three. After some searching, I have been unable to > find any info on this.

Re: [R] How to visualize paired t-test results?

to be from the zero > (otherwise, all the graph gives is the variance, without any useful > knowledge of the distance of the differences from the zero) > > Also, consider using this function for CI plotting: > http://finzi.psych.upenn.edu/R/library/plotrix/html/plotCI.html > &g

[R] How to visualize paired t-test results?

I would like to know if you have any suggestions how to visualize the results from a paired t-test (see the example data below). I tried to produce plots that show the mean and CI's from the original data and the estimate of the difference between means and the confidence intervals (see below) from