3.8 Project: Review and Prep Movies Data: Part 3 Overview In this assignment, I will give you a Jupyter notebook file to review and then complete. In the video guide, I will walk you through some of the work I've done in this notebook. And then I'll hand it off to you to finish! The Movies Data File You will continue using the data file we have used previously. Here it is in case you need it: movies_1902_2019.json.zip = Project Guide Download and follow the steps in this project guide: 3.8 Review and Prep Movies Data Part 3.docx ALSO download and use this Jupyter notebook: 01 Review and Prep Movies Part 3 BEGIN.ipynb Video Overview In this 14-minute video, I walk you through some of the new steps in the notebook I've provided, and I preview the steps you are assigned to complete. https://www.youtube.com/watch?v=-cL3WQUMDSE&t=8s 3.8 Discussion No unread replies.No replies. Use this discussion board to share questions, thoughts, tips, and discussion regarding the assigned project(s). To foster dialogue, I'm requiring everyone to post something -- whether a question, a reflection, or feedback to other users. Here are recommended ideas to prompt your contributions: • • • Have you gotten stuck? You're undoubtedly not alone. Please describe your problem and include screenshots if relevant. Can you provide help in response to another student's question? If so, please do! Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc. Data Analytics @ Newman U Project 3.8: Review & Prep Movies Data: Part 3 Overview In this assignment, I will give you a Jupyter notebook file to review and then complete. In the video guide, I will walk you through some of the work I've done in this notebook. And then I'll hand it off to you to finish! Reminder: Information about this Data The data comes from a large open source project: The Movie Database. You can read about the project at their About page, here. You can find information about specific fields included in the data in the Contribution Bible pages for movies. Recommended Resources Review your previous notebooks as needed — especially from our most recent projects. From Data Analysis with Pandas and Python – Udemy Title https://www.udemy.com/course/data-analysis-with-pandas/learn • • Review previous videos as needed. Recommended new videos: o 67. This Module's Dataset + Memory Optimization o 139. The pd.to_datetime() Method Other Sources to Consult as Needed • Pandas User Guide https://pandas.pydata.org/pandas-docs/stable/user_guide/index.html • Tutorial: 10 Minutes to pandas https://pandas.pydata.org/pandas-docs/stable/user_guide/10min.html • Well-phrased web searches Key Steps in this Project 1. Download the Jupyter notebook I’ve provided with this assignment, with file name: 01 Review and Prep Movies Part 3 BEGIN.ipynb 2. Copy the file and edit the file name to remove BEGIN from the file name. 3. Open it, connect to the data file, and work through it, executing the cells. 4. Review my version of these steps: Not that my way is the only way, but I’ve added a few new wrinkles to #4. a. Import Libraries b. Read Data to Dataframe c. Review Dataframe Fundamentals d. Review Fields for Relevance 5. Complete these steps, following the details laid out in the notebook markdown cells: a. Drop Unneeded Fields b. Drop Unneeded Records c. Assign Data Types d. Write to File If desired — if you’d like to use your own version — migrate the new steps to your own version of the notebook and use it. What to Submit As usual, please submit your completed Jupyter notebook and an HTML copy of it. Page 1 of 1 
Purchase answer to see full attachment