Removing empty cells

From a visual analysis of the imported data, we detect an empty cell at the third row and second column; this indicates the presence of a missing value. It is necessary to eliminate this anomaly before you can analyze the dataset.

In this case, identifying the empty cell was particularly easy given the small amount of data; in the case of large datasets, visual analysis does not work. Therefore, to identify missing values, ​​we can analyze the data quality bar. Here, the missing values ​​are identified in black.

To get a preview on the number of missing data, we can move our cursor over the black part of the data quality bar; the number of missing data is returned, as shown in the following screenshot:

We have confirmed ...

Get Hands-On Machine Learning on Google Cloud Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.