Cleaning Data- More Efficiently

For this lesson you will learn some tips and tricks to making sure your data is cleaned up and ready to be analyzed.


There will be multiple videos attached to the assignment and to this slide show. We will go over the videos and then you will have time to use these new Google Sheets strategies to work on another movie database.

Directions:

• Remove duplicate rows- keep the row with the highest number of votes

• Change date range to only the last year, with no dashes or parentheses

• Delete any rating with less than 100 votes

• Remove anything that is not a movie

• Create 2 new rows for Genre

  • If more than one genre listed, move those entries to the new row

• Look up the RunTime for any movie where this is blank

• Create a new column called Language and indicate movies that do NOT have an English title.

Use the movies2 data and your new skills to clean the new set of data.

This is found attached with this assignment in Google class room.

​You will use these with the Movie Spreadsheet attached to Google Classroom.