
import pandas as pd
import numpy as np, re

import matplotlib.pyplot as plt
from matplotlib import cm

from nltk.corpus import stopwords
from nltk.tokenize import word_tokenize

from sklearn.feature_extraction.text import CountVectorizer
import itertools
import collections

import warnings
warnings.filterwarnings("ignore")


# Loading Tokyo Olympics Tweets data
fields = ['user_location', 'date', 'text', 'hashtags']
tokyo_df = pd.read_csv('tokyo_2020_tweets.csv', skipinitialspace=True, usecols=fields, 
                      dtype=str)


tokyo_df.head(20)


def clean_text(text):
    """
    Remove punctuation and special characters, make lower case
    Args: text 
    Output: text
    """
    text=str(text)
    text=text.lower()
    text=re.sub('</?.*?>',' <>', text)
    text=re.sub('\\d|\\W+|_',' ',text)
    text=re.sub('[^a-zA-Z]'," ", text)
    
    return text

# Create stop words list
stop_words = stopwords.words('english')


# Cleaning 'text' column
tokyo_df['text'] = tokyo_df['text'].apply(lambda x:clean_text(x))

# Preview data
tokyo_df.head()


# Filtering to tweets including 'surf'
tokyo_surf_df = tokyo_df[tokyo_df['text'].str.contains("surf")]

tokyo_surf_df.head(20)


