Exploring Weather Trends

Exploring Weather Trends

We would like to understand how the temperature of New York has been changed during the past 250 years compared with the global temperature by looking at 10-year moving average data plotted by a line chart. The tool used here is Python.

Questions

  • Question 1) What was the temperature range for each?

  • Question 2) What is the average temperature gap?

  • Question 3) Can we decrease the gap soon?

Data gathering

Get the data from the database by writing SQL queries.

The query is executed without error and pulls the intended data with CSV format.

Find the moving average on the Spreadsheet. Select 10 cells and find average and copy & paste all the way down.

(*Captured images are attached on the last page.)



Because there is a categorical variable, year, and a quantitative variable, temperature, I selected two line charts in the same plot. I also added a legend meaning each data with different colors. (1) both lines curve upward over the experimental years by and large. (2) however, the temperature of New York were below the global average for only about 30 years between 1750 and 1800, (3) temperature gap has been around 1.12 Celsius degree since then without reversing each other. (4) the gap was the largest in 1957.

Answer

  • Question 1) What was the temperature range for each(City/Globe)? 7.73 ~ 11.08 (C) / 7.20 ~ 9.59 (C)

  • Question 2) What is the average temperature gap? 1.12 (C)

  • Question 3) Can we find decreasing the gap soon? No, the gap is increasing.





https://github.com/cpasean/Exploring-Weather-Trends


  • Twitter
  • LinkedIn
  • Pinterest
  • YouTube
17880656449892228.jpg