I have the raw data with 9 column and 197977 row:

> dummy
   State Months Bedroom
1    xxx    Jan       1
2    xxx    Jan       2
3    xxx    Jan       1
4    yyy    Jan       1
5    yyy    Jan       2
6    yyy    Jan       1
7    zzz    Jan       3
8    zzz    Jan       1
9    zzz    Jan       2
10   xxx    Feb       3
11   xxx    Feb       4
12   xxx    Feb       2
13   yyy    Feb       1
14   yyy    Feb       2
15   yyy    Feb       1
16   zzz    Feb       2
17   zzz    Feb       3
18   zzz    Feb       3

> dim(rawdata)
[1] 197977      9

I want to do some calculation on the "State" "Months" "Bedroom". So I am
picking only three column using subset.

> subsets.dummy <- subset(dummy, select=c("State","Months","Bedroom"))
> subsets.dummy
   State Months Bedroom
1    xxx    Jan       1
2    xxx    Jan       2
3    xxx    Jan       1
4    yyy    Jan       1
5    yyy    Jan       2
6    yyy    Jan       1
7    zzz    Jan       3
8    zzz    Jan       1
9    zzz    Jan       2
10   xxx    Feb       3
11   xxx    Feb       4
12   xxx    Feb       2
13   yyy    Feb       1
14   yyy    Feb       2
15   yyy    Feb       1
16   zzz    Feb       0
17   zzz    Feb       3
18   zzz    Feb       3

>From the above data. I want below table for 1,2,3,4.... Bedroom.
Ex : for 1 Bedroom, I need how may(count of 1 Bedroom) 1 Bedroom is there in
a particular state for month wise.

State  Jan Feb
 xxx   2    0
 yyy   2    2
 zzz   1    0

for 2 Bedroom :
State  Jan Feb
 xxx   1    1
 yyy   1    1
 zzz   1    0

I want to melt "subsets.dummy" data for the above requirement. To achive
this I am doing like this:
>
melt.data.frame(subsets.dummy,id.vars=c("State","Bedroom"),measure.vars="Months")
   State Bedroom variable value
1    xxx       1   Months   Jan
2    xxx       2   Months   Jan
3    xxx       1   Months   Jan
4    yyy       1   Months   Jan
5    yyy       2   Months   Jan
6    yyy       1   Months   Jan
7    zzz       3   Months   Jan
8    zzz       1   Months   Jan
9    zzz       2   Months   Jan
10   xxx       3   Months   Feb
11   xxx       4   Months   Feb
12   xxx       2   Months   Feb
13   yyy       1   Months   Feb
14   yyy       2   Months   Feb
15   yyy       1   Months   Feb
16   zzz       2   Months   Feb
17   zzz       3   Months   Feb
18   zzz       3   Months   Feb

I trying to get a new data frame for 1 bedroom using cast. But I am not able
to get the below data for 1 Bedroom using cost.

State  Jan Feb
 xxx   2    0
 yyy   2    2
 zzz   1    0

I not able to understand how to cost it.  any help will be greatly
appreciated.

Thanks & Rg
Mohan L

	[[alternative HTML version deleted]]

