Site Visits Analysis

Python • SQL • Data Visualization

Taux de rebond par région France et Espagne

Project Overview

This project analyzes visits to a website, focusing on the bounce rate in different regions of France and Spain. The goal is to understand visitor behavior and visualize which regions tend to leave the site quickly.

  • Language: Python & SQL
  • Libraries: pandas, geopandas, matplotlib
  • Concepts: Data analysis, visualization, database queries

Project Screenshots

Python code for data analysis

Python code used to compute the bounce rate per region and merge it with geographical data.

SQL query for site visits

SQL query to count visits per country and filter data based on user selection.

What I Learned

Through this project, I improved my skills in Python data analysis and . I also learned to write SQL queries to extract and filter data from databases efficiently.

Additionally, I gained experience presenting complex data visually in a way that is understandable even for non-technical users.