Hi Rachel, I'll take a guess and assume that you are monitoring the mobile phones of 36 people, adding an observation every time some specified change of state is sensed on each device. I'll also assume that you are only recording four types of measurement. It seems that you want to aggregate these events for each subject over the interval or observation (or over each day or something). I think you are going to create a new data frame of these summaries from the one you have of individual observations. Creating each summary doesn't look too hard, but you will have to define more precisely what you want those summaries to be. For instance, "I want the mean activity level for each subject during the overall time that their mobile phone is switched on", One you have clearly defined your goals, it probably won't be too hard to get to them.
Jim On Sun, Jan 6, 2019 at 5:39 AM Rachel Thompson <rachel.thomp...@student.uva.nl> wrote: > > Dear Mr/Mrs, > > This is my first time working in R studio. > I have a database of 36 participants but it has 150600 entries. > Column - Column - Column - Column > > Participant Activityprobe - Activity Level - High/low/none > > Participant Screenprobe - screenon/off - > > Participant SMSprobe etc > > Participant CallLogProbe etc. > > I need a code that helps me count the activity level of all the participants > High activity level. No activity level and Low activity level. > And to help me find out for every participant what the percentages are of > all their high/no/low activity. > > For screenprobe I need to count how many times the participant turned their > screen on and how many times they turned it off and the percentage of > screen on/off. > > For callLog I need to count how many times each participant got called and > the percentage. > > For SMS I need to count the number of SMS for each participant and their > percentage. > > I also need to categorize the probes. So that my database shows all the > activity levels first, organized by none/high/low and then all the > screenprobes, organized by on and off etc... > > I hope that my description is clear and that you can maybe help me. > > Best, > > Rachel > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
