reshape2 - Convert from long wide data fromat to long data format in R with multiple depth headers -

-

maybe can't done because have data in bad format, i'm trying "kind of" wide format long format. if modify data in excel first, know how melt, have lot of data, , i'm hoping not have modify hand first.

basically have headers have depth have multiple descriptors each column of sales. account, brand, variety , tier (and maybe others depending on how goes) 

            account             brand             variety             tier dates    1/1/2011    sales xxx 2/1/2011    sales xxx

and format need in be

date account brand variety tier sales

i don't understand how convert using reshape or melt though. suggestions, or have hand?

edit

actual data looks (names changed protect innocent)

account   account account   account   account   account b brand     brand   brand         brand b         brand b         brand c variety   cab           chard           merlot          pinot grigio    pinot noir  tier     tier 2    tier 3          tier 2          tier 1          tier 3 date                     6/1/20     35            47              35               28               -    7/1/2011   12            17              12               12              84                8/1/2011   -             -               -                -                -    9/1/2011   7             7           7            7               84  10/1/2011 28             28              28              28              112  11/1/2011                                            168  12/1/2011  7             7           7            7              224  1/1/2012                 14                              236

if massage in excel this

    date    compilation_red compilation_white   oak_cab oak_chard 1   11/1/2012   351 140 183 190 2   12/1/2012   191 99  120 92 3   1/1/2013    96  56  87  51 4   2/1/2013    30  30  84  61 5   3/1/2013    96  70  100 57 6   4/1/2013    60  38  52  22 7   5/1/2013    12  17  65  49 8   6/1/2013    9   7   28  21 9   7/1/2013    16  13  23  22 10  8/1/2013    26  29  40  33 11  9/1/2013    14  4   30  23 12  10/1/2013   17  4   47  31 13  11/1/2013   23  5   63  35 14  12/1/2013   25  3   70  41 15  1/1/2014    44  1   88  41 16  2/1/2014    28  7   57  43

then know how use melt long format

myitem=melt(account, id.vars="date", variable.name="variety", value.name="sales")

i don't understand how deal headers, , them long format.

also, don't understand why table looks fine when put in, mashed in preview.


Comments

Post a Comment

Popular posts from this blog

How to access named pipes using JavaScript in Firefox add-on? -

-
i'm trying access named pipe in firefox add-on. code, based on solution 2 this codeproject question, is: var file = components.classes["@mozilla.org/file/local;1"].createinstance(components.interfaces.nsilocalfile); file.initwithpath("\\\\.\\pipe\\test"); var text = "some text written"; var writer = components.classes["@mozilla.org/network/file-output-stream;1"].createinstance(components.interfaces.nsifileoutputstream); // open file read/write access, , create if not exist. writer.init (file, 0x04 | 0x08, -1, 0); writer.write (text, text.length); writer.flush (); writer.close (); when run firefox scratchpad, get: /* exception: component returned failure code: 0x80520012 (ns_error_file_not_found) [nsifileoutputstream.init] @6 */ line 6 line call writer.init. i've played passing different flags writer.init, no luck. i'm able write normal file path code, not named pipe path. i've been searching more information of da...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more

node.js - req param returns an empty array -

-
i using node.js , mongodb geolocation app , req param returns empty array exports.findpressure = function(req, res) { var queryobject = req.param('q'); console.log(queryobject); db.collection('pressure', function(err, collection) { collection.find( { loc: { $near :[ req.param('q') ] , $maxdistance : 5 }},{"value" : 1, _id : 0}) .sort({_id : -1}).limit(1).toarray(function(err, items) { res.send(items); }); }); }; the longitude , latitude values displayed in console listening on port 3000... connected 'weather' database 8.9068256,52.019347499999995 /pressure?q=8.9068256,52.019347499999995 200 27ms - 2b the url follows http://localhost:3000/pressure?q=8.9068256,52.019347499999995 if use values 8.9068256,52.019347499999995 getting value database if use req.param('q') returning empty array you seem passing values part of query string. req.query.q should contain comma-s...
Read more