[R] create new column to combine 2 data.frames

regards. Mat -- View this message in context: http://r.789695.n4.nabble.com/create-new-column-to-combine-2-data-frames-tp4674963.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch

Re: [R] create new column to combine 2 data.frames

Thanks first. that doesn't look bad. But if have a equal ID in dat2, the days are no longer correct. the correct data.frame has to look like this one: ID Name Management Training 1 1 Jack 13 2 2 John 10 3 3 Jill 04 not this one: ID Name

Re: [R] create new column to combine 2 data.frames

thanks. Works perfectly you made my day :-) -- View this message in context: http://r.789695.n4.nabble.com/create-new-column-to-combine-2-data-frames-tp4674963p4674994.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-projec

[R] Convert negativ number to 0

Hallo together, i have a data.frame like this one. A 13 2-2 31 and now i want to convert the negative number to 0. A 13 20 31 How can i do this? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/Convert-negativ-number-to-0

Re: [R] Convert negativ number to 0

works perfectly. Thank you :-) -- View this message in context: http://r.789695.n4.nabble.com/Convert-negativ-number-to-0-tp4653529p4653532.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://sta

[R] round 2.3 to 2.5 and 2.2 to 2.0

Hello together, i want to round some numbers in my data.frame. How can i round a number to values like 0.5; 1.0; 1.5; 2.0; etc. It should look like this one before 2.2 ; 2.3; 2.26; 1.11 after 2.0; 2.5; 2.5; 1.0 thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com

Re: [R] round 2.3 to 2.5 and 2.2 to 2.0

thx, works perfektly :-) -- View this message in context: http://r.789695.n4.nabble.com/round-2-3-to-2-5-and-2-2-to-2-0-tp4654813p4654829.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.

[R] How can i keep only latest entries?

want a new data.frame, who show me only the newest entries according to the No. The solution look like this one: No. Datelast change 1 1 2012-11-05 final 2 2 2013-01-17 final can anyone help me? thanks. Mat -- View this message in context: http://r.789695.n4

[R] eliminate double entries in data.frame

e: 1 2 A Albert1800 B Jack2000 C Mike 2200 How can i eliminate this double entries? Thanks. Mat? -- View this message in context: http://r.789695.n4.nabble.com/eliminate-double-entries-in-data-frame-tp4655956.html Sent from the R help mailing list

Re: [R] eliminate double entries in data.frame

thx, works perfectly :-) Mat -- View this message in context: http://r.789695.n4.nabble.com/eliminate-double-entries-in-data-frame-tp4655956p4655963.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list

Re: [R] Change rows and columns

thx, that worked perfekt, but is there any way to convert my Number 1 row # 123 up as column description? -- View this message in context: http://r.789695.n4.nabble.com/Change-rows-and-columns-tp4656965p4656969.html Sent from the R help mailing list archive at Nabble.com.

[R] Change rows and columns

. 1 2 3 1st round 1:22:30:0 2nd round 2:2 1:01:1 can you help me? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/Change-rows-and-columns-tp4656965.html Sent from the R help mailing list archive at Nabble.com

[R] substring from behind

s one. I have: Mercedes_02352 Audi_03555 and now i want to filter this data.frame to 235 355 can you help me? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/substring-from-behind-tp4657029.html Sent from the R help mailing list archive

[R] Filter according to the latest data

111 final2013-01-12 is there any way to filter my data.frame to the latest data, perhabs "max"? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/Filter-according-to-the-latest-data-tp4657248.html Sent from the R help mailing li

[R] merge 2 data.frames

can i do this. Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/merge-2-data-frames-tp4657702.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman

[R] export only if data is available

;,sep=""), "Orders",sep="/"),"txt",sep=".") write.xls( Orders,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) if(dim(CO.PHB)[1]>0){ write.table( CO.PHB,pfad,row.names=FALSE,sep=" | ") }} how should my code look like, if i want onl

Re: [R] match a complete data.frame

i found a way :-) data<-merge(data,project,by.x="PJ_ID",by.y="PROJ_ID",all.x=TRUE) perhaps this can help someone Mat -- View this message in context: http://r.789695.n4.nabble.com/match-a-complete-data-frame-tp4658250p4658252.html Sent from the R help mailing lis

[R] match a complete data.frame

t very productive Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-a-complete-data-frame-tp4658250.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/m

