Back to Projects

Business Distance Calculator

PythonPandasGeocodingExcelData Analysis

Developed for the data consultancy Ray Consulting, the Business Distance Calculator imports Excel spreadsheets with business data, filters energy sector companies, and calculates distances between them using geographic coordinates. It integrates Google’s Geocoding API and applies the Haversine formula for accurate distance calculations, exporting results to Excel with detailed metrics.

Project Goals

  • Import and process large sets of business data
  • Filter energy and gas companies intelligently
  • Convert addresses into geographic coordinates (geocoding)
  • Accurately calculate distances using the Haversine formula
  • Export results and metrics to Excel spreadsheets

My Role

Developer responsible for data processing logic and user-focused output.

Business Distance Calculator

Documentação do Projeto

Project Overview

Project Overview

Documento PDF

Clique para baixar

Other Projects

12 Motivos

12 Motivos

Interactive platform for creating personalized romantic pages with custom animations and music.

Next.jsReactTailwind CSS
Primu's Log

Primu's Log

A modern logistics company website with a focus on user experience and clear information architecture.

wordpressjavascriptLogistics
Natural da Vaca

Natural da Vaca

Premium website for a dairy products company showcasing their history and product offerings.

wordpressjavascriptLogistics