Cleaning and Filtering Mosquito Breeding Site Data

Jun 8, 2024, 9:51 AM

What is the distribution of mosquito breeding sites in 2024?

It seems like the first sheet, 'Plan1', contains some data, while 'Plan2' and 'Plan3' are empty. We'll focus on 'Plan1' to analyze the distribution of mosquito breeding sites for 2024.
Let's clean and process the data from 'Plan1' to extract meaningful information about the mosquito breeding sites.
It seems like there are still some rows with metadata. We'll need to skip a few more rows to reach the actual data.
We have successfully cleaned the data and can now see the relevant columns, including the municipality, state (UF), execution period, and the infestation index percentage (IIP). Next, we'll analyze the distribution of mosquito breeding sites based on this data.
We have renamed the columns for clarity. The data now includes the municipality, state (UF), execution period, infestation index percentage (IIP), and classification.
Next, let's visualize the distribution of mosquito breeding sites based on the IIP values.

Visualize this for me

A bar plot was created to visualize the Infestation Index Percentage (IIP) by Municipality. The plot categorizes the data based on the 'Classification' attribute, providing a clear visual representation of IIP across different municipalities.

Continue the analysis

  • The basic statistics for the IIP values have been calculated.
  • Here are the key findings:
    • Count: 221
    • Mean: 1.675
    • Standard Deviation: 1.768
    • Minimum: 0.0
    • 25th Percentile: 0.3
    • Median (50th Percentile): 1.3
    • 75th Percentile: 2.4
    • Maximum: 10.9

Visualize this for me

A box plot of the Infestation Index Percentage (IIP) values was created using Plotly. The plot includes:
  • A single box plot for the IIP values.
  • Mean value indicated within the plot.
  • Title: 'Box Plot of Infestation Index Percentage (IIP)'.
  • Y-axis labeled as 'Infestation Index Percentage (IIP)'.
  • X-axis labeled as 'IIP Distribution'.
The plot provides a visual representation of the distribution of IIP values.
Get started with Vizly