00:00if your raw data is unclean like this and you want to replace all this special character from
00:04the dictionary to be blank this is how you do it first you're going to create the chart dictionary
00:08into a table like this and give it a name called my tab once that's done to get a clean data you're
00:13going to use a function called reduce and then the first argument will be the raw data itself
00:17and the second argument would be your table my tab you're going to put the header as chart
00:21dictionary close square bracket comma and then you're going to use a lambda function and then
00:25in here you're going to give it a name for the first argument i'm going to call it z comma and
00:29then the second argument with the dictionary d comma and after that you're going to use the
00:32substitute function and you're going to follow and give the same raw data location followed by
00:38your dictionary which is your d comma and you're going to replace whatever you find in your dictionary
00:42as a blank close parenthesis three time and hit enter your raw data get clean accordingly and if
00:48you have any missing character like plus here just put a plus here and you get clean too
01:01you
Comments