def __init__(self):
self.currentConnection = None
self.currentDB = ''
self.tableOut = Output(layout=Layout(max_width='30%'))
self.schemaOut = Output()
self.tableSelect = Dropdown(
options=[''],
value='',
description='Table:',
disabled=False,
)
self.databaseSelect = Dropdown(
options=['sqlite-sakila', 'chinook'],
value='sqlite-sakila',
description='Database:',
disabled=False,
)
self.tableSelect.observe(self.tableChange, names='value')
self.databaseSelect.observe(self.databaseChange, names='value')
self.displayDatabases = VBox([
HBox(
[self.tableOut,
VBox([self.databaseSelect, self.tableSelect])]),
self.schemaOut
])
self.changeDatabase()
def column_output_widget(df, colname, **kwargs):
logger.debug("inside column_output_widget")
output = Output()
with output:
vis_output = Output()
preds_output = Output()
with vis_output:
if df[colname].dtype.name in ['int64', 'float64']:
logger.debug("invoking histogram_widget for %s" % (colname))
hplot = histogram_widget(df, colname)
logger.debug("histogram widget created for %s" % (colname))
hist_html = HTML("<h2>Histogram Plot of %s</h2>" % (colname))
display(hist_html)
display(hplot)
else:
logger.debug("invoking histogram_widget for %s" % (colname))
hplot = histogram_widget(df, colname)
logger.debug("histogram widget created for %s" % (colname))
logger.debug("invoking pie_chart_widget for %s" % (colname))
pie_widg = pie_chart_widget(df, colname)
logger.debug("pie widget created for %s" % (colname))
pie_html = HTML("<h2>Pie Plot of %s</h2>" % (colname))
hist_html = HTML("<h2>Histogram Plot of %s</h2>" % (colname))
display(hist_html)
# histogram plot
display(hplot)
# plot pie chart
display(pie_html)
display(pie_widg)
with preds_output:
# get preds and scores
logger.debug("invoking predictors of %s" % colname)
preds = predictors(df, df[colname])
logger.debug("got predictors of %s" % colname)
logger.debug("creating predictors_widget for %s" % colname)
pw = predictors_widget(preds, colname)
logger.debug("done creating predictors_widget for %s" % colname)
display(pw)
tab = Tab([vis_output, preds_output])
tab.set_title(0, "Visualize")
tab.set_title(1, "Predictors")
# display tab
display(tab)
logger.debug("returning from column_output_widget")
return output
def __init__(self):
self.setting = self.create_settings()
self.keyword = Textarea(
value='',
placeholder='Search dictionary and press enter',
description='',
disabled=False,
rows=1,
layout=Layout(width='50%'))
self.search_button = self.create_button('search')
self.save_button = self.create_button('save file')
self.out = Output()
self.results = {}
self.search_button.on_click(self.search)
self.save_button.on_click(self.save_file)
self.keyword.observe(self.adjust_keyword_size, 'value')
def pplot_output_widget(df):
"""pair plot widget"""
pplot_output = Output()
with pplot_output:
# sns.pairplot(df, vars=[col1, col2])
# dropping na values to avoid
# ValueError: max must be larger than min in range parameter
sns.pairplot(df.dropna())
plt.show()
return pplot_output
def summary_stats_widget(df):
stats_output = Output()
with stats_output:
logger.info("invoking summary_stats")
summ_stats = summary_stats(df)
logger.info("got summary statistics from summary_stats")
logger.info("applying threshold color")
display(apply_thresh_style(summary_stats(df)))
logger.info("finished applying threshold")
return stats_output
def __init__(self, qNo):
self.qNo = qNo
self.qOut = Output()
self.queryArea = Textarea(
value='',
placeholder='Type your Query here',
description='',
disabled=False,
#layout = Layout(max_width='30%')
)
self.execute = Button(
description='Execute',
disabled=False,
button_style='', # 'success', 'info', 'warning', 'danger' or ''
tooltip='Execute',
#layout = Layout(max_width='20%')
)
self.resultMessage = Output()
self.execute.on_click(self.executeQuery)
self.yourOutput = Output(layout=Layout())
self.expectedOutput = Output(layout=Layout())
self.yourOut = Output()
self.expectOut = Output()
with self.yourOut:
display(HTML('<b>Your Ouput:</b>'))
with self.expectOut:
display(HTML('<b>Expected Ouput:</b>'))
self.disPlayWindow = VBox([HBox([self.qOut,self.queryArea,self.execute,self.resultMessage]),\
VBox([VBox([self.expectOut,self.expectedOutput]\
),VBox([self.yourOut,self.yourOutput])])]\
,layout = Layout(width='80%'))
self.qset = pd.read_csv('questions.csv')
self.questionData = self.qset.loc[self.qset.qNo == self.qNo]
expected = self.getExpected()
with self.expectedOutput:
display(expected)
with self.qOut:
print(self.questionData.question.values[0])
def __init__(self):
self.data_titles = []
self.data_scores = []
self.afinn = None
self.select = Dropdown(
options={
'Politiken.dk': 0,
'DR.dk': 1,
'BT.dk': 2,
'Information.dk': 3,
'Børsen.dk': 4,
'Ekstrabladet.dk': 5
},
value=0,
description='Vælg nyhedskilde:',
disabled=False,
layout=Layout(width='300px'),
style={'description_width': '130px'},
)
self.container = Output(value="", )
self.submit_button = Button(
value=False,
description='Indlæs nyheder',
disabled=False,
button_style=
'success', # 'success', 'info', 'warning', 'danger' or ''
tooltip='Få nyheder fra RSS-feed og lav sentiment-analyse',
icon='')
self.widget_box = VBox(
(self.select, self.submit_button, self.container), )
self.submit_button.on_click(self._do_sentiment_analysis)
def _make_output_widget(self):
from ipywidgets.widgets import Output
return Output()
def __init__(self):
self.afinn = Afinn(language="da")
self.speeches_names = [('2018 (Lars Løkke Rasmussen)', '2018'),
('2017 (Lars Løkke Rasmussen)', '2017'),
('2016 (Lars Løkke Rasmussen)', '2016'),
('2015 (Lars Løkke Rasmussen)', '2015'),
('2014 (Helle Thorning-Schmidt)', '2014'),
('2013 (Helle Thorning-Schmidt)', '2013'),
('2012 (Helle Thorning-Schmidt)', '2012'),
('2011 (Helle Thorning-Schmidt)', '2011'),
('2010 (Lars Løkke Rasmussen)', '2010'),
('2009 (Lars Løkke Rasmussen)', '2009'),
('2008 (Anders Fogh Rasmussen)', '2008'),
('2007 (Anders Fogh Rasmussen)', '2007'),
('2006 (Anders Fogh Rasmussen)', '2006'),
('2005 (Anders Fogh Rasmussen)', '2005'),
('2004 (Anders Fogh Rasmussen)', '2004'),
('2003 (Anders Fogh Rasmussen)', '2003'),
('2002 (Anders Fogh Rasmussen)', '2002'),
('2001 (Poul Nyrup Rasmussen)', '2001'),
('2000 (Poul Nyrup Rasmussen)', '2000'),
('1999 (Poul Nyrup Rasmussen)', '1999'),
('1998 (Poul Nyrup Rasmussen)', '1998'),
('1997 (Poul Nyrup Rasmussen)', '1997')]
self.speeches = {}
self.speeches_sentiments = {}
self.select = Dropdown(
options={
'2018 (Lars Løkke Rasmussen)': 0,
'2017 (Lars Løkke Rasmussen)': 1,
'2016 (Lars Løkke Rasmussen)': 2,
'2015 (Lars Løkke Rasmussen)': 3,
'2014 (Helle Thorning-Schmidt)': 4,
'2013 (Helle Thorning-Schmidt)': 5,
'2012 (Helle Thorning-Schmidt)': 6,
'2011 (Helle Thorning-Schmidt)': 7,
'2010 (Lars Løkke Rasmussen)': 8,
'2009 (Lars Løkke Rasmussen)': 9,
'2008 (Anders Fogh Rasmussen)': 10,
'2007 (Anders Fogh Rasmussen)': 11,
'2006 (Anders Fogh Rasmussen)': 12,
'2005 (Anders Fogh Rasmussen)': 13,
'2004 (Anders Fogh Rasmussen)': 14,
'2003 (Anders Fogh Rasmussen)': 15,
'2002 (Anders Fogh Rasmussen)': 16,
'2001 (Poul Nyrup Rasmussen)': 17,
'2000 (Poul Nyrup Rasmussen)': 18,
'1999 (Poul Nyrup Rasmussen)': 19,
'1998 (Poul Nyrup Rasmussen)': 20,
'1997 (Poul Nyrup Rasmussen)': 21
},
value=0,
description='Vælg talen:',
disabled=False,
layout=Layout(width='400px'),
style={'description_width': '100px'},
)
self.container = Output(value="", )
self.submit_button = Button(
value=False,
description='Indlæs talen',
disabled=False,
button_style=
'success', # 'success', 'info', 'warning', 'danger' or ''
tooltip='Indlæs statsministerens tale og lav sentiment-analyse',
icon='')
self.widget_box = VBox(
(self.select, self.submit_button, self.container), )
self.submit_button.on_click(self._do_sentiment_analysis)
def _make_output_widget(self):
return Output()
class UI:
def __init__(self):
self.setting = self.create_settings()
self.keyword = Textarea(
value='',
placeholder='Search dictionary and press enter',
description='',
disabled=False,
rows=1,
layout=Layout(width='50%'))
self.search_button = self.create_button('search')
self.save_button = self.create_button('save file')
self.out = Output()
self.results = {}
self.search_button.on_click(self.search)
self.save_button.on_click(self.save_file)
self.keyword.observe(self.adjust_keyword_size, 'value')
def adjust_keyword_size(self, event):
self.keyword.rows = self.keyword.value.count('\n') + 1
def save_file(self, event):
filename = 'result.txt'
with open(filename, 'w') as fp:
self.show_result(file=fp)
self.out.clear_output()
def get_config(self):
return {
'dictionary': [
dict_name.description
for dict_name in self.setting[1, 1].children if dict_name.value
],
'fields': {
'Cambridge': {
'word': {
dict_name.description: dict_name.value
for dict_name in self.setting[3, 1].children
},
'phrase': {
dict_name.description: dict_name.value
for dict_name in self.setting[4, 1].children
}
},
'Merriam': {
dict_name.description: dict_name.value
for dict_name in self.setting[5, 1].children
},
'Etymology': {
dict_name.description: dict_name.value
for dict_name in self.setting[6, 1].children
},
'translate': {
dict_name.description: dict_name.value
for dict_name in self.setting[7, 1].children
}
}
}
def show_result(self, event=None, file=sys.stdout):
if not self.results:
return
self.out.clear_output()
fields = self.get_config()['fields']
word_field = fields['Cambridge']['word']
phrase_field = fields['Cambridge']['phrase']
translate = fields['translate']['requirment']
with self.out:
for keyword, result in self.results.items():
myprint(keyword + ':', end='\n', file=file)
myprint('*' * 10, end='\n', file=file)
for word in result.get('Cambridge', []):
myprint(word['text'], head=4, file=file)
myprint('(part-of-speech: {})'.format(word['pos'])
if word_field['pos'] else '',
end='\n',
file=file)
defines = word['defines'] if word_field['define'] else []
for idx, define in enumerate(defines):
grammar = define.get('grammar',
word.get('grammar', None))
myprint('define {}: {}'.format(
idx, define['define']['text']),
head=8,
file=file)
myprint('({})'.format(define['define']['translate']) if
translate and define['define']['text'] else '',
head=1,
file=file)
myprint('[{}]'.format(grammar)
if word_field['grammar'] else '',
end='\n',
head=1,
file=file)
examples = define['examples'] if word_field[
'examples'] else []
for ex_idx, example in enumerate(examples):
myprint('- example {}: {}'.format(
ex_idx, example['text']),
head=12,
file=file)
myprint('({})'.format(example['translate'])
if translate and example['text'] else '',
end='\n',
head=1,
file=file)
phrases = define['phrases'] if phrase_field[
'text'] else []
for ph_idx, phrase in enumerate(phrases):
myprint('* phrase {}: {}'.format(
ph_idx, phrase['phrase']),
head=12,
end='\n',
file=file)
myprint('define: {}'.format(
phrase['define']['text']
if phrase_field['define'] else ''),
head=16,
file=file)
myprint(
'({})'.format(phrase['define']['translate']) if
translate and phrase_field['define'] else '',
end='\n',
head=1,
file=file)
examples = phrase['examples'] if phrase_field[
'examples'] else []
for ex_idx, example in enumerate(examples):
myprint('- example {}: {}'.format(
ex_idx, example['text']),
head=20,
file=file)
myprint('({})'.format(
example['translate']
if translate and example['text'] else ''),
end='\n',
head=1,
file=file)
myprint(end='\n', file=file)
merriam_field = fields['Merriam']
if result.get('Merriam') and (merriam_field['first use']
or merriam_field['etymology']):
myprint('In Merriam webster:', end='\n', head=4, file=file)
if merriam_field['first use']:
myprint('First known use:',
head=8,
end='\n',
file=file)
self.print_merriam(
result['Merriam']['first_known_use'], file=file)
if merriam_field['etymology']:
myprint('Etymology:', head=8, end='\n', file=file)
self.print_merriam(result['Merriam']['etymology'],
file=file)
etymology_field = fields['Etymology']
if result.get('Etymology') and (
etymology_field['description']
or etymology_field['image(if any)']):
myprint('In etymology online:',
end='\n',
head=4,
file=file)
if etymology_field['description']:
myprint('Description:', head=8, end='\n', file=file)
data = result['Etymology']['text']
myprint(data if data else 'No data',
head=12,
end='\n',
file=file)
if etymology_field['image(if any)'] and result[
'Etymology']['image_url']:
display(
Image(
requests.get(
result['Etymology']['image_url']).content))
myprint(end='\n', file=file)
myprint('=' * 75, end='\n', file=file)
def print_merriam(self, data, file=sys.stdout):
if data:
for d in data:
if d['type']:
myprint('part-of-speech: {}'.format(d['type']),
head=12,
end='\n',
file=file)
myprint(d['text'], head=12, end='\n', file=file)
myprint(file=file)
else:
myprint(data if data else 'No data', head=8, end='\n', file=file)
def search(self, event):
self.out.clear_output()
config = self.get_config()
dict_names = config['dictionary']
engine = {
'Cambridge':
CamBridge('chinese-traditional' if config['fields']['translate']
['requirment'] else None),
'Merriam':
MerriamWebster(),
'Etymology':
OnlineEtymology()
}
if self.keyword.value:
self.results = {}
with self.out:
for keyword in self.keyword.value.split('\n'):
print('search {}...'.format(keyword))
self.results[keyword] = {
dict_name: engine[dict_name].search(keyword.strip())
for dict_name in dict_names
}
self.show_result()
else:
with self.out:
print('The keyword in search bar is required.')
def create_settings(self):
word = self.create_checkbox('define', 'pos', 'grammar', 'examples')
phrase = self.create_checkbox('text', 'define', 'examples')
dictionary = self.create_checkbox('Cambridge', 'Merriam', 'Etymology')
merriam = self.create_checkbox('first use', 'etymology')
etymology = self.create_checkbox('description', 'image(if any)')
translate = self.create_checkbox('requirment')
setting = GridspecLayout(8, 6)
setting[0, 2] = Label('settings')
setting[1, 1:len(dictionary) + 1] = Box(dictionary)
setting[1, 0] = Label('dictionary')
setting[2, 2] = Label('output')
setting[3, 0] = Label('word')
setting[3, 1:len(word) + 1] = Box(word)
setting[4, 0] = Label('phrase')
setting[4, 1:len(phrase) + 1] = Box(phrase)
setting[5, 0] = Label('Merriam')
setting[5, 1:len(merriam) + 1] = Box(merriam)
setting[6, 0] = Label('Etymology')
setting[6, 1:len(etymology) + 1] = Box(etymology)
setting[7, 0] = Label('Translate')
setting[7, 1:len(translate) + 1] = Box(translate)
return setting
def create_checkbox(self, *options, default=True):
box = [
Checkbox(value=default,
description=dict_name,
disabled=False,
indent=False) for dict_name in options
]
for c in box:
c.observe(self.show_result)
return box
def create_button(self, name):
button = Button(description=name,
disabled=False,
button_style='info',
tooltip='Click me',
icon='')
return button
def run(self):
display(self.keyword)
display(self.search_button)
display(self.setting)
display(self.save_button)
display(self.out)
style = """
<style>
.jupyter-widgets-output-area .output_scroll {
height: unset !important;
border-radius: unset !important;
-webkit-box-shadow: unset !important;
box-shadow: unset !important;
}
.jupyter-widgets-output-area {
height: auto !important;
}
</style>
"""
display(HTML(style))
def __init__(self, wikipedia: Wikipedia, rsspediainit: RsspediaInit):
"""
:param Wikipedia wikipedia: wikipedia class object initialized with correct language
:param RsspediaInit rsspediainit: rsspedia init object - prepares the data and embeddings
"""
self.data_titles = []
self.data_results = []
self.rsspediainit = rsspediainit
self.wikipedia = wikipedia
self.select_feed = Dropdown(
options={
'Politiken.dk': 0,
'DR.dk': 1,
'BT.dk': 2,
'Information.dk': 3,
'Børsen.dk': 4,
'Ekstrabladet.dk': 5
},
value=0,
description='Vælg nyhedskilde:',
disabled=False,
layout=Layout(width='400px'),
style={'description_width': '160px'},
)
self.select_search = Dropdown(
options={
'Okapi BM-25': 0,
'Explicit Semantic Analysis': 1,
'FTN-a': 2,
'FTN-b': 3
},
value=0,
description='Vælg søgnings-algorytme:',
disabled=False,
layout=Layout(width='400px'),
style={'description_width': '160px'},
)
self.select_nmatches = Dropdown(
options={
'3': 3,
'5': 5,
'10': 10
},
value=3,
description='Vælg antal matches:',
disabled=False,
layout=Layout(width='400px'),
style={'description_width': '160px'},
)
self.container = Output(value="", )
self.submit_button = Button(
value=False,
description='Indlæs nyheder',
disabled=False,
button_style=
'success', # 'success', 'info', 'warning', 'danger' or ''
tooltip='Få nyheder fra RSS-feed og find Wikipedia matches',
icon='')
self.widget_box = VBox(
(self.select_feed, self.select_search, self.select_nmatches,
self.submit_button, self.container), )
self.submit_button.on_click(self._run)
class QueryWindow:
def __init__(self, qNo):
self.qNo = qNo
self.qOut = Output()
self.queryArea = Textarea(
value='',
placeholder='Type your Query here',
description='',
disabled=False,
#layout = Layout(max_width='30%')
)
self.execute = Button(
description='Execute',
disabled=False,
button_style='', # 'success', 'info', 'warning', 'danger' or ''
tooltip='Execute',
#layout = Layout(max_width='20%')
)
self.resultMessage = Output()
self.execute.on_click(self.executeQuery)
self.yourOutput = Output(layout=Layout())
self.expectedOutput = Output(layout=Layout())
self.yourOut = Output()
self.expectOut = Output()
with self.yourOut:
display(HTML('<b>Your Ouput:</b>'))
with self.expectOut:
display(HTML('<b>Expected Ouput:</b>'))
self.disPlayWindow = VBox([HBox([self.qOut,self.queryArea,self.execute,self.resultMessage]),\
VBox([VBox([self.expectOut,self.expectedOutput]\
),VBox([self.yourOut,self.yourOutput])])]\
,layout = Layout(width='80%'))
self.qset = pd.read_csv('questions.csv')
self.questionData = self.qset.loc[self.qset.qNo == self.qNo]
expected = self.getExpected()
with self.expectedOutput:
display(expected)
with self.qOut:
print(self.questionData.question.values[0])
def getExpected(self):
expected = pd.read_pickle('results/' +
self.questionData.results.values[0])
if self.questionData.result_type.values[0] != 'set':
expected = expected.iloc[0][0]
return expected
def display(self):
return self.disPlayWindow
def executeQuery(self, event):
self.resultMessage.clear_output()
self.yourOutput.clear_output()
db = databases.getDB(self.questionData.database.values[0])
error = False
try:
result = pd.read_sql_query(self.queryArea.value, db)
except:
with self.resultMessage:
display(
HTML(
'<span style="color:red">Error in processing your query. Please check syntax and retry</span>'
))
error = True
if not error:
match = False
expected = self.getExpected()
if self.questionData.result_type.values[0] != 'set':
if result.shape == (1, 1):
result = result.iloc[0][0]
match = result == expected
else:
if not self.questionData.isOrder.values[0]:
#check all columns are same
if set(result.columns.values) == set(
expected.columns.values) == 0:
match=result.sort_values(by=[self.questionData.sort_key.values[0]])\
.reset_index(drop=True).equals(expected.sort_values(by=[self.questionData.sort_key.values[0]])\
.reset_index(drop=True))
else:
match = result.reset_index(drop=True).equals(
expected.reset_index(drop=True))
with self.yourOutput:
display(result)
msg = '<span style="color:green">Success!!!!!</span>'
if not match:
msg = '<span style="color:red">Sorry your query results doesnot match the expected result. Please try again</span>'
with self.resultMessage:
display(HTML(msg))
def __init__(self):
"""
:param int i:
"""
self.test_sound = None
self.test_data = None
self.select_test_data_options = None
self.select_test_data = Dropdown(
options={'Record test data': 0,
'Load test data files': 1
},
value=0,
description='Choose training data:',
disabled=False,
layout=Layout(width='400px'),
style={'description_width': '160px'},
)
self.select_test_data.observe(self.on_change)
self.select_nseconds = Dropdown(
options={
'2s': 2,
'3s': 3,
'5s': 5
},
value=2,
description='Choose recording length:',
disabled=False,
layout=Layout(width='400px', display='block'),
style={'description_width': '160px'},
)
self.container = Output(
value="",
)
self.submit_button = Button(
value=False,
description='Get test data',
disabled=False,
button_style='success', # 'success', 'info', 'warning', 'danger' or ''
tooltip='TEST: use recorded sounds or record new',
icon=''
)
self.play_button = Button(
value=False,
description='Play the recording',
disabled=False,
button_style='info', # 'success', 'info', 'warning', 'danger' or ''
tooltip='TEST: play recorded or loaded sounds',
icon=''
)
self.widget_box = VBox(
(
HBox(
(
VBox((
self.select_test_data,
self.select_nseconds
), ),
VBox((
self.submit_button,
self.play_button
), )
),
),
self.container
),
)
self.submit_button.on_click(self._run)
self.play_button.on_click(self._playback)
class Display:
def __init__(self):
self.currentConnection = None
self.currentDB = ''
self.tableOut = Output(layout=Layout(max_width='30%'))
self.schemaOut = Output()
self.tableSelect = Dropdown(
options=[''],
value='',
description='Table:',
disabled=False,
)
self.databaseSelect = Dropdown(
options=['sqlite-sakila', 'chinook'],
value='sqlite-sakila',
description='Database:',
disabled=False,
)
self.tableSelect.observe(self.tableChange, names='value')
self.databaseSelect.observe(self.databaseChange, names='value')
self.displayDatabases = VBox([
HBox(
[self.tableOut,
VBox([self.databaseSelect, self.tableSelect])]),
self.schemaOut
])
self.changeDatabase()
@property
def displayDatabases(self):
return self._displayDatabases
@displayDatabases.setter
def displayDatabases(self, value):
self._displayDatabases = value
def changeDatabase(self):
selectedDatabase = self.databaseSelect.value
if self.currentConnection is None or self.currentDB != selectedDatabase:
if self.currentConnection is not None:
self.currentConnection.close()
self.currentConnection = sqlite3.connect(
f'databases/{selectedDatabase}.db')
# lite.connect('folder_A/my_database.db')
# sqlite:///
self.currentDB = f'{selectedDatabase}'
tables = pd.read_sql_query(
"SELECT name FROM sqlite_master WHERE type='table';",
self.currentConnection)
self.tableSelect.options = tables.name.values
self.tableSelect.value = tables.name.values[0]
def displayTable(self):
query = f"select * from {self.tableSelect.value} limit 5"
query2 = f"pragma table_info('{self.tableSelect.value}');"
data = pd.read_sql_query(query, self.currentConnection)
data2 = pd.read_sql_query(
query2, self.currentConnection)[['name', 'type', 'pk']]
self.tableOut.clear_output()
self.schemaOut.clear_output()
with self.tableOut:
display(data)
with self.schemaOut:
display(data2)
def tableChange(self, change):
self.displayTable()
def databaseChange(self, change):
self.changeDatabase()
