similar to: merge table rows (\multirow)

Hi Experts, I would like to present time series data in meaningful way in building some graphics. I've tried: (1) plot(ts(mbaye3)) and (2) plot(ts(mbaye3), start=1990) But I always get this error-message: Fehler [error] in plotts(x = x, y = y, plot.type = plot.type, xy.labels = xy.labels, : cannot plot more than 10 series as "multiple" my data: mbaye3

I want to find the last record for each person_id in a data frame (from a SQL database) ordered by date. Is there a better way than this for loop? for (i in 2:length(history[,1])) { if (history[i, "person_id"] == history[i - 1, "person_id"]) history[i, "order"] = history[i - 1, "order"] + 1 # same person else history[i,

Have the counter function in R ? if we use the software SAS /*** SAS Code **************************/ data tmp(drop= i); retain seed x 0; do i = 1 to 5; call ranuni(seed,x); output; end; run; data new; counter=_n_; ***** this keyword _n_ ****; set tmp; run; /* _n_ (Automatic variables) are created automatically by the DATA step or by DATA step statements. */ /*** Output

Hi all, I am new to R-project I have a problem when when ever I am going to append a row in a *.csv file that is in R-project I created one dataframe and I saved it in "res.csv" and again I got some results in dataframe with same column names and i tried to append in a new row of same "res.csv" file but its appending again with columnnaes like first time when i created

Dear Sirs: I've been working with several variables in a dataframe that serve as part of a calculation that I need to perform in a different way depending on its value. Let me explain: The main dataframe is called llmcc llmcc : 'data.frame': 283 obs. of 11 variables: $ Area : num 308.8 105.6 51.4 51.4 52.9 ... $ mFondo : num 30.1 10 10.2 10.2 40.4 ... $ mFachada :

Hi: I have a dataset and need to interpolate for missing days. In Excel I either average from sampled days from above and below the missing days or use the TREND function to make up for the missing values. I have been reading about na.approx, is this function similar to the TREND function? Which is the best recommendable way to make up for missing data? Here's my dataset: weeks 17,18,26 and 46

Hello group Im trying to plot 3d with scatterplot packages, i got error say " length(color) must be equal length(x) or 1 " may data has dimensions (lon,lat,lev,time) ,the time in month i want to calculate the monthly mean for the time how can i make that , is there any function doing that Thanks a lot ##load rgl package library(rgl) library(fields) library(ncdf)

Hi all, I have a series of measurements made over different types of road surfaces and capacity that I want to summarize in tables via LaTeX. Ideally I'd like a table similar to this ( http://www.andy-roberts.net/misc/latex/tutorial4/multirow.png ) with mean/SD of the measurement broken down by road type (both surface and capacity). Ideally it would be extensible so that when I add layers

Hi to all. First of all exchuse for my bad english I try to use Ajax.InPlaceEditor with a textarea: ################## new Ajax.InPlaceEditor($(''ipblock''), ''tools/admin_save.php'', { ajaxOptions: {method: ''get''}, rows:10, cols:20, callback: function(form, value) { return ''op=ipblock&value='' + value},

Hello, I'm working with asterisk 1.6. And I have success using func_odbc with one row query results (SELECT source,destination from cc WHERE ... ): exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(ARRAY(NUMBER,REALNUMBER1,REALNUMBER2,STATUSAS)=${ODBC_GETVARIABLES(${NUMERIS})}) exten => s,n,Verbose(1| ${NUMERIS}, ${REALNUMBER1} ${REALNUMBER1},

Suppose I have a Master.Rnw file that looks something like this: \documentclass[12pt]{mypaper} \usepackage[margin=1in]{geometry} \usepackage{setspace} \usepackage{url} \usepackage{indentfirst} \usepackage{fancyhdr} \usepackage{Sweave} \pagestyle{fancy} \lhead{sonographic rectal diameter and ADHD} \rhead{ } \usepackage{abbrevs} %\usepackage{natbib} %\usepackage{apacite}

Hello, Now I'm testing func_odbc and hash. My configurations are: func_odbc.conf [GETNUMBER] dsn=sqlserver ;mode=multirow ;rowlimit=10 readsql=SELECT number,real_number1,real_number2,status FROM ivr.dbo.numbers WHERE number=${SQL_ESC(${ARG1})} extensions.conf exten => s,1,Ringing exten => s,n,Wait(4) exten => s,n,Answer exten => s,n,Set(NUMERIS=37037210602) exten =>

Hello, Does asterisk func odbc support multi query? I'm executing stored procedure which returns two tables. With tsql command I can see both tables. But asterisk only shows the first. My database is MSSQL. Maybe there is workaround... Thanks -- Best Regards, Giedrius -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi All Anyone know how to do include files with func_odbc.conf? I now have several pages of functions in my func_odbc.conf and it is getting harder to maintain it. I would like to break them up into files by category. The standard method of using the #include does not seem to work . Ideas are appreciated. Bryant -------------- next part -------------- An HTML attachment was

All, Thank you in advance for any help. I have a customer in need of a conferencing system. A requirement is for users to each have their own PIN for the same bridge. So, I put the list of users, PINs bridges into a MYSQL DB and used an ODBC connector to parse the table. Asterisk is connected and reads the rows as expected. The problem is that if a user enters a PIN that is NOT in the table,

does anyone know to rezize a table produzed by xtable? The size of my table is too big and I would like to resize it like using resizebox but it gives an erros when I try using it using it its fine \SweaveOpts{echo=false} <<results=tex>>= xtable(stats0,caption='Número de transacções dos artigos frequentes e infrequentes',label='tab:INEStats') @ but the size is too

Hello List, While translating documents in markdown, I've noticed that it is often necessary to continue table cell text on the following line, especially when limited to a narrow column, and especially in table headers. Unfortunately, this is impossible with the existing table syntax, which interprets each new line as a new table row. I see that David Wheeler proposed a syntax for a text

This is my first excursion into using reshape2 and I want to ensure that the melt() function call is syntactically correct. The unmodifed data frame is organized this way: head(tds.anal) site sampdate param quant 1 UDS-O 2006-12-06 TDS 10800 4 STC-FS 1996-06-14 Cond 280 7 UDS-O 2007-10-04 Mg 1620 9 UDS-O 2007-10-04 SO4 7580 19 JCM-10B 2007-06-21 Ca 79 20

The data set (called 'chemdata') has 6 columns (4 factors, 1 date, 1 numeric) and I need to create subsets for each of one of the factors ('stream'). This has worked flawlessly for all but two streams which were created yesterday. The command I use to create the subsets is like this: > rnchH <- subset(chemdata, stream == 'RanchSpgsH', select = c(site, sampdate,

I've successfully reformatted data frames from long to wide with reshape2, but this time I'm getting errors that I want to understand and resolve. Here's the data frame structure and the results of the melt() and dcast() functions: str(waterchem) 'data.frame': 128412 obs. of 8 variables: $ site : Factor w/ 64 levels "D-1","D-2","D-3",..: 1 1