Skip to Content
Hands-On Machine Learning on Google Cloud Platform
book

Hands-On Machine Learning on Google Cloud Platform

by Giuseppe Ciaburro, V Kishore Ayyadevara, Alexis Perrier, Bryan Fry, Antonio Gulli
April 2018
Beginner to intermediate
500 pages
11h 26m
English
Packt Publishing
Content preview from Hands-On Machine Learning on Google Cloud Platform

Replacing incorrect values

The next step will allow us to replace the incorrect value indicators. If we take a look at the data again, we will see that in the age column, the value -19 is displayed. That's obviously an incorrect value since for that variable, permissible values are greater than zero (this is an age):

24 -19 32 15 18 21 28 30 26 100 22 NA

We can replace this value with the missing value indicator, NA. To do this, we will write the following formula in the set suggestions:

IF($col<0, 'NA',$col)

A new step will be added to the Recipe panel immediately after the one created in the previous section. At the same time, we can see a preview of the changes made on the dataset. The incorrect value is no longer present; in its place, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Monetizing Machine Learning: Quickly Turn Python ML Ideas into Web Applications on the Serverless Cloud

Monetizing Machine Learning: Quickly Turn Python ML Ideas into Web Applications on the Serverless Cloud

Manuel Amunategui, Mehdi Roopaei

Publisher Resources

ISBN: 9781788393485