Exploratory Data Analysis Using SQL.

INTRODUCTION

Two years in the past after I began studying write SQL code and studying work with SQL, it felt complicated and disjointed to me. However now, working with SQL is considered one of my favourite factor to do and I completely get pleasure from analyzing datasets with SQL because it provides an in depth info of the dataset.

On this challenge, I carried out an exploratory evaluation on petrol/fuel costs world wide. The dataset incorporates information of petrol/fuel costs of ALL the international locations on the planet, each day petrol/fuel consumption of every nation ,various costs per liter and barrel as of June, 2022.

Utilizing SQL, I used to be capable of run some queries via the dataset and get solutions to some questions and in addition to get insights.

DATA PREPARATION AND CLEANING.

The dataset was first loaded into Microsoft Excel in an effort to “clear” the dataset, rename the columns, take away outliers and to verify for consistency within the dataset.
Here’s a image of the dataset in Microsoft Excel:

A database was then created in MYSQL, and the dataset was imported into the SQL workbench in an effort to start evaluation.
Image of the dataset after being imported into the SQL workbench:

Image description

Image description

ANALYSIS

Evaluation was completed to get solutions to some crucial questions and to get an understanding of the dataset.

PETROL/ GAS CONSUMPTION AROUND THE WORLD.

1)To begin with, I needed to know the entire sum of barrel of petrol/fuel consumed by the whole world each day.

Image description

The question above exhibits the world consumes 96,576,722 barrels of petrol/ fuel each day, as of June 2022.

2.Nation with the best petrol/fuel consumption each day:

Image description

The USA of America consumes essentially the most petrol/fuel each day.
19,687,287 barrels per day.

3.Nation with the least petrol/ fuel consumption each day:

Image description

Niue consumes the least petrol/ fuel on the planet. 51 barrels per day.
Till whereas finishing up this evaluation, I didn’t know of the nation known as Niue, needed to google it up and realized it’s a rustic with a mean of 1,620 individuals, positioned within the Oceania continent.

4.High 5 international locations with the best each day oil consumption:

Image description

USA, China, India, Japan and Russia consumes essentially the most petrol/fuel each day .

5.Backside 5 international locations with the bottom oil consumption world wide:

Image description

Niue, Salt Helena, Monsterrat, Kiribati, Saint Pierre & Miquelon consumes the least petrol/ fuel world wide.

PETROL/ GAS PRICE ANALYSIS AROUND THE WORLD:

1.Nation with the best worth for a liter of petrol/fuel.

Image description

North Korea sells a liter of petrol/fuel for $14.5!
Wow!

2.Nation with the least worth for a liter of petrol/fuel:

Image description

Venezuela sells the most affordable petrol/fuel on the planet, with a liter going for a paltry $0.02 greenback.

3.Nation with the best and lowest worth per gallon :

Image description

Image description

According to the info above, North Korea and Venezuela sells petrol/ fuel for the best and least expensive worth per gallon respectively.

4.High 5 international locations with the most costly worth for a liter of petrol/fuel:

Image description

North Korea, Tonga, Niue, Honk Kong, and Norway sells a liter of petrol/fuel for the most costly quantity.

5.Backside 5 international locations with the most affordable worth for petrol/ fuel:

Image description

Venezuela, Libya, Iran, Brunei and Syria sells a liter of petrol/ fuel for the most affordable costs.

        ******
Enter fullscreen mode

Exit fullscreen mode

Thanks for studying!

Feedback and strategies, please do ship a mail: heyfunmi@gmail.com

Add a Comment

Your email address will not be published. Required fields are marked *