Given the attached file, write a Python code to do the following :

$1.$ read the data into a data frame

$2.$ use regular expressions to delete the special characters from the text $($message column$).$

$3.$ drop the duplicated and empty records

$4.$ use the matplotlib library to visualize the distribution of column Type in the data frame.