[R] Trouble reshaping data to my satisfaction

2016-03-24 Thread Jennifer Sabatier
#I am having a lot of trouble reshaping this data. #This is just an examination of sample size on the margin of error that I did for a colleague. #Nothing complicated. #But restructuring the data...another story #Here's code to produce the dataset: n <- seq(1, 10, by=1) P <- seq(0.1

[R] Locating the starting position of the first number in a string

2015-11-02 Thread Jennifer Sabatier
Hi, So, I've got a vector of strings that look like this: ID <- c("IBBS3_MSM_HN01209","IBBS3_MSM_HN01210","IBBS3_MSM_HN01211", "IBBS3_MSM_HN10212","IBBS3_MSM_HN104213","IBBS3_MSM_HN10214", "IBBS3_MSM_HN44215","IBBS3_MSM_HN44216","IBBS3_MSM_HN44217", "IBBS3_MSM_HN44218","IBBS3_MSM_HN44219","IBBS3_

[R] More RGoogleDocs - R1C1 reference style

2014-11-24 Thread Jennifer Sabatier
Thank you all for helping grab data off Google Docs. Now I have another problem. When I pull the data all the formulas come into R as R1C1 reference style, while in Google Docs they're A1 reference style. As a result, the formulas are strings in the cells, rather than values: =AND((R[0]C[34]=1

Re: [R] Saving Google worksheets with common prefix

2014-11-21 Thread Jennifer Sabatier
Upload your own data and play, if you like. On Fri, Nov 21, 2014 at 11:02 AM, Jennifer Sabatier < plessthanpointohf...@gmail.com> wrote: > > On Fri, Nov 21, 2014 at 10:36 AM, Henrik Bengtsson > wrote: > >> print(ts2$i) > > > > You're right. It&#x

Re: [R] Saving Google worksheets with common prefix

2014-11-21 Thread Jennifer Sabatier
On Fri, Nov 21, 2014 at 10:36 AM, Henrik Bengtsson wrote: > print(ts2$i) You're right. It's not doing what I think it's supposed to be doing. The print(ts2$i) gives NULL: [1] "Cash Flows211" NULL [1] "Cash Flows211 - 2014-11-21.csv" 7: getURL(sheet@cellsfeed, curl = getCurlCon(con), follow

Re: [R] Saving Google worksheets with common prefix

2014-11-21 Thread Jennifer Sabatier
Anyone can help? On Thu, Nov 20, 2014 at 6:44 PM, Jennifer Sabatier < plessthanpointohf...@gmail.com> wrote: > Hi R-Help, > > So, I will try to provide a reproducible example...I basically made a > dummy spreadsheet that contains the same number of tabs as the spreads

[R] Saving Google worksheets with common prefix

2014-11-20 Thread Jennifer Sabatier
Hi R-Help, So, I will try to provide a reproducible example...I basically made a dummy spreadsheet that contains the same number of tabs as the spreadsheet I am really interested in. The data on that spreadsheet is really sensitive so I couldn't use it. Anyway, here are the various sheets in the

[R] Within ID variable delete all rows after reaching a specific value

