Transforming vertical Data to a horizontal format in R -


this conceptual question. have data in sql express database loading r via odbc package. data format is:

name, symbol, number of days 1/1/2015, closing price. 

the main company, tmc, 1, 12 xyz company, xyz, 1, 233 1 company, toc, 1, 56 2 company, ttc, 1, 88  main company,tmc, 2, 11.5 xyz company, xyz, 2, 232 1 company, toc, 2, 59 2 company, ttc, 2, 89

my question is: there r package can transform data being in vertical format horizontal? ie

name, symbol, price lag1, price lag2

the main company, tmc, 12, 11.5 xyz company, xyz, 233, 232 1 company, toc, 56,59 2 company, ttc, 88,89

or should try sql code?

we use dcast reshape2 or spread tidyr. before reshaping, may better change lengthy column names spaces no space column names. specify value column in value.var in dcast.

library(reshape2) colnames(df1)[3:4] <- c('numberofdays', 'closing_price') dcast(df1, name+symbol~paste0('lag', numberofdays),                    value.var='closing_price') #              name symbol lag1  lag2 #1 main company    tmc   12  11.5 #2  1 company    toc   56  59.0 #3  2 company    ttc   88  89.0 #4  xyz company    xyz  233 232.0

a similar option using dplyr/tidyr mutate 'numberofdays' pasteing 'lag' string , convert 'long' format 'wide' `spread.

library(dplyr) library(tidyr) df1 %>%     mutate(numberofdays=paste0('lag', numberofdays)) %>%     spread(numberofdays, closing_price)

-

Comments

Post a Comment

Popular posts from this blog

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more

c# - SharpDX Toolkit models rendering inside out -

a little while ago decided switch xna sharpdx toolkit actively being supported , quite similar xna. while i've had no trouble @ creating 2d games decided attempt basic 3d game. can both model , it's texture load when renders shows texture on side facing away camera doesn't show @ in between. this code using set environment. vector3 cameraposition = new vector3(0, 0, -10f * 2.5f); vector3 cameratarget = vector3.zero; boundingsphere modelbounds = model.calculatebounds(); float fovangle = mathutil.degreestoradians(45); float aspectratio = (float)graphicsdevice.backbuffer.width / graphicsdevice.backbuffer.height; float near = 0.01f; float far = 100f; float scaling = 10f / modelbounds.radius; matrix translation = matrix.scaling(scaling) * matrix.rotationy((float)gametime.totalgametime.totalseconds) * matrix.translation(0, -modelbounds.center.y * scaling, 0); matrix lookat = matrix.lookatlh(cameraposition, cameratarget, vector3.u...
Read more