Question

Your task is to find the state with the highest minimum monthly rainfall, and the month in which it occurred, using the weather dataset in climate_data_2017.csv.

In any given month, the minimum monthly rainfall for each state is the lowest rainfall recording from any weather station in that state during that month.
For example, suppose NSW had rainfall recordings of 1, 10, 5, and 7 for January; then its minimum monthly rainfall for January would be min(1,10,5,7)=1, the lowest of those recordings.
If there are several correct answers, your program can output any of the correct answers.
On the given data, your program's output should look like this:
Month: 11
State: QLD
​

Answer 1

Based on the dataset here's a sample code snippet.

import pandas as pd

# Load the dataset

data = pd.read_csv('climate_data_2017.csv')

# Convert the 'Date' column to datetime format

data['Date'] = pd.to_datetime(data['Date'])

# Extract month and state from the 'Date' column

data['Month'] = data['Date'].dt.month

data['State'] = data['Location'].str.strip()

# Find the state with the highest minimum monthly rainfall

result = data.groupby(['Month', 'State'])['Rainfall (mm)'].min().idxmax()

# Extract month and state from the result

month, state = result

# Output the result

print("Month:", month)

print("State:", state)