def validate_state(state): """ Utility function that accepts any valid string representation of a US state and returns a normalized two character abbreviation of the state. :param state: Type: String Default: None Description: String representation of a US state :return: If a valid US state is found, the two character state abbreviation is returned. Otherwise, a ValueError is raised """ zipcode_search = ZipcodeSearchEngine() try: state_zips = zipcode_search.by_state(state) if state: state = state_zips[0] return state.State else: raise ValueError( 'Could not find a valid US state with the given input: {}'. format(state)) except TypeError: raise ValueError( 'Could not find a valid US state with the given input: {}'.format( state))
def get_zip_codes_map(): search = ZipcodeSearchEngine() zipcodes = list() for state in get_states(): # for state in ['New York']: final_response = list() response = search.by_state(state, returns=2000) for r in response: if r['City'] not in [x['City'] for x in final_response]: final_response.append(r) for res in response: if res: zipcodes.append({ 'zip_code': res.Zipcode, 'latitude': res.Latitude, 'longitude': res.Longitude, 'city': res.City, 'state': res.State }) return sorted(zipcodes, key=lambda k: k['state'])
api = Client(apikey) # In[20]: params = {'term': 'Indian', 'limit': 50, 'offset': 0} val = api.business_search(location='New Jersey', **params) df = json_normalize(val, 'businesses') df2 = json_normalize(val) # In[21]: #pip.main(['install','uszipcode']) from uszipcode import ZipcodeSearchEngine search = ZipcodeSearchEngine() res = search.by_state(state='New Jersey', returns=0) resdf = json_normalize(res) zcode = resdf[0] za = zcode.values zc = za[-10:].tolist() zc # In[23]: mdf = pd.DataFrame() for i in zc: params = {'term': 'Indian', 'limit': 50, 'offset': 0} val = api.business_search(location=i, **params) df = json_normalize(val) df2 = json_normalize(val, 'businesses')
ssn = prepare_ssn(df) clean_ssn(df, i, ssn) if len(zip) == 5: set_by_zip(zip, df, i) else: try: L_city = search._find_city(df['City'].values[i], best_match=True) df.iloc[i, df.columns.get_loc('City')] = L_city[0] res = search.by_city(L_city[0]) if (len(res) == 0): try: L_state = search._find_city(df['State'].values[i], best_match=True) df.iloc[i, df.columns.get_loc('State')] = L_state[0] res = search.by_state(L_state[0]) if (len(res) == 0): set_unknown(df, i) else: set_by_state_and_city(res, L_state, df) except ValueError: set_unknown(df, i) else: set_by_city(df, i, res) except ValueError: try: L_state = search._find_city(df['State'].values[i], best_match=True) df.iloc[i, df.columns.get_loc('State')] = L_state[0] res = search.by_state(L_state[0]) if len(res) == 0:
val dd = json_normalize(val) dd dd.head(5) df = json_normalize(val, 'businesses') df.head() df.columns ##package to get all the zipcodes pip.main(['install', 'uszipcode']) from uszipcode import ZipcodeSearchEngine search = ZipcodeSearchEngine() res = search.by_state(state='North Carolina', returns=0) resdf = json_normalize(res) resdf zcode = resdf[0] za = zcode.values za zc = za[-10:].tolist() zc zc.append('28208') zc zc = zc[-1] zc mdf = pd.DataFrame() for i in zc: params = {'term': 'Mexican', 'limit': 50, 'offset': 0}
# data setup db = MySQLdb.connect( host="localhost", # your host, usually localhost user="******", # your username passwd="AshPon", # your password db="where_are_your_stores") # name of the data base cur = db.cursor() sqlStr = ("SELECT njstores.LOCATION_NAME,\ njstores.CITY_NAME \ FROM where_are_your_stores.njstores") # define search object for uszips search = ZipcodeSearchEngine() zipcode = search.by_state('New Jersey', returns=0) # print(zipcode) # for aRec in zipcode: # print (aRec) # start the engine @app.route("/") def homepage(): return render_template("index.html") # define a route called by index and base js # this route will return all the stores information from the file in a list # the file I loaded I will convert it into a list and return it