their last words BEFORE DYING

A Tableau data story — He yelled “F*ckkkkkk” before passing away, and one of them spoke the words “Goodbye, We Perish.” Is that not painfully cold? (my dashboards is fully interactive)

First Dashboard

I had to look for a data science project to work on yesterday as part of my daily data workout. Every open data source I am aware of was visited for the customary hour, and I queried from Big Query like I literally knew the topics from Kaggle by this point (exaggeration).

So, to the point, data was collected in .csv format, which was simple. I collected those who chose my interest and chose this one, “Last Words.” It captured the last words spoken by pilots from particular airlines before they passed away or crashed. The box has four columns: Date, Airlane Name, Flight Number, and Final Words. Yes, those were their genuine last words before passing away. Data Source

data set display immediately after downloading

“GOING A BIT TECHNICAL”

I created a mock-up of the visualization with pen and paper, with the concept of how long it takes to speak each phrase, to prevent the uncertainty that comes with choosing which BI tool to use. My inference; the only variable that could aid with getting that is the number of words they spake, the general mood they were in while speaking and also their demography. To do that I ran a function to get the count of words in the Last_words column first, then wrote a simple expression to get the duration that the words was spoken.

This is the mathematical formula behind it;

1. The demography were mostly American Pilots/airline,
2. The average speech by Americans is 150 WPM but when under pressure/rush it ranges from 200–250 WPM. According to the National Center for Voice and Speech. Source

3. The audience in focus were definitely under pressure but taking account of the fact that not all were Americans and also to avoid bias i used an average of 225 WPM.

4. The data time column we have on our data set is in seconds thus i equated 60 seconds to be one minute.
With the above i was able to come up with the formula;

Duration for spoken word(seconds) = If 225 words is spoken in 60 seconds, then Last Words would be spoken in X seconds
For Example: if the word count is 11words thus to get the duration of words spoken.

Duration to speak 11 words = 60 Seconds * 11 Words/225 WPM = 2.93 seconds

data set display immediately after adding duration column

I did this with Python. And used Google Sheet to complete the same task. But I did find that utilizing Google Sheet was rather quicker.

The following step was to visualize. I use Tableau whenever I need to create a visualization with curved edges; otherwise, I utilize other tools. I had no idea that I would get myself into serious difficulty. The next part of this article outlines the nemesis of my problem.

Did Tableau Public Fail Me!?

…to be continued