How we built it
We used jupyter notebook to organize the pesticides from each state. We Created DataFrames for different states based on the first two letters of 'Sample ID'. We then grouped the data by 'State' and 'Pesticide Name' and calculated the mean concentration. We then filtered the result by state, for example, 'CA' for California. We then filtered the DataFrame to show only the rows for the selected state. We then sorted by 'Concentration' in descending order. We then displayed the result for the chosen state, sorted by highest to lowest average concentration.
For the Highest Concentration
We found the rows with the highest concentration for each state. We then sorted the results by state for clarity.
Log in or sign up for Devpost to join the conversation.