I have a csv file,
 
heartrate          excercise       medicine              Time
12                      0                0                     4:30 am
23                      5                 0                     5:00 am
34                      6               0                       5:30 am
56                      3                  0                    6:00 am
24                     12                 1                     6:30 am
35                      2                  0                     7:00 am
26                      5                  0                     7:30 am
63                      4                  0                     8:00 am
24                      3                  1                     8:30 am 
45                       9                 0                     9:00 am
 
I did the folllowing:
x <- read.table("heart.csv",sep=",")
names(x) <- c("heartrate","ex","Med","Time")
x.newtime <- strptime(x$Time, format= "%H:%M %p")
 
 
What I am tring to do is: 
First I am trying to get all the data from when there was a medicine taken in previous hour.
Second I will plot heartrate VS median Excercise in previous hour.

 
In the first problem, how can I get the desired data? after I got it, should I put it in a new file? How? 
 
How can I refer to a specific cell in a csv file?  
 
I appreciate your kindly help!


---------------------------------


	[[alternative HTML version deleted]]


