Name: Canada Weather
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Canada Weather

Context

I always wanted to show how drastic climates of Canada in winters and summers can be so decided to scrape the data and perform visualizations on it using plotly

Content

Province and Places
Temperatures in both Celsius and Fahrenheit
Height of the place from sea level
Weather station from weather was collected

Acknowledgements

The data was scraped from https://en.wikipedia.org/wiki/Temperature_in_Canada

Tables

Canada Weather

@kaggle.hemil26_canada_weather.canada_weather

14.48 kB
43 rows
10 columns

CREATE TABLE canada_weather (
  "community" VARCHAR,
  "weather_station" VARCHAR,
  "location" VARCHAR,
  "elevation" VARCHAR,
  "january_avg_high_c_f" VARCHAR  -- January(Avg. High °C (°F)),
  "january_avg_low_c_f" VARCHAR  -- January(Avg. Low °C (°F)),
  "july_avg_high_c_f" VARCHAR  -- July(Avg. High °C (°F)),
  "july_avg_low_c_f" VARCHAR  -- July(Avg. Low °C (°F)),
  "annual_avg_high_c_f" VARCHAR  -- Annual(Avg. High °C (°F)),
  "annual_avg_low_c_f" VARCHAR  -- Annual(Avg. Low °C (°F))
);