DataScience in the Real World

Data Cleaning with No Code: Detecting and Fixing Missing Values

Clean your datasets without having to resort to any programming language or data science library. Do everything from a modern, intuitive UI.

Claudio Carnino
Jun 26, 2019 · 5 min read
Image for post
Image for post

Clean up the example dataset

Image for post
Image for post

Import your dataset in Fluidtable

Transform the first row in columns names

Image for post
Image for post

Start cleaning the dataset

Image for post
Image for post

Find and replace missing names

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Remove the row with no age

Image for post
Image for post
Image for post
Image for post

Remove rows where the age is not a number

Image for post
Image for post

Clean the entire dataset

Image for post
Image for post
Image for post
Image for post

Export

Conclusion

Fluidtable

Clean big and complex datasets with a few clicks.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store