Displaying 20 results from an estimated 200 matches similar to: "Reshape question."
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 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
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 11
3
Exporting a list of lists
I have a list
List(Sku=" ", Shape=1, Scale=3, DayOfYear=daylist)
Note: picture daylist as c(2,3,4,3) it is a list with variable length.
Then I have a list of lists
al <- c(al, List(List(Sku=" ", Shape=1, Scale=3, DayOfYear=daylist))
Note: same comment on daylist as above.
So far this creates a list of lists just how I want it. If I do al[1] I get each member and the
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.
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 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 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
2012 May 09
2
Memoria de R y bucles for
Buenos días:
A ver.... una duda muy general, y otra más específica...
Después de haber conseguido tratar con R.... y hacer un script de 161 páginas...
es hora de empezar a hacer bucles para reducirlo a menos de 5 hojas....
el primer problema que me encuentro es que se queja de que el vector de datos que intruduzco (una base de datos de 11 años) es demasiado grande;
tengo segun R... un vector de
2009 Apr 11
0
Rsync 3.0.5 sometimes hangs copying local disk to other local disk (Solaris 9)
I hope I'm sending this report to the right place.
I recently upgraded the rsync binaries in a bunch of our Solaris 9
systems from rsync 2.6.9 to rsync 3.0.5 . I have a script that runs in
each machine that syncs the file systems from an active drive to a
backup drive. Wihtin 3 days, this script had hung in two of the ~20
hosts that I had updated with the new rsync. Those two hosts
2009 Nov 17
0
Bug#556695: FTBFS with binutils-gold
Source: xen-3
Version: 3.4.0-2
Severity: minor
User: peter.fritzsche at gmx.de
Usertags: no-add-needed
Tried to build your package and it fails to build with GNU binutils-gold. The
important difference is that --no-add-needed is the default behavior of of GNU
binutils-gold. Please provide all needed libraries to the linker when building
your executables.
More informations can be found at
2006 Apr 15
8
Inheritance in Rails - I need some help
I''ve got a model, "category" and another model "subcategory." Each
subcategory belongs_to a category, and a category has_many
subcategories.
What I need to do is set it up so that I can search Category and
Subcategory with one .find call. So:
Category.find(:all, <etc)
will find categories and subcategories.
Now, I believe this can be done by making
2006 Jul 23
3
Newbie: Display hierarchical Records in a view
Hi,
I have two models: category and subcategory. (one to many
relationship), and a controller ''home''
I''d like to display all the categories and their sub categories in the
view: home\index.rhtml.
I have a method in the ''home'' controller'' like this:
def list_categories
@categories = Category.find(:all)
end
This list all the categories
2008 Apr 01
1
Navigation Problems
Hi,
I am having problems with my page. I have a banner and navigation bar in
controller_name.rhtml in app/views/layout. Can someone please help?
Thanks
In the navigation bar, I have the following links:
Category1
Sub-Category1
Sub-Category2
Sub-Category3
Sub-Category4
Sub-Category5
Sub-Category6
In the main content, I have the following links:
Sub-Category1 edit delete
2006 Mar 30
5
Heeelp - no idea what''s going wrong.
I''m working on a simple CMS. The main data type are "listings" a listing
habtm (has_and_belongs_to_many) categories and subcategories.
Subcategories belong_to categories. Subcategories are basically the same
as categories, but they are treated differently in a few situations.
The problem is, I can''t seem to write the view/controller/model code
that allows me to