I have a CSV file that contains experimental data. Each row in this set represents a different experiment. The columns are the name of the design, which lab it was tested in, drug used, and the response measured. I would like to aggregate this data set into bins. So,rather than each row representing a different experiment, each row will now represent a specific response range of 100mg for each design, lab, and drug combintation. So, it have these columns: Design, Lab, Drug, Response range (namely 100-200,200-300,300-400,400-500) and then the number of experiments who yielded a response in that range, in that lab, that design, and using that drug. Can anyone help with this? I am new to this software, but really really need some assistance on this one. Thank you for any information and your time.
... View more