Top 100 mentions, per podcast, according to verydisco.app

This is the top 100 mentions of people in the Huberman Podcast, the Lex Fridman Podcast, and the Joe Rogan Experience.

import pandas as pd import matplotlib.pyplot as plt import seaborn as sns # Load the CSV files huberman = pd.read_csv('deepnote_exports/huberman.csv') lex = pd.read_csv('deepnote_exports/lex.csv') rogan = pd.read_csv('deepnote_exports/rogan.csv')

Run to view results

huberman_hosts = ['Andrew Huberman'] huberman_filtered = huberman[~huberman['name'].isin(huberman_hosts)] huberman_filtered

Run to view results

lex_hosts = ['Lex Fridman'] lex_filtered = lex[~lex['name'].isin(lex_hosts)] lex_filtered

Run to view results

rogan_hosts = ['Joe Rogan'] rogan_filtered = rogan[~rogan['name'].isin(rogan_hosts)] rogan_filtered

Run to view results

combined_df = pd.concat([huberman_filtered, lex_filtered, rogan_filtered], ignore_index=True) combined_df = combined_df.groupby(['prs_id', 'name', 'gender'], as_index=False)['mention_counts'].sum() combined_df = combined_df.sort_values(by='mention_counts', ascending=False) combined_df.head(10)

Run to view results

The most mentioned people across all three podcasts are: 1. Donald Trump (1554 mentions) 2. Elon Musk (1462 mentions) 3. Vladimir Putin (1298 mentions) 4. Adolf Hitler (1200 mentions) 5. Joseph Stalin (832 mentions) 6. Joe Rogan (691 mentions) 7. Albert Einstein (590 mentions) 8. Joe Biden (582 mentions) 9. Barack Obama (350 mentions) 10. Friedrich Nietzsche (350 mentions)

# Remove Joe Rogan from the combined_df combined_df = combined_df[combined_df['name'] != 'Joe Rogan'] combined_df.head(10)

Run to view results

The most mentioned people across all three podcasts, excluding Joe Rogan, are: 1. Donald Trump (1554 mentions) 2. Elon Musk (1462 mentions) 3. Vladimir Putin (1298 mentions) 4. Adolf Hitler (1200 mentions) 5. Joseph Stalin (832 mentions) 6. Albert Einstein (590 mentions) 7. Joe Biden (582 mentions) 8. Barack Obama (350 mentions) 9. Friedrich Nietzsche (350 mentions) 10. Steve Jobs (300 mentions)

# Plotting the top 10 mentioned people on the podcasts top_mentions = combined_df.head(20) plt.figure(figsize=(12, 8)) sns.barplot(x='mention_counts', y='name', data=top_mentions, palette='viridis') plt.xlabel('Mention Counts') plt.ylabel('Name') plt.title('Top 20 Mentioned People in Lex Fridman, Joe Rogan, and Andrew Huberman Podcasts') plt.show()

Run to view results

# Filtering the top 20 women mentioned in the combined dataframe top_women_mentions = combined_df[combined_df['gender'] == 'female'].head(20) top_women_mentions

Run to view results

The top 20 women mentioned in the podcasts are: 1. Sara Imari Walker (76 mentions) 2. Ayn Rand (67 mentions) 3. Jane Goodall (56 mentions) 4. Hillary Clinton (36 mentions) 5. Kim Kardashian (13 mentions) 6. Oprah Winfrey (3 mentions) 7. Taylor Swift (0 mentions)