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