Python Developer Needed to Build Simple FMCSA Carrier Lead Filtering Tool for Marketing Split Test

Python Developer Needed to Build Simple FMCSA Carrier Lead Filtering Tool for Marketing Split Test ## Project Overview I am looking for a Python developer/data automation specialist to build a simple, beginner-friendly tool that helps me filter FMCSA/DOT Motor Carrier Census CSV data for a marketing split test. I am not a technical user, so the tool needs to be easy for me to run after it is built. I would also like the developer to teach me how to use it through a short Zoom session or recorded walkthrough. The goal is to take an exported FMCSA carrier CSV file and automatically create clean lead lists for two different marketing campaigns. ## What I Need Built I need a Python-based script or simple desktop-friendly tool that can process an FMCSA Motor Carrier Census CSV file and create two separate campaign lists. ### Campaign A: Georgia Small Carrier List Filter for: * State: Georgia * Carrier status: Active * Entity type: Carrier * Power units: 1 to 11 * CDL drivers/drivers: 1 to 9 * Exclude inactive, pending, broker-only, shipper-only, zero power unit, and zero driver records * Prefer records with MCS-150 updates within the last 24 months if that field is available Campaign code: GA-SMALL-01 ### Campaign B: Cobb/Cherokee Local Carrier List Filter for: * Georgia carriers located in Cobb County or Cherokee County * Use physical ZIP code filtering for Cobb and Cherokee County * Carrier status: Active * Entity type: Carrier * CDL drivers/drivers: 1 to 20 * Power units: 1 to 30, unless otherwise adjusted * Exclude inactive, pending, broker-only, shipper-only, zero power unit, and zero driver records * Prefer records with MCS-150 updates within the last 24 months if that field is available Campaign code: LOCAL-COBB-CHEROKEE-01 ## Required Output Files The tool should export the following CSV files: 1. `01_GA_SMALL_CARRIERS.csv` 2. `02_COBB_CHEROKEE_LOCAL_CARRIERS.csv` 3. `03_COMBINED_SPLIT_TEST_MASTER.csv` 4. Optional: `04_EXCLUDED_RECORDS_REVIEW.csv` The combined master file should include the campaign code so I can upload the records into my CRM and track campaign results separately. ## Required Columns in Output The final files should include as many of these columns as are available from the source file: * Campaign code * USDOT number * Legal name * DBA name * Physical address * Physical city * Physical state * Physical ZIP * Mailing address * Phone number * Email address * Entity type * Operating status * Power units * Drivers/CDL drivers * MCS-150 date * Operation type * Carrier operation * Cargo carried, if available * Lead score * Lead tier * Notes ## Lead Scoring I would like the script to score each lead so I know which carriers to contact first. Suggested scoring model: * Active carrier: +10 * Georgia physical address: +5 * Cobb/Cherokee ZIP code: +8 * 1–9 drivers: +5 * 10–20 drivers: +4 * 1–11 power units: +5 * 12–30 power units: +3 * MCS-150 updated within last 24 months: +4 * Has phone number: +3 * Has email address: +3 * Interstate operation: +4, if available Lead tiers: * A Tier: 28+ points * B Tier: 20–27 points * C Tier: under 20 points ## Important Requirements The tool should: * Work from a CSV file that I export from FMCSA or a related DOT data source * Be able to handle different possible column names in the source file * Deduplicate records by USDOT number * Prevent the same carrier from appearing in both campaign lists, if possible * Sort the best leads first * Create clean CSV files that can be opened in Excel or uploaded to a CRM * Include clear error messages if required columns are missing * Not rely on scraping SAFER one carrier at a time * Be easy for a non-technical person to run ## Preferred User Experience Ideally, I would like one of the following: Option 1: A simple Python script with clear written instructions. Option 2: A script plus a Windows batch file that lets me double-click to run it. Option 3: A very simple interface where I can select the input CSV file and click a button to generate the output files. Please mention in your proposal which option you recommend. ## Training Requirement I need the developer to teach me how to use the program. Please include: * A short Zoom walkthrough or recorded Loom video * Written step-by-step instructions * Explanation of where to place the FMCSA CSV file * Explanation of how to run the tool * Explanation of where the output files will appear * Explanation of how to adjust filters like number of drivers, power units, ZIP codes, and MCS-150 date range ## Deliverables Final deliverables should include: 1. Working Python script or simple desktop-friendly tool 2. Any required dependency/install instructions 3. Sample test run using a CSV file 4. Exported sample output files 5. Written user guide 6. Short training video or live walkthrough 7. Handoff session to make sure I can run it myself ## Ideal Freelancer The ideal person has experience with: * Python * pandas * CSV data processing * Data cleaning * Lead list filtering * Beginner-friendly automation * Creating simple instructions for non-technical business owners Experience with FMCSA/DOT datasets is a plus, but not required if you are comfortable working with CSV data and mapping column names. ## Proposal Instructions When you apply, please answer these questions: 1. Have you built CSV filtering or lead list automation tools before? 2. Can you make this easy for a non-technical person to run? 3. Would you recommend a simple script, double-click batch file, or basic interface? 4. How would you handle FMCSA files with different column names? 5. Can you provide a short training video or live walkthrough? 6. How long would this project take? 7. What fixed price would you charge? ## Budget Please quote a fixed price for the full project, including the tool, documentation, and training. I am looking for a practical, reliable solution rather than an overly complicated system.