Shark-Attack

Project Overview

The project details about the various species of sharks and their attacks over the past 100 years in various countries of the world on various victims (male or female), young or old and the body parts of attacks.

Data Source

The datatset is a csv file format, made available courtsey of Quantum Analytics. Download Here

Tools

-Excel - For filtering and Cleaning -Power BI - For conditional formatting -Tableau - For visualization

Data Cleaning/ Preparation

In the initial data preparation phase , we performed the following tasks:

• Data loading on Microsoft Excel

• Inspection for missing values, wrong spellings and variable type

• Filtering and editting misspellings and grouping of species

• conditional formatting in Power Query for the age band

• Date transformation for time of day of attack.

• Text analysis on the Injury column

  Exploratory Data Analysis

  • Trend of annual number of shark attacks since 1900
  • Countries with the most Shark Attacks.
  • What time of day was the attack prevelant, are attacks more comon during the day or night or during the afternoon?
  • Body part mostly attacked?
  • Which species of shark are attacking most often?
  • Whats the age band of the victims, and which age band was mostly attacked?

Result/Findings

• With an over 900 attacks, Juvenile Sharks were the verocious species of sharks within this period
• Sharks attack predominately during the afternnon, followed by in the morning and little at night.
• More attacks were recoreded in the USA with over 2000 attacks as aginst any other countries.
• Most Attacks were Fatal, as most body parts were missing or completely gone.
• Young Adults and Teens were mostly the victims.

Recommendations

• More research should be done as to know why Sharks attack during the afternoons, is it because of the water temperature or weather conditions and the likes.
• More awareness should be made to address the issues in localities te attacks has takken place over the time.
• Adults and Teens should be made aware of what to do incase of shark attacks, also publicity that would better inform them on measureed to taje before diving into water to prevent such attacks should be put in place.
• This shark predominat to each area can be studied to better understand their pattern and futher prevent attacks.

Interact with the dashoard Here