https://docs.google.com/spreadsheets/d/1hnqPF8u3HeZViLud4vNGnNRBO_A…
Question Answered step-by-step https://docs.google.com/spreadsheets/d/1hnqPF8u3HeZViLud4vNGnNRBO_A… https://docs.google.com/spreadsheets/d/1hnqPF8u3HeZViLud4vNGnNRBO_Aw9sHn6EJn7eSZVxE/edit?usp=sharing Use “FishBioDiversity.csv”(link in the bottom) to understand the dynamics of projects, sites, and geographic locations. Each site (identified by the column SITEID) represents a time and place at which fishing events occurred. Sites are grouped into broader projects (identified by the column Project Name). (a) Using .groupby, find the top three projects by a number of unique sites. (Use unique() )(b) Find the top three and bottom three projects in terms of the proportion of unique sites for each project to the total number of fishing events for that project. (c) Use a single .groupby statement to view the minimum, mean, standard deviation, and maximum air temperature and water temperature for each project during the month of August (use the Month column). (d) Use pd.cut to show a new column ‘Region’ that satisfies the following conditions:Rows with a latitude lower than 42.4 should have Southern in the Region columnRows with latitude between 42.4 and 42.8 should have Central in the Region columnRows with a latitude higher than 42.8 should have Northern in the Region column(e) Make line plots showing maximum air temperature by month and Region. You can have the month on the horizontal axis, the air temperature on the vertical axis, and different colors for different regions.(f) Let’s continue using our Region categorization. Find the top three fish species in each region by number captured.(g) Given by Maximum (mm) and Minimum (mm). Find the overall maximum and minimum lengths of all fish in each region. Which region has the largest range in captured fish length (Use different aggregations per column). https://docs.google.com/spreadsheets/d/1hnqPF8u3HeZViLud4vNGnNRBO_Aw9sHn6EJn7eSZVxE/edit?usp=sharing Computer Science Engineering & Technology Python Programming CS 142 Share QuestionEmailCopy link Comments (0)
