1. Fetch the same data you did last week or choose another state that is not on the list I provided in my announcement (do not remove any column). Insert each one of them into a different collection on your own MongoDb database (make sure to use your initials before or after the name you give). One collection is for the state data and another for the hospital data in that state.
2. Calculate the min, average, and total of hospital beds by region (rural & urban). It should be the same as last week. Total revenue. Calculate the min, average, and total for the total revenue, total community benefits, and unreimbursedcostsby fiscal year.
3. Add a few more data points/documents; update at least one document, then delete the documents you created, in summary, apply all the statements you learned this week. Submit your explanation, code, and a screenshot of it. Create functions to insert, delete and update documents.
4. Write a user interface where you ask a user if he/she wants to insert, update or delete info, and then execute the actions accordingly. make sure to show some stats to the user.
5. It is very easy to save a pandas data frame as a CSV file, so take the opportunity to do it now while the access id is still active; you will need to have it for the final assignment.
Use the same credentials I posted under the discussion board.
Make sure to explain your code well and have your python code in your discovery folder.