44:["$","title",null,{"children":"CSE 412 Assignment 2 | yuchens1 | Observable"}] 4c:T49c,md`From two graphs above, we see the connection between population increase and total emissions increase over the years. We also see that the decrease in agricutural land relate to the growth of urban population. We may also guess that urban population causes the most emissions when compared to farmers on their agricutural lands. Urban populations invest in the economy to build factories and drive cars to burn fossil fuel. Urban populations have the money that drives emission. In this dataset, we also can take a look at how foreign investment relate to emissions. Foreign investment is another source of funding to construct large power plants and factories that are huge players in CO2 emissions.

Looking at the year 2000 for example, we see that huge increase in foreign investment. Assuming this is not an outlier, we see a corresponding increase in CO2 emissions. Similar spikes in CO2 emission happen around the other years where there are heavy foreign investments inflow to the United States. `4d:T664,md`### Insights Through this exploration, I first find population to have a positive relationship with total emissions. Then, I hypothesize that if we subset the population into urban and rural population, urban population will have a much heavier weight in producing emissions. However, as I was exploring the structure of the data, I realized the rural population data contain only 3 non-zero data points, which makes any further exploration meaningless, so I tried looking at how agricutural land % decrease over the years can show a clear trend in increasing urban population and decreasing rural population. When this trend is identified, I further hypothesize that urban population produces more emissions because they drive cars and fund factories or power plants that causes heavy CO2 emissions. But since the dataset doesn't contain any urban population investment information, I took the foreign investment inflow as a substitute and showed that increase in investment does relate to an increase in CO2 emissions. My exploration suggests that CO2 emissions is linked to the economy and linked to urbanization. I originally hoped to compare data from different countries especially between developed and developing countries. However, because of the vast amount of missing data for developing countries, I was forced to limit my exploration to the country of the United States. This exploration made me realize that because developing countries had a much shorter history of recording statistics, many time series data are missing for the developing countries making restrospective comparison studies difficult to conduct. `4e:[{"id":"4c1f0bb0e9ad4a1d63b83472e223f87b707751854c3c7f8c03867d7b63f9bdd8b2acb8769a7f9e3feb847eb2c2065859196f3d9e82ce19bfe2f54a316d43cc17","href":"https://static.observableusercontent.com/files/4c1f0bb0e9ad4a1d63b83472e223f87b707751854c3c7f8c03867d7b63f9bdd8b2acb8769a7f9e3feb847eb2c2065859196f3d9e82ce19bfe2f54a316d43cc17","name":"pic8.png","type":"image/png","lastModified":1618510486290.386,"size":130536},{"id":"8b4ecadbae353b97597627d49311ec1c4f274abe7045067ce7c31c0c02177839e206ce273c16aaf40438373a98884826a1ef7a64fd414b8d44dcbc24dd9e385b","href":"https://static.observableusercontent.com/files/8b4ecadbae353b97597627d49311ec1c4f274abe7045067ce7c31c0c02177839e206ce273c16aaf40438373a98884826a1ef7a64fd414b8d44dcbc24dd9e385b","name":"pic11.png","type":"image/png","lastModified":1618511835879.766,"size":266451},{"id":"9fb13d1fc468b79037f83b8373a1f522bac7b2f8c8fb46bc76d3802b20dc56a80a3aacbabc8ee9d5506dd53e4d3b337fd50594aa11c049d719edf7aad331506e","href":"https://static.observableusercontent.com/files/9fb13d1fc468b79037f83b8373a1f522bac7b2f8c8fb46bc76d3802b20dc56a80a3aacbabc8ee9d5506dd53e4d3b337fd50594aa11c049d719edf7aad331506e","name":"pic10.png","type":"image/png","lastModified":1618510954694.926,"size":257246},{"id":"2708d109f9640e08208f70e80f172d23e37e48cce179511e378520ab61b74c98a0856a73b23d6b7e5c8c0fd3f531d2af5d60d09eb778f78229931fbc4926ed36","href":"https://static.observableusercontent.com/files/2708d109f9640e08208f70e80f172d23e37e48cce179511e378520ab61b74c98a0856a73b23d6b7e5c8c0fd3f531d2af5d60d09eb778f78229931fbc4926ed36","name":"pic1.png","type":"image/png","lastModified":1618495301328.557,"size":136089},{"id":"be7742124050c49196cd2ad2b1fdd7333cbfb2e7e937d6c9b7f0d17954839ed8b50ae9aac8e5ff35034ca738dc48ca0721847c49bdf31f8861280c581d329067","href":"https://static.observableusercontent.com/files/be7742124050c49196cd2ad2b1fdd7333cbfb2e7e937d6c9b7f0d17954839ed8b50ae9aac8e5ff35034ca738dc48ca0721847c49bdf31f8861280c581d329067","name":"pic2.png","type":"image/png","lastModified":1618495301349.072,"size":143679},{"id":"864829de54cfcad0c8de83e4dea85c2911a2cfae064a33a16c387d05d91c0a8192f4c7d933e2d2e8155d807319db74f2bd41030d913446d12281cc8a0b80885f","href":"https://static.observableusercontent.com/files/864829de54cfcad0c8de83e4dea85c2911a2cfae064a33a16c387d05d91c0a8192f4c7d933e2d2e8155d807319db74f2bd41030d913446d12281cc8a0b80885f","name":"pic5.png","type":"image/png","lastModified":1618495301330.217,"size":114859},{"id":"20bed0d3b8abf08131f229bde0ad25303041634a9d3029e98633ba7cec192a6378bdd91fc34f2cec126ecfd4b590980459fd1a75fe8de9a5e3efefd4a6a022e7","href":"https://static.observableusercontent.com/files/20bed0d3b8abf08131f229bde0ad25303041634a9d3029e98633ba7cec192a6378bdd91fc34f2cec126ecfd4b590980459fd1a75fe8de9a5e3efefd4a6a022e7","name":"pic6.png","type":"image/png","lastModified":1618508510434.516,"size":177149},{"id":"de5b27bf7134540981910c6bd15a3b86513ad9255e40d118e6bc4eff6f84a23d56a84f08f95448db37939d53b128fcc84092b865406f841fcc3e329e9bdcaa83","href":"https://static.observableusercontent.com/files/de5b27bf7134540981910c6bd15a3b86513ad9255e40d118e6bc4eff6f84a23d56a84f08f95448db37939d53b128fcc84092b865406f841fcc3e329e9bdcaa83","name":"pic7.png","type":"image/png","lastModified":1618509592920.142,"size":171438}] 48:{"id":"75adcb8cbd863e9f","slug":"cse-412-assignment-2","title":"CSE 412 Assignment 2","thumbnail":"53084614ab03709534e08327ca4d08e3e4f8c10141eb814f5ae6ee6bdd496930","access_level":"public","create_time":"$D2021-04-15T13:42:34.214Z","update_time":"$D2021-04-15T18:56:40.510Z","view_time":null,"first_public_time":"$D2021-04-15T14:10:24.559Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"87ca0046cf58a127","login":"yuchens1","name":"","avatar_url":"https://avatars-next.observableusercontent.com/6221fa95282004679ab5e82301444021d1138ed8ffbf2c4f02e5d1e703bdd97a","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":92,"publish_version":92,"role":null,"authored":false,"authors":[{"type":"individual","id":"d7cb304983e2341a","login":"yuchens1","name":"","avatar_url":"https://avatars-next.observableusercontent.com/6221fa95282004679ab5e82301444021d1138ed8ffbf2c4f02e5d1e703bdd97a","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"d7cb304983e2341a","login":"yuchens1","name":"","avatar_url":"https://avatars-next.observableusercontent.com/6221fa95282004679ab5e82301444021d1138ed8ffbf2c4f02e5d1e703bdd97a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"CSE 412 Assignment 2","cells":[{"id":0,"value":"md`# CSE 412 Assignment 2\n \nStudent: Yuchen Sun\n \nDue: Apr 19\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"md`### Part 1: Data Selection\n\nFor this assignment, I will explore the climate change dataset from [link](https://raw.githubusercontent.com/ZeningQu/World-Bank-Data-by-Indicators/master/climate-change/climate-change.csv). \n\nThis dataset contains 52 time series data. One of the variable is \\`Country Code\\`, so I know the dataset contains data from multiple countries. In this exploration, I will only use the data collected from the **United States** to answer the following questions:\n1. How does emission change over time?\n2. How does agricultural land as a % of total land change over time?\n3. How does fishing, forestry and agriculture as a % of GDP change over time?\n\nAfter some exploratory analysis of the data, I want to answer more questions on the relationship between multiple variables.\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"md`### Part 2: Exploratory Visual Analysis\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"import {aq, op} from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"vg = require('vega-lite')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"data_structure = await aq.loadCSV('https://raw.githubusercontent.com/YuchenS1/CSE412/main/A2/datastr.csv?token=AIK5BGABLL5PELNOB7SUMEDAQGY6G')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":53,"value":"data_structure.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md`\n\nQ. How does emission change over time?\n\n

A dot plot of the CO2 emissions over the years show three missing values on the latest years recorded at 0. The missing values are highlighted in red. They will be removed when answering the question.

A dot plot of the agricultural land as % of total land over the years show 6 extreme values possibly outliers. All 6 points are highglighted in red, with the bottom three clearly miss recorded because they are at 0%. The top three are also suspicious because they are out of the ordinary constant decreasing trend of the data.

A dot plot of the contribution of agriculture, forestry and fishing to GDP shows many missing data prior to the 2000s. These missing data significantly reduces the value of the question. Therefore, I will avoid the use of GDP data from this dataset and ignore this question.

This plot shows there are huge spikes in population data through out the years. These spikes must be outliers because population cannot suddenly increase and decrease like that.

\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`It seems like the total CO2 Emissions didn't grow as smoothly as the total population over the years. This shows that there are some policies in play to restrict CO2 Emissions, which started as soon as the 1970s shown by the first dip. Looking at the most recent years, the plot shows that the CO2 emissions growth has reached a plateu. This could be due to the global combined effort to reduce CO2 emissions from cars and power plants such as the EPA’s 2015 “Carbon Pollution Standard for New Power Plants”.`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"md`It is also interesting to look at the decrease in agricultural land as a % of total land and how this relates to the urban population growth. Urban population growth is expected to triple from 2000 to 2030. The plot below shows urban population as a % of total population over the years.\n\n

This plot shows several % points over 100%. Since this is not a plot showing % growth, those points over 100% are definitely outliers to be removed.