to group successive datasets using pandas in python

[madhu91]

hello. I have a huge GPS datasets of the form (id,timestamp,longitude,latitude). Something like this

id	timestamp	longitude	latitude
3	2001-02-02 13:02:01	132.3245	56.2345
3	2001-02-02 13:02:06	132.3245	56.2345
3	.........	same as above	same as above
	....	....	....
3	2001-02-02 13:05:01	132.3245	56.2345
3	2001-02-02 13:05:06	132.3246	56.2345

the above is just an example of how my data is present. I have around 990000 records roughly. now i want something like this

id	timestamp	longitude	latitude
3	2001-02-02 13:02:01 - 2001-02-02 13:05:01	132.3245	56.2345
3	2001-02-02 13:05:06	132.3246	56.2345

i want to merge all the rows of same latitude and longitude values into a single row. I am a beginner in pandas and i cannot use "group by" function where group by groups all the occurances but i want successive occurances to be grouped.

any help would be surely appreciated.
thank you very much..

[coffeecat]

Thread moved to Programming Talk, at request of OP.