import pandas

data_frame = pandas.read_table('QldLandclearingdata.csv', sep=',')
data_frame.describe()

index = data_frame['Clearing_Rate_ha_yr'].idxmax()
period = data_frame['Period'][index]
region = data_frame['NRM_Region'][index]
replacement = data_frame['Replacement_Class'][index]
print('Solution 2: Period =', period, 'Region =', region, 'R_Class =', replacement)

subsample = data_frame.query('Replacement_Class == @replacement')
rate = subsample['Clearing_Rate_ha_yr']
length = subsample['length']
cleared = rate * length
print('Solution 3: The total area cleared is', round(cleared.sum()), 'ha')