Week 1 Project:

Part 1: From the dataset above, write Python code to answer the following questions:

• Find all records where the weather was exactly clear.
• Find the number of times the wind speed was exactly 4 km/hr.
• Check if there are any NULL values present in the dataset.
• Rename the column "Weather" to "Weather_Condition."
• What is the mean visibility of the dataset?
• Find the number of records where the wind speed is greater than 24 km/hr and visibility is equal to 25 km.
• What is the mean value of each column for each weather condition?
• Find all instances where the weather is clear and the relative humidity is greater than 50, or visibility is above 40.
• Find the number of weather conditions that include snow.

Part 2: Move this CSV into a database of your choice and use SQL to answer 4 of the questions