[R] match in dependence of 2 columns

Value A 33 Evo B 1 Mer 80 C 1 Pold thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405.html

Re: [R] match in dependence of 2 columns

thank you, this code works: library(plyr) join(dat1,dat2,by=c("cu.nr.","name"),type="right") but my dat2 frame has a lot of columns, which i don't want to match. How can i say, that only the column "value" should be match to dat1 ? Thank you. Mat

[R] match a task No. to a few person-IDs

49396 1140 B49396 15013 perhabs anyone can help me. Thank you Mat -- View this message in context: http://r.789695.n4.nabble.com/match-a-task-No-to-a-few-person-IDs-tp4658646.html Sent from the R help mailing list archive at Nabble.com

[R] create bar chart with different totals in a bar

. So the value of one column has to have a own color in dependence of the "Cat". Perhabs anyone have an idea? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/create-bar-chart-with-different-totals-in-a-bar-tp4660703.html Sent from the R help mailing list

Re: [R] create bar chart with different totals in a bar

if i can sort my list as follows, i can create the bar chart. But how can i sort my list from: [,1] [,2] [,3] [,4] abnr2 11425 11425 11555 11888 TIME 21 1

[R] substring if a record has a "\"

w can i do this? The solution look like this one: 1 A Marius Muller - B Rockwood C Microlog Services D Firefox Services Thank you. Best regards. Mat. -- View this message in context: http://r.789695.n4.nabble.com/substring-if-a-record-has-a-tp4689857.html Sent from the R help ma

Re: [R] substring if a record has a "\"

works perfect, thank you :-) -- View this message in context: http://r.789695.n4.nabble.com/substring-if-a-record-has-a-n-tp4689857p4689860.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://sta

[R] create new rows with 0, if nessecary

hello togehter, i have a little problem, i have frames like this two: Cat Hours A101 15 B103 10 Cat Hours A103 16 B106 11 I need to convert this 2 data.frames into the following equal structure: Cat Hours A101 B

[R] substring if value starts with a character

3 4700 4 3500 5 3800 Thanks. Best regards. Mat -- View this message in context: http://r.789695.n4.nabble.com/substring-if-value-starts-with-a-character-tp4690823.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r

[R] create line chart from data.frame

, to create a line chart, with the years (Y10_11, etc.) in the X-axis and the Categorie in the Y-axis. The lines should be created with the numbers for each categorie. So in each plot there should be 6 lines in dependence of the value for each year. Thank you. Best regards. Mat -- View this

[R] Sum Column in data.frame for Excel-Export

] 130 But how can i get this result under my column for the Excel Export? Now my Excel Export looks like this one. PT_PROG 23 100 7 and now i want under this digets the sum of this column (130)? Thanks for your help. Mat -- View this message in context: http://r.789695.n4.nabble.com/Sum-Column

[R] comma as a seperator to numeric

our help. Mat -- View this message in context: http://r.789695.n4.nabble.com/comma-as-a-seperator-to-numeric-tp4651090.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mail

[R] filter data.frame with a vector

Numbers in my vector. this one doens't work: data_export_final<-data_export[(data_export$KD_NR==Top10),] Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/filter-data-frame-with-a-vector-tp4651098.html Sent from the R help mailing list archive at Na

Re: [R] comma as a seperator to numeric

gsub() works perfectly, thank you very much. Mat -- View this message in context: http://r.789695.n4.nabble.com/comma-as-a-seperator-to-numeric-tp4651090p4651106.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org

[R] Colors according to value (Excel-Export)

quot; ? I know how to colour a complete row, like this task: U3R <- sh$Range(zellen_blue) U3RF <- U3R$Font() U3RF[["Bold"]] <- TRUE U3RF[["Size"]] <- "10" U3RF[["Color"]] <-"-10526881" but how can i color numbers accordung to her v

Re: [R] Colors according to value (Excel-Export)

i tried it this way, but this won't help. O3R <- sh$PT_IST(zellen_other) O3RF <- O3R$Font() O3RF[["Bold"]] <- TRUE O3RF[["Size"]] <- "10" O3RF[["Color"]] <-"5287936" perhabs you can help me, how i can differenz between the val

Re: [R] Colors according to value (Excel-Export)

generated from the data above and is ok. The Excel sheet was generated every day. And the numbers can change from day to day. I know how to color the whole row, but i don't know how to color the number "Difference --> 1,15" according to her value, like: if>1,2 <- RED, if <

