Skip to content

Instantly share code, notes, and snippets.

@dmadisetti

dmadisetti/consolidated_climate_data.csv

Last active December 8, 2023 20:08
Show Gist options
  • Save dmadisetti/27cbeb9330ccd6b392f1d1a6daf30c4a to your computer and use it in GitHub Desktop.
Save dmadisetti/27cbeb9330ccd6b392f1d1a6daf30c4a to your computer and use it in GitHub Desktop.
Download ZIP
fam-climate.ipynb
Raw
consolidated_climate_data.csv
Year Total_Emission_Debt Fossil_Emissions CO2_ppm Temp_Model_Adjusted J-D NASA_Temp_Anomaly Fusion_World_Temp_Model Ocean_Sink Land_Sink Cement_Sink Land_Emissions
1850 44.62777214 53.69868079 280.0767681 -0.6798807638 18.92484 16.4195 45.86756865 72.141
1851 142.8091743 54.22164267 280.2456586 -0.6772716508 12.55284 16.5485 1.526900468 74.588
1852 238.3707906 56.60868334 280.4100425 -0.6747336667 6.96672 17.1645 12.79518039 75.87933333
1853 339.1552426 59.25776166 280.5834107 -0.6720585828 0.97704 17.2905 17.704103 77.49833333
1854 428.4229425 69.60512241 280.7369679 -0.6696905637 -3.90816 17.432 45.28458255 78.471
1855 549.1738302 70.98919056 280.9446821 -0.6664894451 -6.35076 18.083 17.25272954 78.74666667
1856 630.0007868 75.68134435 281.0837197 -0.6643480361 -6.32952 18.227 62.13890773 79.182
1857 668.2234337 76.40065946 281.1494698 -0.6633357438 -5.28876 18.896 104.8241059 80.25333333
1858 782.5013495 77.57236773 281.3460493 -0.6603106077 -3.63204 19.561 28.15549193 80.79
1859 947.0170268 82.28200476 281.6290471 -0.6559593 -1.3806 19.76 -18.47973922 82.13333333
1860 1057.07163 90.32821506 281.8183617 -0.6530508843 1.4868 19.967 36.74181218 77.922
1861 1247.560967 94.91970881 282.1460391 -0.6480214321 5.0976 20.6965 -46.25472889 75.109
1862 1423.624889 96.74915536 282.4489022 -0.643378043 9.47304 21.9015 -36.2563063 74.433
1863 1485.979702 103.2151045 282.5561641 -0.6417347337 14.6556 22.639 77.6360252 74.07033333
1864 1562.658318 111.2789231 282.6880658 -0.6397147876 20.709 22.8825 64.35680705 73.348
1865 1701.680948 118.1384085 282.9272108 -0.6360549143 27.42084 23.6465 0.1067712536 72.05833333
1866 1787.057948 121.8759791 283.0740753 -0.6338088348 33.49548 24.4015 51.15566632 72.55366667
1867 1862.746531 130.5023877 283.2042738 -0.6318186103 38.59308 25.209 63.90505806 72.89333333
1868 1926.793996 134.1571931 283.3144475 -0.6301352025 42.75612 25.9695 73.48677491 72.10266667
1869 2039.995199 142.4547501 283.5091748 -0.6271614503 45.92088 26.803 28.20966708 71.68
1870 2130.518833 145.5617487 283.6648925 -0.6247848986 48.17232 27.1125 57.62829469 77.875
1871 2292.78661 154.7192614 283.9440235 -0.6205280837 49.57416 27.913 -4.401342548 80.63433333
1872 2444.921452 171.206673 284.205724 -0.616540888 49.74408 28.7825 22.53058388 81.98533333
1873 2610.115072 181.8998967 284.4898881 -0.6122155995 48.66084 29.5945 22.27427065 83.82333333
1874 2736.58475 170.369139 284.7074397 -0.6089071445 46.3032 30.465 52.53992771 85.40866667
1875 2892.637444 184.8018078 284.9758796 -0.6048282784 43.13844 31.3115 40.33450722 86.03533333
1876 3013.854067 187.4400179 285.184395 -0.6016625992 41.05692 32.18 79.84780807 86.86133333
1877 3109.937939 191.1584065 285.3496773 -0.5991549281 40.48344 33.546 109.5020941 88.457
1878 3255.970346 192.6783733 285.6008804 -0.5953464416 41.43924 34.427 60.84506016 90.06533333
1879 3465.735957 206.3292798 285.9617167 -0.5898816677 43.81812 35.277 8.369548103 90.901
1880 3641.041522 233.0557893 286.2632752 -0.5853199273 -0.16 46.85544 36.152 66.81811751 92.07533333
1881 3908.501202 241.1419382 286.7233561 -0.5783694348 -0.07 50.445 37.0275 -22.64757481 91.14266667
1882 4175.503612 254.7380284 287.1826503 -0.5714419409 -0.1 54.56556 37.901 -11.78827449 92.94266667
1883 4343.157913 270.9480364 287.4710472 -0.5670977372 -0.16 59.23836 38.723 100.1893754 94.857
1884 4513.527761 274.0540614 287.7641154 -0.5626876315 -0.27 64.73952 39.5745 94.44652609 95.07633333
1885 4738.61147 276.1018373 288.1513016 -0.5568681127 -0.33 71.98236 40.4035 33.54926864 94.917
1886 4915.905035 280.4087096 288.4562798 -0.5522897065 -0.31 78.33312 40.716 80.29502465 96.229
1887 5094.910499 294.417803 288.7642028 -0.5476720009 -0.35 82.22004 41.5325 89.46446587 97.80466667
1888 5294.061151 325.9696084 289.1067794 -0.5425404038 -0.17 83.96172 41.8595 99.05906906 98.06133333
1889 5531.106993 326.0436859 289.5145427 -0.5364402662 -0.1 85.32108 42.6245 58.89759804 97.84533333
1890 5777.578349 354.9023758 289.9385198 -0.5301066766 -0.35 86.36184 43.3865 83.72967888 105.047
1891 6109.614586 371.6567085 290.5096844 -0.5215889479 -0.22 86.19192 43.643 17.75188562 107.9663333
1892 6406.698697 374.562358 291.0207249 -0.5139820295 -0.27 84.429 44.394 57.78091375 109.1256667
1893 6701.97065 369.9446891 291.5286481 -0.5064347364 -0.31 81.28548 45.139 59.48025597 111.232
1894 6997.579312 382.9200778 292.0371505 -0.4988919973 -0.3 77.35608 45.927 76.23966883 112.2113333
1895 7332.030293 405.9586182 292.612469 -0.4903739785 -0.22 72.76824 46.162 65.88106358 113.3036667
1896 7632.216625 419.3137582 293.1288459 -0.4827428842 -0.11 66.50244 46.931 120.1496535 114.4556667
1897 7949.143072 439.2007541 293.6740189 -0.4747008108 -0.1 59.06844 47.716 130.3298667 114.84
1898 8353.307 463.2004398 294.3692567 -0.4644667 -0.26 53.2062 47.9805 73.54347903 115.6936667
1899 8841.942326 505.9250053 295.2098013 -0.452125859 -0.17 49.65912 48.7715 36.17672532 117.3176667
1900 9312.743553 532.8082653 296.0196678 -0.4402686237 -0.08 48.25728 49.1055 84.1125916 119.4683333
1901 9877.028131 550.4215282 296.9903432 -0.4260996565 -0.15 48.40596 49.9255 8.383156852 120.5776667
1902 10490.89965 564.3242217 298.0463175 -0.4107380773 -0.27 49.89276 50.2425 -27.23955297 122.443
1903 10985.23441 615.2020059 298.8966661 -0.398407306 -0.36 52.59024 51.101 139.8850023 122.709
1904 11480.89653 622.2018054 299.7492981 -0.3860785965 -0.46 56.45592 51.9745 143.19893 125.0896667
1905 12120.70152 662.4777232 300.8498828 -0.3702163381 -0.26 60.9588 52.319 34.88527073 125.4903333
1906 12711.09705 691.7940056 301.865474 -0.3556304503 -0.22 64.22976 53.1915 110.1772103 126.2
1907 13383.78326 788.2963946 303.0226206 -0.3390712383 -0.38 66.906 54.0975 121.9666917 127.36
1908 14026.96156 757.7622645 304.1290081 -0.3232974374 -0.43 68.90256 54.9505 119.1492301 128.4183333
1909 14745.89589 788.8904969 305.3657101 -0.3057335146 -0.48 70.07076 55.817 73.59508091 129.5266667
1910 15470.67101 828.0812816 306.6124594 -0.2880987527 -0.43 70.79292 56.192 103.0325684 126.7113333
1911 16268.93542 840.4754386 307.9856241 -0.2687586873 -0.43 72.5346 57.0295 38.42326279 125.7763333
1912 17086.94674 883.1778426 309.3927572 -0.24902945 -0.35 75.59316 57.396 56.35303579 124.1756667
1913 17964.96496 956.9529911 310.9031134 -0.22795253 -0.34 78.92784 58.2225 65.65543053 123.871
1914 18717.87504 868.0009765 312.1982602 -0.2099602301 -0.15 81.51912 58.512 98.86910364 123.8093333
1915 19491.50655 855.5824396 313.5290516 -0.1915503337 -0.14 83.60064 59.3875 61.51178948 122.549
1916 20266.59388 924.0879912 314.8623474 -0.1731839899 -0.35 84.76884 59.6995 125.7899854 121.2576667
1917 21026.38432 966.2736619 316.1693297 -0.1552554494 -0.45 84.8538 60.49 182.0010884 120.8616667
1918 21864.69153 953.4017846 317.6113755 -0.1355599687 -0.29 83.60064 61.2745 91.81944362 121.6
1919 22649.43345 826.6939274 318.9612789 -0.1172038365 -0.27 80.96688 61.601 19.83479272 120.4506667
1920 23474.91737 961.0882627 320.3812663 -0.09797834818 -0.27 77.56848 62.373 121.4381902 125.7753333
1921 24192.58035 843.3670013 321.6157814 -0.08133312217 -0.18 74.93472 63.178 116.7349728 129.1436667
1922 25016.04092 884.3651406 323.0322882 -0.06231259845 -0.28 73.29924 63.4325 55.01516611 130.8423333
1923 25886.37733 1003.338739 324.5294303 -0.04229977278 -0.26 72.70452 64.2225 126.7516375 130.6763333
1924 26817.80454 1006.337392 326.13166 -0.02098421933 -0.27 72.8532 64.4645 68.78681471 131.1943333
1925 27739.24518 1017.203543 327.716711 0 -0.22 73.34172 65.195 90.27018618 133.044
1926 28690.12683 999.189576 329.352406 0.02154854546 -0.1 74.59488 65.4085 40.90021032 132.5956667
1927 29651.24884 1090.64645 331.0057163 0.04322067351 -0.21 76.18788 65.5995 120.5653913 132.8283333
1928 30687.50364 1085.906982 332.7882692 0.06646601525 -0.19 77.99328 66.2745 38.43773973 133.0533333
1929 31779.93253 1165.640794 334.667452 0.09083702467 -0.36 79.09776 66.403 61.14680447 133.4356667
1930 32763.98799 1074.945008 336.3602122 0.1126734589 -0.16 79.20396 66.5485 80.61609135 135.479
1931 33720.61961 960.6722795 338.0057982 0.133796263 -0.09 79.14024 66.6855 -4.358748867 137.4263333
1932 34498.02716 866.1234482 339.3430852 0.1508861247 -0.16 79.0128 67.242 81.42443447 138.9633333
1933 35322.99264 911.9864087 340.7621808 0.1689479617 -0.29 78.75792 67.314 80.47767906 139.5286667
1934 36238.94603 991.8782087 342.3377926 0.1889139829 -0.13 78.35436 67.3565 71.08162515 140.8676667
1935 37219.22158 1041.156755 344.0240506 0.2101805585 -0.2 77.50476 67.3935 56.9352736 140.9523333
1936 38307.23001 1142.334546 345.8956295 0.233662632 -0.15 75.91176 67.3925 52.67852505 141.6566667
1937 39476.29932 1221.133412 347.9066482 0.2587530216 -0.03 73.9152 67.3775 52.04873788 141.2773333
1938 40558.32195 1148.17166 349.7679303 0.2818463284 0 71.45136 67.3425 69.37683568 142.0216667
1939 41645.93297 1214.860074 351.6388255 0.304935393 -0.02 67.2246 67.3255 134.7922813 142.0933333
1940 42882.98005 1326.786429 353.7667788 0.3310480034 0.13 60.72516 67.3305 107.480029 145.7963333
1941 44237.80917 1356.66333 356.0973393 0.3594672467 0.19 52.3566 66.803 33.18360732 150.509
1942 45532.61989 1353.598818 358.3246569 0.3864542416 0.07 43.011 66.835 100.4177629 151.4756667
1943 46842.52171 1376.008271 360.5779341 0.4135856144 0.09 33.453 66.8845 116.9409536 151.172
1944 48277.794 1396.809135 363.0468719 0.4431197449 0.2 25.97652 66.985 19.76699364 151.1916667
1945 49427.40072 1161.882187 365.0244114 0.4666311244 0.09 21.4524 67.1235 73.95656492 150.257
1946 50708.35558 1268.046835 367.2278943 0.4926792237 -0.07 20.36916 67.8325 48.71965016 149.8293333
1947 52045.4282 1404.416436 369.5279103 0.5197022817 -0.03 21.53736 68.1085 126.2666157 148.5686667
1948 53473.38463 1480.60936 371.9842635 0.5483770494 -0.11 25.04196 68.902 105.2316444 146.5226667
1949 54854.11894 1414.029949 374.3593858 0.5759240547 -0.11 30.35196 69.308 78.74034333 145.1046667
1950 56327.51489 1618.270106 376.8939036 0.6051276543 -0.17 36.27792 70.2545 203.9277307 165.586
1951 58031.48668 1741.650054 379.825055 0.638657504 -0.07 41.92776 71.233 92.71717902 168.1996667
1952 59839.03154 1765.130202 382.9343716 0.6739437582 0.01 48.04488 72.84 8.776126128 172.0756667
1953 61593.24365 1815.19141 385.9519459 0.7079159724 0.08 54.84168 74.464 106.8156143 175.142
1954 63397.01116 1853.028751 389.0547647 0.7425720229 -0.13 62.31816 75.6845 90.63225474 179.3736667
1955 65275.4697 2031.621392 392.2860662 0.7783705552 -0.14 70.04952 76.967 191.5563298 185.41
1956 67241.92073 2163.204266 395.6687312 0.815531449 -0.19 77.58972 78.329 231.6805134 190.846
1957 69415.24643 2234.064852 399.4072596 0.8562339437 0.05 87.14772 79.2965 90.06159579 195.7666667
1958 71655.82866 2297.259736 403.2614818 0.8977991103 0.06 174.1158665 80.7815 3.249806071 201.4696667
1959 73938.46491 2416.665456 407.1880448 0.9397378896 0.03 203.904 99.24198 43.03589517 212.1526667
1960 76317.01136 2561.796211 411.2795914 0.9830107292 -0.03 150.804 93.65142918 125.234663 186.4403333
1961 78725.60238 2569.427515 415.4228202 1.026393686 0.06 165.672 83.95087835 89.96195146 178.7483333
1962 81210.76375 2660.086233 419.6977645 1.070704614 0.03 118.944 92.36032753 129.3962035 165.7756667
1963 83844.82724 2801.868781 424.2288484 1.117180468 0.05 121.068 111.1697767 95.97317982 160.4056667
1964 86563.88296 2954.044224 428.9061348 1.164638132 -0.2 104.076 122.9492259 164.4886173 156.5253333
1965 89388.56924 3086.705587 433.7651257 1.213394477 -0.11 233.64 133.7886751 36.66362438 142.073
1966 92246.53324 3237.365852 438.6813605 1.262172501 -0.06 233.64 126.8381242 156.3293953 137.4056667
1967 95313.59403 3339.609301 443.957281 1.313914865 -0.02 129.564 111.0075734 173.0972744 141.1203333
1968 98399.38785 3521.92569 449.2654259 1.365356399 -0.08 210.276 120.0970226 248.56318 142.8043333
1969 101802.2092 3755.68761 455.1189176 1.421382943 0.05 280.368 129.9864718 76.56012691 134.0483333
1970 105579.0818 4066.090712 461.6158478 1.48273054 0.03 240.012 111.3059209 77.47951854 139.5793333
1971 109433.0817 4231.109638 468.2454513 1.544447217 -0.08 155.052 122.9253701 230.6640669 131.5316667
1972 113401.7407 4427.79468 475.0722902 1.607093458 0.01 312.228 153.1248193 125.3937953 131.611
1973 117576.4217 4662.527456 482.2535254 1.672027632 0.16 310.104 137.1942685 168.6948679 128.1466667
1974 121690.4033 4642.298615 489.3303464 1.735078545 -0.07 144.432 131.8637176 376.5889699 124.5676667
1975 125832.3668 4653.378644 496.4553014 1.797643767 -0.01 261.252 123.8031668 252.2553245 125.8953333
1976 130216.4283 4908.636736 503.9967104 1.86289523 -0.1 206.028 144.052616 299.7899716 125.2953333
1977 134686.7913 5047.666914 511.6865743 1.928433419 0.18 407.808 153.0920652 141.7101717 125.3063333
1978 139328.0642 5203.044493 519.6704353 1.995443231 0.07 273.996 155.5515143 253.8517653 121.6276667
1979 144070.0292 5350.164359 527.8275057 2.062851877 0.16 454.536 152.5009635 116.5996657 115.4373333
1980 148921.2132 5317.259993 536.1724531 2.130743577 0.26 363.204 178.8404127 44.29666143 120.265
1981 153600.4477 5190.215328 544.2216153 2.195235053 0.32 244.26 176.2898619 217.4755512 127.0446667
1982 158307.7709 5148.846395 552.3190952 2.259158296 0.14 212.4 194.709311 162.0518848 127.638
1983 162995.8161 5181.741625 560.3834132 2.32189504 0.31 388.692 209.8487602 35.97670663 140.821
1984 167786.5729 5360.733803 568.6244147 2.385080411 0.16 261.252 187.4082094 284.1700739 162.8533333
1985 172686.3407 5541.793264 577.0529354 2.448763285 0.12 350.46 176.6976586 265.0944873 150.2266667
1986 177822.3771 5624.32119 585.8878826 2.514526114 0.18 216.648 183.4271078 243.5813351 155.3716667
1987 182946.0036 5798.52154 594.7014823 2.579149293 0.32 2.579149293 562.86 198.8565569 63.68516939 150.5066667
1988 188266.7256 6025.487138 289.7156237 -0.5334352585 0.39 -0.5334352585 458.784 180.9060061 209.6901296 144.615
1989 193667.5823 6107.797353 289.9943383 -0.5292735196 0.28 -0.5292735196 310.104 184.6454553 355.2275667 143.0363333
1990 199321.8799 6209.79811 290.2861319 -0.5249207704 0.45 -0.5249207704 259.128 200.8756579 236.5148815 141.018
1991 205209.1406 6339.922251 290.5899478 -0.5203933301 0.41 -0.5203933301 159.3 213.9805427 214.3846033 135.0036667
1992 210883.3737 6159.170024 290.8827702 -0.5160341906 0.22 -0.5160341906 152.928 230.1725826 244.388355 142.552
1993 216460.1324 6222.257178 291.1705623 -0.5117542079 0.24 -0.5117542079 261.252 224.5826043 299.6492445 139.9853333
1994 222200.5427 6286.783591 291.4667998 -0.507353044 0.32 -0.507353044 352.584 203.4234618 148.0194982 157.6536667
1995 227962.8133 6420.439935 291.7641655 -0.5029396162 0.45 -0.5029396162 424.8 203.3206139 183.9646751 153.916
1996 233977.4641 6618.494234 292.0745553 -0.4983376813 0.33 -0.4983376813 223.02 202.8526559 341.6528128 163.682
1997 239872.7639 6658.283437 292.378786 -0.4938318078 0.47 -0.4938318078 418.428 220.0500515 328.6812253 204.1756667
1998 245702.2311 6640.541938 292.6796194 -0.4893808592 0.61 -0.4893808592 603.216 224.0400205 152.0810703 168.2623333
1999 251806.4718 6777.700499 292.9946326 -0.4847250147 0.39 -0.4847250147 282.492 199.6638796 355.1686017 163.8646667
2000 258072.3673 6959.958454 293.3179881 -0.4799510758 0.4 -0.4799510758 265.5 193.6719566 381.6066037 146.7156667
2001 264387.7721 7007.349984 293.6438986 -0.4751447385 0.54 -0.4751447385 390.816 183.7084719 254.8707065 137.45
2002 270842.0233 7163.834459 293.9769743 -0.4702382408 0.63 -0.4702382408 503.388 223.7809127 129.389719 146.9753333
2003 277570.8538 7546.02874 294.3242198 -0.4651289243 0.62 -0.4651289243 486.396 234.3089908 255.7056323 159.2123333
2004 284607.3653 7811.187939 294.6873435 -0.4597924239 0.54 -0.4597924239 331.344 230.3435164 360.1998724 147.211
2005 291857.4097 8076.447289 295.0614866 -0.4543008536 0.68 -0.4543008536 524.628 233.6899474 201.5976151 133.5126667
2006 299408.9456 8353.102395 295.4511884 -0.4485883165 0.64 -0.4485883165 375.948 244.5972109 323.8899246 142.8686667
2007 307153.1065 8597.088978 295.8508307 -0.4427378839 0.67 -0.4427378839 450.288 237.7707296 289.2153592 124.346
2008 315048.9784 8745.060733 296.2583022 -0.4367809702 0.55 -0.4367809702 375.948 240.1370364 362.4921191 129.3883333
2009 322895.8595 8595.323847 296.6632455 -0.4308691283 0.66 -0.4308691283 335.592 255.9065859 299.8521825 142.908
2010 331027.0051 9090.155017 297.0828584 -0.4247516289 0.73 -0.4247516289 514.008 251.828282 334.4808578 141.3076667
2011 339542.2344 9398.60004 297.5222922 -0.418354418 0.61 -0.418354418 356.832 255.6846706 413.2666979 142.4126667
2012 348190.0584 9534.785309 297.9685686 -0.4118672562 0.65 -0.4118672562 511.884 261.7698426 259.1914894 145.884
2013 356789.2671 9615.84801 298.4123363 -0.4054261903 0.68 -0.4054261903 520.38 264.9486241 363.9193355 132.6086667
2014 365513.7122 9679.638329 298.8625668 -0.3989010998 0.75 -0.3989010998 433.296 278.5954224 385.6130914 142.3113333
2015 374206.8698 9678.824989 299.3111827 -0.3924091794 0.9 -0.3924091794 626.58 284.9992191 227.7525489 153.6643333
2016 382816.2073 9677.954599 299.755473 -0.3859894374 1.02 -0.3859894374 603.216 296.9237041 293.9957047 125.5183333
2017 391662.5052 9832.273843 300.2119918 -0.3794029047 0.93 -0.3794029047 454.536 283.0498102 372.9804319 124.5903333
2018 400655.2483 10034.64659 300.676068 -0.3727175939 0.85 -0.3727175939 507.636 290.7491374 360.4710237 116.9526667
2019 409762.3451 10109.19852 301.1460455 -0.3659577791 0.98 -0.3659577791 531 295.5931523 300.9866407 125.478
2020 418334.6287 9554.513897 301.5884237 -0.359604565 1.02 -0.359604565 497.016 291.436547 311.0043659 117.2266667
2021 427343.5525 10048.18298 302.0533349 -0.3529377773 -0.3529377773 520.38 282.5585012 354.2676978 117.947
2022 436481.3016 10139.13339 302.5248942 -0.3461861304 -0.3461861304 463.032 277.9694058 378.0125554 117.6296667
Display the source blob
Display the rendered blob
Raw
fam-climate.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment