r - Aggregate, Date, Values -
I am new to R and am trying to gather results and am trying to find minimum dates. For example if I have
date of the ID value 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 -02 7 1 2013-12-02 9 I'm seeing the result as:
ID date value 2013-02-02 5 1 2013-04-02 7 Any time will be appreciated.
here data.table Library (Data Eligible) df $ date & lt; - as.Date (df $ date) is a solution with data. You can use dplyr (thanksgiving): (sd) [which.man (date),] = id < pre> library (dplyr) df%.% group_by (id)%.% filter (date == minute (date)) Both the output of something: ID date value 1: 0 2013-02-02 5 2: 1 2013-04-02 7
Comments
Post a Comment