[Solved] Files Use Filepopulationestimatescsv File Find County State Lowest Population 2013 Net Gai Q37241374

FILES

Use the filepopulation_estimates.csv

From that file, find:

• The county and state with lowest population in 2013
• Net gain or loss of people in Hughes County, SD from 2011 to2012 (Domestic Migration)
• The states with the 3 highest and 3 lowest death rates in2017

WEB

• Using four websites of your choice, print the title of eachsite.
• On the main page of the EECS website, find the number ofinstances of the word Engineeringorengineering.  (https://www.sdstate.edu/electrical-engineering-and-computer-science)
• Using the Wikipedia pages of these four bagpipe bands, printthe following:
  • The name of the band
  • The year it was established
  • The grade the band plays in for competitions
  • The pipe major

The bands: Triumph_Street_Pipe_Band,78th_Fraser_Highlanders_Pipe_Band,

Windsor_Police_Pipe_Band,City_of_Whitehorse_Pipe_Band

Requirements:

• The usual comments
• No errors
• Printed description of the results along with the results

The assignment is due on April 29.

Here is a sample printout.  All results are accurate(with the possible exception of the second item in the Websection).

*****************************

Here is the File information.

*****************************

The county with the lowest population in 2013 is Kalawao Countyin HI with 89.

The net population loss in Hughes County, SD, from 2011 to 2012is 70 people.

The states with the highest death rates are:

             California: 273977

             Florida: 203428

             Texas: 194621

The states with the lowest death rates are:

             Alaska: 4543

             Wyoming: 4847

             Vermont: 5497

********************************

Now here is the Web information.

********************************

These are the titles of the web pages:

Dakota State University

Harvard University

South Dakota State University

MIT – Massachusetts Institute of Technology

The word “Engineering” and “engineering” appear 85 times on theEECS website.

Pipe Band Data:  Band Name, Year Established, Grade,Pipe Major

————————————————————

Triumph Street Pipe Band

1971

1

David Hilder

**********************************

78th Fraser Highlanders Pipe Band

1982

1

Doug MacRae

**********************************

Windsor Police Pipe Band

1967

3

Brian Robertson

**********************************

City of Whitehorse Pipe Band

1956

1

George Shepherd

**********************************

Expert Answer

---

Answer to FILES Use the filepopulation_estimates.csv From that file, find: The county and state with lowest population in 2013 Net… . . .