Description
Tasks:
1. [40 points] Write a python script “load.py” which load the rows for the above senior customers
to your database.
Execution format:
python3 load.py
You can assume the WA_Fn-UseC_-Telco-Customer-Churn.csv file is stored at the same directory
where you execute your script.
2. [30 points] Write a Python script “churn.py” to find the first k (senior) customers who has
churned. Only need to return IDs of first k customers (ordered by their IDs).
Execution format:
python3 churn.py
For example:
python3 churn.py 10
will return IDs of first 10 customers who have churned.
3. [30 points] Write a Python script “tenure.py” to find out how many customers who have used
the service for at least k months.
Execution format:
python3 tenure.py
For example,
python3 tenure.py 10
Requirements:
● For each query in both patterns, only one round trip (send request and receive response) is
permitted to the Firebase server.
● You should not download entire database to answer the query.
● You should create indexes in Firebase console that allow the above programs to execute
without errors.
Permitted libraries: pandas, requests, json, and other common Python libraries (e.g., sys). Do not use
firebase-admin, firebase python libraries.
Submissions:
● Above 3 scripts.
● Prepend your full name to the script name, e.g., John_Smith_load.py, so on.
● A document (word/pdf) explaining why your program sends only one request to Firebase for
each query.
● A JSON dump of your Firebase database for this app.
● A screenshot of your Firebase, showing the structure of your database.
● Submit online. See syllabus for late penalty!
Checklist for Submission :
1. Name your folder and zip LASTNAME_FIRSTNAME_HWX. Your submission should be a zip (not
rar) file AND unzipping it would have all your files (no folders). Do not include csv files. Notice
that your submission should have capital first and last names. Example: TANEJA_DAKSH_HW1.
2. DO NOT return anything we didn’t ask for. For example, “please enter XXX: ___”. Please no. We
have given you the EXACT output format. Please just follow them.
3. Use ONLY relative path. You should assume your scripts will be run in the directory where the
scripts are at. For example, no ‘C:\\homework1\…’ or ‘/Users/blabla/….’
4. Make sure that you are able to run the code according to the execution format mentioned above
in the questions.
5. Double-check your files before submitting them. Please use python3 to complete the homework
and try to maintain the python version as 3.7. Do not use any libraries other than the ones
specified in the handout. You can use EC2 to test your code, and python 3.7 is preinstalled on
EC2.
6. You can submit it multiple times on DEN but only the latest attempt will be graded.