2014-04-25 Thread Jennifer Sabatier
So, I know that's a confusing Subject header. Here's similar data: tmp <- data.frame(matrix( c(rbinom(1000, 1, .03), array(1:127, c(1000,1)), array(format(seq(ISOdate(1990,1,1), by='month', length=56), format='%d.%m.%Y')

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
Hah - I guess I didn't mean I understood it in full as I expect I will run into it again without anticipating it. But, now that I know the "old adage" I will look there first when I run into a problem. Also, I used the square root of machine precision instead - thanks for that, too. Thank you, t

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
might want to ensure that it is that type. > Otherwise, you might want to use Michael's suggestion of using > abs(... - 1) < 1e-05. > > Peter Ehlers > > > On 2012-08-24 14:56, Jennifer Sabatier wrote: >> >> Hi Michael, >> >> Thanks for letting me kno

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
would just put my data up. I will check out the R FAQ you mentioned. Thanks, again, Jen On Fri, Aug 24, 2012 at 5:50 PM, R. Michael Weylandt wrote: > On Fri, Aug 24, 2012 at 4:46 PM, Jennifer Sabatier > wrote: >> Hi Michael, >> >> No, I never use attach(), exactly

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
24-08-2012 22:46, Jennifer Sabatier escreveu: > >> Hi Michael, >> >> No, I never use attach(), exactly for the reasons you state. To do >> due diligence I did a search of code for the function and it didn't >> come up (I would have been shocked because I never us it!

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
t now. Thanks, Jen On Fri, Aug 24, 2012 at 5:38 PM, R. Michael Weylandt wrote: > Off the wall / wild guess, do you use attach() frequently? Not > entirely sure how it would come up, but it tends to make weird errors > like this occur. > > M > > On Fri, Aug 24, 2012 at 4:36 PM,

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
Hi Rui, Thanks so much for responding but I think with my HTML problem the vn data you made must not be the same. I tried running your code on the data (I uploaded a copy) and I got the same thing I had before. Jen On Fri, Aug 24, 2012 at 5:28 PM, Rui Barradas wrote: > > 165114 1 0 0 0 0 417

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
BTW - no one else who has replied to this topic was snobby or unfriendly and I thank you very much for trying to help me. It's just Bert is not the first to respond to my request for help as such. As someone looking forward to becoming an advanced R programmer in my statistical work it is discour

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
is just a subset of >300 observations. The error seems to happen without a pattern I can discern. I am assuming I am doing something wrong. Thanks, Jen On Fri, Aug 24, 2012 at 5:17 PM, Peter Ehlers wrote: > On 2012-08-24 13:22, Jennifer Sabatier wrote: >> >> Hi R-Helpers

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
t; > If Michael is wrong, then the above homily should be amended to: > If you have not already done so, read the FAQ's and An Introduction to > R. You will save yourself -- and us -- much time and effort by doing > so. > > Thus endeth the lesson. > > -- Bert >

Re: [R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
24, 2012 at 3:22 PM, Jennifer Sabatier > wrote: > > Hi R-Helpers, > > > > I don't think I need to post a dataset for this question but if I do, I > > can. Anyway, I am having a lot of trouble with the ifelse command. > > > You probably should have: dput(

[R] ifelse problem - bug or operator error

2012-08-24 Thread Jennifer Sabatier
Hi R-Helpers, I don't think I need to post a dataset for this question but if I do, I can. Anyway, I am having a lot of trouble with the ifelse command. Here is my code: vn$PM.DIST_flag <- ifelse( (vn$PM.EXP > 0.0) & (vn$PM.DIST.TOT != 1.0), 1, 0 ) And here is my output that doesn't make ANY

Re: [R] Error using ddply inside user-defined function

2012-08-08 Thread Jennifer Sabatier
ode. Thanks, again, Jen On Tue, Aug 7, 2012 at 4:53 PM, Jennifer Sabatier < plessthanpointohf...@gmail.com> wrote: > Hi All, > > I *think* it's ddply because the function recognizes vr1, etc, in other > parts of the function. > > Here's some code: &g

[R] Error using ddply inside user-defined function

2012-08-07 Thread Jennifer Sabatier
Hi All, I *think* it's ddply because the function recognizes vr1, etc, in other parts of the function. Here's some code: # create dataset PROV.PM.FBCTS <- c(0.00 ,0.00, 33205.19, 25994.56, 23351.37, 26959.56 ,27632.58, 26076.24, 0.00, 0.00 , 6741.42, 18665.09 ,18129.59 ,21468.39 ,21294.60 ,

Re: [R] Help with NaN when 0 divided by 0

2012-08-01 Thread Jennifer Sabatier
dy for the once or twice a year I do this. Jen On Tue, Jul 31, 2012 at 5:19 PM, David Winsemius wrote: > > On Jul 31, 2012, at 1:23 PM, Jennifer Sabatier wrote: > > Hi All, >> >> >> >> I have some data where I am doing fairly simple calculations, nothing mor

[R] Help with NaN when 0 divided by 0

2012-07-31 Thread Jennifer Sabatier
Hi All, I have some data where I am doing fairly simple calculations, nothing more than adding, subtracting, multiplying and dividing. I’m running into a problem when I divide one variable by another and when they’re both 0 I get NaN. I realize that if you divide a non-zero by 0 then you get

Re: [R] Packages/functions for competing risk analysis

2012-04-24 Thread Jennifer Sabatier
n. I will be happy to do so. Best, Jen On Mon, Feb 27, 2012 at 11:09 PM, Jennifer Sabatier < plessthanpointohf...@gmail.com> wrote: > Hi Rs, > > I am analyzing a time to event dataset with several competing risks. > > 0 = Active by end of study > 1 = Stopped treatment t

[R] Packages/functions for competing risk analysis

2012-02-27 Thread Jennifer Sabatier
Hi Rs, I am analyzing a time to event dataset with several competing risks. 0 = Active by end of study 1 = Stopped treatment to start another treatment 2 = Lost 3 = Dead My event of interest in Lost to Followup but starting a different treatment and dying are competing risks. All 1,2,3 events a

Re: [R] decimal seperator

2010-07-23 Thread Jennifer Sabatier
Wow, that's even better! Thanks to you both. I know both options will come in handy! Jen On Fri, Jul 23, 2010 at 11:58 AM, David Winsemius wrote: > > On Jul 23, 2010, at 11:32 AM, Jennifer Sabatier wrote: > > Hi R-List, >> >> I have a question regarding R-lan

Re: [R] decimal seperator

2010-07-23 Thread Jennifer Sabatier
> HTH, > Alain > > > > > On 23-Jul-10 17:32, Jennifer Sabatier wrote: > >> Hi R-List, >> >> I have a question regarding R-language formats, I think. I am producing a >> series of graphs (using plot, barplot, barchart, and bwplot, using either >>

[R] decimal seperator

2010-07-23 Thread Jennifer Sabatier
Hi R-List, I have a question regarding R-language formats, I think. I am producing a series of graphs (using plot, barplot, barchart, and bwplot, using either text or mtext to place values on the graphs) and tables for a Francophone country. In fact, I have already done so. However, while they