title: how do you create a data frame from an existing data frame with summary
body: <p>I am trying to create to separate data frames what will include Avg, Max and 95th percentile fo the data by Hostname. </p>
  
  <ol>
  <li>for the Cpubusy and 2. for the UsedPercentMemory</li>
  </ol>
  
  <p>The data frame would look something like this:</p>
  
  <pre><code>Hostname   Avg   Max 95th Percentile
  Web01      10     90    92
  Web02      5      80    75
  
  dput(d)
  
  
  
  structure(list(Hostname = structure(c(8L, 8L, 9L, 5L, 6L, 7L, 
  1L, 2L, 3L, 4L), .Label = c("db01", "db02", "farm01", "farm02", 
  "tom01", "tom02", "tom03", "web01", "web03"), class = "factor"), 
      Date = structure(c(6L, 10L, 5L, 3L, 2L, 1L, 8L, 9L, 7L, 4L
      ), .Label = c("10/5/2015 1:15", "10/5/2015 1:30", "10/5/2015 2:15", 
      "10/5/2015 4:30", "10/5/2015 8:30", "10/5/2015 8:45", "10/6/2015 8:15", 
      "10/6/2015 8:30", "9/11/2015 5:00", "9/11/2015 6:00"), class = "factor"), 
      Cpubusy = c(31L, 20L, 30L, 20L, 18L, 20L, 41L, 21L, 29L, 
      24L), UsedPercentMemory = c(99L, 98L, 95L, 99L, 99L, 99L, 
      99L, 98L, 63L, 99L)), .Names = c("Hostname", "Date", "Cpubusy", 
  "UsedPercentMemory"), class = "data.frame", row.names = c(NA, 
  -10L))
  </code></pre>
  
  <p>Is there an easy way to do this in r, I am trying to avoid loops.</p>
  
  <p>I tried this:</p>
  
  <pre><code>dd %&gt;% group_by(Hostname) %&gt;% summarise_each(funs(mean, max))
  </code></pre>
  
  <p>I cannot figure out 95th percentile.</p>