{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"{'actual': 20.050000000000001,\n",
" 'error': 0.73699999999999999,\n",
" 'inst#': 1.0,\n",
" 'predicted': 20.786999999999999}"
]
},
"execution_count": 1,
"metadata": {
},
"output_type": "execute_result"
}
],
"source": [
"import pandas\n",
"import os\n",
"from __future__ import division\n",
"\n",
"root='/projects/3572606d-aafc-4285-a345-c223c56d1457/ML/Main/WEKA-test-result/'\n",
"file_list=[]\n",
"for file in os.listdir(root):\n",
" if file.endswith(\".xlsx\"):\n",
" file_list.append(os.path.join(root, file))\n",
"#print(file_list)\n",
"\n",
"data = {}\n",
"for path in file_list:\n",
" base_name_without_ext = os.path.basename(path)\n",
" base_name_without_ext = os.path.splitext(base_name_without_ext)[0]\n",
" try:\n",
" data[base_name_without_ext] = pandas.read_excel(open(path,'rb'), sheetname='test1').to_dict(orient='index')\n",
" except Exception as e:\n",
" print(e, base_name_without_ext)\n",
" pass\n",
"data['RIVP-features-test1'][0]"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"'/projects/3572606d-aafc-4285-a345-c223c56d1457'"
]
},
"execution_count": 2,
"metadata": {
},
"output_type": "execute_result"
}
],
"source": [
"os.path.expanduser('~')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"WARNING: 1 intermediate output message was discarded.\n"
]
}
],
"source": [
"import numpy as np\n",
"import plotly.offline as py\n",
"import plotly.graph_objs as go\n",
"\n",
"py.init_notebook_mode()\n",
"def _draw2(data0, data1, data2, name1, name2):\n",
" trace1 = go.Scatter(\n",
" x = data0,\n",
" y = data1, #value\n",
" name = name1 ,\n",
" line = dict(\n",
" color = ('rgb(205, 12, 24)'),\n",
" width = 4))\n",
" trace2 = go.Scatter(\n",
" x = data0,\n",
" y = data2, #value\n",
" name = name2,\n",
" line = dict(\n",
" color = ('rgb(33, 136, 220)'),\n",
" width = 4))\n",
" data = [trace1, trace2]\n",
" # Edit the layout\n",
" layout = dict(title = name1+' usporedba s ' + name2,\n",
" xaxis = dict(title = 'Dani'),\n",
" yaxis = dict(title = 'Vrijednost'),\n",
" )\n",
" fig = dict(data=data, layout=layout)\n",
" py.iplot(fig, filename=name1)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
""
]
},
"execution_count": 4,
"metadata": {
},
"output_type": "execute_result"
},
{
"data": {
"text/html": [
""
]
},
"execution_count": 4,
"metadata": {
},
"output_type": "execute_result"
}
],
"source": [
"def analiza(rezultat):\n",
" actual = [] #stvarna\n",
" error = [] #greška\n",
" inst = [] #broj\n",
" predicted = [] #predviđena\n",
" \n",
" for i in range(len(data[rezultat])):\n",
" actual.append(data[rezultat][i][u'actual'])\n",
" error.append(data[rezultat][i][u'error'])\n",
" inst.append(data[rezultat][i][u'inst#'])\n",
" predicted.append(data[rezultat][i][u'predicted'])\n",
" \n",
" _draw2(inst,actual,predicted,'Stvarna od '+rezultat,'Predviđena od '+rezultat)\n",
" \n",
" return \n",
"\n",
"analiza('RIVP-features-test1')\n",
"analiza('RIVP-test1')"
]
},
{
"cell_type": "code",
"execution_count": 0,
"metadata": {
"collapsed": false
},
"outputs": [
],
"source": [
]
},
{
"cell_type": "code",
"execution_count": 0,
"metadata": {
"collapsed": true
},
"outputs": [
],
"source": [
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (Anaconda)",
"language": "python",
"name": "anaconda3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.4"
}
},
"nbformat": 4,
"nbformat_minor": 0
}