[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

[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

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

into ggplot2 (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 johannesr...@gmail.com wrote: My intention

[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

[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!!

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

(newFile%04d, fileNo)            )        buffer - buffer[-c(1:indx)]  # remove data        fileNo - fileNo + 1    } } On Tue, Oct 18, 2011 at 8:12 AM, johannes rara johannesr...@gmail.com wrote: I have a data set like this in one .txt file (cols separated by !): APE!KKU!684! APE!VAL

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

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. On Tue, Oct 18, 2011 at 8:57 AM, johannes rara johannesr...@gmail.com

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

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 johannesr...@gmail.com wrote: Thanks Jim for your help. I tried this code using readLines and it works

[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

Re: [R] Regexp question

Thank you all! 2011/5/4 David Wolfskill r...@catwhisker.org: 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 can I remove the last comma before the FROM

[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

[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

[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

Re: [R] Regexp question

Great, thanks! 2010/11/17 Henrique Dallazuanna www...@gmail.com: Try this: Reduce(union, strsplit(gsub(([A-Z]), ;\\1, a), ;)) On Wed, Nov 17, 2010 at 5:59 PM, johannes rara johannesr...@gmail.com wrote: I have a vector like this: a - c(thisIsName, thisIsAlsoName, andThisName) How

[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

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

Thanks, data.frame or matrix. -J 2010/11/8 Erik Iverson er...@ccbr.umn.edu: 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?: l - list(a = c(1, 2), b = c(1, 2, 3)) l

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 er...@ccbr.umn.edu: So what do you want the matrix to look like, since the number of columns will be different between the two rows? johannes rara wrote: Thanks

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 er...@ccbr.umn.edu: Then one solution is to use rbind.fill from the plyr package. johannes rara wrote: This is the ideal result (data.frame): result

[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 mailing list

[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

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

a possibility to get limited amount of rows from a dataset when importing data to R. -J 2010/10/19 David Winsemius dwinsem...@comcast.net: On Oct 19, 2010, at 6:47 AM, johannes rara wrote: I'm trying to read SAS datasets on Windows: sashome - C:/Program Files/SAS/SAS 9.1 fold - C:/temp g

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 dwinsem...@comcast.net: On Oct 19, 2010, at 1:31 PM, johannes rara wrote: Thanks David, Yes, my code really works (using

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

2010/10/3 johannes rara johannesr...@gmail.com 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

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

a dbBuildTableDefinition that 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 ggrothendi...@gmail.com wrote: On Sat, Oct 9, 2010 at 9:02 AM, johannes

[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

[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,

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

...@me.com: 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:                  data1             rows= 10

[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

[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] data.table error

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 johannesr...@gmail.com wrote: I'm trying to learn data.table package but I get a following annoying error message

Re: [R] data.table error

) 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 dwinsem...@comcast.net: On Apr 29, 2010, at 3:49 PM, johannes rara wrote: Thanks for the quick response. I tried to install from

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

[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 =

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

at 8:30 AM, johannes rara johannesr...@gmail.com 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 below, but how to create recoding for A, B and C and assing

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

Thanks, you're a lifesaver. -J 2010/3/30 Henrique Dallazuanna www...@gmail.com: 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 johannesr...@gmail.com wrote: Thanks John and Henrique, my

[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 be most

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-06-26 2010-02-15 -J 2010/3/12 johannes rara johannesr...@gmail.com: Hi, I have dates in this kind of format (day, month, year

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

Exactly, thanks! -jrara 2010/1/30 David Winsemius dwinsem...@comcast.net: 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])

[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] 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

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

...@stats.ox.ac.uk: On Sat, 2 Jan 2010, johannes rara wrote: How can I suppress ALL output when running Rscript in Terminal? ~/DocumentsRscript test.r Rscript test.r /dev/null or equivalent in your shell.  But note that Rscript produces no output itself: tystie% touch test.r tystie

[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 is

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

] [1] 05.12.2009 On Sat, Jan 2, 2010 at 10:08 AM, johannes rara johannesr...@gmail.com wrote: 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

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

examples are more generic. I'll have to look gsubfn more closely. -J 2010/1/2 Gabor Grothendieck ggrothendi...@gmail.com: Use regexpr to get the offset into the string and its length and then use substr to pick extract it. On Sat, Jan 2, 2010 at 10:43 AM, johannes rara johannesr...@gmail.com wrote

[R] Rscript: how to suppress all output

How can I suppress ALL output when running Rscript in Terminal? ~/DocumentsRscript 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.1

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

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 dwinsem...@comcast.net: On Dec 1, 2009, at 12:42 AM, johannes rara wrote: Hi, Is there a way

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

$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 johannesr...@gmail.com: I was probably too vague. I meant that the group variable descirbes the group (eg

[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)

[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

[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

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

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 johannesr...@gmail.com: Hello, I'm trying to import a SAS file made using SAS on Unix

[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] 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

[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 gospodar...@rambler.ru: 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 -

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 cbe...@tajo.ucsd.edu: On Mon, 28 Sep 2009, johannes rara wrote

[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

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 cbe...@tajo.ucsd.edu: On Mon, 28 Sep 2009, johannes rara wrote: Hi, I'm trying to use Sweave in my .tex

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 rainer_...@yahoo.de: Dear all, I have received a microarray data set in standard Affymetrix CEL-format consisting of only six samples  without any replicates (same organism

Re: [R] cut and re-factor data

Try e.g. function recode from package car. 2009/9/22 Chris Hane christopher.a.h...@gmail.com: 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

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

This is probably a describe function from Hmisc-package. 2009/9/21 Petr PIKAL petr.pi...@precheza.cz: 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

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 samtpla...@gmail.com: # 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))

[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 the

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

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 to enter  # for other stuff by hand. Best wishes to all, Ted. johannes rara wrote

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

to automate the check for Mac using .Platform$GUI On Sat, Sep 19, 2009 at 12:08 PM, David Winsemius dwinsem...@comcast.net wrote: On Sep 19, 2009, at 11:58 AM, johannes rara wrote: Thanks for the responses. I think that the best way to avoid lots of hassle is that people copy-paste

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 dnort...@gmail.com 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

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

) Also, consider using this function for CI plotting: http://finzi.psych.upenn.edu/R/library/plotrix/html/plotCI.html Best, Tal Galili On Sat, Sep 12, 2009 at 12:00 PM, johannes rara johannesr...@gmail.comwrote: I would like to know if you have any suggestions how to visualize

[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)