[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

[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 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 a record has a \

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

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

[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

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-frame-in-dependence-of-an-ID-tp4687745p4687767

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 33688812

[R] find max value in different columns

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-in-different-columns

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

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 Sent from the R help mailing list

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

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

[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-tp4682118.html Sent from the R help mailing

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] 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] kill colnames Matrix

with plotbase-t(plotbase). Maybe you can help me. Thanks Mat -- View this message in context: http://r.789695.n4.nabble.com/kill-colnames-Matrix-tp4677726.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list

[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

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

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] 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] 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 -- View this message in context: http://r.789695

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 list archive at Nabble.com

[R] match a complete data.frame

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/mailman

[R] export only if data is available

=.) 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 only an Export, when there is data in the data.frame? Thanks Mat -- View this message in context: http

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

[R] substring from behind

: 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 at Nabble.com

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

[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] eliminate double entries in data.frame

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 archive

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

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

[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

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

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

is 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: if1,2 - RED, if 1,2 - GREEN Thanks. Mat

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=),sep=:) #

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

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 value? Thanks. Mat -- View this message in context: http://r.789695.n4.nabble.com/Colors

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 values of more and less than 1,25? Thanks. Mat -- View this message in context

[R] comma as a seperator to numeric

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/mailman/listinfo

[R] filter data.frame with a vector

, with the 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 Nabble.com

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] Sum Column in data.frame for Excel-Export

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-in-data-frame

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

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 Stiglermatthieu.stig...@gmail.com: Jim Thanks for your feedback! The problem is that the people those responsible for layout are us... We are doing the book in

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] #line

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)

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

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 synaptic

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

a é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, matmatthieu.stig...@gmail.com wrote: Hi I have a few problems with tail/head when applied to multiple time series. I'm not sure as whether I

[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

[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] 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 2010 08:32:38 +0100 From

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

) 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] Lattice

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

is the best way to determine the two best teams to play for the championship - a far from perfect scenario. Yet another debate of the use of Super Crunching if I may borrow from Ian Ayres. Open to any ideas/opinions. Cheers, -Mat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

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

. The 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