{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"source": [
"# Sujet 1 : Concentration de CO2 dans l'atmosphère depuis 1958"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Traitement des données : pre-processing"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"outputs": [],
"source": [
"%matplotlib inline\n",
"import matplotlib.pyplot as plt\n",
"import pandas as pd\n",
"import isoweek\n",
"import numpy as np"
]
},
{
"cell_type": "markdown",
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"source": [
"Extraction des données depuis l'url et création d'une copie locale :"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"outputs": [],
"source": [
"data_url = 'https://scrippsco2.ucsd.edu/assets/data/atmospheric/stations/in_situ_co2/weekly/weekly_in_situ_co2_mlo.csv'"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"outputs": [],
"source": [
"# read data from url (and delete header)\n",
"raw_data = pd.read_csv(data_url, skiprows=44, names=['date','CO2'])\n",
"# path for local copy\n",
"file = '/home/jovyan/work/module3/exo3/weekly_in_situ_co2_mlo.csv'\n",
"# check existing local copy\n",
"try:\n",
" local_data = pd.read_csv(file)\n",
"# if no local copy, create it\n",
"except FileNotFoundError:\n",
" raw_data.to_csv('weekly_in_situ_co2_mlo.csv')\n",
"# read local copy\n",
"raw_data = pd.read_csv('weekly_in_situ_co2_mlo.csv')"
]
},
{
"cell_type": "markdown",
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"source": [
"Vérification et suppression de données manquantes :"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"hideCode": false,
"hidePrompt": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Unnamed: 0 | \n",
" date | \n",
" CO2 | \n",
"
\n",
" \n",
" \n",
" \n",
"
\n",
"