|
Dear Mr. Dani, Thanks for your mail. I am so happy that you are exactly understanding
my problem and you have already understood it correctly even beyond what I have
explained. Sorry there are 10 data fields and I have given the 10 labels.
Distance and Flag are two labels. Distance means distance from the origin of the
route(Point A) to the bus location. When calculating the sequence, I have considered only the
Distance data. As explained in my previous mail, depending on the distance I
have given numbers 0,1,2,3 and 4 and which is in last column. In this case I
am considering only one route and hence route no need not be considered. As you
have correctly understood, I have to consider the Date and VID also in
recognizing the sequence. Yes, it is true that the bus has moved along the route
several times in a day. Sometimes more than 20 times. Still I am thinking how to separate these
drives. I want to give them a name such as Trajectory1, Trajectory 2 , so on. The sequence is exactly 0,0,0,0,……0, 1,1,1, …………1, 2,2,…………..2,
3,3,………….3, 4,4,……………..4.
like that.
As I have observed one sequence has in average 1500 records, because bus
stops at bus halts and intersections and then same recoding is there for a long
time. Since the number of records per group depends on the speed of the bus,
bus stops ect, there is no
maximum number of records per group. Yes the group of records from which I calculate the sequence
is ordered in the file. Yes I have the 3 cases you have identified. But the case is
when the bus goes to the end of the route it change the direction and then we
get 0,1,2,3,4,3,2,1,0,1,2,…that way. I will send here 30 lines of my data set, but unfortunately
it is difficult to cover a sequence in 30 lines.( it
takes at least 1200 lines) Thank you very much for taking trouble in this connection. Best wishes, Geetha |
data_sample.xls
Description: MS-Excel spreadsheet
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
