| 12345678910111213 |
- import codecs
- import dataset
- db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/google_poi?charset=utf8mb4')
- table=db['lat_lon_loc']
- fr=codecs.open('lat_long_location.csv','r','utf-8')
- lines=fr.readlines()
- for l in lines[1:]:
- newl=l.strip()
- # print(newl)
- elmts=newl.split(',')
- table.insert({'num':elmts[0],'loc':elmts[1],'lat':elmts[2],'lon':elmts[3]})
- #print(lines)
- fr.close()
|
