Name: Weather Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Weather Data

📹Project Video available on YouTube - https://youtu.be/4hYOkHijtNw

📖 Get Python Data Analysis Self Study Notes - https://rzp.io/l/dslnotes239

The Weather Dataset is a time-series data set with per-hour information about the weather conditions at a particular location. It records Temperature, Dew Point Temperature, Relative Humidity, Wind Speed, Visibility, Pressure, and Conditions.

This data is available as a CSV file. We have analysed this data using the Pandas library.

Using this dataset, we answered multiple questions with Python in our Project.

Q. 1) Find all the unique 'Wind Speed' values in the data.

Q. 2) Find the number of times when the 'Weather is exactly Clear'.

Q. 3) Find the number of times when the 'Wind Speed was exactly 4 km/h'.

Q. 4) Find out all the Null Values in the data.

Q. 5) Rename the column name 'Weather' of the dataframe to 'Weather Condition'.

Q. 6) What is the mean 'Visibility' ?

Q. 7) What is the Standard Deviation of 'Pressure' in this data?

Q. 8) What is the Variance of 'Relative Humidity' in this data ?

Q. 9) Find all instances when 'Snow' was recorded.

Q. 10) Find all instances when 'Wind Speed is above 24' and 'Visibility is 25'.

Q. 11) What is the Mean value of each column against each 'Weather Condition ?

Q. 12) What is the Minimum & Maximum value of each column against each 'Weather Condition ?

Q. 13) Show all the Records where Weather Condition is Fog.

Q. 14) Find all instances when 'Weather is Clear' or 'Visibility is above 40'.

Q. 15) Find all instances when :
A. 'Weather is Clear' and 'Relative Humidity is greater than 50'
or
B. 'Visibility is above 40'

These are the main Features/Columns available in the dataset :

Date/Time - The timestamp when the weather observation was recorded. Format: M/D/YYYY H:MM.
Temp_C - The air temperature in degrees Celsius at the time of observation.
Dew Point Temp_C - The temperature at which air becomes saturated with moisture (dew point), also measured in degrees Celsius.
Rel Hum_% - The relative humidity, expressed as a percentage (%), indicating how much moisture is in the air compared to the maximum it could hold at that temperature.
Wind Speed_km/h - The speed of the wind at the time of observation, measured in kilometers per hour.
Visibility_km - The distance one can clearly see, measured in kilometers. Lower values often indicate fog or precipitation.
Press_kPa - Atmospheric pressure at the time of observation, measured in kilopascals (kPa).
Weather - A text description of the observed weather conditions, such as "Fog", "Rain", or "Snow".

Tables

Project 1 Weather Dataset

@kaggle.rohitgrewal_weather_data.project_1_weather_dataset

146.59 kB
8,784 rows
8 columns

CREATE TABLE project_1_weather_dataset (
  "date_time" TIMESTAMP,
  "temp_c" DOUBLE,
  "dew_point_temp_c" DOUBLE,
  "rel_hum" BIGINT  -- Rel Hum %,
  "wind_speed_km_h" BIGINT,
  "visibility_km" DOUBLE,
  "press_kpa" DOUBLE,
  "weather" VARCHAR
);