data cleaning

There is :

special characters in Name → = Table.AddColumn(#"Changed Type", "New Name", each

Text.Remove([Name], {"!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "-", "_", "=", "+", "[", "]", "{", "}", "\", "|", ";", ":", "'", """", ",", ".",

"<", ">", "/", "?", "~", "`","0".."9"}))

o Missing values in Name → Replace Values to unknown

o special characters in phone → Replace Values from “-“ to “ ”

o missing values in phone → Replace Values to unknown

o outlier in phone → = Table.AddColumn(#"Extracted First Characters", "New phone", each if

Text.Length(Text.Select([Phone], {"0".."9"})) < 11 then "Unknown" else [Phone])

o outlier in Mail → Remove Row

o Missing Values in Email → Rep

There is :

• Special characters In Location → = Table.AddColumn(#"Changed Type", "NewLocation", each

Text.Remove([Location],{"!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "-", "_", "=", "+", "[", "]", "{", "}", "\",

"|", ";", ":", "'", """", ",", ".", "<", ">", "/", "?", "~", "`"})) → = Table.AddColumn(#"Replaced Value",

"New contact", each Text.Remove([Contact_Number],{"A".."z"}))

• There Is missing Values in Location → Replaced to “Unknown”

• Special Characters in Contact_Number And Outlier in Contact_Number → =

Table.AddColumn(#"Added Custom1", "Custom", each if Text.Length(Text.Select([New contact],

{"0".."9"})) < 10 then "Unknown"

else if Text.Length(Text.Select([New contact], {"0".."9"})) >11 then "Unknown"

else [New contact])