This project involves the analysis a set of clinical trials, representing a collection of research report carried out within a period of three years, in combination with an accompanied set of pharmaceutical violations by a list of pharmaceutical companies. This was carried out in three different implementations which include Data Frame, Spark SQL, and RDD, as well as with visualization of results.