Displaying 20 results from an estimated 3000 matches similar to: "Reorganize data frame"
2017 Aug 02
1
Looping Through QuantMod Objects
Dear R Helpers,
I have run into a problem trying to perform a number of actions on a set
of quantmod data objects through a loop and I am hoping that this is an
easy problem for someone else as opposed to very difficult for me.
The example task is to get the first three objects of the quarterly
balance sheet for a number of companies from the getFinancials object and
put them together into a
2013 Nov 06
1
Multiple String word replacements: Performance Issue
Dear experts,
I?ve been on this for weeks now, and couldn?t find a solution..Sorry for the long description. I figured I post many details, so you get the problem entirely, although it?s not hard to grasp.
**Situation:**
Data frame consisting of 4 million entries (total size: 250 MB). Two columns: `ID` and `TEXT`. Text strings are each up to 200 characters.
**Task:**
Preprocessing the text
2011 Nov 20
2
Continuasly Compunded Returns with quantmod-data
Hey guys,
i want to calculate the continuasly compounded returns for stock prices.
Formula for CCR:
R_t = ln(P_t/P_{t-1})*100
With R:
First i have to modify the vectors, so that they have the same length
and we start at the second observation.
log(GOOG1[-1]/GOOG1[1:length(GOOG1)-1])*100
That does work with normal vectors.
My Questions:
1) I want to use this for stock prices.
so i
2011 Jul 29
2
Different result on using apply.
Dear R-helpers,
In the following example I compute ret and returns the SAME way. In ret I
use compute returns for EACH column and in returns I do it for the whole
data frame. Could someone please tell me why I see a lagged result,by which
I mean ret and returns are different by one lag.
getSymbols("GOOG",src="yahoo")
ret<-apply(GOOG,2,function(x) diff(log(x)) / lag(x,1) )
2012 Feb 03
3
Cannot get "==" operator to return TRUE
I have a data.frame named "df". The dput of df is at the bottom of this e-mail.
What I'd like to do is replace the "n/a " values with NA. On Mac OSX, it works
to do this:
df[df == "n/a"] <- NA
However, it does not work on Ubuntu. See below.
Thanks in advance,
Garrett
> x <- df[27, 4] # complete data.frame dput is below
> dput(x)
"n/a?"
2009 Mar 05
3
character string as object name
Can someone please tell me why the following (last line) doesn't work
(as I expect it to :-)
library(quantmod)
a = getSymbols("MSFT",from="2009-3-01")
a
MSFT
eval(as.name(a))
MSFT$MSFT.Adjusted
b=paste(a,'$MSFT.Adjusted',sep='')
b
eval(as.name(b))
Why does this last line not work the way the earlier eval does?
Thanks.
2010 Dec 07
3
help on timeseries
i have time series of momentum signal. I want to get the date of each of the
"-1" signal period. for example , the first period of -1 signal begins on
2005-9-21 and ends on 2005-9-28. 2nd period of -1 signal begins on
2005-09-30 and ends on 2005-10-28.
Thx
Cameron
date Px 200MA Signals
2005-09-15 26.27 25.83865 1
2005-09-16 26.07 25.83275 1
2017 Sep 18
3
Convert data into zoo object using Performance analytics package
Dear All,
While i am trying convert data frame object to zoo object I am
getting numeric(0) error in performance analytics package.
The source code i am using from this website to learn r in finance:
https://faculty.washington.edu/ezivot/econ424/returnCalculations.r
# create zoo objects from data.frame objects
dates.sbux = as.yearmon(sbux.df$Date, format="%m/%d/%Y")
dates.msft =
2010 May 30
1
890FX AMD-Vi (IOMMU)
Hello,
I was hoping someone might be able to tell me why IOMMU does not seem to be found on my system. At the very least is there any way I can get more debug information in addition to adding iommu=verbose to the command line?
Xen 4.0.0
MSI 890FXA-GD70 (I spoke with an MSI representative who confirmed that this motherboard does support IOMMU)
AMD Phenom II 1090T x6
# dmesg
__ __
2010 Jan 20
1
Quantmod error
Hi all I have installed quantmod package but when I try to obtain GOOG data
appers this message: Can anyone inform why itappears?
I type getSymbols("GOOG",src="google")
Thanks and Best Regards for all
Error en download.file(paste(google.URL, "q=", Symbols.name, "&startdate=",
:
no fue posible abrir la URL '
2007 Aug 22
5
Bug#439156: xen-hypervisor-3.0.3-1-amd64: large memory not detected
Package: xen-hypervisor-3.0.3-1-amd64
Version: 3.0.3-0-2
Severity: important
On a machine with 2 dual-core Opterons and 16GB of memory, only about 3GB is detected by the hypervisor. Transcript:
root at thismachine:~# xm dmesg
Xen version 3.0.3-1 (Debian 3.0.3-0-2) (ultrotter at debian.org) (gcc version 4.1.2 20061028 (prerelease) (Debian 4.1.1-19)) Fri Nov 3 00:21:27 CET 2006
Latest
2011 Aug 23
1
Testing Specific Hypothesis
Hi All!
I am interested in testing whether the means for the data I am investigating
are equal to a specific value - let's say 0.01. I have already run a
one-way ANOVA and know that the differences in the means are not
significant, so now I want to know what values the means take on. "otestme"
is the data I am working with (it would be hard for me to get into a form
that would be
2000 Jul 07
1
reorganizing a data frame
Hi,
I have what I think is an easy question.
I have a data frame, called stockdata, of stock prices that looks like this:
date ticker close
1 01/02/1998 GE 24.667
2 01/05/1998 GE 25.104
3 01/06/1998 GE 24.771
4 01/07/1998 GE 24.979
5 01/08/1998 GE 24.750
6 01/02/1998 HIT 71.125
7 01/05/1998 HIT 72.313
2010 Dec 02
5
Help summarizing R data frame
I am trying to aggregate data in column 2 to identifiers in col 1
eg..
take this>
identifier quantity
1 10
1 20
2 30
1 15
2 10
3 20
and make this>
identifier quantity
1 45
2 40
3 20
Thanks in
2012 Nov 29
1
Hacked by Microsoft?
This morning someone tried to make sip call through my Asterisk. My
server just drop these calls and record them in CDR with IP address:
2012-11-28 06:30:51 SIP/216... 1000 "1000" <1000> Hangup
999011972592249388 ANSWERED 00:01 Hacker: 168.63.67.239
2. 2012-11-28 06:30:49 SIP/216... 1000 "1000" <1000> Hangup
88011972592249388 ANSWERED 00:01 Hacker:
2012 Jul 08
1
VNC console only shows black screen on HVM guest running on Xen 4.1 with Ubuntu 12.04 as Dom0
Hello all,
I have a problem getting a working VNC console for HVM guests on Xen
4.1. When I start the DomU with xm create everything is fine the DomU
runs and in xm list it has the running state but when I try to connect
to the VNC console to install an operating system (Ubuntu and Debian I
have tested) the VNC viewer only shows a black screen. So I searched in
the logs and found a log entry
2008 Dec 09
4
[VT-D]iommu.c:775: iommu_page_fault: iommu->reg = ffff828bfff57000
Hello,
I have been working sometime now on getting a HVM accepting a PCI card from
the host. As was said in the VT-D wiki I bought an ASUS P5E VM DO
motherboard (rel 0803) which has the VT-D option in the bios. I want to pass
a Hauppauge PVR 500 card to a virtual machine running LinuxMCE. After first
trying XEN 3.2.1 which did not enable the "VT-D virtualisation" bit in xm
dmesg, i
2012 Jul 17
1
[PATCH 01/15] Drivers: hv: Format GUIDS as per MSFT standards
On Tue, 2012-07-17 at 09:04 -0700, Greg KH wrote:
> On Sat, Jul 14, 2012 at 01:34:06PM -0700, K. Y. Srinivasan wrote:
> > Format GUIDS as per MSFT standard. This makes interacting with MSFT
> > tool stack easier.
[]
> > diff --git a/drivers/hv/vmbus_drv.c b/drivers/hv/vmbus_drv.c
[]
> > @@ -147,7 +147,7 @@ static ssize_t vmbus_show_device_attr(struct device *dev,
>
2012 Jul 17
1
[PATCH 01/15] Drivers: hv: Format GUIDS as per MSFT standards
On Tue, 2012-07-17 at 09:04 -0700, Greg KH wrote:
> On Sat, Jul 14, 2012 at 01:34:06PM -0700, K. Y. Srinivasan wrote:
> > Format GUIDS as per MSFT standard. This makes interacting with MSFT
> > tool stack easier.
[]
> > diff --git a/drivers/hv/vmbus_drv.c b/drivers/hv/vmbus_drv.c
[]
> > @@ -147,7 +147,7 @@ static ssize_t vmbus_show_device_attr(struct device *dev,
>
2017 Sep 20
1
Convert data into zoo object using Performance analytics package
Dear Sir,
Thanks for your mail and help. I got this error while trying to run your
code.
sbux1.z <- read.csv.zoo(u, FUN = as.yearmon, format = fmt)
Error in read.table(file = file, header = header, sep = sep, quote = quote,
:
'file' must be a character string or connection
Thanks and Regards,
Upananda Pani
On Tue, Sep 19, 2017 at 4:31 PM, Upananda Pani <upananda.pani at