alexchaomander
commented
9 years ago - May not have been clearly communicated through the instructions, but we wanted you to create an app token so that you could interact with the API. What you have works but using the app token will have allowed you to do data[0] and see results.
- Use this url to access the API with a working token https://data.sfgov.org/resource/vw6y-z8j6.json?$$app_token=Iq3JEcmMzuOIvahirX7cR0GTI
- This will change a few of the column names, notably media_url. So you’d only need to drop ‘point’
- Good job though choosing to drop the missing values. Since all values in the row were missing, this is the right choice. Usually you wouldn’t want to drop rows if you have some data elements in them.
- Nice use of adding a percentage column in your query results. You’re the first student I saw do this!
- One thing I would suggest is that when using the IPython notebook, don’t show the full data or make sure you use head() or limit in your sql queries otherwise the reader will have to scroll a lot to get to the next cell.
- All in all, good work. In general, query results were what we were expecting and hopefully you were able to get more familiar with pandas.