by Nathan Smith | Apr 9, 2017 | Student_Work
.csv file: FL_COMBINED Identify the counties and the rates of all counties with poverty rates greater than 25%: Hamilton County (29%), Putnam County (28%), Holmes County (27%), Madison County (25%), Gadsden County (26%), Okeechobee County (26%), DeSoto County (29%),...
by Nathan Smith | Apr 6, 2017 | Daily-Class, Spring_2017
Import the FL_poverty data and clean up the labels. –You may find it easier to edit the labels on Excel first before importing them. Remember, no spaces 2) Join the Fl_nativity and FL_poverty tables in SQL. Join them on the Id2 field. Query SELECT * to show both...
by Nathan Smith | Apr 5, 2017 | Student_Work
Highest total poverty rate: Miami-Dade County Lowest total poverty rate: Liberty County Top 3 counties with noncitizen poverty: Miami-Dade county, Broward county, Palm Beach county
by Nathan Smith | Apr 5, 2017 | Student_Work
This took me a while to figure out because I had to figure out what was actually going on in these excel data sets. Once I looked over those thoroughly, and cleaned them up it became a bit easier. When I was first trying to join the FL_Nativity and FL_Poverty2, it...
by Nathan Smith | Apr 5, 2017 | Student_Work
While my program is running fine, and I was able to clean up the sheet in Excel, I am not able to upload it. This is the message that I keep getting. I tried restarting the program, and my computer, and still no luck! I don’t know if formatting is the issue, but...
Recent Comments