Just curious -- why do you continue to post in HTML when you have been
asked not to?
Cheers,
Bert
Bert Gunter
Genentech Nonclinical Biostatistics
(650) 467-7374
"Data is not information. Information is not knowledge. And knowledge
is certainly not wisdom."
H. Gilbert Welch
On Sat, Jan 25, 2014 at 11:46 AM, umair durrani
<umairdurr...@outlook.com> wrote:
> Hello everyone,Here is the version using dput. I am sorry for the junk I
> posted before. I have a large vehicle trajectory data of which following is a
> small part:
> structure(list(vehicle = c(1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L,2L, 2L), frame
> = c(221L, 222L, 223L, 224L, 115L, 116L, 117L, 118L, 119L, 120L, 121L),
> globalx = c(6451259.685, 6451261.244, 6451262.831, 6451264.362, 6451181.179,
> 6451183.532, 6451185.884, 6451188.237, 6451190.609, 6451192.912,
> 6451195.132), class = c(2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), velocity
> = c(23.37, 23.16, 22.94, 22.85, 35, 35.01, 35.03, 34.92, 34.49, 33.66, 32.5),
> lane = c(5L, 5L, 5L, 5L, 4L, 4L, 4L, 4L, 4L, 4L, 4L)), .Names = c("vehicle",
> "frame", "globalx", "class", "velocity", "lane"), row.names = c(85L, 86L,
> 87L, 88L, 447L, 448L, 449L, 450L, 451L, 452L, 453L), class = "data.frame")
> Explanation of Columns:vehicle = unique ID of vehicle. It is repeated (in
> column) for every frame in which it was observed;frame= ID of the frame in
> which the vehicle was observed. One frame is 0.1 seconds long;class = class
> of vehicle i.e. 1=motorcycle, 2=car, 3=truck;velocity= velocity of vehicle in
> feet per second;lane= lane number in which vehicle is present in a particular
> frame;
>
> 'frame' number can also repeat e.g. in frame 120 the example data shows
> vehicle 2 was observed but in the original data many more vehicles might have
> been observed in this frame. Similarly, 'class' is defined above and all
> three classes are present in the original data (here example data only shows
> classes 2 and 3 i.e. cars and trucks).
> I need to determine two things:1) Number of vehicles observed in every 30
> seconds i.e. 300 frames 2) Average velocity of each vehicle class in every 30
> seconds
>> This means that the first step might be to determine the minimum and maximum
>> frame numbers and then divide them in slots so that every slot has 300
>> frames. In my original data I found 22 as min and 9233 as max frame number.
>> This makes 30 time slots as 22-322, 322-622, ..., 9022-9233. I need
>> following columns in one table as an output (note that Timeslot column
>> should contain the time intervals as described before): TimeSlot,
>> Total-Cars, Total-Trucks, Total-Motorcycles, MeanVelocity-Cars,
>> MeanVelocity-Trucks, MeanVelocity-Motorcycles
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> 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
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.
