Final Project Review

[BF1103]

Hello Xin,
I have downloaded your final project zip file on my computer and I ran your jupyter notebook to get the results on my computer successfully. Your group did a great job.

#Part1
I really like the answer of your first part. You gave detailed introduction of your American Time Use Survey (ATUS). The topic itself is really interested. Moreover, you raised interesting questions and explained the goal of your project clearly.

#Part2
In this part, you demonstrated your strong ability to use python. I was really impressed by it. You also used python to deal with your null values. It was great to use python to deal with data, but Trifact might also be another choice. One little recommendation in this part is to change the duplicate “https” in your wget code to download your csv file. I could only download your csv file after I deleted one of the ‘https’.

#Part3
In part 3, you have demonstrated your ability to create and connect to a new database, define a database and load your dataset into the database. You also defined your star schema successfully. In the process of exploring your star schema, you mainly focused on daily activity for the employer related to Computer science in financial industry and the race distribute among all respondents. The result of your analysis was really interesting.

Overall, you have done a great job in this final project.

All the best,
Boer Feng