How can I get started on a Data Project? A simple example

First Steps: The (not so) great expectations

Step 2: Honing your questions

  1. By how much has CO2 emission increased since 1950’s?
  2. Which type of fuel has contributed the most to CO2 emissions in the last 50 years?
  3. Who are the major emitters?

Step 3: Begin Cleaning and Analysing the Data

  Date Decimal Date Average Interpolated Trend Number of Days
0 1958–03–01 1958.208 315.71 315.71 314.62 -1
1 1958–04–01 1958.292 317.45 317.45 315.29 -1
2 1958–05–01 1958.375 317.50 317.50 314.71 -1
3 1958–06–01 1958.458 -99.99 317.10 314.85 -1
4 1958–07–01 1958.542 315.86 315.86 314.98 -1
Rows: 727
Date  Decimal Date  Average  ...   Trend  Number of Days  year
0 1958-03-01 1958.208 315.71 ... 314.62 -1 1958
1 1958-04-01 1958.292 317.45 ... 315.29 -1 1958
2 1958-05-01 1958.375 317.50 ... 314.71 -1 1958
4 1958-07-01 1958.542 315.86 ... 314.98 -1 1958
5 1958-08-01 1958.625 314.93 ... 315.94 -1 1958
Rows: 720
year   Average            
1958 315.331250
1959 315.974167
1960 316.907500
1961 317.637500
1962 318.450833
rows: 61
Average CO2 emission per year from 1958 –2018.
Year  Total  Gas Fuel  ...  Cement  Gas Flaring  Per Capita
1751 3 0 ... 0 0 NaN
1752 3 0 ... 0 0 NaN
1753 3 0 ... 0 0 NaN
1754 3 0 ... 0 0 NaN
1755 3 0 ... 0 0 NaN
... ... ... ... ... ... ...
2006 8370 1525 ... 356 61 1.27
2007 8566 1572 ... 382 68 1.28
2008 8783 1631 ... 388 71 1.30
2009 8740 1585 ... 413 66 1.28
2010 9167 1702 ... 450 59 1.33
Left: Total CO2 emission from all fuel from 1950–2010. Right: CO2 emission per capita between 1950–2010.
Year         Country         ...    Per Capita  
1751 UNITED KINGDOM ... 0.00 1752 UNITED KINGDOM ... 0.00
1753 UNITED KINGDOM ... 0.00
1754 UNITED KINGDOM ... 0.00
1755 UNITED KINGDOM ... 0.00
... ... ... ...
2014 VIET NAM ... 0.49
2014 Zimbabwe ... 0.22
Top: five biggest CO2 emitting nations. Bottom: bottom five emitting nations.
Top 5 highest per capita emitters

Getting the Project Out

Final Words

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Safal Mukhia

Safal Mukhia

6 Followers

I am a data analyst with a background in philosophy, cognitive science and mathematics, interested in learning, creating and sharing!