Carbon Emissions and Sea Level by Year
Uses Pandas and BS4 to read in the two data files:
Co2.html
200242002.292... 200252002.375... 200262002.458...SeaLevel.csv
2002.3797,3.43000,1.23000,, 2002.4069,1.13000,0.33000,, 2002.4340,-5.67000,-2.17000,,
Both files have monthly/daily data. Python iterators and reducers are used to handle converting data to annual.
Data is stored in a Pandas Dataframe after getting converted. Users can select a year to view the data for.
Database:
Stores the Dataframes in an SQLite data base. Uses a class to interface to the SQLite database:
class Database:
def __init__(self):
self.db = sqliteConnection()
...
Class has functionality for table creation, inserting, searching and deleting entries in the database.
Shows insertion and deletion with database, and accessing emissions/ sea level data for a selected year through user input
TOPEX/Poseidon Sea Level data begins at 1992