Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

where did you sleep MS?

By: a guest on May 7th, 2011  |  syntax: Python  |  size: 0.37 KB  |  hits: 115  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. import csv
  2.  
  3. content = csv.reader(open('date-and-location.csv'), delimiter='\t', escapechar='')
  4.  
  5. locid = 0
  6. last_lat = ''
  7. last_lon = ''
  8. for row in content:
  9.     id, date, lat, lon = row
  10.     if last_lat != lat and last_lon != lon:
  11.         locid = locid + 1
  12.         last_lat = lat
  13.         last_lon = lon
  14.     print 'UPDATE ms SET locid = %s WHERE id = %s;' % (locid,id)
create a new version of this paste RAW Paste Data