Skip to content

Instantly share code, notes, and snippets.

@focaalvarez

focaalvarez/Pubs Uk.py

Created July 11, 2019 12:06
Show Gist options
  • Save focaalvarez/57befb070e2502826684e41ebfed201a to your computer and use it in GitHub Desktop.
Save focaalvarez/57befb070e2502826684e41ebfed201a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Pubs Uk.py
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
from wordcloud import WordCloud, STOPWORDS, ImageColorGenerator
pubs=pd.read_excel('open_pubs.xlsx',sheet_name='open_pubs',converters={'name':str})
cities=pd.read_excel('open_pubs.xlsx',sheet_name='population')
#transform to lower case and transform to strings
pubs['name']=pubs['name'].str.lower()
stopwords=['the','ltd','club','inn']
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment