HW 1 Feedback

[alexchaomander]

• 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 another library to do build the SQL database! As long as it works :)
• Nice bonus query that you came up with!
• All in all, good work. Query results were what we were expecting and hopefully you were able to get more familiar with pandas.