CSV File: Combined Final

–Identify the counties and the rates of all counties with poverty rates greater than 25%:

Hamilton County with 28.1%, Putnam County with 27.4%, Holmes County with 26.4%,  Madison County with 25.3%, and Gadsden County with 25.2%

–Identify the TOP 10 counties with the highest non-citizen population by ratio

Miami-Dade County with 23.6%, Hendry County with 18.03%, Broward County with 14.06%, Collier County with 13.9%, DeSoto County with 13.7%, Hardee County with 13.4%, Palm Beach County with 11.97%, Orange County with 10.1%, Glades County with 9.7%, and Osceola County with 9.6%

–Identify the TOP 10 counties with the highest US poverty by ratio.

Hamilton County with 28.06%, Putnam County with 27.4%, Holmes County with 26.4%, Madison County with 25.3%, Gadsden County with 25.2%, Okeechobee County with 23.4%, DeSoto County with 23.2%, Hardee County with 22.6%, Suwannee County with 22.1%, and Gilchrist County with 21.8%

No luck at the bonus question. I could only get it to show the columns for noncitizens and US poverty but wasn’t sure how to filter it.