The darker boxes of text are code.
If you click on one: hit undefined + undefined to execute the cell's code.
This line of code prints out the red text inside of it hiFollow along as we run the rest one by one?
This next line will install geopandas. It is the only library not pre-provided by COLABS
Pip is a tool colabs provides to install python libraries onto the virtual machine they provide us.
We use it's command line API here:
You may have seen a lot stuff it undefined...
Feel free to hit the X button in the left of the cell (when hovering over) to delete it.
Now the virtual machine has our needed library.
With that done, formally 'import' the library into our python runtime enviornment so we may use it.
This next part is a little bit hard.
Hit this link. Find a statistic you'd like to visualize. Copy and paste its undefined into the code cell below.
Lets see our final query?
And were all set!
For a simple pull of our data, just run the next cell!
Lets see it?
Right of the bat, we can use two different libraries to get dramatically different results:
| libcard11 | libcard12 | libcard13 | libcard14 | libcard15 | libcard16 | libcard17 | libcard18 | libcard19 | geometry | |
|---|---|---|---|---|---|---|---|---|---|---|
| CSA2010 | ||||||||||
| The Waverlies | 358.957823 | 345.672643 | 270.346962 | 447.826648 | 504.449890 | 458.274216 | 403.714691 | 405.004514 | 400.490133 | POLYGON ((-76.59550 39.33416, -76.59548 39.334... |
| Upton/Druid Heights | 293.656933 | 285.341327 | 253.142526 | 426.513247 | 465.673951 | 382.517888 | 315.993038 | 316.863276 | 310.674918 | POLYGON ((-76.63401 39.31045, -76.62509 39.303... |
| Washington Village/Pigtown | 318.916954 | 301.835363 | 271.669998 | 422.496820 | 446.302017 | 370.343449 | 319.280393 | 329.820098 | 331.092132 | POLYGON ((-76.62096 39.27466, -76.62110 39.274... |
| Westport/Mount Winans/Lakeland | 155.499368 | 149.318725 | 133.445709 | 246.382919 | 267.734232 | 229.526619 | 181.345695 | 185.981177 | 176.288805 | POLYGON ((-76.62627 39.26790, -76.62631 39.267... |
Use the `plot function to see a map!
Geopandas provides a convenient webpage to help you get really pretty results in not time!
Awesome!
If you want to save the data you may use this undefined library.
A full, unedited list of our available endpoints may be found here
You can also click this link, find the service and or layer you want to query; and there will be a little 'query' button in the bottom left which will take you to an advanced GUI to help you generate custom queries.
example: https://services1.arcgis.com/mVFRs7NF4iFitgbY/ArcGIS/rest/services/Aastud/FeatureServer/query
NOW!
If we want to change our visualization of the data.
We can use the underlying library used by geopandas itself: matplotlib, and seaborn.
Geojson data does not play nicely with these kind of maps. so we will drop it "for now."
But these look a bit aweful.
A full list of visualizations you may use with the seaborn and matplotlib libraries can be found on each of their corresponding websites.
What will you do?
We may use the remainder of our time today to explore some of these libraries, API's and most importantly
UNDERSTANDING THEIR DOCUMENTATION USING THE LINKS ABOVE.
The rest of this doc is a playground: