What's the best way to solve this?
Block them and go back to watching anime
>>56498585
simple! But there's a lot of options. Personally, I'd just do the following.
Step 1.) Download zip code database
Step 2.) Python script that recursively searches zip_code_db and appends the location to the CSV
Also, happy birthday Anon.
Happy Birthday, OP
>>56498585
Python script.
Use module to read excel docs. For each row in zipcode column send curl or wget to zipcode lookup URL. The lookup probably uses a GET parameter for the query. Scrape results. Profit?
>>56498718
This. "Fuck you, pay me".
>iterate over the list of zip codes
>for each one, use curl to plug it into that search form
>scrape out the data you want from result of each search
>done
Very simple shit, like computer use 101
Just noticed it was an excel file, this would be even easier then. Literally what Excel is for
http://ws.cdyne.com/psaddress/addresslookup.asmx
Literally the 2nd result on DuckDuckGo
http://congressional-district.insidegov.com/
Happy birthday op, use python like other anons said. Read in csv with pandas, then use
>>56498881
To make a dictionary of district plus zip code.
>>56499420
There's a literal SOAP web service available here >>56498844, why would he even consider doing that?
>>56498585
>it's your birthday
>your faggot friend bothers you with a metnial and easily solveable problem
>oh btw happy birthday
>doing shit for a friend that didn't have the decency to say happy birthday first or at least the temerity to engage in small talk before asking you a favour
Delete them
>>56498585
Convert the column which contains the zip code to csv or some plain text format. You can also use openpyxl and iterate through the column and scrap the info from a web service. But dont. Fuck her. Happy birthday.
>>56498585
>I hope you had a great birthday and that all is well!
lmao
tell her to fuck off.
>>56498585
>Hey Anonette, thanks! Sure, it isn't too difficult. Wanna help me back with something? My dick is currently not being stimulated. Do you know of a way to easily fix that? Like a blowjob or something? Or maybe some kind of anal? I'd appreciate any job you can give me, and if you have no idea, don't worry about it.
>>56500213
this, verbatim.
100% success rate in my experience