search

MacHu-GWU / uszipcode-project

USA zipcode programmable database, includes up-to-date census and geometry information.
MIT License
231 stars 49 forks source link

How do you parse Common_city_list #66

Closed 931743010 closed 1 year ago

931743010 commented 2 years ago

Want to use Data in simple_db.sqlite; Export to Excel; Common_city_list is displayed as eJyLVgouLSqqVIoFAA9dAyI= How do you parse this data; Python is not very good; How do you parse this data using Java?

MacHu-GWU commented 1 year ago

Hi, it is just a base encoded pickle in Python. You could do this in Python:

import pickle
import base64

real_common_city_list = pickle.load(base64.b64decode(common_city_list.encode("utf-8")))