Global Carbon Emission from Countries during 1996-2021

This the group project of Team Delta to show global and national fossil carbon dioxide (CO2) emission for 26 years from year 1996 to year 2021. This project is developed with Django and deployed in Render. Visit this link https://delta-emission.onrender.com to access the website.

Data shown in the website is extracted from https://www.kaggle.com/datasets/thedevastator/global-fossil-co2-emissions-by-country-2002-2022?select=GCB2022v27_sources_flat.csv produced by The Devastator by quantifying sources and emission levels. Such data is retrieved from the Global Carbon Project's fossil CO2 emissions dataset: 2022 release by Robbie Andrew and Glen P. Peters, CICERO Center for International Climate Research.

Main features of the website

Filtering function is implemented in many parts of the website with different criteria.

• Total CO2 emissions table (country, year)
• Per Capita CO2 emissions table (country, year)
• Total CO2 emissions line graph (country, material)
• Total CO2 emissions bar graph (country, material)
• Per Capita CO2 emissions line graph (country, material)
• Per Capita CO2 emissions bar graph (country, material)

Data visual components are implemented in the website

• Total CO2 emissions line and bar graph (country, material)
• Per Capita CO2 emissions line and bar graph (country, material)

Templates in the website

There are 3 sets of templates in this web application.

• Landing Page (index.html)
• Total CO2 emissions Page (total.html)
  • Table
    • Showing annual CO2 emissions data rows from all countries and all years with proper pagination
    • Drop down search bar implemented for countries and years
      • Table showing annual CO2 emissions data rows with selected country or year (total_filter.html)
  • Data Visual
    • Showing line or bar graph for annual CO2 emissions with selected country and material (totalemission_graph.html)
• Per Capita CO2 emissions Page (per_capita.html)
  • Table
    • Showing per capita CO2 emissions data rows from all countries and all years with proper pagination
    • Drop down search bar implemented for countries and years
      • Table showing per capita CO2 emissions data rows with selected country or year (total_filter.html)
  • Data Visual
    • Showing line or graph for per capita CO2 emissions with selected country and material (totalemission_graph.html)

Models in the application

The database model comprises 4 Class objects

• Year
  • This table refers to the dates in years where the CO2 emission of each country is considered
  • The objects in the Year table were populated by iterating from the range 1996-2021 and this will be used mainly for handling search/filtering requests
• Country
  • This table shows the countries and locations where the CO2 emissions from the different elements are produced
• TotalEmission
  • This table gives the total emission of CO2 produced by the different sources i.e. coal, gas, oil, cement production in a country in a year
• PerCapitaEmission
  • This table refers to the breakdown of the CO2 emission per capita per country within the years considered The objects for tables other than the Year were parsed from the CSV files in the data directory. The parse program was written so that it deletes existing tables in the database and recreate them again when run

Basic setup of the virtual environment

A virtual environment with Python version 3.10.7 is created. Run the following code in the terminal inside the project folder to setup the required virtual environment.

pyenv update
pyenv install 3.10.7
pyenv local 3.10.7
python3 -m venv .venv
source .venv/bin/activate
pip install --upgrade pip
pip install django
pip install whitenoise

For later times for open the previously created virtual environment, run the following code in the project folder.

source .venv/bin/activate

Reset database

For database regeneration, use the following command after deleting the file db.sqlite3

python3 manage.py migrate

To generate migration folder and files, use the following command:

python3 manage.py makemigrations emission

To run the generated migration, use the following command:

python3 manage.py migrate emission

To parse the data from csv files in data folder into the database, run the following command:

python3 manage.py parse_csv

Start the server

For starting the server in local machine, run the following command in terminal:

python3 manage.py runserver

For starting the server in Codio, run the following command in Codio terminal:

python3 manage.py runserver 0.0.0.0:8000

Maintenance

Latest code is pulled from GitHub for Render deployment. At most two websites can be opened at once from the Render deployed link. The number of rows of data in the two data CSV files can be increased and include data from more number of years. However, the server ability on Render should also be considered when doing such decision.

Generate git log using the following command:

git log --pretty=format:"%h - %an, %ad : %s" --graph > git-log.txt

Testing

Django tests for filter function, graph, HTML pages, views, model setup and data input are implemented.

If you change anything in the static folder, please run this command before running the next command:

python3 manage.py collectstatic

For running tests, run the following command in the terminal:

python3 manage.py test

Documents

Git-log: git-log.txt

One page design and development report: CS551Q Team Delta one-page report.pdf

License

MIT License

Copyright (c) 2023 Cloudy030

Documentation

Documentation is placed in the code's comments.

Background

This is an assessment of course Enterprise Software Development (CS551Q) for Master of Information Technology (MScIT) from University of Aberdeen (UoA). It is required to develop a database-driven web application using Django and deploy the developed website with Render.

This is a production of Team Delta in March 2023.

Team Delta

• Amaldev Edamana Sudhakaran (ESAmadev)
• Chinedu Ezeokoye (dunechee)
• Ogugua Ezedozie (Gugusjay)
• Pok Nga Ho (Cloudy030)
• Tasnim Fateha (tasnimfeteha)
• Zishuo Liu (dingzhen00)