Python Tutorial : How to remove unwanted characters in a data frame
Channel: Data Analytics Ireland
Date: 2020-04-25

The ability to data cleanse and remove unwanted characters in a data frame to have clean data in excel, is covered off in this video. We talk through a simple scenario where there is a dataset of numbers, which cannot have anything else but numbers, but we include invalid characters that need to be removed. Firstly we identify the errors through the use of a regular expression. Then based on a list of predefined mistakes, we fix those errors found and output the cleansed numbers to a new column.

⏲⏲⏲TIMESTAMPS⏲⏲⏲
Beginning 00:00
Intro and overview 00:01
Create the dataset 01:56
Create the dataframe 03:34
Create a function to find errors 04:01
Review of output and fixes 11:31


To see the code for this, click here: https://bit.ly/2WPZzfE

Blog posting:
https://dataanalyticsireland.ie/2020/04/25/python-how-do-i-remove-unwanted-characters/

################     Lets be Social!    ##################

 Website - https://www.dataanalyticsireland.ie/
 Twitter - https://twitter.com/dataanalyticsi1
 Facebook - https://www.facebook.com/dataanalyticsirl
 Linkedin - https://www.linkedin.com/company/data-analytics-ireland
 Pinterest - https://www.pinterest.ie/dataanalyticsireland/

#dataanalytics #python #dataanalyticsireland