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’
- Nice use of filter though to get ride of the blank rows!
- In the future, try not to show the entire dataset (especially if it’s big!) Lot’s of scrolling…
- Nice use of StackOverflow to find out how to create a sqlite database in python
- Look at the solutions that will be posted soon for alternative ways to make the queries
- 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.