[R] Convert data set to data frame
jim holtman
jholtman at gmail.com
Tue Jul 15 01:13:55 CEST 2008
Is this what you want:
> x <- data.frame(a=1:10,b=1:10)
> x
a b
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
6 6 6
7 7 7
8 8 8
9 9 9
10 10 10
> t(x)
[,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10]
a 1 2 3 4 5 6 7 8 9 10
b 1 2 3 4 5 6 7 8 9 10
>
On Mon, Jul 14, 2008 at 5:40 PM, Willa Wei <wwei at dataquick.com> wrote:
>
> Greetings,
>
> I have a data set look like this:
>
>> print(MyResult)
> 2 5 9 10
> 11 13
> mean 6.108394 3.272211e+01 3.951703e+02 2.086217e+03
> 79.838867 2.592272e+04
> median 1.288889 2.743511e+00 4.061491e+00 4.943710e+01
> -2.821667 -3.040625e+00
> var 2885.350595 2.343144e+05 1.022680e+06 1.200589e+07
> 365179.508831 3.363738e+09
> sd 53.715460 4.840603e+02 1.011276e+03 3.464952e+03
> 604.300843 5.799774e+04
> valid.n 83501.000000 2.699000e+03 2.600000e+01 1.000000e+01
> 491.000000 5.000000e+00
> 14 17 19 20 21
> mean 226.58561 273.2301 1611.224 620.8836 3608.207
> median 51.68978 56.7179 1266.557 140.8548 459.320
> var 758255.12696 485670.6679 2393157.095 1232059.4957 38426150.479
> sd 870.77846 696.9008 1546.983 1109.9818 6198.883
> valid.n 118.00000 90.0000 58.000 77.0000 15.000
> attr(,"class")
> [1] "dstat"
>
> The above data set was generated from brkdn function and the numbers 2,
> 5, and etc. indicate the levels in my breakdown. Now, I want to have a
> data frame looks like shown below so that I can save it into my
> database:
>
> Level mean median var sd valid.n
> 2 6.11 1.29 2885 53.72 8.35e+04
> 5 32.72 2.74 2.343e+05 484.1 2699
> 9 395.2 4.06 1.023e+06 1011 26
> 10 2086 49.44 1.201e+07 3465 10
> 11 79.84 -2.82 3.652e+05 604.3 491
> 13 2.592e+04 -3.04 3.364e+09 5.8e+04 5
> 14 226.6 51.69 7.583e+05 870.8 118
> 17 273.2 56.72 4.857e+05 696.9 90
> 19 1611 1267 2.393e+06 1547 58
> 20 620.9 140.8 1.232e+06 1110 77
> 21 3608 459.3 3.843e+07 6199 15
>
>
> How can I do it?
>
> Thanks in advance for your help,
> Willa
>
>
> This message contains confidential information and is ...{{dropped:18}}
More information about the R-help
mailing list