The Office Project
Tableau, Python
Overview:
Using data from The Office lines spreadsheet (https://docs.google.com/spreadsheets/
d/18wS5AAwOh8QO95RwHLS95POmSNKA2jjzdt0phrxe
AE0/edit#gid=747974534) data from April 2018 The Office DatViz Battle ( https://www.reddit.com/
r/dataisbeautiful/comments/88ymvb/battle_dataviz_battle_for_the_month_of_april_2018/) , developed Tableau Public Dashboards. Wrote Python script to adjust script text to remove non-speaking lines in addition to adding supplmental information needed for customizing/controlling visibility within TV Dashboard.
r/dataisbeautiful/comments/88ymvb/battle_dataviz_battle_for_the_month_of_april_2018/) , developed Tableau Public Dashboards. Wrote Python script to adjust script text to remove non-speaking linesin addition to adding supplmental information needed for customizing/controlling visibility within TV Dashboard.
Features/Analysis Enablement:
Filters including searching for specific words/phrases, selecting one or more Characters/Seasons/Episodes/Scenes, and if the Scene was deleted or not. Discover lines by using a variety of filters to see total number of lines, trending of lines across Seasons, and the line details. Can click on specific "Line Text" in bottom table to navigate to that scene. The x-axis for the trending graph can be by Character or Episode and is controlled by the "Filter Trending Type" filter. Continue exploring and visualizing non-deleted Scenes from The Office by using TV remote Season/Episode/Scene filters.
Consider purchasing/watching the actual show at NBC store (https://www.nbcstore.com/products/the-office-complete-series-dvd)
Usage Example 1
Navigated to TV Dashboard
Navigated to TV Dashboard
Using the filter near the upper-middle left side, can type "dog" and see statistics, frequency of character/season, and actual lines where the word "dog" was said. You can then click on a particular row from the bottom filtered table results to navigate to TV Dashboard at that particular Scene.
Navigated to TV Dashboard
Navigated to TV Dashboard
Navigated to TV Dashboard
Based on the specific scene, different visualization layouts conditionally applied.