[R] How to Reformat a dataframe
jim holtman
jho|tm@n @end|ng |rom gm@||@com
Sat Oct 28 17:25:34 CEST 2023
You can also use the pivot_longer to do it:
library(tidyverse)
input <- structure(list(...1 = c(92.9925354, 76.0024254, 44.99547465,
28.00536465, 120.0068103, 31.9980405, 85.0071837, 40.1532933,
19.3120917, 113.12581575, 28.45843425, 114.400074, 143.0000925,
46.439634, 20.7845679, 50.82874575, 36.9818061, 44.6273556, 40.57804605,
:
:
:
row.names = c(NA, -126L), class = "data.frame")
> input$row <- seq(nrow(input)) # add row number for reference> head(input) ...1 ...2 ...3 ...4 ...5 ...6 ...7 ...8
1 92.99254 34.99963 24.04101 43.01330 53.00914 62.01390 91.01036 88.99986
2 76.00243 22.00219 22.00219 25.00378 44.99547 60.99449 63.00499 92.99254
3 44.99547 22.99328 15.00793 15.99902 38.00121 44.00438 62.01390 79.99510
4 28.00536 19.00061 12.99743 12.99743 44.00438 49.01647 55.95410 69.00816
5 120.00681 35.99072 22.99328 47.99706 60.00341 62.01390 60.00341 66.00658
6 31.99804 23.95606 13.98852 15.99902 38.99230 54.99132 88.00877 89.99095
...9 ...10 ...11 ...12 row
1 54.00023 75.01134 111.99314 49.01647 1
2 68.01707 75.01134 82.99669 63.99608 2
3 60.99449 91.01036 84.01609 65.01549 3
4 82.99669 78.01292 135.01474 85.99827 4
5 66.99767 91.01036 88.99986 51.98974 5
6 79.00401 78.01292 113.52225 155.00644 6> > x <-
pivot_longer(input,names_to = "col",cols=1:12)> head(x, 20)# A tibble:
20 × 3
row col value
<int> <chr> <dbl> 1 1 ...1 93.0 2 1 ...2 35.0 3 1
...3 24.0 4 1 ...4 43.0 5 1 ...5 53.0 6 1 ...6
62.0 7 1 ...7 91.0 8 1 ...8 89.0 9 1 ...9 54.010
1 ...10 75.011 1 ...11 112. 12 1 ...12 49.013 2 ...1
76.014 2 ...2 22.015 2 ...3 22.016 2 ...4 25.017
2 ...5 45.018 2 ...6 61.019 2 ...7 63.020 2 ...8
93.0
>
Thanks
Jim Holtman
*Data Munger Guru*
*What is the problem that you are trying to solve?Tell me what you want to
do, not how you want to do it.*
On Fri, Oct 27, 2023 at 10:41 PM Paul Bernal <paulbernal07 using gmail.com> wrote:
> Hi Iris,
>
> Thank you so much for your valuable feedback. I wonder why your code gives
> you 1512 rows, given that the original structure has 12 columns and 126
> rows, so I would expect (125*12)+ 9=1,509 total rows.
>
> Cheers,
> Paul
> El El vie, 27 de oct. de 2023 a la(s) 10:40 p. m., Iris Simmons <
> ikwsimmo using gmail.com> escribió:
>
> > You are not getting the structure you want because the indexes are
> > wrong. They should be something more like this:
> >
> > i <- 0
> > for (row in 1:nrow(alajuela_df)){
> > for (col in 1:ncol(alajuela_df)){
> > i <- i + 1
> > df[i,1]=alajuela_df[row,col]
> > }
> > }
> >
> > but I think what you are doing can be written much shorter and will run
> > faster:
> >
> > ## transpose here matches your original code
> > df <- data.frame(aportes_alajuela = c(t(alajuela_df)))
> >
> > ## but if you do not want to transpose, then do this
> > df <- data.frame(aportes_alajuela = unlist(alajuela_df, use.names =
> FALSE))
> >
> > However, you said you expected 1509 observations, but this gives you
> > 1512 observations. If you want to exclude the 3 NA observations, do
> > something like:
> >
> > df <- df[!is.na(df$aportes_alajuela), , drop = FALSE]
> >
> > On Fri, Oct 27, 2023 at 11:14 PM Paul Bernal <paulbernal07 using gmail.com>
> > wrote:
> > >
> > > Dear friends,
> > >
> > > I have the following dataframe:
> > > dim(alajuela_df)
> > > [1] 126 12
> > >
> > > dput(alajuela_df)
> > > structure(list(...1 = c(92.9925354, 76.0024254, 44.99547465,
> > > 28.00536465, 120.0068103, 31.9980405, 85.0071837, 40.1532933,
> > > 19.3120917, 113.12581575, 28.45843425, 114.400074, 143.0000925,
> > > 46.439634, 20.7845679, 50.82874575, 36.9818061, 44.6273556,
> 40.57804605,
> > > 30.38398005, 47.94042705, 36.38715225, 28.06199835, 28.4867511,
> > > 122.86681215, 56.4071652, 35.9057658, 52.669341, 24.94714485,
> > > 54.4249857, 61.164396, 47.88379335, 30.582198, 26.051502, 43.041612,
> > > 64.59073485, 51.6499344, 78.8202902886201, 35.2390173175627,
> > > 82.2394568898745, 47.760850180466, 54.3654763342294, 49.4878058854839,
> > > 32.8813266149642, 38.9301880693548, 51.9506275455197, 55.4404001992832,
> > > 50.7979761262545, 37.1198211413082, 36.9144309425627, 33.7829493281362,
> > > 32.8647492475806, 42.8926863444444, 63.9814428257048, 39.219040238172,
> > > 88.7557324417563, 42.0964144925627, 129.15973304991, 117.872998635484,
> > > 35.4004098300179, 83.4102757505377, 38.6443638074373, 100.491764259319,
> > > 40.219162961828, 35.901029409319, 85.2814714674731, 26.5821299974014,
> > > 33.0141992892473, 52.4006692386201, 62.7450310643369, 33.3732853655914,
> > > 36.4616827405018, 146.501706130466, 59.9869292767025, 132.659282967294,
> > > 29.9692075517921, 45.8436438112007, 29.3028312143369, 49.9042699517921,
> > > 27.4678688861111, 29.8483957580645, 26.1192323867384, 62.1371491517921,
> > > 53.92489050681, 64.5840869873656, 28.4476420455197, 52.9893180218638,
> > > 36.4730500781362, 40.8595060662186, 33.4571194806452, 35.6201445262545,
> > > 47.5373940344086, 62.5177012273297, 31.9702480361111, 29.6637272685484,
> > > 49.9578249978495, 26.1936613831541, 30.8051128442652, 153.165249601165,
> > > 36.7652008047491, 14.3854334390681, 55.9930862447133, 87.5882628859319,
> > > 88.414763059767, 58.6046644034946, 20.5301898890681, 39.0037205346774,
> > > 67.5971386298632, 25.1295804696237, 32.7864973072581, 59.5662701215054,
> > > 56.3503435331631, 25.2768483884409, 120.187620533964, 51.3699688189953,
> > > 42.6889983487868, 34.5183987020052, 32.9513272936733, 20.6141437461215,
> > > 43.4197954932283, 107.258904254306, 23.7548470509806, 48.4457090643702,
> > > 72.3249287581108, 32.7272590911596, 48.6115621286089), ...2 =
> > c(34.9996266,
> > > 22.00219245, 22.9932822, 19.00060635, 35.99071635, 23.9560551,
> > > 44.99547465, 22.00219245, 17.35822905, 38.9639856, 16.4804067,
> > > 93.87035775, 81.2693595, 65.4119235, 14.6114946, 33.32893245,
> > > 23.3330844, 66.68618175, 29.1097218, 18.77407155, 28.1469489,
> > > 20.64298365, 15.31941585, 25.79665035, 39.5869563, 35.9057658,
> > > 28.11863205, 27.09922545, 18.03783345, 52.3295388, 47.99706075,
> > > 21.88892505, 18.8590221, 17.64139755, 29.2796229, 27.750513,
> > > 26.9576412, 36.8932410314484, 19.1194611744253, 37.5166237491071,
> > > 37.9625421619439, 23.444984650496, 37.4408609345785, 43.1033210084325,
> > > 28.1252430606151, 38.4216392645833, 41.0532302780651, 34.4822260610119,
> > > 27.8096188059524, 25.9720387760913, 19.5989670673372, 21.1366557174603,
> > > 34.0091174203373, 111.149568174301, 24.5438738482759, 62.923693488747,
> > > 36.056976280754, 36.934798630754, 47.0895472967433, 23.0987961767857,
> > > 45.1991799260913, 23.0274422095238, 26.8716961246169, 21.5009916962302,
> > > 25.315076619246, 41.2098751296627, 15.6537752838123, 20.1723471152778,
> > > 31.7437694203373, 34.6486999232143, 27.6318028338123, 23.9637897951389,
> > > 50.6646878095238, 33.3208231933532, 38.0673028746602, 19.9469359998016,
> > > 27.0503264451389, 19.8385753555556, 29.0062549955939, 17.231889453373,
> > > 25.3320442555556, 17.651735447619, 37.12988188841, 37.7982565469246,
> > > 33.1890524548611, 15.4283008803571, 33.5040593288314, 24.9726150325397,
> > > 29.0612348127976, 30.2629592267857, 32.8065534719349, 43.3676303365079,
> > > 39.19334780424, 23.9252474159722, 15.8641806903257, 27.51501019685,
> > > 21.5861832758362, 18.5136698379577, 54.9166790494253, 29.2865335598214,
> > > 12.8130786005824, 46.2078437446569, 37.9351942968391, 31.8758398080357,
> > > 25.4830299994048, 17.4062173291544, 19.1528843310516, 37.2160194109127,
> > > 25.3577400835684, 21.3381885368056, 37.5842732179795, 62.4856267757438,
> > > 19.2393143990079, 49.4806272500855, 29.5274325254668, 18.7819282827049,
> > > 19.5089694997422, 25.524181172185, 15.9275217745507, 25.461470312583,
> > > 37.4026236465872, 14.6120197959536, 26.5773978462589, 27.6541154512847,
> > > 22.5193597452548, 27.9919830179818), ...3 = c(24.04100565, 22.00219245,
> > > 15.0079305, 12.99743415, 22.9932822, 13.9885239, 27.0142749,
> > > 16.3671393, 12.2895129, 28.68496905, 16.56535725, 32.70596175,
> > > 46.01488125, 24.94714485, 10.8170367, 19.68021075, 15.0079305,
> > > 26.41962105, 21.9738756, 15.71585175, 21.26595435, 13.28060265,
> > > 11.6099085, 15.5742675, 25.96655145, 20.5013994, 15.99902025,
> > > 18.03783345, 11.07188835, 32.59269435, 29.7326925, 15.82911915,
> > > 13.4788206, 22.11545985, 17.6130807, 22.3136778, 17.01842685,
> > > 24.8211230265233, 13.237941302509, 22.3448026530466, 26.8162566663605,
> > > 19.755485530466, 28.9524567137097, 35.9159180773958, 29.0510074712366,
> > > 29.6768770591437, 19.74645255681, 21.3046743438172, 18.2600040043011,
> > > 14.1888055630824, 13.2245440831541, 14.2163781231183, 19.9802103525986,
> > > 56.1211624398027, 13.9762431155914, 26.4956908674731, 29.4013819718638,
> > > 26.8419717732975, 44.6725035525986, 14.7828541642548, 24.4708500199821,
> > > 10.5834818923835, 20.2093501674731, 14.2639281024194, 17.2504254149642,
> > > 19.7845974174731, 10.850022277957, 16.4476927547907, 20.9176435624552,
> > > 22.8783063162186, 25.7326244974014, 20.1825218974014, 51.1908599407987,
> > > 40.9448287612007, 20.2191781781362, 10.3501469886201, 21.1253173781362,
> > > 13.4899172867384, 23.1471303187276, 12.8374587906722, 16.9906343861111,
> > > 13.1835697522092, 17.8847127055556, 32.4731512323477, 17.6332611074373,
> > > 13.4532405190011, 19.4829400781362, 24.2590318624552, 26.5715576967742,
> > > 19.0041586430108, 28.5379041193548, 29.7763011256272, 32.1823265123117,
> > > 29.7879391141577, 14.0165763547689, 37.6846187388183, 16.3880639974014,
> > > 13.8338638285842, 44.6845644331541, 18.6545178642578, 11.2407237620968,
> > > 34.0711681997412, 29.0336803177268, 18.1338299396953, 39.7917534240684,
> > > 10.6510092909498, 16.2566291560036, 28.5616029884409, 38.8678199534946,
> > > 15.4433570447133, 17.2045135497178, 49.4081574106672, 32.6989511276381,
> > > 38.5789940244859, 32.1769916573031, 28.9463686859436, 13.4928541224532,
> > > 19.5413894417691, 10.7006215291469, 29.8260981653798, 25.4362115265858,
> > > 11.5257100913926, 16.8079233526533, 27.4408077645845, 40.6526894052778,
> > > 18.8694236080065), ...4 = c(43.01329515, 25.00377855, 15.99902025,
> > > 12.99743415, 47.99706075, 15.99902025, 62.0139015, 12.5160477,
> > > 20.13328035, 18.4625862, 16.7635752, 31.4317035, 88.914909,
> 47.82715965,
> > > 10.50555135, 14.18674185, 13.28060265, 72.3778686, 21.9738756,
> > > 12.82753305, 28.74160275, 46.69448565, 8.6083224, 15.291099,
> > > 23.6162529, 15.8008023, 33.27229875, 18.0661503, 7.95703485,
> > > 44.76893985, 22.22872725, 21.03941955, 26.92932435, 22.65348,
> > > 46.07151495, 15.9140697, 22.4835789, 17.7829818, 18.2384985351852,
> > > 20.5132854851852, 61.5926915188615, 15.693652737963, 19.5663315662037,
> > > 24.3550255328704, 53.0975022597222, 36.7972078271926, 36.7901429763889,
> > > 18.8871641546296, 20.9930987768519, 20.1431562884259, 10.6699463958333,
> > > 15.75360755, 37.4331277462963, 54.1371851226852, 19.1322272638889,
> > > 25.599830762963, 33.3566375162037, 19.421600999537, 43.1187841560185,
> > > 11.9100427961142, 15.1950489439815, 20.8816316998207, 63.5722125117055,
> > > 21.3153340421296, 17.4206699247302, 42.4256331148148, 26.851255354471,
> > > 13.8370396062451, 65.4289660486111, 70.8573662263666, 29.3347708393519,
> > > 30.1223113805556, 104.141421110648, 53.9017718844937, 50.7707224048161,
> > > 9.85083922838523, 16.679586024537, 8.50117283796296, 29.7760417518519,
> > > 12.3623151717593, 58.2226773143519, 43.8683067041667, 18.6122984347222,
> > > 236.356918314815, 26.518730025, 18.768390700463, 13.0113303819444,
> > > 27.8125653564815, 63.6389740583333, 80.2297640347222, 23.5851393240741,
> > > 29.110683174537, 26.2230636560185, 18.1385155833333, 35.5873651333171,
> > > 71.1575933980326, 14.1058989912037, 22.352831962963, 37.7497695597222,
> > > 13.9331137675926, 35.9453219891346, 66.8659299971482, 25.6415400254835,
> > > 15.1121959384259, 76.2625002964008, 19.6161482467593, 30.3616062425926,
> > > 50.555977574537, 48.0870803657407, 60.781296601654, 17.5123175343251,
> > > 46.3781020162159, 32.9047155318093, 45.2884006349093, 39.7311056806747,
> > > 26.0169754879377, 32.1970505053614, 22.6549346464934, 16.8551283466882,
> > > 22.976903453078, 24.6695897641777, 10.0811787631618, 22.3981217825916,
> > > 58.8947786812898, 75.1529521249874, 15.0698117186505), ...5 =
> > c(53.0091432,
> > > 44.99547465, 38.0012127, 44.0043849, 60.00340515, 38.99230245,
> > > 51.536667, 54.7081542, 31.0919013, 60.3715242, 73.48222575, 68.526777,
> > > 147.813957, 79.0040115, 47.6289417, 58.07785935, 59.8051872,
> > > 96.19233945, 59.21053335, 57.9929088, 122.6685942, 66.4879638,
> > > 13.90357335, 30.89368335, 61.3342971, 35.6225973, 75.8325243,
> > > 28.91150385, 14.80971255, 95.17293285, 41.71072005, 49.5544875,
> > > 58.58756265, 54.11350035, 61.47588135, 38.02952955, 68.526777,
> > > 62.15548575, 77.6784310738351, 50.5600232415771, 131.876932720878,
> > > 20.6789463878136, 30.9527021610215, 51.8652541034946, 50.5158733141577,
> > > 65.3799359472222, 100.009112523321, 53.1610290997312, 60.1700076922043,
> > > 32.2775382972222, 33.8153090258961, 54.401286830914, 95.0948838978495,
> > > 76.6519537191756, 57.9907266771505, 100.305556442832, 67.9363689859319,
> > > 36.8437233959677, 104.980864599731, 29.1320843302867, 48.3498203616488,
> > > 45.5838020353047, 70.4890298277778, 38.6008566758961, 55.4927880633513,
> > > 87.7219305972222, 54.7773224196237, 43.3184540353047, 94.7221976139785,
> > > 109.994754833695, 69.5983515602151, 65.4988362689964, 130.990821687186,
> > > 67.8702794202509, 64.9310106890681, 40.9020659196237, 28.7862263164875,
> > > 73.8719355863588, 44.2015371620968, 26.9290029520609, 87.4829120246416,
> > > 49.3287477370072, 52.4560850095878, 105.858686949731, 51.1010205514337,
> > > 84.4875812418607, 44.0169194196237, 56.9543198177419, 109.201614576703,
> > > 155.199816965233, 59.9808227158602, 47.1291171577061, 93.1677987708781,
> > > 80.5607447070789, 116.459338258333, 82.8986102315412, 64.9543881602151,
> > > 50.5573167326165, 107.571298157258, 67.0962686045699, 77.3657611358944,
> > > 70.7801148664875, 73.4220260571224, 30.2768192108423, 53.2795572765233,
> > > 39.5983236376344, 119.826015501434, 41.0489109464158, 79.0048065370072,
> > > 67.9431183426523, 50.6200062464158, 81.1957762876344, 51.8652033564516,
> > > 45.4861804724328, 64.5839189739347, 69.7335909436077, 83.2834162480453,
> > > 60.7586179353601, 59.0404232122419, 52.2671818563404, 46.4495093287553,
> > > 40.0792220246565, 33.0039252222804, 69.8833876014689, 71.1205502192063,
> > > 25.9164851853527), ...6 = c(62.0139015, 60.9944949, 44.0043849,
> > > 49.01646735, 62.0139015, 54.9913227, 75.29450415, 45.1370589,
> > > 38.59586655, 84.63906465, 62.66518905, 137.9030595, 93.7287735,
> > > 81.58084485, 52.58439045, 56.49211575, 59.0123154, 90.18916725,
> > > 88.37688885, 86.79114525, 104.00779005, 53.43389595, 61.5041982,
> > > 60.1449894, 77.10678255, 61.13607915, 75.57767265, 52.01805345,
> > > 56.067363, 108.170367, 79.37213055, 61.64578245, 57.05845275,
> > > 63.11825865, 85.99827345, 49.1580516, 67.7339052, 65.89330995,
> > > 49.4663906333333, 62.902124174537, 125.42931227963, 56.1662971796296,
> > > 49.3735742916667, 89.0394507013889, 92.5179659694444, 86.3792399597222,
> > > 70.559909350463, 68.0506344111111, 77.1285445736111, 68.6415301606481,
> > > 60.7908582935185, 107.425126938426, 90.4807259277778, 81.396785325,
> > > 72.1131410115741, 68.8834469532407, 91.5248660726852, 48.0119183564815,
> > > 82.2235674268519, 33.5023294574074, 58.6514503578704, 64.0816433337963,
> > > 82.6175561916667, 114.884519368981, 59.435669787037, 93.4450806138889,
> > > 110.401979493519, 78.3836627305556, 84.819803062963, 117.287431325463,
> > > 86.534895237037, 45.5510617347222, 69.754801874537, 103.916983855093,
> > > 69.9525828361111, 71.7655604175926, 52.4842327027778, 78.1433190962963,
> > > 50.0991498740741, 33.9123993962963, 107.815794591204, 71.0580761560185,
> > > 85.9337739583333, 104.136789033333, 58.433218337963, 56.3486961486111,
> > > 105.916555494444, 100.764898941204, 89.4245249023148, 101.514945875463,
> > > 62.5367144527778, 80.3241535347222, 50.7403866902778, 52.1234550583333,
> > > 106.172281121296, 119.406737793519, 109.830748223148, 98.7653273018519,
> > > 110.709881538426, 60.5554089296296, 57.7968757921296, 164.881151758333,
> > > 114.807172417593, 42.3015284018519, 47.3479581421296, 69.258295625,
> > > 79.6316142773148, 38.6308256240741, 93.6480180388889, 74.1446128060185,
> > > 68.0709980717593, 92.146788000463, 79.0773117590429, 89.7252644488388,
> > > 53.5003470216826, 62.6669327681478, 74.0358775483401, 49.6010839106274,
> > > 62.4195698709396, 39.292332545434, 99.9687981401921, 40.2746960761065,
> > > 76.0016770163077, 69.3366089449157, 89.2159743205815, 48.0730413172471
> > > ), ...7 = c(91.0103559, 63.00499125, 62.0139015, 55.9540956,
> > > 60.00340515, 88.0087698, 75.80420745, 35.2827951, 85.48857015,
> > > 119.63869125, 74.72816715, 93.445605, 125.160477, 73.87866165,
> > > 73.3972752, 56.77528425, 42.95666145, 118.8175026, 82.4586672,
> > > 93.81372405, 99.42046035, 58.332711, 87.1026306, 72.12301695,
> > > 54.73647105, 49.41290325, 98.68422225, 60.7679601, 61.02281175,
> > > 178.48110555, 60.22993995, 54.84973845, 64.70400225, 94.43669475,
> > > 75.06796935, 59.7485535, 60.45647475, 151.8915834, 77.8770211688172,
> > > 76.8059709947133, 95.5358418702509, 45.1915104771505, 44.3152274541219,
> > > 79.5500496827957, 73.7685236509857, 61.4291771547491, 97.5867666978495,
> > > 88.5714360972222, 116.80599130914, 81.5496015871864, 109.510765562724,
> > > 136.904898995341, 164.49342743405, 86.2917435997312, 98.5759449758961,
> > > 95.1858395146057, 111.213971651613, 86.007780062724, 136.084454635305,
> > > 37.0162295108423, 83.3701686708781, 62.8513968664875, 86.4204719321685,
> > > 72.132523562724, 104.871318649552, 109.474532174014, 95.9775948796595,
> > > 50.6672348277778, 88.3225895139785, 121.58091591147, 76.8334928077061,
> > > 55.6079161882617, 95.6947985246416, 127.831395367742, 49.1690975396953,
> > > 86.238831349552, 63.4233667882616, 111.597500887007, 31.898796199552,
> > > 48.6903161045699, 106.279244610842, 74.6957567051971, 47.4088856058244,
> > > 130.007276330914, 88.8368093008065, 50.7865072945341, 101.199211870251,
> > > 75.9300093696237, 73.9893747821685, 103.683178131541, 140.684961650806,
> > > 104.768995695161, 57.2737217064516, 58.7820591501792, 92.9597528102151,
> > > 99.9310094340502, 94.2899004702509, 115.778989568369, 96.1018067252688,
> > > 39.8479145108423, 87.5417785945341, 108.026972772133, 67.422470597043,
> > > 70.607930149552, 88.305961399552, 59.7161430551971, 69.4862005951613,
> > > 54.6980047913978, 126.661692942025, 127.072473339516, 110.780456578853,
> > > 93.7374850757168, 69.9698735972591, 106.738637147415, 64.5152740485102,
> > > 87.1268323629885, 43.3975092336417, 52.5152792378864, 63.7137140203338,
> > > 84.6634689840074, 83.2759556945253, 47.5837274800544, 86.8166065787247,
> > > 112.648942563551, 143.549465228576, 65.8425685705771), ...8 =
> > > c(88.99985955,
> > > 92.9925354, 79.99510125, 69.00816345, 66.00657735, 89.9909493,
> > > 44.71230615, 62.49528795, 91.8032277, 83.67629175, 85.14876795,
> > > 115.8159165, 124.59414, 66.79944915, 73.057473, 71.6416305,
> 59.89013775,
> > > 79.59866535, 116.8919568, 133.7687994, 100.77966915, 58.02122565,
> > > 101.85570945, 97.38164715, 77.61648585, 72.9442056, 95.3145171,
> > > 71.358462, 85.71510495, 104.3759091, 96.5604585, 94.71986325,
> > > 51.16854795, 87.8388687, 97.6931325, 69.093114, 64.08103155,
> > > 116.463431853136, 69.5767840669355, 88.8546045972222, 155.196044768369,
> > > 76.1697722321685, 88.3709345302867, 96.0580289428316, 82.8718327085125,
> > > 81.7255585009857, 126.300796887814, 113.122145047222, 92.5947124141577,
> > > 96.673455249104, 66.9335905003584, 106.393679192832, 124.757342490323,
> > > 91.3846322578853, 112.209577888441, 80.9145700066308, 118.335473354122,
> > > 136.781803584677, 88.5102859103943, 48.9130787077061, 76.6303862258961,
> > > 66.0512009164875, 91.1909307947133, 90.038228628405, 120.433525268996,
> > > 127.600344080914, 93.5963237177419, 58.4067678514337, 91.812734312724,
> > > 96.4453811221326, 95.4837246570789, 91.6730107876344, 117.778913617742,
> > > 107.262417822133, 72.8408169577061, 93.2214045639785, 75.6332406620968,
> > > 138.346774728405, 41.828554683871, 82.8804427901434, 121.71458362276,
> > > 92.5882337083333, 71.4110021051971, 105.813741985305, 73.4316986108423,
> > > 52.584441197043, 149.500585721505, 70.0548212120968, 71.3453354315412,
> > > 118.636386403495, 159.896641868369, 124.508495907079, 99.5186897095878,
> > > 61.6371723683692, 135.166203807706, 69.8381144227599, 99.953642615233,
> > > 96.6851439846774, 113.023966434677, 37.3526316589606, 94.9774214089606,
> > > 129.41979472966, 96.4015525926523, 68.4592496014337, 92.3934158102151,
> > > 112.763803260842, 87.9348144426523, 115.168451893907, 114.463558550806,
> > > 105.081225335125, 115.213396858333, 107.920082583871, 113.556526721806,
> > > 87.182534043245, 100.746877538778, 107.820717028533, 61.2195953835266,
> > > 54.8629442665856, 71.7839889353526, 69.3780698503958, 64.8880471329152,
> > > 84.3745727047643, 86.8773256086014, 115.250098093976, 124.182856141139,
> > > 90.1817841662871), ...9 = c(54.00023295, 68.0170737, 60.9944949,
> > > 82.99668735, 66.9976671, 79.0040115, 80.2499529, 48.7616157,
> > > 78.80579355, 110.5489824, 105.0555135, 100.807986, 122.86681215,
> > > 51.8198355, 80.78797305, 79.3438137, 124.96225905, 82.65688515,
> > > 113.1541326, 135.6377115, 104.9422461, 84.8372826, 68.49846015,
> > > 88.77332475, 103.6963047, 81.69411225, 74.55826605, 67.6772715,
> > > 88.914909, 142.5470229, 96.7303596, 67.64895465, 76.3422276,
> > > 119.2705722, 79.54203165, 85.0071837, 79.7968833, 85.1213250768518,
> > > 91.1265074236111, 94.8002691203704, 101.243139074537, 67.7463156712963,
> > > 65.3070462777778, 92.9989154310185, 104.489963079167, 88.6454619365741,
> > > 95.6530957324074, 96.2138392805556, 106.431327860185, 82.2418335430556,
> > > 71.5570295407407, 113.462384235648, 93.298339900463, 92.4140501217593,
> > > 94.4176420546296, 86.020909450463, 103.683457240278, 85.9453104527778,
> > > 94.0256634365741, 59.9890719296296, 93.0187547055556, 100.441352710648,
> > > 82.4177650833333, 94.4054063787037, 95.6760813236111, 118.294777044907,
> > > 108.812652588426, 95.822822037037, 109.342894344444, 98.7759898194444,
> > > 98.0270790550926, 94.9162458486111, 119.636593705556, 93.1206604064815,
> > > 96.5566130018519, 87.0842770861111, 75.9921124731482, 95.2274690055556,
> > > 63.7360728865741, 75.1976675148148, 87.622734224537, 79.9642498671296,
> > > 64.7750565680556, 72.1407586800926, 75.4217551796296, 89.185317437963,
> > > 106.493555012037, 121.68947793287, 111.078000588426, 137.71209555787,
> > > 119.270484802315, 83.6887022212963, 110.169414253241, 106.021782307407,
> > > 105.793237360648, 112.292741014815, 92.3540953097222, 88.7946497851852,
> > > 88.3137003236111, 48.0344669592593, 56.6142103162037, 100.058725644907,
> > > 92.1715215453704, 81.5248229337963, 84.5357605861111, 99.5218416648148,
> > > 98.9644192287037, 113.18262424537, 84.0182788921296, 78.1174493814815,
> > > 58.5339878689815, 86.7326761986111, 63.3940417265209, 90.5242216237781,
> > > 87.7613482821531, 79.4634654046871, 75.4329525046438, 87.8455136741353,
> > > 82.7085680835468, 66.420417900437, 87.3192277343693, 64.8283838519554,
> > > 90.4344488320088, 101.89113025832, 107.25424417281, 55.0424269132735
> > > ), ...10 = c(75.01133565, 75.01133565, 91.0103559, 78.01292175,
> > > 91.0103559, 78.01292175, 57.51152235, 75.5493558, 58.899048,
> > > 129.77612355, 102.25214535, 103.78125525, 124.5375063, 68.15865795,
> > > 86.083224, 75.12460305, 149.7395028, 108.82165455, 122.92344585,
> > > 119.63869125, 108.4535355, 71.1319272, 136.8836529, 92.34124785,
> > > 106.10323695, 270.3126501, 75.12460305, 90.98203905, 76.3988613,
> > > 91.6899603, 114.76819305, 96.30560685, 95.00303175, 89.33966175,
> > > 115.5893817, 53.43389595, 130.17255945, 74.0648187194444,
> > 98.415448994534,
> > > 117.077048181541, 111.656418203943, 69.0909318771505, 91.8837125102151,
> > > 184.392256445341, 143.99505594095, 111.688557997849, 164.432649392204,
> > > 92.4773006723118, 96.031623564785, 98.7507854547491, 89.6331318997312,
> > > 116.630034395341, 79.1743862390681, 82.1261387428315, 145.541538245341,
> > > 97.1231247972222, 70.2878347179212, 74.8902532053764, 109.844562695968,
> > > 99.9151256095878, 80.1571873053764, 93.3414720677419, 112.481429797849,
> > > 107.20843988405, 99.7747085415771, 91.5307329947133, 103.970490973387,
> > > 120.196790313351, 104.027496818369, 93.228576812724, 119.336712512724,
> > > 82.0989383277778, 126.093123072133, 106.900354585932, 89.8837884608423,
> > > 100.182088887186, 104.524344200806, 134.879635255824, 91.8319674420251,
> > > 133.253513925269, 83.6035035746416, 88.3071285815412, 96.0991509633513,
> > > 95.2481568834229, 117.772485658961, 106.50540726586, 128.208598138441,
> > > 95.8156103183692, 153.21083736147, 131.853555249731, 152.367387675269,
> > > 119.728631925896, 147.733996575896, 85.6276001321685, 83.440402578405,
> > > 147.025703180914, 101.382341032796, 77.8944443202509, 94.4307404302867,
> > > 59.4824360064516, 91.2871979353047, 100.210777882168, 116.855774158333,
> > > 71.9237333120968, 85.1692190083333, 99.4269390558244, 119.594219924642,
> > > 69.1883154526882, 122.62561145457, 78.3248299920251, 62.5127111014337,
> > > 109.128674160215, 92.5094141691414, 102.214150982881, 113.304196757922,
> > > 104.289463219631, 69.3166222008229, 75.6406286742023, 96.6916710132641,
> > > 61.1471702956426, 87.6592065685503, 60.3468631148267, 81.8521951100248,
> > > 76.5965939733406, 103.143649918913, NA), ...11 = c(111.99314175,
> > > 82.99668735, 84.01609395, 135.0147408, 88.99985955, 113.52225165,
> > > 117.31670955, 64.19429895, 97.21174605, 109.4729421, 181.22784,
> > > 319.980405, 127.1426565, 100.60976805, 156.90366585, 174.6583308,
> > > 107.7172974, 126.4064184, 110.35076445, 234.83163705, 71.55667995,
> > > 71.4150957, 109.10482305, 119.0440374, 168.3719901, 146.76623355,
> > > 107.68898055, 109.4729421, 92.79431745, 139.34721885, 169.02327765,
> > > 103.49808675, 99.108975, 269.09502555, 239.7304521, 117.3450264,
> > > 165.5403051, 452.789752612037, 112.674668899074, 136.845023123148,
> > > 125.390507707407, 147.205406918056, 101.483482708796, 148.538046821759,
> > > 93.6385790888889, 104.208804725926, 145.404228024074, 92.5718903412037,
> > > 77.9773508921296, 100.475874796296, 108.628243472685, 140.548237839815,
> > > 144.128658808796, 84.9861208578704, 82.5432681592593, 121.266910125,
> > > 142.538632722222, 193.310132988426, 182.567559116204, 142.72417800787,
> > > 104.623069753704, 141.985492772685, 103.156623993981, 114.944911169444,
> > > 104.799438282407, 117.003563643981, 117.717515334259, 147.705758665741,
> > > 254.736285055556, 120.990908235185, 113.687171081944, 87.6590916615741,
> > > 129.361771124537, 107.696933739352, 77.3595366555556, 151.29439501713,
> > > 100.562660697685, 138.193744200926, 95.7973893106481, 102.302224223611,
> > > 110.082453556481, 108.45808017963, 100.091499776852, 115.70011456713,
> > > 72.1630450898148, 114.096978827778, 133.093564884259, 83.1709583342593,
> > > 133.803933269444, 182.775128618519, 122.711069475, 148.112857083333,
> > > 121.410067533333, 149.270963809722, 104.353972281019, 113.122844228704,
> > > 147.872513449074, 112.707443031019, 122.870308057407, 58.9955350444444,
> > > 89.6550799958333, 147.303729313889, 75.6135057009259, 106.781442987037,
> > > 137.607567926389, 127.527206314815, 234.885299228704, 92.3349552166667,
> > > 202.163518497685, 202.821273476389, 143.923798634722, 225.143428851852,
> > > 157.530355633389, 187.676065594925, 221.071077738915, 82.7623531446858,
> > > 77.798518465568, 129.726331786836, 174.877740649028, 76.0276641003277,
> > > 152.010982110292, 102.903773583178, 83.4300837163835, 99.7688463421467,
> > > 96.9843391694606, NA), ...12 = c(49.01646735, 63.996081, 65.0154876,
> > > 85.99827345, 51.9897366, 155.0064369, 66.5445975, 36.38715225,
> > > 206.23161855, 82.0055976, 116.75037255, 489.881505, 168.8816934,
> > > 39.38873835, 86.5929273, 65.9216268, 97.8630336, 95.4277845,
> > > 76.82361405, 88.99985955, 46.9493373, 61.9006341, 62.863407,
> > > 102.81848235, 117.4582938, 71.5283631, 99.5054109, 61.47588135,
> > > 98.2594695, 155.94089295, 109.9826454, 61.36261395, 67.02598395,
> > > 85.77173865, 132.04147155, 140.9612793, 95.28620025, 226.915825714606,
> > > 47.7665338492832, 215.910399075269, 212.148030222133, 90.9036179528674,
> > > 44.6233634992832, 82.859771827957, 84.9997408003584, 183.01078660914,
> > > 226.450745981093, 151.807529381093, 156.272135815412, 96.0256184980287,
> > > 57.7046317643369, 114.181235834857, 157.950002214158, 77.9836407061828,
> > > 135.604607512276, 84.7630565917563, 122.853364183602, 101.765599617294,
> > > 91.7150293392473, 87.4384406992832, 72.8254067723118, 204.161240689247,
> > > 214.597674566667, 70.3557850085125, 75.8190763336022, 49.8698972879928,
> > > 44.2102994848566, 126.040684461021, 166.839209497222, 110.586112319803,
> > > 68.2977386792115, 147.835203095341, 203.118727268996, 52.2794852999104,
> > > 56.9600542336022, 69.8238206723118, 61.674251541129, 129.046414902867,
> > > 32.7366637110215, 79.5157277660394, 52.6014922034946, 98.6752400233871,
> > > 89.3299859804659, 141.735763754749, 39.2333339886201, 181.927574060394,
> > > 74.4077503204301, 145.684661822312, 63.3958957223118, 89.1317680304659,
> > > 84.1083689898745, 86.3574610204301, 103.421949269803, 72.9182738610215,
> > > 68.2365377453405, 68.8206192947133, 58.5744868285842, 122.020063906004,
> > > 178.942193182796, 28.2040562390681, 138.280685162724, 296.330997365233,
> > > 173.333545410842, 149.083377365233, 65.756343680914, 159.737685213978,
> > > 105.61780765224, 46.7002200658602, 86.7429017277778, 189.154748022133,
> > > 96.7353497258961, 68.4664725972222, 499.277855419375, 170.849271829193,
> > > 148.879966449353, 60.8120779047451, 91.4588421221316, 43.0376842705498,
> > > 108.148547912706, 121.468512697252, 42.6455518427129, 96.4984871785073,
> > > 109.87928815051, 85.3031155445198, 58.5462485275265, NA)), row.names =
> > > c(NA,
> > > -126L), class = "data.frame")
> > >
> > > What I want to do is, instead of having 12 observations by row, I want
> > to
> > > have one observation by row. I want to have a single column with 1509
> > > observations instead of 126 rows with 12 columns per row.
> > >
> > > I tried the following:
> > > df = data.frame(matrix(nrow = Length, ncol = 1))
> > > colnames(df) = c("aportes_alajuela")
> > >
> > >
> > >
> > > for (row in 1:nrow(alajuela_df)){
> > > for (col in 1:ncol(alajuela_df)){
> > > df[i,1]=alajuela_df[i,j]
> > > }
> > > }
> > >
> > > But I am not getting the data in the structure I want.
> > >
> > > Any help will be greatly appreciated.
> > >
> > > Best regards,
> > > Paul
> > >
> > > [[alternative HTML version deleted]]
> > >
> > > ______________________________________________
> > > R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > > and provide commented, minimal, self-contained, reproducible code.
> >
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
[[alternative HTML version deleted]]
More information about the R-help
mailing list