Run Python Script for Restaurant/Winery Data
Budget: $30 – $250 USD
Freelance Job Brief: Run a Python Script to Pull Restaurant/Winery Data
What I need
I have a Python script already written that needs to be run once. It connects to the Yelp API and pulls restaurant, winery, and wine bar data for 48 U.S. cities/towns, then saves the results into an Excel file. I need someone to run this script for me and send me back the resulting Excel file.
What you'll need to do
Get a free Yelp Fusion API key (yelp.com/developers/v3/manage_app) — sign in with a Yelp account, create an app, copy the API key. Takes about 5 minutes.
Install Python packages: pip install requests openpyxl
Add the API key to the script (one line near the top, clearly marked)
Run the script: python3 all_locations_pull.py
Send me back the output file: all_locations_pull.xlsx (this is generated automatically by the script — you don't need to build anything, just run it)
Estimated time
The script itself takes 2-4 minutes to run once set up. Total time including setup should be well under an hour for anyone with basic Python experience.
Deliverable
The all_locations_pull.xlsx file the script generates, with two tabs:
Summary: restaurant, winery, and wine bar counts for all 48 locations
Detail: full list of individual businesses found, with names, ratings, and addresses
Requirements
Comfortable running Python scripts from the command line
Able to sign up for a free Yelp developer account
No coding changes needed — the script is complete and tested; it just needs to be executed
What I'm providing
The complete, ready-to-run Python script (attached: all_locations_pull.py)
Clear instructions are included as comments at the top of the script itself
Notes
I will not be sharing my own Yelp API key — please use your own free one, since it's free and takes just a few minutes to create
Please don't modify the script's logic — just add your API key and run it
If you hit any errors, send me a screenshot along with the file
What I need
I have a Python script already written that needs to be run once. It connects to the Yelp API and pulls restaurant, winery, and wine bar data for 48 U.S. cities/towns, then saves the results into an Excel file. I need someone to run this script for me and send me back the resulting Excel file.
What you'll need to do
Get a free Yelp Fusion API key (yelp.com/developers/v3/manage_app) — sign in with a Yelp account, create an app, copy the API key. Takes about 5 minutes.
Install Python packages: pip install requests openpyxl
Add the API key to the script (one line near the top, clearly marked)
Run the script: python3 all_locations_pull.py
Send me back the output file: all_locations_pull.xlsx (this is generated automatically by the script — you don't need to build anything, just run it)
Estimated time
The script itself takes 2-4 minutes to run once set up. Total time including setup should be well under an hour for anyone with basic Python experience.
Deliverable
The all_locations_pull.xlsx file the script generates, with two tabs:
Summary: restaurant, winery, and wine bar counts for all 48 locations
Detail: full list of individual businesses found, with names, ratings, and addresses
Requirements
Comfortable running Python scripts from the command line
Able to sign up for a free Yelp developer account
No coding changes needed — the script is complete and tested; it just needs to be executed
What I'm providing
The complete, ready-to-run Python script (attached: all_locations_pull.py)
Clear instructions are included as comments at the top of the script itself
Notes
I will not be sharing my own Yelp API key — please use your own free one, since it's free and takes just a few minutes to create
Please don't modify the script's logic — just add your API key and run it
If you hit any errors, send me a screenshot along with the file
Related categories:
PHP
Python
Excel
Web Scraping
Software Architecture
Data Extraction
API
Data Analysis