I am pretty new at R and I think I've bitten off more than I can chew. I have done my tables and figures in Excel, but would like it to look more professional by coding it with R.
Here is the table I am trying to duplicate right now:
My data set is here: https://docs.google.com/spreadsheets/d/e/2PACX-1vSyQRiTb9gUVNHE-WwDGgDMi8v5GAP_phBymLrH5s46Pl4uWYsfXbdlh8WvOlROyA18aufGfN9bXMOR/pub?gid=1732065428&single=true&output=csv
I've attempted this so far but have gotten stuck:
library(data.table)
fish <- fread('https://docs.google.com/spreadsheets/d/e/2PACX-1vSyQRiTb9gUVNHE-WwDGgDMi8v5GAP_phBymLrH5s46Pl4uWYsfXbdlh8WvOlROyA18aufGfN9bXMOR/pub?gid=1732065428&single=true&output=csv')
head(fish)#I want to split summarize the table into performers, sustained swimming, and prolonged/burst swimmers by percentage."
library( dplyr )
fish.percent<- select(fish, Absolute.Velocity, TtF)
fish.percent%>%
group_by(Absolute.Velocity)%>%
summarize(n())
The SM count and percentage would come from TtF >60, and the PBM data is 0<PBM<200.
Should I just stick with Excel for this? Any advice is welcome.