tokyo_surf_df.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 1758 entries, 2199 to 296995
Data columns (total 4 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   user_location  1372 non-null   object
 1   date           1758 non-null   object
 2   text           1758 non-null   object
 3   hashtags       1293 non-null   object
dtypes: object(4)
memory usage: 68.7+ KB


# Filtering to tweets including 'skateboarding'
tokyo_skateboarding_df = tokyo_df[tokyo_df['text'].str.contains("skateboarding")]

tokyo_skateboarding_df.head(20)


tokyo_skateboarding_df.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 3420 entries, 437 to 296492
Data columns (total 4 columns):
 #   Column         Non-Null Count  Dtype 
---  ------         --------------  ----- 
 0   user_location  2572 non-null   object
 1   date           3420 non-null   object
 2   text           3420 non-null   object
 3   hashtags       2956 non-null   object
dtypes: object(4)
memory usage: 133.6+ KB


# Remove stop words from 'txt', store in new column
tokyo_surf_df['text_no_stop_words'] = tokyo_surf_df.text.apply(
    lambda x: ' '.join([word for word in x.split() if word not in (stop_words)]))

# Preview data
print(tokyo_surf_df.head(20))

                 user_location                 date  \
2199              La Jolla, CA  2021-07-24 10:31:31   
2303                       NaN  2021-07-24 10:30:23   
2491                 Bucks, UK  2021-07-24 10:28:27   
2734     Auckland, New Zealand  2021-07-24 10:24:52   
3760               New Zealand  2021-07-24 10:10:40   
4438          Burtonsville, MD  2021-07-24 10:01:07   
5125                     India  2021-07-24 09:53:42   
5266               Seattle, WA  2021-07-24 09:52:12   
5632      Where the +Vibes are  2021-07-24 09:47:46   
5976                       NaN  2021-07-24 09:43:51   
6581               Seattle, WA  2021-07-24 09:37:09   
11703                   Israel  2021-07-24 11:15:00   
12813               Quilty 🇮🇪   2021-07-24 12:53:07   
14935  England, United Kingdom  2021-07-24 13:18:26   
15383        Florida/Illinois   2021-07-24 13:34:37   
15718            Mumbai, India  2021-07-24 13:38:39   
16622                      NaN  2021-07-24 13:58:40   
16671          London & Dublin  2021-07-24 13:57:51   
16804                      NaN  2021-07-24 13:59:30   
18170         Lisbon, Portugal  2021-07-24 14:38:34   

                                                    text  \
2199   one big step for surfing tomorrow strongertoge...   
2303   for the past two years endangered sea turtle n...   
2491   a bit on tokyo     s brushes with the local wi...   
2734     fizzing surfing tokyo     https t co fpsftsrert   
3760   the surfing at tokyo     kicks off sunday morn...   
4438    olympics in tokyo     just kick off today loo...   
5125   in my stream surfing i ve somehow ended up on ...   
5266    olympics surfers are unsung masters of scienc...   
5632   history in the making surfers inaugurate tokyo...   
5976   rumours say wout van aert will be starring in ...   
6581   surf s up day   of surfing s olympics debut is...   
11703  anat lelior s first experience with surfing ca...   
12813  i really wish the field hockey surface was gre...   
14935  unqualified journalists writing columns amp br...   
15383  so excited for surfing to get its moment at to...   
15718  the rise of the silver surfer she wanted to qu...   
16622   abcnews same could happen in japan but it wil...   
16671  this year they ve added   new sports to the ol...   
16804  surfing is a new addition to the olympic games...   
18170  tomorrow is the day surfing will have its debu...   

                                                hashtags  \
2199   ['Surfing', 'StrongerTogether', 'Tokyo2020', '...   
2303                                         ['surfing']   
2491   ['Tokyo2020', 'wildlife', 'olympics', 'surfing...   
2734                            ['surfing', 'Tokyo2020']   
3760                                       ['Tokyo2020']   
4438   ['Olympics', 'Tokyo2020', 'skateboarding', 'bm...   
5125                      ['basketball3x3', 'Tokyo2020']   
5266                                        ['Olympics']   
5632                            ['Surfers', 'Tokyo2020']   
5976                        ['CyclingRoad', 'Tokyo2020']   
6581                           ['Olympics', 'Tokyo2020']   
11703                                                NaN   
12813                                      ['Tokyo2020']   
14935        ['theguardian', 'BBCOlympics', 'Tokyo2020']   
15383                                      ['Tokyo2020']   
15718                                                NaN   
16622                                      ['medalling']   
16671                                                NaN   
16804                                                NaN   
18170                                                NaN   

                                      text_no_stop_words  
2199   one big step surfing tomorrow strongertogether...  
2303   past two years endangered sea turtle nesting i...  
2491   bit tokyo brushes local wildlife https co jktq...  
2734           fizzing surfing tokyo https co fpsftsrert  
3760   surfing tokyo kicks sunday morning nz time mak...  
4438   olympics tokyo kick today looking forward debu...  
5125   stream surfing somehow ended basketball x utte...  
5266   olympics surfers unsung masters science climat...  
5632   history making surfers inaugurate tokyo openin...  
5976   rumours say wout van aert starring new fantast...  
6581   surf day surfing olympics debut expected start...  
11703  anat lelior first experience surfing came age ...  
12813       really wish field hockey surface green tokyo  
14935  unqualified journalists writing columns amp br...  
15383  excited surfing get moment tokyo article must ...  
15718  rise silver surfer wanted quit missing medal r...  
16622  abcnews could happen japan surely improve aust...  
16671  year added new sports olympics excited see sur...  
16804  surfing new addition olympic games tokyo men w...  
18170  tomorrow day surfing debut olympic games waiti...


# Creating a list of lists containing words for each tweet
words_surf = [text.split() for text in tokyo_surf_df.text_no_stop_words]
words_surf[:3]

[['one',
  'big',
  'step',
  'surfing',
  'tomorrow',
  'strongertogether',
  'tokyo',
  'olympics',
  'https',
  'co',
  'xs',
  'oevl'],
 ['past',
  'two',
  'years',
  'endangered',
  'sea',
  'turtle',
  'nesting',
  'identified',
  'tsurigasaki',
  'beach',
  'surfing',
  'https',
  'co',
  'hjpz',
  'e'],
 ['bit',
  'tokyo',
  'brushes',
  'local',
  'wildlife',
  'https',
  'co',
  'jktqccarz',
  'olympics',
  'surfing',
  'spiders',
  'turtle',
  'ants',
  'insects']]


# Remove stop words from 'txt', store in new column
tokyo_skateboarding_df['text_no_stop_words'] = tokyo_skateboarding_df.text.apply(
    lambda x: ' '.join([word for word in x.split() if word not in (stop_words)]))

# Preview data
print(tokyo_skateboarding_df.head(20))

                       user_location                 date  \
437    saw ac 020419; jb 111116 etc.  2021-07-24 10:56:04   
3084                  Athens, Greece  2021-07-24 10:19:21   
3283                         Austria  2021-07-24 10:16:21   
4438                Burtonsville, MD  2021-07-24 10:01:07   
4604                         Germany  2021-07-24 09:59:44   
4777             South West, England  2021-07-24 09:57:57   
6302                           Cambs  2021-07-24 09:40:03   
9917                          London  2021-07-24 09:04:13   
10557                             UK  2021-07-24 11:33:26   
10721                      Aylesbury  2021-07-24 11:30:41   
14685                  Illinois, USA  2021-07-24 13:21:59   
14737                       mongolia  2021-07-24 13:21:26   
14935        England, United Kingdom  2021-07-24 13:18:26   
15114                            NaN  2021-07-24 13:30:44   
15582            Cheltenham, England  2021-07-24 13:35:48   
15701               Philadelphia, PA  2021-07-24 13:38:58   
16664                     Austin, TX  2021-07-24 13:58:03   
17168                         Canada  2021-07-24 14:07:27   
17843           Nathan’s fluffy curl  2021-07-24 14:24:12   
19724                 Saint Paul, MN  2021-07-24 15:48:00   

                                                    text  \
437    tony and rayssa my new religion skateboarding ...   
3084   so excited to watch skateboarding and bmxfrees...   
3283   who will go for the first ever olympic gold in...   
4438    olympics in tokyo     just kick off today loo...   
4604   skateboarding makes its debut at the olympics ...   
4777   what time bst is the skateboarding at the olym...   
6302   will definitely be watching the skateboarding ...   
9917   nyjah huston and skateboarding hit the olympic...   
10557  merrily watching day   of tokyo     and lookin...   
10721         can t wait for the skateboarding tokyo       
14685  radio articles are discussing how skateboardin...   
14737   skateboarding in tokyo     olympics starts wi...   
14935  unqualified journalists writing columns amp br...   
15114   teamusa s nyjah and japan s world champion ho...   
15582  does anyone know how when i can watch the skat...   
15701   tonyhawk calling skateboarding art artisevery...   
16664  i m glad to see sports like skateboarding  x  ...   
17168  dyk that skateboarding is making its olympic d...   
17843  men s street skateboarding start list tokyo   ...   
19724  the rocket bros from fort are hyped for the de...   

                                                hashtags  \
437                       ['skateboarding', 'Tokyo2020']   
3084   ['skateboarding', 'bmxfreestyle', 'Olympics', ...   
3283                      ['skateboarding', 'Tokyo2020']   
4438   ['Olympics', 'Tokyo2020', 'skateboarding', 'bm...   
4604                                        ['Olympics']   
4777                      ['Tokyo2020', 'skateboarding']   
6302                                       ['Tokyo2020']   
9917                                       ['Tokyo2020']   
10557                                      ['Tokyo2020']   
10721                                      ['Tokyo2020']   
14685                                                NaN   
14737         ['skateboarding', 'Tokyo2020', 'Olympics']   
14935        ['theguardian', 'BBCOlympics', 'Tokyo2020']   
15114              ['TeamUSA', 'Japan', 'skateboarding']   
15582                                                NaN   
15701  ['artiseverywhere', 'makeartnotwar', 'Tokyo202...   
16664                                                NaN   
17168                                      ['Tokyo2020']   
17843                                      ['tokyo2020']   
19724                                      ['Tokyo2020']   

                                      text_no_stop_words  
437    tony rayssa new religion skateboarding tokyo h...  
3084   excited watch skateboarding bmxfreestyle makin...  
3283   go first ever olympic gold skateboarding tokyo...  
4438   olympics tokyo kick today looking forward debu...  
4604   skateboarding makes debut olympics skaters rep...  
4777   time bst skateboarding olympics anybody knows ...  
6302   definitely watching skateboarding finally part...  
9917   nyjah huston skateboarding hit olympics sport ...  
10557  merrily watching day tokyo looking forward new...  
10721                           wait skateboarding tokyo  
14685  radio articles discussing skateboarding could ...  
14737  skateboarding tokyo olympics starts men street...  
14935  unqualified journalists writing columns amp br...  
15114  teamusa nyjah japan world champion horigome yu...  
15582  anyone know watch skateboarding bbc actually b...  
15701  tonyhawk calling skateboarding art artiseveryw...  
16664  glad see sports like skateboarding x bmx etc m...  
17168  dyk skateboarding making olympic debut tokyo m...  
17843  men street skateboarding start list tokyo http...  
19724  rocket bros fort hyped debut skateboarding tok...


# Creating a list of lists containing words for each tweet
words_skateboarding = [text.split() for text in tokyo_skateboarding_df.text_no_stop_words]
words_skateboarding[:3]

[['tony',
  'rayssa',
  'new',
  'religion',
  'skateboarding',
  'tokyo',
  'https',
  'co',
  'zg',
  'itywrp'],
 ['excited',
  'watch',
  'skateboarding',
  'bmxfreestyle',
  'making',
  'olympics',
  'debuts',
  'tokyo'],
 ['go',
  'first',
  'ever',
  'olympic',
  'gold',
  'skateboarding',
  'tokyo',
  'pictograms',
  'seen',
  'https',
  'co',
  'gtdvslieaj']]


# List of all words across surfing tweets
words_surf_all = list(itertools.chain(*words_surf))

# Creating counter
counts_surf = collections.Counter(words_surf_all)

counts_surf.most_common(20)

[('surfing', 1608),
 ('co', 1297),
 ('https', 1296),
 ('tokyo', 1141),
 ('olympics', 435),
 ('olympic', 323),
 ('ever', 224),
 ('women', 194),
 ('one', 179),
 ('semifinals', 172),
 ('medal', 165),
 ('event', 164),
 ('history', 158),
 ('shame', 154),
 ('first', 153),
 ('happened', 152),
 ('unbelievable', 152),
 ('gold', 145),
 ('surf', 140),
 ('men', 138)]


# Creating dataframe from word counts list
counts_surf_df = pd.DataFrame(counts_surf.most_common(20),
                             columns=['words', 'count'])

counts_surf_df


# Saving common words dataframe to csv
counts_surf_df.to_csv('counts_surf_df.csv')


fig, ax = plt.subplots(figsize=(8, 8))

# Plot horizontal bar graph
counts_surf_df.sort_values(by='count').plot.barh(x='words', 
                                                 y='count',
                                                 ax=ax,
                                                 color="blue")

ax.set_title("Common words in Tokyo 2020 Olympic tweets about surfing")

plt.show()


# List of all words across skateboarding tweets
words_skateboarding_all = list(itertools.chain(*words_skateboarding))

# Creating counter
counts_skateboarding = collections.Counter(words_skateboarding_all)

counts_skateboarding.most_common(20)

[('skateboarding', 3522),
 ('tokyo', 2651),
 ('co', 1981),
 ('https', 1979),
 ('olympics', 1133),
 ('street', 548),
 ('women', 545),
 ('gold', 498),
 ('olympic', 409),
 ('first', 344),
 ('didal', 320),
 ('old', 275),
 ('japan', 257),
 ('year', 250),
 ('medal', 243),
 ('margielyn', 242),
 ('nishiya', 216),
 ('yuto', 203),
 ('momiji', 202),
 ('ever', 187)]


# Creating dataframe from word counts list
counts_skateboarding_df = pd.DataFrame(counts_skateboarding.most_common(20),
                             columns=['words', 'count'])

counts_skateboarding_df


# Saving common words dataframe to csv
counts_skateboarding_df.to_csv('counts_skateboarding_df.csv')


fig, ax = plt.subplots(figsize=(8, 8))

# Plot horizontal bar graph
counts_skateboarding_df.sort_values(by='count').plot.barh(x='words', 
                                                          y='count',
                                                          ax=ax,
                                                          color="purple")

ax.set_title("Common words in Tokyo 2020 Olympic tweets about skateboarding")

plt.show()


from textblob import TextBlob


# Create textblob objects of the tweets, store polarity values in new column
tokyo_surf_df['sentiment'] = tokyo_surf_df['text_no_stop_words'].apply(
    lambda tweet: TextBlob(tweet).sentiment.polarity)


tokyo_surf_df.head()


fig, ax = plt.subplots(figsize=(8, 6))

# Plot histogram of the polarity values
tokyo_surf_df['sentiment'].hist(bins=[-1, -0.75, -0.5, -0.25, 0.25, 0.5, 0.75, 1],
                                ax=ax,
                                color="blue")

plt.title("Sentiments from tweets about surfing")
plt.show()


# Remove polarity values equal to zero
tokyo_surf_df2 = tokyo_surf_df[tokyo_surf_df.sentiment != 0]


fig, ax = plt.subplots(figsize=(8, 6))

# Plot histogram with break at zero
tokyo_surf_df2['sentiment'].hist(bins=[-1, -0.75, -0.5, -0.25, 0.0, 0.25, 0.5, 0.75, 1],
                                 ax=ax,
                                 color="blue")

plt.title("Sentiments from tweets about surfing")
plt.show()


# Saving surf dataframe to csv
tokyo_surf_df2.to_csv('tokyo_surf.csv')


# Create textblob objects of the tweets, store polarity values in new column
tokyo_skateboarding_df['sentiment'] = tokyo_skateboarding_df['text_no_stop_words'].apply(
    lambda tweet: TextBlob(tweet).sentiment.polarity)


tokyo_skateboarding_df.head()


fig, ax = plt.subplots(figsize=(8, 6))

# Plot histogram of the polarity values
tokyo_skateboarding_df['sentiment'].hist(bins=[-1, -0.75, -0.5, -0.25, 0.25, 0.5, 0.75, 1],
                                         ax=ax,
                                         color="purple")

plt.title("Sentiments from tweets about skateboarding")
plt.show()


# Remove polarity values equal to zero
tokyo_skateboarding_df2 = tokyo_skateboarding_df[tokyo_skateboarding_df.sentiment != 0]


fig, ax = plt.subplots(figsize=(8, 6))

# Plot histogram with break at zero
tokyo_skateboarding_df2['sentiment'].hist(bins=[-1, -0.75, -0.5, -0.25, 0.0, 0.25, 0.5, 0.75, 1],
                                          ax=ax,
                                          color="purple")

plt.title("Sentiments from tweets about skateboarding")
plt.show()


# Saving skateboarding dataframe to csv
tokyo_skateboarding_df2.to_csv('tokyo_skateboarding.csv')

	user_location	date	text	hashtags
0	Udupi, India	2021-07-24 10:59:49	Let the party begin\n#Tokyo2020	['Tokyo2020']
1	Manipur, India	2021-07-24 10:58:45	Congratulations #Tokyo2020 https://t.co/8OFKMs...	['Tokyo2020']
2	Global	2021-07-24 10:58:17	Big Breaking Now \n\nTokyo Olympic Update \n\n...	NaN
3	Lausanne	2021-07-24 10:57:56	Q4: 🇬🇧3-1🇿🇦\n\nGreat Britain finally find a wa...	NaN
4	Australia	2021-07-24 10:52:51	All I can think of every time I watch the ring...	['Tokyo2020', 'ArtisticGymnastics', '7Olympics...
5	India	2021-07-24 10:45:42	#Tokyo2020 #Olympics\n#MirabaiChanu\n#Weightli...	['Tokyo2020', 'Olympics', 'MirabaiChanu', 'Wei...
6	City by the water	2021-07-24 10:27:14	Can't help but cheer for them. Banda 6 goals i...	NaN
7	Manila	2021-07-24 11:02:49	@inquirerdotnet @ftjochoaINQ Caloy Yulo's 14.0...	NaN
8	Lausanne	2021-07-24 11:02:49	Q3 🇨🇦 1-4 🇩🇪\n\nGreen card for Canada's captai...	['Tokyo2020', 'CANvGER']
9	Puttur, Karnataka,India	2021-07-24 11:02:48	Hearty Congratulations to \nIndian Railways 🏋️...	NaN
10	Bacoor, Calabarzon	2021-07-24 11:02:48	GREAT FIRST ROUND ON THE RINGS!! #LabaPilipina...	['LabaPilipinas', 'TeamPhilippines', 'Tokyo202...
11	Lusaka	2021-07-24 11:02:48	Gymnastics ❤️ #Tokyo2020	['Tokyo2020']
12	Somewhere on the southside ✶	2021-07-24 11:02:48	Morning everyone! Caffeine check! @LoriLindsey...	['Tokyo2020', 'TokyoOlympics']
13	Kolkata, India	2021-07-24 11:02:46	5years of hardwork comes to an end for @offici...	['VikasKrishan']
14	Where sport happens.	2021-07-24 11:02:44	#Tokyo2020 #Tennis \n\nA win to remember for @...	['Tokyo2020', 'Tennis', 'Olympics']
15	NaN	2021-07-24 11:02:40	Proud of uhh Mirabai chanu \n#silvermedal\n#Mi...	['silvermedal', 'MirabaiChanu', 'Weightlifting...
16	Manila	2021-07-24 11:02:40	Up next for Carlos Yulo is vault. #ArtisticGym...	['ArtisticGymnastics', 'Tokyo2020']
17	NaN	2021-07-24 11:02:40	Congrates @mirabai_chanu you make our country ...	NaN
18	NaN	2021-07-24 11:02:38	Koreans are full of shit, period. \n\nRising S...	['Olympics', 'Tokyo2020', 'OlympicGames']
19	NaN	2021-07-24 11:02:37	The wait for a weightlifting medal is over! 👏🥈...	['Tokyo2020']

	user_location	date	text	hashtags
0	Udupi, India	2021-07-24 10:59:49	let the party begin tokyo	['Tokyo2020']
1	Manipur, India	2021-07-24 10:58:45	congratulations tokyo https t co ofkms ukq	['Tokyo2020']
2	Global	2021-07-24 10:58:17	big breaking now tokyo olympic update japan wo...	NaN
3	Lausanne	2021-07-24 10:57:56	q great britain finally find a way way pi...	NaN
4	Australia	2021-07-24 10:52:51	all i can think of every time i watch the ring...	['Tokyo2020', 'ArtisticGymnastics', '7Olympics...

Sentiment analysis of tweets about debut sports during the Tokyo 2020 Olympics¶

Data Source:¶

Loading Data¶

Text Cleanup¶

Filtering data by sport¶

Surfing¶

Skateboarding¶

Text Mining¶

Surfing¶

Skateboarding¶

Word Frequencies - Surfing Tweets¶

Plotting Common Words - Surfing¶

Word Frequencies - Skateboarding Tweets¶

Plotting Common Words - Skateboarding¶

Sentiment Analysis of Surfing Tweets¶

Sentiment Analysis of Skateboarding Tweets¶

	user_location	date	text	hashtags
2199	La Jolla, CA	2021-07-24 10:31:31	one big step for surfing tomorrow strongertoge...	['Surfing', 'StrongerTogether', 'Tokyo2020', '...
2303	NaN	2021-07-24 10:30:23	for the past two years endangered sea turtle n...	['surfing']
2491	Bucks, UK	2021-07-24 10:28:27	a bit on tokyo s brushes with the local wi...	['Tokyo2020', 'wildlife', 'olympics', 'surfing...
2734	Auckland, New Zealand	2021-07-24 10:24:52	fizzing surfing tokyo https t co fpsftsrert	['surfing', 'Tokyo2020']
3760	New Zealand	2021-07-24 10:10:40	the surfing at tokyo kicks off sunday morn...	['Tokyo2020']
4438	Burtonsville, MD	2021-07-24 10:01:07	olympics in tokyo just kick off today loo...	['Olympics', 'Tokyo2020', 'skateboarding', 'bm...
5125	India	2021-07-24 09:53:42	in my stream surfing i ve somehow ended up on ...	['basketball3x3', 'Tokyo2020']
5266	Seattle, WA	2021-07-24 09:52:12	olympics surfers are unsung masters of scienc...	['Olympics']
5632	Where the +Vibes are	2021-07-24 09:47:46	history in the making surfers inaugurate tokyo...	['Surfers', 'Tokyo2020']
5976	NaN	2021-07-24 09:43:51	rumours say wout van aert will be starring in ...	['CyclingRoad', 'Tokyo2020']
6581	Seattle, WA	2021-07-24 09:37:09	surf s up day of surfing s olympics debut is...	['Olympics', 'Tokyo2020']
11703	Israel	2021-07-24 11:15:00	anat lelior s first experience with surfing ca...	NaN
12813	Quilty 🇮🇪	2021-07-24 12:53:07	i really wish the field hockey surface was gre...	['Tokyo2020']
14935	England, United Kingdom	2021-07-24 13:18:26	unqualified journalists writing columns amp br...	['theguardian', 'BBCOlympics', 'Tokyo2020']
15383	Florida/Illinois	2021-07-24 13:34:37	so excited for surfing to get its moment at to...	['Tokyo2020']
15718	Mumbai, India	2021-07-24 13:38:39	the rise of the silver surfer she wanted to qu...	NaN
16622	NaN	2021-07-24 13:58:40	abcnews same could happen in japan but it wil...	['medalling']
16671	London & Dublin	2021-07-24 13:57:51	this year they ve added new sports to the ol...	NaN
16804	NaN	2021-07-24 13:59:30	surfing is a new addition to the olympic games...	NaN
18170	Lisbon, Portugal	2021-07-24 14:38:34	tomorrow is the day surfing will have its debu...	NaN

	user_location	date	text	hashtags
437	saw ac 020419; jb 111116 etc.	2021-07-24 10:56:04	tony and rayssa my new religion skateboarding ...	['skateboarding', 'Tokyo2020']
3084	Athens, Greece	2021-07-24 10:19:21	so excited to watch skateboarding and bmxfrees...	['skateboarding', 'bmxfreestyle', 'Olympics', ...
3283	Austria	2021-07-24 10:16:21	who will go for the first ever olympic gold in...	['skateboarding', 'Tokyo2020']
4438	Burtonsville, MD	2021-07-24 10:01:07	olympics in tokyo just kick off today loo...	['Olympics', 'Tokyo2020', 'skateboarding', 'bm...
4604	Germany	2021-07-24 09:59:44	skateboarding makes its debut at the olympics ...	['Olympics']
4777	South West, England	2021-07-24 09:57:57	what time bst is the skateboarding at the olym...	['Tokyo2020', 'skateboarding']
6302	Cambs	2021-07-24 09:40:03	will definitely be watching the skateboarding ...	['Tokyo2020']
9917	London	2021-07-24 09:04:13	nyjah huston and skateboarding hit the olympic...	['Tokyo2020']
10557	UK	2021-07-24 11:33:26	merrily watching day of tokyo and lookin...	['Tokyo2020']
10721	Aylesbury	2021-07-24 11:30:41	can t wait for the skateboarding tokyo	['Tokyo2020']
14685	Illinois, USA	2021-07-24 13:21:59	radio articles are discussing how skateboardin...	NaN
14737	mongolia	2021-07-24 13:21:26	skateboarding in tokyo olympics starts wi...	['skateboarding', 'Tokyo2020', 'Olympics']
14935	England, United Kingdom	2021-07-24 13:18:26	unqualified journalists writing columns amp br...	['theguardian', 'BBCOlympics', 'Tokyo2020']
15114	NaN	2021-07-24 13:30:44	teamusa s nyjah and japan s world champion ho...	['TeamUSA', 'Japan', 'skateboarding']
15582	Cheltenham, England	2021-07-24 13:35:48	does anyone know how when i can watch the skat...	NaN
15701	Philadelphia, PA	2021-07-24 13:38:58	tonyhawk calling skateboarding art artisevery...	['artiseverywhere', 'makeartnotwar', 'Tokyo202...
16664	Austin, TX	2021-07-24 13:58:03	i m glad to see sports like skateboarding x ...	NaN
17168	Canada	2021-07-24 14:07:27	dyk that skateboarding is making its olympic d...	['Tokyo2020']
17843	Nathan’s fluffy curl	2021-07-24 14:24:12	men s street skateboarding start list tokyo ...	['tokyo2020']
19724	Saint Paul, MN	2021-07-24 15:48:00	the rocket bros from fort are hyped for the de...	['Tokyo2020']

	words	count
0	surfing	1608
1	co	1297
2	https	1296
3	tokyo	1141
4	olympics	435
5	olympic	323
6	ever	224
7	women	194
8	one	179
9	semifinals	172
10	medal	165
11	event	164
12	history	158
13	shame	154
14	first	153
15	happened	152
16	unbelievable	152
17	gold	145
18	surf	140
19	men	138

	words	count
0	skateboarding	3522
1	tokyo	2651
2	co	1981
3	https	1979
4	olympics	1133
5	street	548
6	women	545
7	gold	498
8	olympic	409
9	first	344
10	didal	320
11	old	275
12	japan	257
13	year	250
14	medal	243
15	margielyn	242
16	nishiya	216
17	yuto	203
18	momiji	202
19	ever	187