From the course: Data Cleaning and Manipulating with Python in Excel

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Validating data

Validating data

From the course: Data Cleaning and Manipulating with Python in Excel

Start my 1-month free trial Buy for my team

Validating data

“

- [Instructor] If you've been working with Excel for some time, you've likely had to validate data in your work. Nothing's worse than data from marketing coming by and ruining the Excel report you've been spending countless hours on. Validating data is a necessity in Excel that helps ensure the accuracy and consistency of your data. By using Python, we could take a look at our dataset to ensure our data is as accurate as it can be. In this video you'll learn the importance of validating data. You'll also learn different ways we can validate data using Python. Lastly, you'll understand the various parts that go into the Python code for validating data. Awesome, let's get right into it. So let's open up the exercise file For this video. We'll use the chapter 2 02_03 tab. Okay, so take a look at our dataset. We have a couple different variables here. Some things like the sales ID, date, name and so on. Now there's some things that we've been told to validate and we're going to take a…

Contents