From the course: Cleaning Bad Data in R
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Missing rows
- [Instructor] Sometimes our data sets are missing entire rows. We've already talked about some of the reasons this may occur. Rows may be missing completely at random, missing at random, or missing not at random. In the last video we looked at the situation that arises when we are missing values from a data set. Those are generally easy to detect. We can simply look for NA values or unusual flags in a file. In the last video we looked at a data set that had periods and Zs that both represented zero. Missing rows are usually much more difficult to detect because there's no row there to analyze. Detecting missing rows generally requires some additional subject matter knowledge. For example, if we know that there is supposed to be a row in a data set for every year and we have rows for 1990 through 2016 and then another row for 2018, it's logical to conclude that 2017 is missing. Let's take a look at an example of a data file that's missing rows in R. As with the previous example, I've…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.