Python:

Snippet of csv file:

cannot add .csv file to here but i uploaded a screenshot of what is in the file.

The attached csv, Hidden_Island.csv, describes the occurrences of four new species found on an island hidden away off the west coast of Canada - purple puffins, wisteria wombats, burgundy Bichon Frise (a kind of dog), and pumpkin Pomeranians. The island has three distinct ranges, identified as range 1, 2 and 3. The file lists sightings of species in each region, as well as how many unique individuals were observed in that sighting. Program Task You are first asked to structure the data from Hidden_Island.csv into a structured NumPy array, where the species are strings and the other data are stored as integers. It is suggested that the header from the csv become the columns labels for the array. Next, you are asked to print the following summary stats to the console: The mean occurrences of each species in each region (that is, the mean of each species for range 1. range 2, and range 3) The species with the highest population for each region and what that population is (this should be only one species per region) The species with the lowest population for each region and what that population is this should be only one species per region) The mean of each species overall and the standard deviation of each species overall (all regions should be included in this one calculation) Finally, for the sake of easy comparison, you are asked to construct a bar chart where the x-axis represents each region, the y-axis the species count and bars are properly given a label for each of the four species. The bars should match the color of the animals as well (or be close enough - purple, pink, burgundy, and orange suffice). Note that for all of this, it is expected you will use NumPy functions and arrays when possible! Points may be deducted for using older methods on this assignment. A1 X fo Animal B 2 1 4 2 2 2 A B 1 Animal Range Unique Individuals 2 Purple Puffin 1 1 3 Wisteria Wombat 3 4 4 Pumpkin Pomeranian 1 3 5 Wisteria Wombat 2 3 6 Burgundy Bichon Frise 2 7 Purple Puffin 1 8 Wisteria Wombat 2 9 Pumpkin Pomeranian 1 10 Pumpkin Pomeranian 3 1 11 Burgundy Bichon Frise 2 2 12 Wisteria Wombat 1 5 13 Pumpkin Pomeranian 2 1 14 Pumpkin Pomeranian 1 3 15 Purple Puffin 1 1 16 Burgundy Bichon Frise 3 1 17 Wisteria Wombat 1 3 18 Purple Puffin 1 5 19 Purple Puffin 3 1 20 Pumpkin Pomeranian 2 21 Pumpkin Pomeranian 3 22 Purple Puffin 1 3 23 Purple Puffin 3 24 Pumpkin Pomeranian 1 2 25 Burgundy Bichon Frise 1 5 26 Burgundy Bichon Frise 2 1 27 Purple Puffin 1 5 28 Pumpkin Pomeranian 2 2 29 Pumpkin Pomeranian 2 30 Burgundy Bichon Frise 2 2 31 Pumpkin Pomeranian 1 4 32 Purple Puffin 1 3 33 Purple Puffin 2 3 34 Purple Puffin 1 4 35 Burgundy Bichon Frise 2 2 36 Wisteria Wombat 3 4 37 Purple Puffin 2 Hidden_Island 1 4 3 1 5 1 + Dondur