Filtering a ‘R’ data frame
November 12, 2013 Leave a comment
This is an example showing how to strip a data frame of rows based on a ‘Time’
column. I have removed rows where the ‘Time’ column has hour as ’00’.
This is one row.
147769 264640 00:36:35
input <- read.table(textConnection("
PermGenAfterFullGC X9 Time
12862 25984 19:36:16
39212 69504 19:36:26
182327 331456 20:36:27
147729 293504 21:36:29
147743 286336 22:36:31
147760 276096 23:36:33
147769 264640 00:36:35
147748 252224 01:36:36
147758 240320 02:36:38"),header=T)
input <- data.frame(input)
print(input$Time)
print( subset(input,as.POSIXlt(strptime(input$Time,"%H:%M:%S"))$hour != 0) )
I have a plan to convert some of this code to Java using the Java lambda API.