Re: [R] Colors according to value (Excel-Export)

i tried it this way. With this Code the Row "Difference" gets complete green. But i want the color change to red according to a different value. highlight_other<-out.ex1[(out.ex1$AUFTR_NAME=="Difference"),]$LFD2 zellen_other<-paste(paste("A",highlight_other,sep=""),paste("S",highlight_other,sep=""

[R] Count cell Count by her frequency

1 How can i do this? Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/Count-cell-Count-by-her-frequency-tp4652650.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list

Re: [R] Count cell Count by her frequency

Thank you all, a few ideas worked perfectly for me. I take "with(dat1,aggregate(B,by=list(A=A),length))" for my task. Have a nice day. Mat -- View this message in context: http://r.789695.n4.nabble.com/Count-cell-Count-by-her-frequency-tp4652650p4652678.html Sent from the R he

[R] calculate an value in dependence of another column

Hello together, i have a little problem, to create a new column, in a data.frame. I know i can calculate one column with as a example 2 like this: ORDER$WEIGHT <- ORDER$VALUE * 2 But how can i create the ORDER$WEIGHT with different numbers, like this one. I have a data.frame like this one: ORDE

Re: [R] calculate an value in dependence of another column

thanks a lot, works perfectly -- View this message in context: http://r.789695.n4.nabble.com/calculate-an-value-in-dependence-of-another-column-tp4683727p4683732.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org m

[R] combine 2 data.frames in dependence of the ID

e row. The earlier date value should stand under "FIRST", the newer date under "SECOND". Maybe anyone can help me, how i can do this. Best regards. Mat -- View this message in context: http://r.789695.n4.nabble.com/combine-2-data-frames-in-dependence-of-the-ID-tp4685781.html Sen

Re: [R] combine 2 data.frames in dependence of the ID

thanks for the help up to here. A little problem remains. I have different "ABNR", if i try it with another ABNR, the Column extend for each ABNR, it should start with "FIRST" again. dat1 <- read.table(text="FS_ID ABNR 932733688812 11391 33688812 11392 33688812 11388 33688812 11390 3368

[R] find max value in different columns

ne: IDONE TWO THREEMAX 1 2 57 7 2 6 NA NA 6 3 5 7NA 7 4 1 NA NA 1 how can i do this? thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/find-max-value-

Re: [R] find max value in different columns

Thanks for the help. problem is solved. :-) -- View this message in context: http://r.789695.n4.nabble.com/find-max-value-in-different-columns-tp4685905p4685912.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org ma

[R] match from a data.frame in dependence of an ID

Hello togehter, i have a litte problem. I have an output data.frame which look like this one: ID 1 10 2 11 3 12 Now I have another data.frame with more than one line for each ID: IDGroupValue 1 10110 2 10220 3 103

Re: [R] match from a data.frame in dependence of an ID

df2$ID"? My solution should like this one, that i can convert into a data.frame ID 1 2 3 4 5 110 10 20 30 40 50 211 0 0 60 70 0 312 0 0 0 80 0 Thank you Mat -- View this message in context: http://r.789695.n4.nabble.com/match-from-a-data-fr

[R] kill colnames Matrix

80.58285 5 2013-02 1013.72028 6 2013-03 939.63030 7 2013-04 977.17073 8 2013-050.0 9 2013-060.0 10 2013-07 1047.56938 11 2013-08 225.44031 12 2013-09 667.91489 13 2013-100.0 i converted this data.frame with plotbase<-t(plotbas

[R] match values in dependence of ID and Date

-10-0415 32013-10-0110 the result should be this one: IDName First SecondThird 1 Andy10 15 2 John 7 10 15 3 Amy 10 maybe you can help me, to do this? Thank you. Mat -- View this message in context: http://r.789695.n4

[R] filter a data.frame

ee i tried it like this one: out1<-out[(out$No==no.ind),] in no.ind i have the 2 numbers: c("2","3") but this doesn't work. Maybe anyone can help me. Thank you. Mat -- View this message in context: http://r.789695.n4.nabble.com/filter-a-data-frame-tp46821

Re: [R] filter a data.frame

thanks together, out1 <- out[(out$No %in% no.ind),] works perfectly :-) -- View this message in context: http://r.789695.n4.nabble.com/filter-a-data-frame-tp4682118p4682131.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r

Re: [R] R-help Digest, Vol 89, Issue 10

Raghu Those packages are still not on CRAN. You can download the current version from R-forge: *|install.packages("blotter", repos="http://R-Forge.R-project.org";) Mat |* Le 10. 07. 10 12:00, r-help-requ...@r-project.org a écrit : > Message: 137 > Date: Sat, 10 Jul

Re: [R] [R-sig-Debian] Debian ?Ubuntu version of latest R using synaptic in Ubuntu 10.10

Ajay Please avoid cross-posting on two lists. Continue this thread only on thes-ig-debian list. You can't update packages from within R? Did you try to start R with sudo permissions?: sudo R Hope this helps Mat Le 22. 01. 11 07:50, Ajay Ohri a écrit : Dear List I use synapt

Re: [R] error with source(): invalid 'times' value

Hi Well this is the output of str(dep) on a small example: str(dep) chr [1:8] "###" ... Browse[1]> dep [1] "###" [2] "### chunk number 1:" [3] "###" [4]

Re: [R] error with source(): invalid 'times' value

indeed this makes the trick! quite strange... is this a known bug/issue? thanks! Matthieu Le 24. 01. 11 19:48, William Dunlap a écrit : Put a space after the # in the line #line 516 to avoid the problem. A similar problem also appears in parse(). > parse(text="#line 102\nlog(pi)\n") E

Re: [R] error with source(): invalid 'times' value

Le 24. 01. 11 20:43, Duncan Murdoch a écrit : On 11-01-24 12:07 PM, Matthieu Stigler wrote: hi I am seeing a strange behavior I can't understand... doing: > source("/tmp/RFile.r",echo=TRUE) Error in rep.int(c(prompt.echo, continue.echo), c(leading, length(dep) - : invalid 'times' value

[R] tail.matrix returns matrix, while tail.mts return vector

Hi I have a few problems with tail/head when applied to multiple time series. I'm not sure as whether I did not understand the function or whether it correspond to an unexpected behavior. When head(a,n) is applied on data.frame or matrix, it returns a data-frame or matrix with first n obs of

Re: [R] tail.matrix returns matrix, while tail.mts return vector

écrit : Hi Mat, You might be able to use the matrix method to get what you want. head.matrix(EuStockMarkets) -Ista On Sat, Sep 4, 2010 at 1:15 PM, mat wrote: Hi I have a few problems with tail/head when applied to multiple time series. I'm not sure as whether I did not understan

Re: [R] R plots pdf() does not allow spotcolors?

Barry, thanks a lot for checking for this!! Find below answers. Le 13. 04. 11 18:26, Barry Rowlingson a écrit : 2011/4/13 Matthieu Stigler: Jim Thanks for your feedback! The problem is that the people "those responsible for layout" are us... We are doing the book in Latex, and till now did not

Re: [R] Axes Alignment Problem for Multiple Plots

Ok, I can replicate your problem, with following code: dat <- 1:10 barplot(dat, beside=TRUE,ylim=c(0,100)); par()$usr; par(new=T); plot(dat, ylim=c(0,100), type="l"); par()$usr; So it looks like even if you specify yourself ylim, the resulting effective ylim (usr[3:4] ) will be d

[R] ask for help about netcdf

array or vector by himself, then the r tools use the array or vector to calculate? I am very looking forward to your reply thanks very much sincerely mat chueng [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https

Re: [R] Lattice + Word: Changing .wmf files to .pdf files

your case) which looked quite well. At least this seemed to work out all right on my Windows XP PC. Hope this helps, -Mat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Prager Sent: Thursday, June 05, 2008 9:38 AM To: [EMAIL PROTECTED] Subject: Re: [

[R] Position Openings at the U.S. Food and Drug Administration

formal job announcement is available at www.usajobs.gov - enter FDA-09-07-109 in the search box. This announcement contains details about the position, qualifications, and information about applying. If you have any other questions, I would be happy to assist in anyway. Thanks, -Mat

Re: [R] Appropriate measure of correlation with'zero-inflated' data?

he computers. 2) USC and OK St. and GA: Both have lower Cavg scores, but high human polls (Harris and USA Today) which tend to coincide w/ the preseason ranking. 3) As for bias, #2 seems to show some bias in the human polls, though I would not say the computer ranking is not w/o flaw. Basical