Weekly Dose of Data Analyst#9 — What kind of guests does Joe Rogan Experience (JRE) invite on his program ?
Problem:
I like listening to JRE. He always manage to invite people from different field to talk on his program.
I want to know what kind of guests (i.e. professional field) does Joe Rogan like to invite on his program.
Summary:
Overall(during 2018–2020), his guests are mostly comedians, book authors and actors.
Detailed Analysis:
From #1059 to #1575 (with #1090 missing), total of 516 episodes, 178 of them has comedian labels. This is not surprising considering Joe Rogan start as a stand-up comedian at very early of his career before his become a commentator in MMA.
91 episodes has book authors label.
84 episodes has actors label. This is probably related to his career as a host of TV show “Fear Factor”.
Other than the three categories mentioned above, scientists/phds/professors (academia) are the most frequent guests on his show. Following that, many athletes come on his show as well.
Surprisingly, there are not many episodes carries the label related to politics. There are only 31 episodes have been labelled as political-commentators and 20 of them have been labelled as intellectual dark web (Please see definition of intellectual dark web here)
Please notice, all these episodes do not take consideration of the special program such as “MMA Show” and “Fight Companion”.
Also, the reason only 516 episodes are considered in the article will be discussed later.
Preparation Process:
- Following data is required:
- JRE Episode List
- JRE Category Label for each episode/guests
The episode list can be found on JRE Library website (Episode List — Joe Rogan Experience Podcast | JRE Library).
Same with the category label for each episode (Guest Categories — Joe Rogan Experience Podcast | JRE Library)
The website also comes with some of their own stats regarding JRE as well. You can check this link if you are interested.
2. Data Acquisition & Extraction:
Python code is used here to extract the label information using its web scraping package.
The function of the code is to read all links in the category information table of the web page. And record episode number and its label information in a matrix. And save it in a csv files for later to use.
Please click the link here to access the Python code.
3. Data Examination:
Based on the episodes number, there should be 1575 episodes in the database. Using Tableau’s countd function, we find out there are 1574 episodes in the database. The missing episodes is #1090. For some reasons this does not exist in the full list of JRE. However, this will not affect final outcome considering its small quantity.
From portion of the labelled episode data over of the years, it can be observed that majority of the episodes have been labelled in the data source from year 2018.
4. Data Cleaning:
Since we are categorizing episodes based on year, if in one year, majority of the episode is not labelled it will not be a good assessment of actual conditions. Therefore episodes airdate which are earlier than 2018 has been filtered out.
Category “athlete” and “scientist” all has their subcategory, however, since the number of episodes which has subcategory is not many. All subcategory (e.g. “rock-climber”, “physicist”) will be counted towards their main category.
Please click the link here to access my Tableau workbook.
