Skip to content

anri-Tvalabeishvili/Analysis-Of-Georgian-Data

Repository files navigation

💻 Analysis of Georgian Data

This repository processes three main types of data: vehicles, suicide and suicide attempts, issuing and registering driving licenses.

Due to the fact that the data are taken from the official website of the Ministry of Internal Affairs of Georgia, data is given in Georgian. Thus, the results obtained after processing and visualization are given in Georgian.

Processing details are provided in the form of comments in English.

Used Data and their sources

Vehicles-Statistic (Means of transportation) : https://info.police.ge/page?id=121
Suicide-Statistic (Suicide and suicide attempts) : https://info.police.ge/page?id=107
Driving-License-Statistic (Issuance and registration of driving licenses) : https://info.police.ge/page?id=110
Currency-Exchange-Rate-Statistic ( GEL exchange rate) : https://nbg.gov.ge/statistics/statistics-data

Tech/Framework used :

  • Python (3.9.7)
  • Excel
  • Power BI
  • NumPy library (1.21.2)
  • Pandas library (1.3.4)
  • Matplotlib library (3.4.3)
  • Jupyterlab (Notebook) (3.2.1)

🚗 Description of Vehicles-Statistic :

The data are taken from the official website of the Ministry of Internal Affairs of Georgia.

The data refer to the vehicles that were sold, imported and registered in Georgia in 2017-2020.

Data are processed by: transport type, body type, manufacturer type, model type, color type, fuel type, owner type, and regions.

The data was processed using Excel, Python and Power BI.

⚰️ Description of Suicide-Statistic :

The data are taken from the official website of the Ministry of Internal Affairs of Georgia.

The data show the facts of suicide and suicide attempts on the territory of Georgia in 2017-2020.

Only data of Georgian citizens are processed by: age, sex and regions.

The data was processed using Excel and Power BI.

💳 Description of Driving-License-Statistic :

The data are taken from the official website of the Ministry of Internal Affairs of Georgia.

The data show the statistics of driving licenses issued in 2017-2020.

The data also show the statistics of driving licenses registered on the territory of Georgia from 2006 to 2020

Only data of Georgian citizens are processed by: age, sex and regions.

The data was processed using Excel and Power BI.

💱 Description of Currency-Exchange-Rate-Statistic :

The data are taken from the official website of the National Bank of Georgia.

The data show the statistics of national currency exchange rate in 2003-2021.

The processed data show the GEL exchange rate against the USD, EUR and GBP.

The data was processed using Excel and Power BI.

ℹ️ About me:

Linkedin : https://www.linkedin.com/in/anri-tvalabeishvili/
Facebook : https://www.facebook.com/Anri.Tvalabeishvil
Github : https://github.com/anri-Tvalabeishvili
stackoverflow : https://stackoverflow.com/users/17742066/anri-tvalabeishvili