How can I use that information for a graph that is currently Water Usage on the y axis and Lot Size on the x axis. The code is as follows: # Create the interactive scatter plot df_clean = df_complete.dropna(subset=['Lot Size (Acres)']) # Convert 'Lot Size (Acres)' to numeric, replacing errors with NaN df_clean['Lot Size (Acres)'] = pd.to_numeric(df_complete['Lot Size (Acres)'], errors='coerce') # Drop rows with NaN values in 'Lot Size (Acres)' df_clean = df_clean.dropna(subset=['Lot Size (Acres)']) aggregated_data = df_clean.groupby('Building Type').agg({ 'Lot Size (Acres)': 'sum', 'Value': 'sum' }).reset_index() # Create the scatter plot using the aggregated data fig = px.scatter( aggregated_data, x='Lot Size (Acres)', y='Value', color='Building Type', size='Lot Size (Acres)', hover_data=['Building Type'], size_max=80, labels={'Value': 'Total Water Usage'}, log_x=True, log_y=True ) # Update layout for better readability and larger size fig.update_layout( title='Correlation Between Building\'s Lot Size and Water Usage (in Acres)', xaxis_title='Lot Size (Acres)', yaxis_title='Total Water Usage', xaxis_tickangle=-45, plot_bgcolor='rgba(0,0,0,0)', legend_title_text='Building', width=1800, height=800 ) # Show the plot fig.show()