In [1]:
import agate
text = agate.Text()
number = agate.Number()
mean_temps = agate.Table.from_csv('mon_temps_lnk.csv')
In [2]:
print(mean_temps)
mon_averages = {'JAN':24.6, 'FEB':29,'MAR':40.1,'APR':51.6,'MAY':62.3,'JUN':72.6,'JUL':77.6,'AUG':75.3,'SEP':66,'OCT':53.2,'NOV':38.9,'DEC':26.8,'Annual':51.6}
mon_temps = mean_temps.where(lambda row: row['Year'] != 'Averages')
print(len(mon_temps.rows))
mon_temps.print_table(50)
|---------------+---------------|
| column_names | column_types |
|---------------+---------------|
| Year | Text |
| JAN | Number |
| FEB | Number |
| MAR | Number |
| APR | Number |
| MAY | Number |
| JUN | Number |
| JUL | Number |
| AUG | Number |
| SEP | Number |
| OCT | Number |
| NOV | Number |
| DEC | Number |
| Annual | Number |
|---------------+---------------|
129
|-------+------+------+------+------+------+------+------+------+------+------+------+------+---------|
| Year | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Annual |
|-------+------+------+------+------+------+------+------+------+------+------+------+------+---------|
| 2015 | 28.1 | 21.6 | 43.3 | 54.0 | 61.5 | 73.4 | 77.1 | 73.8 | 71.4 | 57.1 | 44.9 | 33.6 | 53.3 |
| 2014 | 22.3 | 22.5 | 37.1 | 52.7 | 65.2 | 73.9 | 75.0 | 76.1 | 65.6 | 55.2 | 34.6 | 31.4 | 51.1 |
| 2013 | 25.2 | 29.9 | 34.8 | 46.1 | 61.5 | 71.8 | 75.8 | 76.1 | 70.6 | 51.7 | 36.7 | 22.2 | 50.2 |
| 2012 | 30.0 | 30.6 | 55.0 | 56.0 | 66.9 | 75.1 | 81.3 | 74.3 | 64.6 | 49.5 | 41.3 | 27.9 | 54.5 |
| 2011 | 18.4 | 26.9 | 39.4 | 51.6 | 61.8 | 72.9 | 81.5 | 75.5 | 61.5 | 55.6 | 39.9 | 29.2 | 51.2 |
| 2010 | 18.0 | 28.3 | 41.0 | 55.6 | 60.5 | 74.2 | 77.8 | 78.1 | 66.3 | 55.4 | 39.1 | 25.0 | 51.1 |
| 2009 | 23.9 | 31.1 | 40.0 | 50.1 | 63.9 | 72.3 | 72.6 | 72.3 | 64.4 | 46.2 | 44.0 | 19.7 | 50.0 |
| 2008 | 22.6 | 25.6 | 38.3 | 47.3 | 60.4 | 72.8 | 78.6 | 75.4 | 65.5 | 54.4 | 39.7 | 23.0 | 50.6 |
| 2007 | 23.7 | 23.9 | 48.0 | 50.3 | 65.9 | 72.5 | 79.2 | 79.5 | 67.1 | 57.4 | 39.5 | 24.2 | 52.6 |
| 2006 | 36.7 | 29.7 | 39.5 | 55.5 | 64.7 | 74.3 | 80.2 | 75.7 | 63.2 | 50.5 | 40.1 | 33.5 | 53.6 |
| 2005 | 21.0 | 33.6 | 41.3 | 54.0 | 62.0 | 75.3 | 79.4 | 75.0 | 70.3 | 54.9 | 42.2 | 24.7 | 52.8 |
| 2004 | 21.7 | 25.4 | 45.0 | 53.4 | 64.5 | 69.0 | 73.6 | 71.6 | 70.1 | 54.9 | 41.9 | 30.9 | 51.8 |
| 2003 | 24.3 | 24.6 | 40.5 | 52.7 | 59.4 | 69.2 | 79.1 | 77.7 | 62.3 | 55.3 | 37.8 | 30.5 | 51.1 |
| 2002 | 29.9 | 31.0 | 32.8 | 52.7 | 59.5 | 77.7 | 80.6 | 76.3 | 67.6 | 46.7 | 37.6 | 32.0 | 53.9 |
| 2001 | 26.6 | 21.3 | 36.1 | 54.8 | 63.9 | 71.4 | 79.8 | 76.5 | 65.4 | 53.2 | 48.4 | 32.5 | 52.5 |
| 2000 | 28.2 | 36.0 | 44.2 | 51.4 | 66.5 | 71.7 | 76.2 | 79.0 | 67.8 | 56.5 | 32.3 | 15.8 | 52.1 |
| 1999 | 23.5 | 37.3 | 39.1 | 50.8 | 61.6 | 70.2 | 80.6 | 73.9 | 64.0 | 53.6 | 46.6 | 31.7 | 52.7 |
| 1998 | 25.6 | 36.3 | 32.3 | 50.9 | 66.1 | 70.4 | 77.9 | 76.2 | 71.3 | 55.9 | 43.6 | 30.9 | 53.2 |
| 1997 | 20.6 | 29.8 | 42.1 | 45.1 | 57.5 | 72.6 | 77.6 | 73.6 | 67.6 | 53.8 | 35.8 | 29.5 | 50.6 |
| 1996 | 18.4 | 30.4 | 33.0 | 49.9 | 59.3 | 73.0 | 73.8 | 72.3 | 63.2 | 54.1 | 32.6 | 23.1 | 48.7 |
| 1995 | 23.6 | 32.5 | 39.4 | 47.6 | 56.6 | 70.9 | 78.1 | 79.5 | 63.9 | 53.1 | 34.9 | 28.2 | 50.8 |
| 1994 | 20.8 | 21.8 | 41.5 | 50.3 | 62.9 | 73.6 | 72.6 | 71.7 | 66.1 | 53.6 | 40.5 | 28.3 | 50.5 |
| 1993 | 17.3 | 20.6 | 35.9 | 47.5 | 60.3 | 69.0 | 76.0 | 75.0 | 59.6 | 50.3 | 35.1 | 30.5 | 48.3 |
| 1992 | 34.4 | 37.3 | 43.7 | 51.5 | 62.2 | 69.5 | 72.8 | 70.2 | 65.5 | 53.8 | 33.8 | 26.4 | 51.8 |
| 1991 | 18.1 | 37.6 | 44.2 | 54.6 | 66.6 | 76.6 | 78.1 | 76.2 | 67.6 | 52.9 | 31.7 | 33.6 | 53.2 |
| 1990 | 33.8 | 31.7 | 42.7 | 51.1 | 59.5 | 75.3 | 76.5 | 76.7 | 70.5 | 55.0 | 44.7 | 23.4 | 53.5 |
| 1989 | 33.5 | 16.3 | 38.8 | 54.8 | 62.2 | 70.5 | 78.3 | 75.0 | 63.3 | 54.4 | 37.8 | 19.0 | 50.5 |
| 1988 | 21.5 | 25.9 | 41.3 | 51.0 | 67.6 | 77.8 | 77.8 | 78.3 | 67.6 | 50.7 | 41.3 | 31.7 | 52.8 |
| 1987 | 29.6 | 37.2 | 41.8 | 55.1 | 67.3 | 75.8 | 79.4 | 72.8 | 65.7 | 48.4 | 43.9 | 32.3 | 54.2 |
| 1986 | 32.6 | 26.2 | 45.8 | 53.2 | 63.1 | 75.4 | 78.6 | 71.0 | 68.4 | 53.6 | 35.6 | 30.5 | 53.0 |
| 1985 | 20.1 | 22.5 | 42.6 | 54.9 | 64.5 | 69.0 | 76.0 | 71.3 | 63.5 | 53.8 | 29.0 | 21.4 | 49.2 |
| 1984 | 21.8 | 36.0 | 33.4 | 48.4 | 59.1 | 73.4 | 77.5 | 78.0 | 63.0 | 53.2 | 40.1 | 27.9 | 51.1 |
| 1983 | 26.9 | 31.5 | 39.4 | 45.3 | 58.1 | 71.7 | 81.1 | 83.4 | 69.2 | 54.8 | 39.3 | 8.1 | 50.8 |
| 1982 | 11.9 | 23.4 | 36.3 | 48.3 | 63.4 | 66.7 | 78.9 | 74.1 | 65.1 | 54.6 | 36.8 | 29.9 | 49.3 |
| 1981 | 28.1 | 31.4 | 42.8 | 58.7 | 59.8 | 74.9 | 78.6 | 72.3 | 65.9 | 52.1 | 42.1 | 24.9 | 52.7 |
| 1980 | 23.4 | 22.1 | 35.2 | 52.2 | 62.8 | 74.3 | 82.2 | 78.8 | 66.8 | 51.8 | 42.5 | 28.6 | 51.9 |
| 1979 | 7.2 | 13.0 | 38.4 | 49.6 | 59.7 | 72.1 | 75.0 | 75.2 | 68.6 | 54.4 | 37.3 | 32.3 | 48.8 |
| 1978 | 9.9 | 13.1 | 33.6 | 51.3 | 60.0 | 71.6 | 76.8 | 74.9 | 69.1 | 52.1 | 36.5 | 22.3 | 47.8 |
| 1977 | 13.0 | 31.7 | 43.4 | 56.6 | 68.4 | 74.3 | 80.9 | 72.2 | 66.4 | 51.4 | 38.3 | 25.1 | 51.9 |
| 1976 | 24.2 | 36.9 | 39.2 | 54.3 | 58.9 | 71.6 | 78.1 | 76.2 | 66.8 | 47.2 | 32.1 | 24.3 | 50.9 |
| 1975 | 21.6 | 20.1 | 30.6 | 48.4 | 63.4 | 70.9 | 78.5 | 79.5 | 61.6 | 57.3 | 39.5 | 29.9 | 50.3 |
| 1974 | 15.6 | 31.1 | 42.1 | 51.8 | 62.1 | 70.9 | 83.8 | 70.7 | 60.9 | 56.1 | 39.3 | 26.9 | 51.1 |
| 1973 | 23.4 | 28.4 | 42.6 | 49.5 | 59.0 | 73.3 | 75.0 | 77.2 | 63.2 | 56.1 | 39.0 | 21.8 | 50.8 |
| 1972 | 20.8 | 25.0 | 41.5 | 49.5 | 60.7 | 71.2 | 74.1 | 72.3 | 65.1 | 49.0 | 36.2 | 21.6 | 49.0 |
| 1971 | 16.7 | 23.2 | 35.4 | 52.9 | 58.8 | 76.8 | 74.0 | 74.8 | 65.9 | 57.0 | 37.3 | 29.3 | 50.3 |
| 1970 | 16.9 | 32.9 | 36.1 | 52.9 | 67.4 | 73.4 | 78.0 | 76.5 | 65.0 | 50.1 | 37.1 | 28.5 | 51.3 |
| 1969 | 17.6 | 24.5 | 30.5 | 53.1 | 63.4 | 68.1 | 77.7 | 75.4 | 67.6 | 49.0 | 40.1 | 24.2 | 49.4 |
| 1968 | 22.5 | 27.6 | 44.3 | 52.1 | 58.3 | 74.3 | 77.0 | 74.7 | 64.4 | 55.0 | 35.8 | 21.9 | 50.8 |
| 1967 | 23.1 | 28.9 | 43.7 | 54.3 | 59.5 | 70.6 | 73.4 | 70.6 | 62.0 | 51.5 | 37.6 | 28.0 | 50.4 |
| 1966 | 17.7 | 27.2 | 42.6 | 46.6 | 61.2 | 72.3 | 81.5 | 72.1 | 63.3 | 54.6 | 38.5 | 26.5 | 50.5 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
|-------+------+------+------+------+------+------+------+------+------+------+------+------+---------|
In [3]:
from decimal import Decimal
class differenceAverage(agate.Computation):
"""
Calculates the difference between normal and each monthly
"""
def __init__(self, month, monthDict):
self._month = month
self._monthDict = monthDict
def get_computed_data_type(self, table):
"""
The return value is a number.
"""
return agate.Number()
def validate(self, table):
"""
Verify the column is a number.
"""
column = table.columns[self._month]
if not isinstance(column.data_type, agate.Number):
raise agate.DataTypeError('Can only be applied to number data.')
def run(self, table):
new_column = []
for row in table.rows:
current = row[self._month]
normal = self._monthDict[self._month]
normal_decimal = Decimal(normal)
diff = current - normal_decimal
new_column.append(diff.quantize(Decimal('0.01')))
return new_column
In [11]:
computations = []
for month in mon_averages.keys():
print(month)
value = differenceAverage(month, mon_averages)
computations.append(('diff_{}'.format(month), value))
new_table = mon_temps.compute(computations)
new_table.print_table()
tables_diff = new_table.select(['Year','diff_Annual'])
SEP
OCT
FEB
APR
JUN
Annual
MAY
AUG
NOV
MAR
JUL
DEC
JAN
|-------+------+------+------+------+------+------+------+------+------+------+------+------+--------+----------+----------+----------+----------+----------+-------------+----------+----------+----------+----------+----------+----------+-----------|
| Year | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Annual | diff_SEP | diff_OCT | diff_FEB | diff_APR | diff_JUN | diff_Annual | diff_MAY | diff_AUG | diff_NOV | diff_MAR | diff_JUL | diff_DEC | diff_JAN |
|-------+------+------+------+------+------+------+------+------+------+------+------+------+--------+----------+----------+----------+----------+----------+-------------+----------+----------+----------+----------+----------+----------+-----------|
| 2015 | 28.1 | 21.6 | 43.3 | 54.0 | 61.5 | 73.4 | 77.1 | 73.8 | 71.4 | 57.1 | 44.9 | 33.6 | 53.3 | 5.4 | 3.9 | -7.4 | 2.4 | 0.8 | 1.7 | -0.8 | -1.5 | 6.0 | 3.2 | -0.5 | 6.8 | 3.5 |
| 2014 | 22.3 | 22.5 | 37.1 | 52.7 | 65.2 | 73.9 | 75.0 | 76.1 | 65.6 | 55.2 | 34.6 | 31.4 | 51.1 | -0.4 | 2.0 | -6.5 | 1.1 | 1.3 | -0.5 | 2.9 | 0.8 | -4.3 | -3.0 | -2.6 | 4.6 | -2.3 |
| 2013 | 25.2 | 29.9 | 34.8 | 46.1 | 61.5 | 71.8 | 75.8 | 76.1 | 70.6 | 51.7 | 36.7 | 22.2 | 50.2 | 4.6 | -1.5 | 0.9 | -5.5 | -0.8 | -1.4 | -0.8 | 0.8 | -2.2 | -5.3 | -1.8 | -4.6 | 0.6 |
| 2012 | 30.0 | 30.6 | 55.0 | 56.0 | 66.9 | 75.1 | 81.3 | 74.3 | 64.6 | 49.5 | 41.3 | 27.9 | 54.5 | -1.4 | -3.7 | 1.6 | 4.4 | 2.5 | 2.9 | 4.6 | -1.0 | 2.4 | 14.9 | 3.7 | 1.1 | 5.4 |
| 2011 | 18.4 | 26.9 | 39.4 | 51.6 | 61.8 | 72.9 | 81.5 | 75.5 | 61.5 | 55.6 | 39.9 | 29.2 | 51.2 | -4.5 | 2.4 | -2.1 | -0.0 | 0.3 | -0.4 | -0.5 | 0.2 | 1.0 | -0.7 | 3.9 | 2.4 | -6.2 |
| 2010 | 18.0 | 28.3 | 41.0 | 55.6 | 60.5 | 74.2 | 77.8 | 78.1 | 66.3 | 55.4 | 39.1 | 25.0 | 51.1 | 0.3 | 2.2 | -0.7 | 4.0 | 1.6 | -0.5 | -1.8 | 2.8 | 0.2 | 0.9 | 0.2 | -1.8 | -6.6 |
| 2009 | 23.9 | 31.1 | 40.0 | 50.1 | 63.9 | 72.3 | 72.6 | 72.3 | 64.4 | 46.2 | 44.0 | 19.7 | 50.0 | -1.6 | -7.0 | 2.1 | -1.5 | -0.3 | -1.6 | 1.6 | -3.0 | 5.1 | -0.1 | -5.0 | -7.1 | -0.7 |
| 2008 | 22.6 | 25.6 | 38.3 | 47.3 | 60.4 | 72.8 | 78.6 | 75.4 | 65.5 | 54.4 | 39.7 | 23.0 | 50.6 | -0.5 | 1.2 | -3.4 | -4.3 | 0.2 | -1.0 | -1.9 | 0.1 | 0.8 | -1.8 | 1.0 | -3.8 | -2.0 |
| 2007 | 23.7 | 23.9 | 48.0 | 50.3 | 65.9 | 72.5 | 79.2 | 79.5 | 67.1 | 57.4 | 39.5 | 24.2 | 52.6 | 1.1 | 4.2 | -5.1 | -1.3 | -0.1 | 1.0 | 3.6 | 4.2 | 0.6 | 7.9 | 1.6 | -2.6 | -0.9 |
| 2006 | 36.7 | 29.7 | 39.5 | 55.5 | 64.7 | 74.3 | 80.2 | 75.7 | 63.2 | 50.5 | 40.1 | 33.5 | 53.6 | -2.8 | -2.7 | 0.7 | 3.9 | 1.7 | 2.0 | 2.4 | 0.4 | 1.2 | -0.6 | 2.6 | 6.7 | 12.1 |
| 2005 | 21.0 | 33.6 | 41.3 | 54.0 | 62.0 | 75.3 | 79.4 | 75.0 | 70.3 | 54.9 | 42.2 | 24.7 | 52.8 | 4.3 | 1.7 | 4.6 | 2.4 | 2.7 | 1.2 | -0.3 | -0.3 | 3.3 | 1.2 | 1.8 | -2.1 | -3.6 |
| 2004 | 21.7 | 25.4 | 45.0 | 53.4 | 64.5 | 69.0 | 73.6 | 71.6 | 70.1 | 54.9 | 41.9 | 30.9 | 51.8 | 4.1 | 1.7 | -3.6 | 1.8 | -3.6 | 0.2 | 2.2 | -3.7 | 3.0 | 4.9 | -4.0 | 4.1 | -2.9 |
| 2003 | 24.3 | 24.6 | 40.5 | 52.7 | 59.4 | 69.2 | 79.1 | 77.7 | 62.3 | 55.3 | 37.8 | 30.5 | 51.1 | -3.7 | 2.1 | -4.4 | 1.1 | -3.4 | -0.5 | -2.9 | 2.4 | -1.1 | 0.4 | 1.5 | 3.7 | -0.3 |
| 2002 | 29.9 | 31.0 | 32.8 | 52.7 | 59.5 | 77.7 | 80.6 | 76.3 | 67.6 | 46.7 | 37.6 | 32.0 | 53.9 | 1.6 | -6.5 | 2.0 | 1.1 | 5.1 | 2.3 | -2.8 | 1.0 | -1.3 | -7.3 | 3.0 | 5.2 | 5.3 |
| 2001 | 26.6 | 21.3 | 36.1 | 54.8 | 63.9 | 71.4 | 79.8 | 76.5 | 65.4 | 53.2 | 48.4 | 32.5 | 52.5 | -0.6 | -0.0 | -7.7 | 3.2 | -1.2 | 0.9 | 1.6 | 1.2 | 9.5 | -4.0 | 2.2 | 5.7 | 2.0 |
| 2000 | 28.2 | 36.0 | 44.2 | 51.4 | 66.5 | 71.7 | 76.2 | 79.0 | 67.8 | 56.5 | 32.3 | 15.8 | 52.1 | 1.8 | 3.3 | 7.0 | -0.2 | -0.9 | 0.5 | 4.2 | 3.7 | -6.6 | 4.1 | -1.4 | -11.0 | 3.6 |
| 1999 | 23.5 | 37.3 | 39.1 | 50.8 | 61.6 | 70.2 | 80.6 | 73.9 | 64.0 | 53.6 | 46.6 | 31.7 | 52.7 | -2.0 | 0.4 | 8.3 | -0.8 | -2.4 | 1.1 | -0.7 | -1.4 | 7.7 | -1.0 | 3.0 | 4.9 | -1.1 |
| 1998 | 25.6 | 36.3 | 32.3 | 50.9 | 66.1 | 70.4 | 77.9 | 76.2 | 71.3 | 55.9 | 43.6 | 30.9 | 53.2 | 5.3 | 2.7 | 7.3 | -0.7 | -2.2 | 1.6 | 3.8 | 0.9 | 4.7 | -7.8 | 0.3 | 4.1 | 1.0 |
| 1997 | 20.6 | 29.8 | 42.1 | 45.1 | 57.5 | 72.6 | 77.6 | 73.6 | 67.6 | 53.8 | 35.8 | 29.5 | 50.6 | 1.6 | 0.6 | 0.8 | -6.5 | 0.0 | -1.0 | -4.8 | -1.7 | -3.1 | 2.0 | 0.0 | 2.7 | -4.0 |
| 1996 | 18.4 | 30.4 | 33.0 | 49.9 | 59.3 | 73.0 | 73.8 | 72.3 | 63.2 | 54.1 | 32.6 | 23.1 | 48.7 | -2.8 | 0.9 | 1.4 | -1.7 | 0.4 | -2.9 | -3.0 | -3.0 | -6.3 | -7.1 | -3.8 | -3.7 | -6.2 |
| 1995 | 23.6 | 32.5 | 39.4 | 47.6 | 56.6 | 70.9 | 78.1 | 79.5 | 63.9 | 53.1 | 34.9 | 28.2 | 50.8 | -2.1 | -0.1 | 3.5 | -4.0 | -1.7 | -0.8 | -5.7 | 4.2 | -4.0 | -0.7 | 0.5 | 1.4 | -1.0 |
| 1994 | 20.8 | 21.8 | 41.5 | 50.3 | 62.9 | 73.6 | 72.6 | 71.7 | 66.1 | 53.6 | 40.5 | 28.3 | 50.5 | 0.1 | 0.4 | -7.2 | -1.3 | 1.0 | -1.1 | 0.6 | -3.6 | 1.6 | 1.4 | -5.0 | 1.5 | -3.8 |
| 1993 | 17.3 | 20.6 | 35.9 | 47.5 | 60.3 | 69.0 | 76.0 | 75.0 | 59.6 | 50.3 | 35.1 | 30.5 | 48.3 | -6.4 | -2.9 | -8.4 | -4.1 | -3.6 | -3.3 | -2.0 | -0.3 | -3.8 | -4.2 | -1.6 | 3.7 | -7.3 |
| 1992 | 34.4 | 37.3 | 43.7 | 51.5 | 62.2 | 69.5 | 72.8 | 70.2 | 65.5 | 53.8 | 33.8 | 26.4 | 51.8 | -0.5 | 0.6 | 8.3 | -0.1 | -3.1 | 0.2 | -0.1 | -5.1 | -5.1 | 3.6 | -4.8 | -0.4 | 9.8 |
| 1991 | 18.1 | 37.6 | 44.2 | 54.6 | 66.6 | 76.6 | 78.1 | 76.2 | 67.6 | 52.9 | 31.7 | 33.6 | 53.2 | 1.6 | -0.3 | 8.6 | 3.0 | 4.0 | 1.6 | 4.3 | 0.9 | -7.2 | 4.1 | 0.5 | 6.8 | -6.5 |
| 1990 | 33.8 | 31.7 | 42.7 | 51.1 | 59.5 | 75.3 | 76.5 | 76.7 | 70.5 | 55.0 | 44.7 | 23.4 | 53.5 | 4.5 | 1.8 | 2.7 | -0.5 | 2.7 | 1.9 | -2.8 | 1.4 | 5.8 | 2.6 | -1.1 | -3.4 | 9.2 |
| 1989 | 33.5 | 16.3 | 38.8 | 54.8 | 62.2 | 70.5 | 78.3 | 75.0 | 63.3 | 54.4 | 37.8 | 19.0 | 50.5 | -2.7 | 1.2 | -12.7 | 3.2 | -2.1 | -1.1 | -0.1 | -0.3 | -1.1 | -1.3 | 0.7 | -7.8 | 8.9 |
| 1988 | 21.5 | 25.9 | 41.3 | 51.0 | 67.6 | 77.8 | 77.8 | 78.3 | 67.6 | 50.7 | 41.3 | 31.7 | 52.8 | 1.6 | -2.5 | -3.1 | -0.6 | 5.2 | 1.2 | 5.3 | 3.0 | 2.4 | 1.2 | 0.2 | 4.9 | -3.1 |
| 1987 | 29.6 | 37.2 | 41.8 | 55.1 | 67.3 | 75.8 | 79.4 | 72.8 | 65.7 | 48.4 | 43.9 | 32.3 | 54.2 | -0.3 | -4.8 | 8.2 | 3.5 | 3.2 | 2.6 | 5.0 | -2.5 | 5.0 | 1.7 | 1.8 | 5.5 | 5.0 |
| 1986 | 32.6 | 26.2 | 45.8 | 53.2 | 63.1 | 75.4 | 78.6 | 71.0 | 68.4 | 53.6 | 35.6 | 30.5 | 53.0 | 2.4 | 0.4 | -2.8 | 1.6 | 2.8 | 1.4 | 0.8 | -4.3 | -3.3 | 5.7 | 1.0 | 3.7 | 8.0 |
| 1985 | 20.1 | 22.5 | 42.6 | 54.9 | 64.5 | 69.0 | 76.0 | 71.3 | 63.5 | 53.8 | 29.0 | 21.4 | 49.2 | -2.5 | 0.6 | -6.5 | 3.3 | -3.6 | -2.4 | 2.2 | -4.0 | -9.9 | 2.5 | -1.6 | -5.4 | -4.5 |
| 1984 | 21.8 | 36.0 | 33.4 | 48.4 | 59.1 | 73.4 | 77.5 | 78.0 | 63.0 | 53.2 | 40.1 | 27.9 | 51.1 | -3.0 | -0.0 | 7.0 | -3.2 | 0.8 | -0.5 | -3.2 | 2.7 | 1.2 | -6.7 | -0.1 | 1.1 | -2.8 |
| 1983 | 26.9 | 31.5 | 39.4 | 45.3 | 58.1 | 71.7 | 81.1 | 83.4 | 69.2 | 54.8 | 39.3 | 8.1 | 50.8 | 3.2 | 1.6 | 2.5 | -6.3 | -0.9 | -0.8 | -4.2 | 8.1 | 0.4 | -0.7 | 3.5 | -18.7 | 2.3 |
| 1982 | 11.9 | 23.4 | 36.3 | 48.3 | 63.4 | 66.7 | 78.9 | 74.1 | 65.1 | 54.6 | 36.8 | 29.9 | 49.3 | -0.9 | 1.4 | -5.6 | -3.3 | -5.9 | -2.3 | 1.1 | -1.2 | -2.1 | -3.8 | 1.3 | 3.1 | -12.7 |
| 1981 | 28.1 | 31.4 | 42.8 | 58.7 | 59.8 | 74.9 | 78.6 | 72.3 | 65.9 | 52.1 | 42.1 | 24.9 | 52.7 | -0.1 | -1.1 | 2.4 | 7.1 | 2.3 | 1.1 | -2.5 | -3.0 | 3.2 | 2.7 | 1.0 | -1.9 | 3.5 |
| 1980 | 23.4 | 22.1 | 35.2 | 52.2 | 62.8 | 74.3 | 82.2 | 78.8 | 66.8 | 51.8 | 42.5 | 28.6 | 51.9 | 0.8 | -1.4 | -6.9 | 0.6 | 1.7 | 0.3 | 0.5 | 3.5 | 3.6 | -4.9 | 4.6 | 1.8 | -1.2 |
| 1979 | 7.2 | 13.0 | 38.4 | 49.6 | 59.7 | 72.1 | 75.0 | 75.2 | 68.6 | 54.4 | 37.3 | 32.3 | 48.8 | 2.6 | 1.2 | -16.0 | -2.0 | -0.5 | -2.8 | -2.6 | -0.1 | -1.6 | -1.7 | -2.6 | 5.5 | -17.4 |
| 1978 | 9.9 | 13.1 | 33.6 | 51.3 | 60.0 | 71.6 | 76.8 | 74.9 | 69.1 | 52.1 | 36.5 | 22.3 | 47.8 | 3.1 | -1.1 | -15.9 | -0.3 | -1.0 | -3.8 | -2.3 | -0.4 | -2.4 | -6.5 | -0.8 | -4.5 | -14.7 |
| 1977 | 13.0 | 31.7 | 43.4 | 56.6 | 68.4 | 74.3 | 80.9 | 72.2 | 66.4 | 51.4 | 38.3 | 25.1 | 51.9 | 0.4 | -1.8 | 2.7 | 5.0 | 1.7 | 0.3 | 6.1 | -3.1 | -0.6 | 3.3 | 3.3 | -1.7 | -11.6 |
| 1976 | 24.2 | 36.9 | 39.2 | 54.3 | 58.9 | 71.6 | 78.1 | 76.2 | 66.8 | 47.2 | 32.1 | 24.3 | 50.9 | 0.8 | -6.0 | 7.9 | 2.7 | -1.0 | -0.7 | -3.4 | 0.9 | -6.8 | -0.9 | 0.5 | -2.5 | -0.4 |
| 1975 | 21.6 | 20.1 | 30.6 | 48.4 | 63.4 | 70.9 | 78.5 | 79.5 | 61.6 | 57.3 | 39.5 | 29.9 | 50.3 | -4.4 | 4.1 | -8.9 | -3.2 | -1.7 | -1.3 | 1.1 | 4.2 | 0.6 | -9.5 | 0.9 | 3.1 | -3.0 |
| 1974 | 15.6 | 31.1 | 42.1 | 51.8 | 62.1 | 70.9 | 83.8 | 70.7 | 60.9 | 56.1 | 39.3 | 26.9 | 51.1 | -5.1 | 2.9 | 2.1 | 0.2 | -1.7 | -0.5 | -0.2 | -4.6 | 0.4 | 2.0 | 6.2 | 0.1 | -9.0 |
| 1973 | 23.4 | 28.4 | 42.6 | 49.5 | 59.0 | 73.3 | 75.0 | 77.2 | 63.2 | 56.1 | 39.0 | 21.8 | 50.8 | -2.8 | 2.9 | -0.6 | -2.1 | 0.7 | -0.8 | -3.3 | 1.9 | 0.1 | 2.5 | -2.6 | -5.0 | -1.2 |
| 1972 | 20.8 | 25.0 | 41.5 | 49.5 | 60.7 | 71.2 | 74.1 | 72.3 | 65.1 | 49.0 | 36.2 | 21.6 | 49.0 | -0.9 | -4.2 | -4.0 | -2.1 | -1.4 | -2.6 | -1.6 | -3.0 | -2.7 | 1.4 | -3.5 | -5.2 | -3.8 |
| 1971 | 16.7 | 23.2 | 35.4 | 52.9 | 58.8 | 76.8 | 74.0 | 74.8 | 65.9 | 57.0 | 37.3 | 29.3 | 50.3 | -0.1 | 3.8 | -5.8 | 1.3 | 4.2 | -1.3 | -3.5 | -0.5 | -1.6 | -4.7 | -3.6 | 2.5 | -7.9 |
| 1970 | 16.9 | 32.9 | 36.1 | 52.9 | 67.4 | 73.4 | 78.0 | 76.5 | 65.0 | 50.1 | 37.1 | 28.5 | 51.3 | -1.0 | -3.1 | 3.9 | 1.3 | 0.8 | -0.3 | 5.1 | 1.2 | -1.8 | -4.0 | 0.4 | 1.7 | -7.7 |
| 1969 | 17.6 | 24.5 | 30.5 | 53.1 | 63.4 | 68.1 | 77.7 | 75.4 | 67.6 | 49.0 | 40.1 | 24.2 | 49.4 | 1.6 | -4.2 | -4.5 | 1.5 | -4.5 | -2.2 | 1.1 | 0.1 | 1.2 | -9.6 | 0.1 | -2.6 | -7.0 |
| 1968 | 22.5 | 27.6 | 44.3 | 52.1 | 58.3 | 74.3 | 77.0 | 74.7 | 64.4 | 55.0 | 35.8 | 21.9 | 50.8 | -1.6 | 1.8 | -1.4 | 0.5 | 1.7 | -0.8 | -4.0 | -0.6 | -3.1 | 4.2 | -0.6 | -4.9 | -2.1 |
| 1967 | 23.1 | 28.9 | 43.7 | 54.3 | 59.5 | 70.6 | 73.4 | 70.6 | 62.0 | 51.5 | 37.6 | 28.0 | 50.4 | -4.0 | -1.7 | -0.1 | 2.7 | -2.0 | -1.2 | -2.8 | -4.7 | -1.3 | 3.6 | -4.2 | 1.2 | -1.5 |
| 1966 | 17.7 | 27.2 | 42.6 | 46.6 | 61.2 | 72.3 | 81.5 | 72.1 | 63.3 | 54.6 | 38.5 | 26.5 | 50.5 | -2.7 | 1.4 | -1.8 | -5.0 | -0.3 | -1.1 | -1.1 | -3.2 | -0.4 | 2.5 | 3.9 | -0.3 | -6.9 |
| 1965 | 22.0 | 20.6 | 26.4 | 52.9 | 67.0 | 71.6 | 75.6 | 75.4 | 60.5 | 56.1 | 41.6 | 34.8 | 50.5 | -5.5 | 2.9 | -8.4 | 1.3 | -1.0 | -1.1 | 4.7 | 0.1 | 2.7 | -13.7 | -2.0 | 8.0 | -2.6 |
| 1964 | 30.2 | 29.9 | 35.1 | 52.7 | 67.8 | 70.5 | 80.9 | 71.7 | 65.7 | 53.0 | 40.8 | 25.0 | 52.1 | -0.3 | -0.2 | 0.9 | 1.1 | -2.1 | 0.5 | 5.5 | -3.6 | 1.9 | -5.0 | 3.3 | -1.8 | 5.6 |
| 1963 | 14.0 | 31.1 | 43.3 | 53.3 | 63.5 | 76.8 | 79.0 | 75.9 | 67.9 | 64.2 | 45.0 | 19.4 | 52.9 | 1.9 | 11.0 | 2.1 | 1.7 | 4.2 | 1.3 | 1.2 | 0.6 | 6.1 | 3.2 | 1.4 | -7.4 | -10.6 |
| 1962 | 20.1 | 26.8 | 32.6 | 51.4 | 70.1 | 71.6 | 75.8 | 76.5 | 64.7 | 56.7 | 40.8 | 28.3 | 51.4 | -1.3 | 3.5 | -2.2 | -0.2 | -1.0 | -0.2 | 7.8 | 1.2 | 1.9 | -7.5 | -1.8 | 1.5 | -4.5 |
| 1961 | 25.4 | 32.3 | 40.4 | 47.2 | 58.7 | 71.0 | 76.6 | 75.9 | 63.1 | 57.0 | 38.7 | 21.2 | 50.7 | -2.9 | 3.8 | 3.3 | -4.4 | -1.6 | -0.9 | -3.6 | 0.6 | -0.2 | 0.3 | -1.0 | -5.6 | 0.8 |
| 1960 | 21.2 | 20.4 | 24.3 | 53.7 | 62.4 | 70.5 | 76.1 | 76.6 | 69.0 | 56.6 | 40.8 | 29.1 | 50.2 | 3.0 | 3.4 | -8.6 | 2.1 | -2.1 | -1.4 | 0.1 | 1.3 | 1.9 | -15.8 | -1.5 | 2.3 | -3.4 |
| 1959 | 20.5 | 25.2 | 40.1 | 51.1 | 63.4 | 75.1 | 74.7 | 81.1 | 65.8 | 51.1 | 33.8 | 35.0 | 51.6 | -0.2 | -2.1 | -3.8 | -0.5 | 2.5 | -0.0 | 1.1 | 5.8 | -5.1 | -0.0 | -2.9 | 8.2 | -4.1 |
| 1958 | 26.4 | 22.7 | 34.5 | 50.2 | 65.0 | 70.6 | 73.9 | 76.4 | 68.3 | 57.4 | 42.1 | 27.2 | 51.4 | 2.3 | 4.2 | -6.3 | -1.4 | -2.0 | -0.2 | 2.7 | 1.1 | 3.2 | -5.6 | -3.7 | 0.4 | 1.8 |
| 1957 | 18.2 | 33.2 | 38.5 | 50.4 | 60.9 | 71.1 | 81.9 | 77.6 | 64.2 | 52.5 | 37.0 | 35.3 | 51.8 | -1.8 | -0.7 | 4.2 | -1.2 | -1.5 | 0.2 | -1.4 | 2.3 | -1.9 | -1.6 | 4.3 | 8.5 | -6.4 |
| 1956 | 21.1 | 25.3 | 38.7 | 47.5 | 65.6 | 77.2 | 77.9 | 78.3 | 68.4 | 61.3 | 40.2 | 33.2 | 53.0 | 2.4 | 8.1 | -3.7 | -4.1 | 4.6 | 1.4 | 3.3 | 3.0 | 1.3 | -1.4 | 0.3 | 6.4 | -3.5 |
| 1955 | 25.0 | 22.7 | 37.9 | 59.7 | 66.7 | 69.0 | 84.3 | 81.2 | 69.9 | 55.9 | 33.7 | 23.4 | 52.6 | 3.9 | 2.7 | -6.3 | 8.1 | -3.6 | 1.0 | 4.4 | 5.9 | -5.2 | -2.2 | 6.7 | -3.4 | 0.4 |
| 1954 | 20.6 | 40.5 | 34.8 | 54.1 | 56.9 | 75.1 | 83.0 | 75.9 | 71.2 | 54.1 | 45.6 | 33.4 | 53.8 | 5.2 | 0.9 | 11.5 | 2.5 | 2.5 | 2.2 | -5.4 | 0.6 | 6.7 | -5.3 | 5.4 | 6.6 | -4.0 |
| 1953 | 25.2 | 34.1 | 41.5 | 46.6 | 61.2 | 78.8 | 79.4 | 77.2 | 68.4 | 59.2 | 42.6 | 32.0 | 54.0 | 2.4 | 6.0 | 5.1 | -5.0 | 6.2 | 2.4 | -1.1 | 1.9 | 3.7 | 1.4 | 1.8 | 5.2 | 0.6 |
| 1952 | 23.8 | 34.4 | 33.2 | 49.8 | 61.9 | 78.7 | 77.5 | 73.7 | 68.7 | 50.4 | 38.2 | 25.8 | 51.4 | 2.7 | -2.8 | 5.4 | -1.8 | 6.1 | -0.2 | -0.4 | -1.6 | -0.7 | -6.9 | -0.1 | -1.0 | -0.8 |
| 1951 | 21.0 | 30.1 | 31.5 | 46.0 | 62.2 | 65.9 | 74.0 | 74.8 | 60.9 | 52.2 | 34.4 | 21.8 | 48.0 | -5.1 | -1.0 | 1.1 | -5.6 | -6.7 | -3.6 | -0.1 | -0.5 | -4.5 | -8.6 | -3.6 | -5.0 | -3.6 |
| 1950 | 18.9 | 27.2 | 34.4 | 46.0 | 60.3 | 71.2 | 71.6 | 70.2 | 63.9 | 57.8 | 35.2 | 26.4 | 48.7 | -2.1 | 4.6 | -1.8 | -5.6 | -1.4 | -2.9 | -2.0 | -5.1 | -3.7 | -5.7 | -6.0 | -0.4 | -5.7 |
| 1949 | 16.3 | 20.6 | 36.3 | 51.9 | 64.2 | 73.8 | 77.6 | 74.2 | 61.1 | 56.0 | 45.5 | 29.2 | 50.7 | -4.9 | 2.8 | -8.4 | 0.3 | 1.2 | -0.9 | 1.9 | -1.1 | 6.6 | -3.8 | 0.0 | 2.4 | -8.3 |
| 1948 | 21.6 | 23.7 | 31.5 | 56.3 | 61.8 | 71.5 | 77.4 | 77.3 | 69.7 | 52.6 | 38.8 | 26.4 | 50.9 | 3.7 | -0.6 | -5.3 | 4.7 | -1.1 | -0.7 | -0.5 | 2.0 | -0.1 | -8.6 | -0.2 | -0.4 | -3.0 |
| 1947 | 28.8 | 23.7 | 35.0 | 48.4 | 57.4 | 68.2 | 75.6 | 84.0 | 70.0 | 63.6 | 35.6 | 28.5 | 51.7 | 4.0 | 10.4 | -5.3 | -3.2 | -4.4 | 0.1 | -4.9 | 8.7 | -3.3 | -5.1 | -2.0 | 1.7 | 4.2 |
| 1946 | 27.6 | 35.3 | 50.3 | 57.0 | 57.5 | 74.0 | 77.2 | 72.8 | 65.6 | 55.2 | 39.6 | 31.5 | 53.7 | -0.4 | 2.0 | 6.3 | 5.4 | 1.4 | 2.1 | -4.8 | -2.5 | 0.7 | 10.2 | -0.4 | 4.7 | 3.0 |
| 1945 | 26.6 | 30.0 | 46.1 | 47.8 | 56.3 | 64.7 | 75.6 | 76.0 | 65.9 | 54.6 | 40.2 | 20.7 | 50.5 | -0.1 | 1.4 | 1.0 | -3.8 | -7.9 | -1.1 | -6.0 | 0.7 | 1.3 | 6.0 | -2.0 | -6.1 | 2.0 |
| 1944 | 31.5 | 27.9 | 30.4 | 44.6 | 65.6 | 72.5 | 76.5 | 74.8 | 65.6 | 55.2 | 39.1 | 25.1 | 50.9 | -0.4 | 2.0 | -1.1 | -7.0 | -0.1 | -0.7 | 3.3 | -0.5 | 0.2 | -9.7 | -1.1 | -1.7 | 6.9 |
| 1943 | 21.1 | 33.4 | 33.2 | 52.5 | 58.7 | 72.3 | 77.8 | 78.4 | 63.6 | 51.7 | 36.5 | 28.1 | 50.7 | -2.4 | -1.5 | 4.4 | 0.9 | -0.3 | -0.9 | -3.6 | 3.1 | -2.4 | -6.9 | 0.2 | 1.3 | -3.5 |
| 1942 | 25.0 | 25.6 | 39.1 | 55.5 | 59.3 | 71.0 | 79.2 | 76.4 | 63.3 | 54.8 | 40.8 | 24.4 | 51.3 | -2.7 | 1.6 | -3.4 | 3.9 | -1.6 | -0.3 | -3.0 | 1.1 | 1.9 | -1.0 | 1.6 | -2.4 | 0.4 |
| 1941 | 25.7 | 26.3 | 35.7 | 53.3 | 66.8 | 71.7 | 77.8 | 77.7 | 68.2 | 54.3 | 40.4 | 32.2 | 52.7 | 2.2 | 1.1 | -2.7 | 1.7 | -0.9 | 1.1 | 4.5 | 2.4 | 1.5 | -4.4 | 0.2 | 5.4 | 1.1 |
| 1940 | 6.4 | 23.7 | 37.1 | 49.8 | 59.8 | 73.3 | 81.6 | 72.9 | 69.2 | 61.3 | 34.4 | 29.4 | 50.1 | 3.2 | 8.1 | -5.3 | -1.8 | 0.7 | -1.5 | -2.5 | -2.4 | -4.5 | -3.0 | 4.0 | 2.6 | -18.2 |
| 1939 | 34.8 | 22.4 | 41.0 | 51.7 | 69.6 | 74.6 | 81.9 | 75.0 | 72.9 | 56.5 | 43.0 | 36.0 | 55.2 | 6.9 | 3.3 | -6.6 | 0.1 | 2.0 | 3.6 | 7.3 | -0.3 | 4.1 | 0.9 | 4.3 | 9.2 | 10.2 |
| 1938 | 27.2 | 29.7 | 46.0 | 54.1 | 60.9 | 73.2 | 80.8 | 80.2 | 71.3 | 64.4 | 39.8 | 32.7 | 55.2 | 5.3 | 11.2 | 0.7 | 2.5 | 0.6 | 3.6 | -1.4 | 4.9 | 0.9 | 5.9 | 3.2 | 5.9 | 2.6 |
| 1937 | 13.2 | 25.0 | 36.6 | 51.1 | 64.5 | 72.7 | 80.9 | 84.3 | 70.3 | 54.0 | 37.9 | 28.3 | 51.7 | 4.3 | 0.8 | -4.0 | -0.5 | 0.1 | 0.1 | 2.2 | 9.0 | -1.0 | -3.5 | 3.3 | 1.5 | -11.4 |
| 1936 | 14.0 | 8.2 | 44.3 | 49.5 | 68.2 | 74.6 | 87.9 | 83.2 | 71.5 | 54.1 | 39.9 | 31.9 | 52.6 | 5.5 | 0.9 | -20.8 | -2.1 | 2.0 | 1.0 | 5.9 | 7.9 | 1.0 | 4.2 | 10.3 | 5.1 | -10.6 |
| 1935 | 27.0 | 34.7 | 45.0 | 49.5 | 55.7 | 68.5 | 85.0 | 78.5 | 67.8 | 52.0 | 37.0 | 29.6 | 52.6 | 1.8 | -1.2 | 5.7 | -2.1 | -4.1 | 1.0 | -6.6 | 3.2 | -1.9 | 4.9 | 7.4 | 2.8 | 2.4 |
| 1934 | 31.7 | 30.3 | 38.1 | 55.2 | 71.9 | 79.8 | 86.7 | 79.0 | 62.5 | 60.2 | 44.3 | 26.9 | 55.7 | -3.5 | 7.0 | 1.3 | 3.6 | 7.2 | 4.1 | 9.6 | 3.7 | 5.4 | -2.0 | 9.1 | 0.1 | 7.1 |
| 1933 | 36.7 | 27.1 | 39.4 | 51.1 | 61.2 | 80.4 | 78.7 | 73.6 | 71.5 | 53.8 | 43.0 | 32.9 | 54.3 | 5.5 | 0.6 | -1.9 | -0.5 | 7.8 | 2.7 | -1.1 | -1.7 | 4.1 | -0.7 | 1.1 | 6.1 | 12.1 |
| 1932 | 20.2 | 30.3 | 32.2 | 54.6 | 64.8 | 73.2 | 79.7 | 75.7 | 65.2 | 52.1 | 37.8 | 23.8 | 50.9 | -0.8 | -1.1 | 1.3 | 3.0 | 0.6 | -0.7 | 2.5 | 0.4 | -1.1 | -7.9 | 2.1 | -3.0 | -4.4 |
| 1931 | 34.0 | 38.1 | 36.3 | 53.2 | 58.7 | 78.4 | 79.5 | 75.1 | 74.6 | 58.8 | 43.8 | 37.0 | 55.7 | 8.6 | 5.6 | 9.1 | 1.6 | 5.8 | 4.1 | -3.6 | -0.2 | 4.9 | -3.8 | 1.9 | 10.2 | 9.4 |
| 1930 | 14.2 | 41.6 | 39.7 | 55.7 | 61.3 | 71.2 | 82.8 | 77.2 | 68.1 | 53.6 | 44.4 | 31.8 | 53.5 | 2.1 | 0.4 | 12.6 | 4.1 | -1.4 | 1.9 | -1.0 | 1.9 | 5.5 | -0.4 | 5.2 | 5.0 | -10.4 |
| 1929 | 15.3 | 19.2 | 42.7 | 54.2 | 60.0 | 70.6 | 77.4 | 76.7 | 64.6 | 54.6 | 34.3 | 28.9 | 50.0 | -1.4 | 1.4 | -9.8 | 2.6 | -2.0 | -1.6 | -2.3 | 1.4 | -4.6 | 2.6 | -0.2 | 2.1 | -9.3 |
| 1928 | 30.4 | 32.7 | 43.4 | 48.2 | 64.6 | 66.8 | 77.0 | 76.1 | 64.7 | 55.5 | 40.2 | 31.2 | 52.7 | -1.3 | 2.3 | 3.7 | -3.4 | -5.8 | 1.1 | 2.3 | 0.8 | 1.3 | 3.3 | -0.6 | 4.4 | 5.8 |
| 1927 | 27.5 | 33.2 | 41.0 | 52.2 | 61.3 | 69.6 | 76.4 | 69.8 | 69.5 | 58.7 | 40.0 | 20.6 | 51.7 | 3.5 | 5.5 | 4.2 | 0.6 | -3.0 | 0.1 | -1.0 | -5.5 | 1.1 | 0.9 | -1.2 | -6.2 | 2.9 |
| 1926 | 28.0 | 36.9 | 37.3 | 49.0 | 66.2 | 71.0 | 78.6 | 77.6 | 64.3 | 54.8 | 35.3 | 26.0 | 52.2 | -1.7 | 1.6 | 7.9 | -2.6 | -1.6 | 0.6 | 3.9 | 2.3 | -3.6 | -2.8 | 1.0 | -0.8 | 3.4 |
| 1925 | 22.7 | 33.2 | 43.4 | 59.5 | 60.6 | 74.2 | 78.2 | 75.3 | 71.1 | 42.8 | 40.3 | 27.5 | 52.5 | 5.1 | -10.4 | 4.2 | 7.9 | 1.6 | 0.9 | -1.7 | 0.0 | 1.4 | 3.3 | 0.6 | 0.7 | -1.9 |
| 1924 | 17.9 | 30.2 | 34.3 | 53.6 | 55.7 | 69.1 | 72.9 | 77.0 | 62.8 | 61.8 | 42.6 | 18.5 | 49.8 | -3.2 | 8.6 | 1.2 | 2.0 | -3.5 | -1.8 | -6.6 | 1.7 | 3.7 | -5.8 | -4.7 | -8.3 | -6.7 |
| 1923 | 33.6 | 26.4 | 33.9 | 51.2 | 60.1 | 71.9 | 78.8 | 73.2 | 67.6 | 51.7 | 43.2 | 35.1 | 52.4 | 1.6 | -1.5 | -2.6 | -0.4 | -0.7 | 0.8 | -2.2 | -2.1 | 4.3 | -6.2 | 1.2 | 8.3 | 9.0 |
| 1922 | 24.1 | 25.9 | 40.9 | 53.2 | 63.9 | 75.4 | 73.8 | 78.5 | 72.2 | 58.9 | 43.5 | 28.1 | 53.3 | 6.2 | 5.7 | -3.1 | 1.6 | 2.8 | 1.7 | 1.6 | 3.2 | 4.6 | 0.8 | -3.8 | 1.3 | -0.5 |
| 1921 | 32.7 | 36.4 | 45.6 | 53.9 | 65.3 | 76.5 | 78.8 | 76.3 | 71.3 | 58.3 | 37.5 | 31.6 | 55.5 | 5.3 | 5.1 | 7.4 | 2.3 | 3.9 | 3.9 | 3.0 | 1.0 | -1.4 | 5.5 | 1.2 | 4.8 | 8.1 |
| 1920 | 25.7 | 31.0 | 42.6 | 44.0 | 61.0 | 73.0 | 76.6 | 71.9 | 68.8 | 60.5 | 36.9 | 29.2 | 51.9 | 2.8 | 7.3 | 2.0 | -7.6 | 0.4 | 0.3 | -1.3 | -3.4 | -2.0 | 2.5 | -1.0 | 2.4 | 1.1 |
| 1919 | 32.9 | 27.9 | 40.7 | 49.5 | 60.7 | 72.9 | 82.2 | 74.9 | 70.9 | 50.1 | 36.1 | 20.4 | 51.7 | 4.9 | -3.1 | -1.1 | -2.1 | 0.3 | 0.1 | -1.6 | -0.4 | -2.8 | 0.6 | 4.6 | -6.4 | 8.3 |
| 1918 | 12.7 | 28.3 | 46.7 | 46.9 | 68.0 | 77.3 | 77.5 | 80.9 | 62.1 | 58.1 | 41.7 | 34.4 | 53.0 | -3.9 | 4.9 | -0.7 | -4.7 | 4.7 | 1.4 | 5.7 | 5.6 | 2.8 | 6.6 | -0.1 | 7.6 | -11.9 |
| 1917 | 24.1 | 24.3 | 39.0 | 48.8 | 56.7 | 69.7 | 78.5 | 71.6 | 66.5 | 46.5 | 44.9 | 18.6 | 49.2 | 0.5 | -6.7 | -4.7 | -2.8 | -2.9 | -2.4 | -5.6 | -3.7 | 6.0 | -1.1 | 0.9 | -8.2 | -0.5 |
| 1916 | 18.3 | 24.2 | 41.1 | 49.2 | 62.2 | 67.8 | 82.1 | 75.7 | 65.3 | 54.2 | 40.1 | 22.2 | 50.4 | -0.7 | 1.0 | -4.8 | -2.4 | -4.8 | -1.2 | -0.1 | 0.4 | 1.2 | 1.0 | 4.5 | -4.6 | -6.3 |
| 1915 | 21.9 | 31.0 | 29.3 | 59.3 | 59.0 | 67.3 | 71.7 | 67.9 | 66.3 | 58.1 | 44.2 | 29.7 | 50.5 | 0.3 | 4.9 | 2.0 | 7.7 | -5.3 | -1.1 | -3.3 | -7.4 | 5.3 | -10.8 | -5.9 | 2.9 | -2.7 |
| 1914 | 31.9 | 22.4 | 37.0 | 52.2 | 64.2 | 75.3 | 79.1 | 76.7 | 67.9 | 57.3 | 44.8 | 18.1 | 52.4 | 1.9 | 4.1 | -6.6 | 0.6 | 2.7 | 0.8 | 1.9 | 1.4 | 5.9 | -3.1 | 1.5 | -8.7 | 7.3 |
| 1913 | 24.0 | 22.9 | 35.6 | 53.7 | 63.0 | 73.9 | 81.0 | 82.6 | 67.4 | 51.0 | 46.4 | 33.5 | 53.1 | 1.4 | -2.2 | -6.1 | 2.1 | 1.3 | 1.5 | 0.7 | 7.3 | 7.5 | -4.5 | 3.4 | 6.7 | -0.6 |
| 1912 | 12.2 | 25.2 | 26.4 | 53.0 | 65.6 | 68.3 | 79.0 | 75.4 | 63.4 | 55.1 | 43.8 | 33.1 | 50.2 | -2.6 | 1.9 | -3.8 | 1.4 | -4.3 | -1.4 | 3.3 | 0.1 | 4.9 | -13.7 | 1.4 | 6.3 | -12.4 |
| 1911 | 26.6 | 30.9 | 43.1 | 51.0 | 65.3 | 78.7 | 78.3 | 74.7 | 69.7 | 51.7 | 33.5 | 28.9 | 52.8 | 3.7 | -1.5 | 1.9 | -0.6 | 6.1 | 1.2 | 3.0 | -0.6 | -5.4 | 3.0 | 0.7 | 2.1 | 2.0 |
| 1910 | 21.9 | 24.2 | 53.4 | 55.8 | 57.9 | 71.9 | 76.9 | 73.5 | 66.6 | 58.2 | 39.0 | 27.3 | 52.4 | 0.6 | 5.0 | -4.8 | 4.2 | -0.7 | 0.8 | -4.4 | -1.8 | 0.1 | 13.3 | -0.7 | 0.5 | -2.7 |
| 1909 | 23.3 | 31.2 | 36.5 | 46.3 | 60.4 | 71.3 | 76.2 | 80.1 | 66.2 | 53.9 | 44.3 | 15.2 | 50.5 | 0.2 | 0.7 | 2.2 | -5.3 | -1.3 | -1.1 | -1.9 | 4.8 | 5.4 | -3.6 | -1.4 | -11.6 | -1.3 |
| 1908 | 31.0 | 28.4 | 42.0 | 54.2 | 60.4 | 69.4 | 73.9 | 72.9 | 70.8 | 52.9 | 41.4 | 31.7 | 52.5 | 4.8 | -0.3 | -0.6 | 2.6 | -3.2 | 0.9 | -1.9 | -2.4 | 2.5 | 1.9 | -3.7 | 4.9 | 6.4 |
| 1907 | 21.8 | 28.4 | 44.5 | 43.5 | 56.3 | 69.4 | 76.2 | 75.3 | 66.3 | 54.2 | 40.9 | 31.1 | 50.8 | 0.3 | 1.0 | -0.6 | -8.1 | -3.2 | -0.8 | -6.0 | 0.0 | 2.0 | 4.4 | -1.4 | 4.3 | -2.8 |
| 1906 | 31.0 | 30.5 | 28.6 | 55.6 | 63.4 | 70.4 | 72.4 | 76.1 | 68.2 | 52.7 | 38.5 | 30.5 | 51.6 | 2.2 | -0.5 | 1.5 | 4.0 | -2.2 | -0.0 | 1.1 | 0.8 | -0.4 | -11.5 | -5.2 | 3.7 | 6.4 |
| 1905 | 14.8 | 16.1 | 46.0 | 49.3 | 59.6 | 71.5 | 72.5 | 77.1 | 68.5 | 51.6 | 42.5 | 32.1 | 50.3 | 2.5 | -1.6 | -12.9 | -2.3 | -1.1 | -1.3 | -2.7 | 1.8 | 3.6 | 5.9 | -5.1 | 5.3 | -9.8 |
| 1904 | 22.2 | 21.3 | 38.9 | 45.5 | 60.9 | 67.8 | 72.7 | 72.1 | 66.5 | 56.5 | 44.6 | 27.5 | 49.9 | 0.5 | 3.3 | -7.7 | -6.1 | -4.8 | -1.7 | -1.4 | -3.2 | 5.7 | -1.2 | -4.9 | 0.7 | -2.4 |
| 1903 | 27.5 | 21.2 | 39.1 | 52.4 | 61.3 | 66.5 | 75.5 | 71.5 | 63.0 | 55.6 | 38.5 | 28.2 | 50.2 | -3.0 | 2.4 | -7.8 | 0.8 | -6.1 | -1.4 | -1.0 | -3.8 | -0.4 | -1.0 | -2.1 | 1.4 | 2.9 |
| 1902 | 26.4 | 22.5 | 42.5 | 51.5 | 65.3 | 66.9 | 74.4 | 72.4 | 61.6 | 57.1 | 41.7 | 22.0 | 50.5 | -4.4 | 3.9 | -6.5 | -0.1 | -5.7 | -1.1 | 3.0 | -2.9 | 2.8 | 2.4 | -3.2 | -4.8 | 1.8 |
| 1901 | 28.8 | 23.6 | 37.6 | 51.2 | 61.4 | 75.1 | 85.4 | 76.4 | 65.3 | 57.2 | 40.8 | 25.2 | 52.5 | -0.7 | 4.0 | -5.4 | -0.4 | 2.5 | 0.9 | -0.9 | 1.1 | 1.9 | -2.5 | 7.8 | -1.6 | 4.2 |
| 1900 | 30.6 | 19.1 | 36.8 | 54.5 | 64.8 | 72.2 | 76.3 | 78.5 | 67.1 | 61.6 | 37.5 | 33.9 | 53.0 | 1.1 | 8.4 | -9.9 | 2.9 | -0.4 | 1.4 | 2.5 | 3.2 | -1.4 | -3.3 | -1.3 | 7.1 | 6.0 |
| 1899 | 25.7 | 14.1 | 27.7 | 50.9 | 62.3 | 72.0 | 74.4 | 76.8 | 66.7 | 59.5 | 46.7 | 25.8 | 50.4 | 0.7 | 6.3 | -14.9 | -0.7 | -0.6 | -1.2 | 0.0 | 1.5 | 7.8 | -12.4 | -3.2 | -1.0 | 1.1 |
| 1898 | 29.3 | 31.8 | 39.3 | 50.7 | 60.4 | 73.3 | 74.7 | 76.3 | 68.2 | 49.7 | 34.3 | 23.2 | 51.0 | 2.2 | -3.5 | 2.8 | -0.9 | 0.7 | -0.6 | -1.9 | 1.0 | -4.6 | -0.8 | -2.9 | -3.6 | 4.7 |
| 1897 | 22.5 | 27.0 | 35.6 | 50.0 | 60.9 | 72.0 | 78.2 | 71.7 | 74.8 | 58.9 | 37.2 | 22.6 | 51.1 | 8.8 | 5.7 | -2.0 | -1.6 | -0.6 | -0.5 | -1.4 | -3.6 | -1.7 | -4.5 | 0.6 | -4.2 | -2.1 |
| 1896 | 29.0 | 34.3 | 32.6 | 57.1 | 66.2 | 71.5 | 74.5 | 73.7 | 61.9 | 51.6 | 31.2 | 37.0 | 51.8 | -4.1 | -1.6 | 5.3 | 5.5 | -1.1 | 0.2 | 3.9 | -1.6 | -7.7 | -7.5 | -3.1 | 10.2 | 4.4 |
| 1895 | 19.5 | 22.2 | 38.5 | 57.3 | 63.9 | 69.9 | 74.9 | 74.6 | 71.9 | 50.4 | 37.9 | 30.5 | 51.1 | 5.9 | -2.8 | -6.8 | 5.7 | -2.7 | -0.5 | 1.6 | -0.7 | -1.0 | -1.6 | -2.7 | 3.7 | -5.1 |
| 1894 | 22.6 | 21.7 | 43.3 | 54.2 | 63.7 | 72.6 | 76.9 | 77.8 | 68.1 | 55.8 | 38.2 | 33.6 | 52.6 | 2.1 | 2.6 | -7.3 | 2.6 | 0.0 | 1.0 | 1.4 | 2.5 | -0.7 | 3.2 | -0.7 | 6.8 | -2.0 |
| 1893 | 20.7 | 22.0 | 34.1 | 49.9 | 59.0 | 72.2 | 76.6 | 71.3 | 68.0 | 55.4 | 38.4 | 29.7 | 49.9 | 2.0 | 2.2 | -7.0 | -1.7 | -0.4 | -1.7 | -3.3 | -4.0 | -0.5 | -6.0 | -1.0 | 2.9 | -3.9 |
| 1892 | 20.1 | 30.5 | 34.9 | 48.0 | 53.7 | 71.0 | 75.6 | 73.6 | 68.5 | 57.2 | 38.1 | 22.3 | 49.5 | 2.5 | 4.0 | 1.5 | -3.6 | -1.6 | -2.1 | -8.6 | -1.7 | -0.8 | -5.2 | -2.0 | -4.5 | -4.5 |
| 1891 | 29.0 | 20.5 | 29.1 | 54.4 | 59.1 | 68.3 | 71.1 | 71.4 | 69.7 | 52.4 | 35.5 | 34.5 | 49.8 | 3.7 | -0.8 | -8.5 | 2.8 | -4.3 | -1.8 | -3.2 | -3.9 | -3.4 | -11.0 | -6.5 | 7.7 | 4.4 |
| 1890 | 18.4 | 24.9 | 32.7 | 54.2 | 59.5 | 74.0 | 79.2 | 71.2 | 62.5 | 52.7 | 42.0 | 33.8 | 50.5 | -3.5 | -0.5 | -4.1 | 2.6 | 1.4 | -1.1 | -2.8 | -4.1 | 3.1 | -7.4 | 1.6 | 7.0 | -6.2 |
| 1889 | 24.9 | 22.5 | 41.5 | 53.6 | 61.1 | 68.9 | 73.4 | 71.6 | 63.1 | 51.7 | 34.5 | 38.6 | 50.6 | -2.9 | -1.5 | -6.5 | 2.0 | -3.7 | -1.0 | -1.2 | -3.7 | -4.4 | 1.4 | -4.2 | 11.8 | 0.3 |
| 1888 | 8.3 | 26.6 | 29.9 | 53.8 | 57.3 | 69.9 | 78.1 | 72.1 | 64.3 | 50.4 | 38.2 | 32.0 | 48.5 | -1.7 | -2.8 | -2.4 | 2.2 | -2.7 | -3.1 | -5.0 | -3.2 | -0.7 | -10.2 | 0.5 | 5.2 | -16.3 |
| 1887 | 14.3 | 18.9 | 38.5 | 53.5 | 65.7 | 71.6 | 76.4 | 71.5 | 65.7 | 50.0 | 38.0 | 23.4 | 49.1 | -0.3 | -3.2 | -10.1 | 1.9 | -1.0 | -2.5 | 3.4 | -3.8 | -0.9 | -1.6 | -1.2 | -3.4 | -10.3 |
|-------+------+------+------+------+------+------+------+------+------+------+------+------+--------+----------+----------+----------+----------+----------+-------------+----------+----------+----------+----------+----------+----------+-----------|
In [12]:
tables_diff.print_table()
|-------+--------------|
| Year | diff_Annual |
|-------+--------------|
| 2015 | 1.7 |
| 2014 | -0.5 |
| 2013 | -1.4 |
| 2012 | 2.9 |
| 2011 | -0.4 |
| 2010 | -0.5 |
| 2009 | -1.6 |
| 2008 | -1.0 |
| 2007 | 1.0 |
| 2006 | 2.0 |
| 2005 | 1.2 |
| 2004 | 0.2 |
| 2003 | -0.5 |
| 2002 | 2.3 |
| 2001 | 0.9 |
| 2000 | 0.5 |
| 1999 | 1.1 |
| 1998 | 1.6 |
| 1997 | -1.0 |
| 1996 | -2.9 |
| 1995 | -0.8 |
| 1994 | -1.1 |
| 1993 | -3.3 |
| 1992 | 0.2 |
| 1991 | 1.6 |
| 1990 | 1.9 |
| 1989 | -1.1 |
| 1988 | 1.2 |
| 1987 | 2.6 |
| 1986 | 1.4 |
| 1985 | -2.4 |
| 1984 | -0.5 |
| 1983 | -0.8 |
| 1982 | -2.3 |
| 1981 | 1.1 |
| 1980 | 0.3 |
| 1979 | -2.8 |
| 1978 | -3.8 |
| 1977 | 0.3 |
| 1976 | -0.7 |
| 1975 | -1.3 |
| 1974 | -0.5 |
| 1973 | -0.8 |
| 1972 | -2.6 |
| 1971 | -1.3 |
| 1970 | -0.3 |
| 1969 | -2.2 |
| 1968 | -0.8 |
| 1967 | -1.2 |
| 1966 | -1.1 |
| 1965 | -1.1 |
| 1964 | 0.5 |
| 1963 | 1.3 |
| 1962 | -0.2 |
| 1961 | -0.9 |
| 1960 | -1.4 |
| 1959 | -0.0 |
| 1958 | -0.2 |
| 1957 | 0.2 |
| 1956 | 1.4 |
| 1955 | 1.0 |
| 1954 | 2.2 |
| 1953 | 2.4 |
| 1952 | -0.2 |
| 1951 | -3.6 |
| 1950 | -2.9 |
| 1949 | -0.9 |
| 1948 | -0.7 |
| 1947 | 0.1 |
| 1946 | 2.1 |
| 1945 | -1.1 |
| 1944 | -0.7 |
| 1943 | -0.9 |
| 1942 | -0.3 |
| 1941 | 1.1 |
| 1940 | -1.5 |
| 1939 | 3.6 |
| 1938 | 3.6 |
| 1937 | 0.1 |
| 1936 | 1.0 |
| 1935 | 1.0 |
| 1934 | 4.1 |
| 1933 | 2.7 |
| 1932 | -0.7 |
| 1931 | 4.1 |
| 1930 | 1.9 |
| 1929 | -1.6 |
| 1928 | 1.1 |
| 1927 | 0.1 |
| 1926 | 0.6 |
| 1925 | 0.9 |
| 1924 | -1.8 |
| 1923 | 0.8 |
| 1922 | 1.7 |
| 1921 | 3.9 |
| 1920 | 0.3 |
| 1919 | 0.1 |
| 1918 | 1.4 |
| 1917 | -2.4 |
| 1916 | -1.2 |
| 1915 | -1.1 |
| 1914 | 0.8 |
| 1913 | 1.5 |
| 1912 | -1.4 |
| 1911 | 1.2 |
| 1910 | 0.8 |
| 1909 | -1.1 |
| 1908 | 0.9 |
| 1907 | -0.8 |
| 1906 | -0.0 |
| 1905 | -1.3 |
| 1904 | -1.7 |
| 1903 | -1.4 |
| 1902 | -1.1 |
| 1901 | 0.9 |
| 1900 | 1.4 |
| 1899 | -1.2 |
| 1898 | -0.6 |
| 1897 | -0.5 |
| 1896 | 0.2 |
| 1895 | -0.5 |
| 1894 | 1.0 |
| 1893 | -1.7 |
| 1892 | -2.1 |
| 1891 | -1.8 |
| 1890 | -1.1 |
| 1889 | -1.0 |
| 1888 | -3.1 |
| 1887 | -2.5 |
|-------+--------------|
In [13]:
differences = tables_diff.to_csv('lnkMonths.csv')
In [14]:
import seaborn as sns
import matplotlib.pyplot as plt
import pandas as pd
sns.set(style="ticks", context='talk', font_scale=1)
%matplotlib inline
In [15]:
df = pd.read_csv('lnkMonths.csv')
In [17]:
sns.set_style("white")
sns.stripplot(x="Year" , y="diff_Annual", data=df);
plt.ylabel('')
plt.xlabel('Differences in Annual Temperatures Compared to 30 year average 1981-2010')
plt.xticks(rotation=90)
plt.autoscale(tight=True)
#ax = plt.gca()
#ax.get_xticks().get_major_formatter().scaled[365] = '%y'
sns.despine(bottom=True, left=True)
In [ ]:
Content source: lexieheinle/jour407homework
Similar notebooks: