Getting counts of data in R -

-

i using r first time. have following data set ( mockup of large data set working with):

type       date         size       color l shape    2008-04-14   161    blue     l shape    2010-10-16   654    yellow l shape    2005-07-03   149    blue l shape    2006-08-16   657    yellow l shape    2007-04-08   229    yellow l shape    2004-03-17   784    green y shape    2014-02-22   917    pink y shape    2012-05-04   186    green y shape    2006-11-25   641    yellow y shape    2015-09-07   493    blue y shape 2011-07-06  953 green

i number of occurrances of each color each type, dates each type , min, max , mean size each type. output should this:

type       colors   dates           mean size   min size    max size l shape      3          2008-04-14  439         149         784                 2010-10-16                           2005-07-03                           2006-08-16                           2007-04-08                           2004-03-17            y shape     4           2014-02-22  638         186         953                 2012-05-04                           2006-11-25                           2015-09-07                           2011-07-06

this i’ve done far:

cat <- big_catalog  na.rm = true  library(plyr)  mydata <-ddply(cat, c("type", "date", "size", "color"), summarize,                colors = length(color),                dates = (date),                mean_size = mean(size),                minimum_size = min(size),                maximum_size = max(size) )

but end this:

type    date    size    color   colors  dates   mean size   min size    max size l shape 2008-04-14  161 blue    2   2008-04-14  161 161 161 l shape 2010-10-16  654 yellow  3   2010-10-16  654 654 654 l shape 2005-07-03  149 blue    2   2005-07-03  149 149 149 l shape 2006-08-16  657 yellow  3   2006-08-16  657 657 657 l shape 2007-04-08  229 yellow  2   2007-04-08  229 229 229 l shape 2004-03-17  784 green   1   2004-03-17  784 784 784 y shape 2014-02-22  917 pink    1   2014-02-22  917 917 917 y shape 2012-05-04  186 green   2   2012-05-04  186 186 186 y shape 2006-11-25  641 yellow  1   2006-11-25  641 641 641 y shape 2015-09-07  493 blue    1   2015-09-07  493 493 493 y shape 2011-07-06  953 green   2   2011-07-06  953 953 953

i apparently need loop on this, new r , don’t see how it.

something like....

df <- read.table(text= "type       date         size       color lshape    2008-04-14   161    blue     lshape    2010-10-16   654    yellow lshape    2005-07-03   149    blue lshape    2006-08-16   657    yellow lshape    2007-04-08   229    yellow lshape    2004-03-17   784    green yshape    2014-02-22   917    pink yshape    2012-05-04   186    green yshape    2006-11-25   641    yellow yshape    2015-09-07   493    blue yshape 2011-07-06  953 green", header=true)  by(df, df$type, function(x){   data.frame(colors = length(unique(x$color)),              dates = paste(x$date, collapse=";"),              mean.size = mean(x$size),              min.size = min(x$size),              max.size = max(x$size)) })

Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more