Displaying 20 results from an estimated 500 matches similar to: "Exporting a list of lists"
2008 Aug 09
1
Reshape set operations?
I have mange to use the library reshape to give me data structures that I want. Specifically:
m2008 <- melt(t2008, id.var=c("DayOfYear","Category","SubCategory","Sku"), measure.var=c("Quantity"))
m2007 <- melt(t2007, id.var=c("DayOfYear","Category","SubCategory","Sku"),
2008 Aug 27
1
Updating a list.
I have a list that is generated from the resape package function 'cast'. It consists of three columns, Sku, DayOfYear, variable it is generated like:
r2007 <- cast(m2008, DayOfYear ~ variable | Sku, sum)
Now DayOfYear can range from 1:365 but there are not necessarily that many rows in the list. What I want to do is make every row in the list of lenght 365 and have the values
2008 Aug 05
1
RESHAPE cast help.
I have a set of data that is basically sales figures for a given year. It has columns for Yeaqr, Day Of Year, Sku, SubCatetory, and Category. The first few lines of data look like:
Year DayOfYear Sku Quantity CatId Category SubCategory
1 2007 1 100091 1 10862 HOLIDAY Christmas
2 2007 1 100138 1 11160 PET COSTUMES Famous
2008 Jul 26
1
Simple vector question.
I have some data that I read in via read.csv:
sales2007 <- read.csv("Total2007.dat", header=TRUE)
The data looks like:
> sales2007[1:605,]
Year DayOfYear Sku Quantity CatId Category SubCategory
1 2007 1 100091 1 10862 HOLIDAY Christmas
2 2007 1 100138 1 11160 PET COSTUMES Famous (Licensed)
3 2007
2009 Mar 11
1
Reshape question.
This hopefully is trivial. I am trying to reshape the data using the reshape package.
First I read in the data:
a2009 <- read.csv("Total2009.dat", header = TRUE)
Then I trim it so that it only contains the columns that I have interested in:
m2009 <- melt(a2009, id.var=c("DayOfYear","Category","SubCategory","Sku"),
2008 Jul 26
4
Data length mismatch.
I have two vectos (list) that represent a years of data. Each "row" is represented by the day of year and the quantity that was sold for that day. I would like to form a new vector that is the difference between the two years of data. A sample of A (and similarly B) looks like:
> A[1:5,]
DayOfYear x
1 1 1429
2 2 3952
3 3 3049
4 4 2844
5 5
2008 May 15
1
lattice histogram problem with integers values and nint
been puzzling over this for a day.
Summary
integer variable to use with histogram, 170,000 rows. Value is day of
year. Hist works, lattice histogram with nint does not work (spurious
spikes in display), lattice histogram using breaks=c(0:365) works
fine. Spike values appear to be sum of two adjacent bins. Want to
know if this is a familiar problem, and what the recommended
work-around is.
2012 Jul 19
1
Switching log(J) to log(J+1) to avoid log(0) in HAR-RVJ model
I am working with xts dependent data, and my code is as follows (the problem
is explained throughout):
dat <- getdat("prices")
dat <- read.zoo(dat, sep = "",format="%d/%m/%Y %H:%M",
tz="", FUN=NULL, regular=TRUE,
header=TRUE, index.column=1, colClasses=c("character",
"numeric"))
dat <- as.xts(dat)
2008 Aug 07
1
Where is the archive? Calling a function within a function.
I seem to remember this topic coming up before so I decided to look at the archive and realized that I didn't know where it was. Is there a searchable archive for this list? Thank you.
My question is calling a function from within a function. I have
smerge <- function(d1,d2) {
temp <- merge(d1,d2,all=TRUE,by.x="DayOfYear",by.y="DayOfYear")
return
2008 Aug 08
1
write.csv writing the "index"
I have a simple command to export a data.frame:
write.csv(output, "TotalPredicted2008.dat")
The structure of the data.frame can be seen with:
> head(output)
DayOfYear Sales
1 1 1429
2 2 3952
3 3 3049
4 4 2844
5 5 2219
6 6 2340
But it seems that the index is getting written out to the file. The first few lines look like:
2008 Aug 08
2
Length of data.frame column
I have a beginner question. After I finally get the data to a data.frame that I can work with I have the following a data frame that is fairly long:
> length(r2007)
[1] 17409
If I look at the first element:
> r2007[1]
$`100009`
DayOfYear Quantity
1 66 1
2 128 1
3 137 1
4 193 1
Now how do I get the length of this list (actually it is
2012 Mar 27
1
Convert day of year back into a date format.
Hello,
I am having trouble figuring out how to convert a Day of Year integer
back into a Date format. For example I have the following:
date <- c('2008-01-01','2008-01-02','2008-01-03','2008-01-04','2008-01-05','2008-01-06','2008-01-07',
2012 Oct 07
2
gam error message: matrix not +ve definite
Hello,
I'm running a multimodel analysis which involves fitting several GAM models
as implemented in package mgcv. The issue I'm having is that when I try to
fit my model, gam gives me the following error message: 'Error in
initial.sp(w * X, S, off) : S[[2]] matrix is not +ve definite.' The strange
part of this is that the error message stops my model fitting function when
run
2008 Jul 12
1
Assoociative array?
I have search the archive and I could not find what I need so I will try to ask the question here.
I read a table in (read.table)
a <- read.table(.....)
The table has column names like DayOfYear, Quantity, and Category.
The values in the row for Category are strings (characters).
I want to get all of the rows grouped by Category. The number of unique category names could be around 50. Say
2011 Jul 07
3
How to make matrix missing data 0
Dear All,
I am trying to analysis traffic data with one timestamp column and speed
column. This data set contains six years data; for each year, I want to make
a matrix in (day of the year) * (hour)
0 1 2 . . . 23
1
2
.
.
365
However random day's record is missing(e.g. there are 40 missing records in
2005 data set), when I tried to use tapply function, matrix came out is
2016 Jun 14
3
Samba4 Domain Member Server "Getent show diferents UID"
On 14/06/16 18:36, Juan Ignacio wrote:
> Traducir del: Inglés
> Ok, I have correctly configured the option to use RFC2307 in the
> Actide Directory Domain Controller and the option on the member server.
>
> But anyway still showing bad UIDs.
>
> Here we show how both configurations are actualemente.
>
> Within RSAT I can place the UID attribute for example uanaco.
>
2013 Mar 15
2
Help finding first value in a BY group
I have a large Excel file with SKU numbers (stock keeping units) and
forecasts which can be mimicked with the following:
Period <- c(1, 2, 3, 1, 2, 3, 4, 1, 2)
SKU <- c("A1","A1","A1","X4","X4","X4","X4","K2","K2")
Forecast <- c(99, 103, 128, 63, 69, 72, 75, 207, 201)
PeriodSKUForecast <-
2013 Feb 06
3
how to "multiply" list of matrices by list of vectors
Hi everyone,
I'd like to be able to apply lda to each 2D matrix slice of a 3D array, and
then use the scalings to obtain the corresponding lda scores.
I can use 'apply' to get a list of the lda output for each 2D slice, and
can create a list of the resulting scalings, but I'm not sure how to
multiply them in a vectorized way.
Here's how I made a list of 2D matrices
2009 Jan 22
1
convergence problem gamm / lme
Hope one of you could help with the following question/problem:
We would like to explain the spatial
distribution of juvenile fish. We have 2135 records, from 75 vessels
(code_tripnr) and 7 to 39 observations for each vessel, hence the random effect
for code_tripnr. The offset (‘offsetter’) accounts for the haul duration and
sub sampling factor. There are no extreme outliers in lat/lon. The model
2016 Jun 14
2
Samba4 Domain Member Server "Getent show diferents UID"
On 14/06/16 17:32, Juan Ignacio wrote:
> Rowland, a question.
>
>
> "is to copy idmap.ldap from the first DC to all others and then keep
> them in sync, the other is to use RFC2307 attributes."
>
> I can do the same with my member server? Maybe it works, or not for
> beign a member server.
>
> Maybe i can change my Member Server to a Domain Controller and