similar to: Adding new column variable to a existing spreadsheet

Displaying 20 results from an estimated 8000 matches similar to: "Adding new column variable to a existing spreadsheet"

2010 Apr 22
2
time difference
Hi, Does anyone know how to take a time difference when the format of the time is as 13:22:23.586? I am trying to take the difference of time between stock transactions and need to keep the three decimal places for seconds. I have tried *diff(strptime(x, "%H:%M:%S.000))*, but apperantly that doesn't work. Carol Gao [[alternative HTML version deleted]]
2013 Apr 11
3
odfWeave: Some questions about potential formatting options
Hello All, Learning to use the odfWeave package. I really like the package. It has good documentation, makes some very nice looking tables, and seems to have lots of options for customizing output. There are a few things I'd like to do that don't seem to be covered in the documentation though. So I'm not sure if they're possible or not. Here's a list of some things I'd
2010 Apr 29
1
time zone convert
Hi there, I've got a column vector in a csv file as follows, and I need to add 11 hours to each of them. Is there a way that I can do it? (The actual file size is much bigger than this.) Time "01-DEC-2008 00:00:28.611" "01-DEC-2008 00:00:43.155" "01-DEC-2008 00:01:06.677" "01-DEC-2008 00:01:06.677" "01-DEC-2008 00:01:06.677" "01-DEC-2008
2010 May 07
2
problem in using optim
Dear R users, When I was trying to use the function *optim* to get the MLEs, quite a few warning messages showed up as below: Warning in log(psi * lam) : NaNs produced I am just wondering what does this mean? Was it something wrong with my likelihood function or was it sth wrong with the data? Thanks in advance. Carol Gao [[alternative HTML version deleted]]
2010 May 24
2
How to set parameters constraints in a function?
Dear R list, I have a function specifying my log-likelihood, and now I need to set the constraint that *alpha > kappa*, could anyone help me with setting this in my function? the function is defined as follows: mll <- function(param){ n <- length(x) psi <- numeric(n) psi[1] <- 1.0 a0 <- exp(param[1]); a1 <-exp(param[2]); b1 <- exp(param[3]); *alpha *<-
2010 May 01
1
select subset of data according to date range
Dear R lists, Would anyone help me with setting data frames according to the date? X.RIC Date.G. Time.G. GMT.Offset Type Price Volume Time 1 QAN.AX 01-DEC-2008 00:00:28.611 11 Trade 2.28 105 2008-12-01 11:00:28.611 2 QAN.AX 01-DEC-2008 00:00:43.155 11 Trade 2.28 250 2008-12-01 11:00:43.155 3 QAN.AX 01-DEC-2008 00:01:06.677 11
2009 Nov 21
2
Fw: Re: title problem
It seems that there is a problem in displaying subtitle in general, independently from multi-plot display. when I do plot (c(1,2,3), c(9,8,7), type = "l") title(main = "Main title", sub ="Sub title",cex.main=2, cex.sub = 2) subtitle doesn't get displayed > --- On Sat, 11/21/09, David Winsemius <dwinsemius at comcast.net> > wrote: >
2001 Nov 20
1
using samba to serve the whole tree of home directories
I'm trying to use samba to serve a number of home directories to other samba Linux clients on my network. ie. I have a set of client machines that want to use the /home directory that my samba server will provide I thought I could set up a share that goes something like this [homedirs] path = /home writable = true On a client machine, I smbmount //myserver/homedirs
2018 May 10
3
Fill down a new column in data frame with a number
Hi, I am a begginer in R programming. I am traying to create a a column in my data frame filled down with a number. > df$newcolumn <- number How can I do it? I am considering use rep() but in this case it is necessary know the number of rows in each data base that I have and I would like to do it in a faster ( and more elegant) way. TKs [[alternative HTML version deleted]]
2008 Nov 04
1
Is SIPPEER curcalls working for you ?
Hi, In this thread http://lists.digium.com/pipermail/asterisk-users/2008-October/219592.html , I wondered whether SIPPEER curcalls was working. I could test this anew today. Here are my findings : Alice, Bob and Carol ar all using SIP Phones. Whenever Alice is calling Bob, - if Carol is calling Alice, SIPPEER(Alice:curcalls) equals 0 - if Carol is calling Bob, SIPPEER(Bob:curcalls) equals 1
2006 Jun 09
4
HTML nsmall vector format problem
Hello All I am having a bit of trouble formatting my HTML with the desired number of digits after the decimal place. Am I doing something wrong/misunderstanding or is it a bug? Looking at the example supplied with ?HTML.data.frame: HTML(iris[1:2,1:2],nsmall=c(3,1),file="") Gives html output that includes the lines: </tr> <tr><td
2012 Jul 20
3
function for inverse normal transformation
Hi, What is the function for inverse normal transformation? Thanks, Carol [[alternative HTML version deleted]]
2012 Jul 24
5
First value in a row
Hi. This is likely a trivial problem but have not found a solution. Imagine the following dataframe: Lat Lon x1 x2 x3 01 10 NA NA .1 01 11 NA .2 .3 01 12 .4 .5 .6 I want to generate another column that consist of the first value in each row from columns x1 to x3. That is NewColumn .1 .2 .4 Any input greatly appreciated, Thanks, Camilo Camilo Mora, Ph.D.
2007 Jan 20
2
Conditional pluralize without the number
Hi. Assume you have an array of person names. I want to generate results in my view that look like this: Abby is your friend or Abby, Bob, and Carol are your friends. So I''d like to say: <%= friends.to_sentence %> <%= pluralize(friends.count, "is") %> your <%= pluralize(friends.count, "friend") %> But because pluralize puts in the
2009 Sep 01
2
numerical summaries across variables.
Hi Every one, I have a dataframe "class" with "name", "sex", "age", "height", "Weight". if i caluclate summary statistics with the below code numSummary(class[,c("Height", "Weight")], groups=class$Name, statistics=c("mean", "sd", "quantiles"), quantiles=c(0, .25,.5,.75,1)) iam getting
2012 Jun 10
3
Data.frames can not hold objects...What can be done in the following scenario?
R-Help community, I understand that data.frames can hold elements of type double, string etc but NOT objects (such as a matrix etc). This is not convenient for me in the following situation. I have a function that takes 2 inputs and returns a vector: testfun <- function (x,y) seq(x,y,1) I have a data.frame defined as follows: testframe<-data.frame(xvalues=c(2,3),yvalues=c(4,5)) I would
2009 Oct 09
2
plot the same types of graphics on the same R graphic device
Hi, How to plot the same types of graphics on the same R graphic device? Suppose that we want to plot a vector y against x (using plot for instance). How is it possible to plot y against x for different values of these two vectors on the same device so that the plots could be compared? Cheers, Carol [[alternative HTML version deleted]]
2008 Jan 29
8
Asterisk's DANGEROUS Transfer CDR's
Hi All, PLEASE READ if you depend on Asterisk CDR's and support transfers. Apologies for the shout but I'm desperate to get others to agree Asterisk has a big problem with the CDR's that are generated for transfers. I can understand why not too many people are interested as transfers are complicated and messy. However for those of us having to support transfers and depending on
2009 Nov 21
4
title problem
Hi, I got problem in using title function to create a title for multiple plots presented together by par. As can be seen in the attached file, the title is displayed truncated and the subtitle doesn't get displayed. Here is the code: par(mfrow = c(1,2)) plot(c(1,2,3), c(9,8,7)) plot(c(1,2,3), c(9,8,7)) title(main = "Main title", sub ="Sub title",outer = TRUE,
2009 Apr 29
1
RweaveHTML (R2HTML) Help
I have found Sweave() to be great for producing PDF documents. I have been experimenting with RweaveHTML (from the R2HTML) package and have had moderate success. My main issue has been that I simply want the R output to be shown verbatim in the HTML document but RweaveHTML tends to convert most output to a table, for example. So, is there a way to force the RweaveHTML driver to simply provide