{"id":3486,"date":"2018-06-15T19:17:19","date_gmt":"2018-06-15T19:17:19","guid":{"rendered":"https:\/\/max-drake.cc\/?p=3486"},"modified":"2018-06-29T15:25:52","modified_gmt":"2018-06-29T15:25:52","slug":"orange-free-data-mining-tool","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=3486","title":{"rendered":"Orange free Data Mining Tool"},"content":{"rendered":"<p><img decoding=\"async\" class=\"wp-image-3494 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01-1024x658.jpg\" alt=\"\" width=\"1468\" height=\"944\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01-1024x658.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01-300x193.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01-768x493.jpg 768w\" data-sizes=\"(max-width: 1468px) 100vw, 1468px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1468px; --smush-placeholder-aspect-ratio: 1468\/944;\" \/><\/p>\n<p>I was looking through <a href=\"https:\/\/www.labnol.org\/internet\/101-useful-websites\/18078\/\" target=\"_blank\" rel=\"noopener\">101-useful-websites<\/a> article and came across <a href=\"https:\/\/alternativeto.net\/platform\/windows\/\" target=\"_blank\" rel=\"noopener\">AlternativeTo.net<\/a> and used it to look up alternatives to say &#8220;Revit&#8221; and &#8220;AutoCad&#8221; and other tools I use.<\/p>\n<p>I then typed in KNIME which I use for <span class=\"item-desc\">data mining, data analysis and it came up with <a href=\"https:\/\/orange.biolab.si\/\" target=\"_blank\" rel=\"noopener\"><strong>Orange<\/strong><\/a> as a free alternative.&nbsp; So I looked at some videos on it on YouTube <\/span><\/p>\n<p><iframe title=\"Getting Started with Orange 01: Welcome to Orange\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/HXjnDIgGDuI?list=PLmNPvQr9Tf-ZSDLwOzxpvY-HrE0yv-8Fy\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n<p>The point that drew my attention to the programme straight away was that it seems to have an SQL Database link (unfortunately I am having difficulty getting python pymssql to load which it needs) and also the quick visualisation with simple scatterplots and reviewing data quickly with datatables. The other nice thing is you can use Python Scripts.<\/p>\n<h3>Testing<\/h3>\n<p>I filtered data using Open Refine &amp; Excel to simplify room data from a properties file, looking at room sizes for room types. The table is over 18000 rows long.<\/p>\n<p><img decoding=\"async\" class=\"wp-image-3496 aligncenter lazyload\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm02-1024x669.jpg\" alt=\"\" width=\"1501\" height=\"981\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm02-1024x669.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm02-300x196.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm02-768x501.jpg 768w\" data-sizes=\"(max-width: 1501px) 100vw, 1501px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1501px; --smush-placeholder-aspect-ratio: 1501\/981;\" \/><\/p>\n<p>Item 1. Import CSV file<\/p>\n<p>Item 2. Filter Rows for only displaying Floor Finishes (for getting floor area) and<\/p>\n<p>Item 3. Select Room Names &amp; Quantity (Floor Area. m2).&nbsp;<\/p>\n<p>Item 4. Use Scatter Plot to show X axis= Room Names &amp;&nbsp; Y axis = Quantity (Floor Area. m2).&nbsp;<\/p>\n<p>On initial testing a few things arise.<\/p>\n<ul>\n<li>You can create reports that then can be exported as HTML files, so you can post to web.<\/li>\n<li>Maps are static PNG files, so if you want to zoom in you have to save a few files to show different magnifications<\/li>\n<li>Graphs\/Tables can be saved in the Reports and also as PNG files too.<\/li>\n<\/ul>\n<h3>End Comments<\/h3>\n<p>This is pretty fast with the excel files. It processes the data and displays it quickly.<\/p>\n<p>I would like to get the Database connections working. The MS SQL is being a bit difficult in Python so I may try and use the PostGres connection and try it with the OpenMaint Database.<\/p>\n<p>I will definitely be giving this a better run. It has tools that I am interested in and I&#8217;m keen to try using the Python Script &amp; the Text Mining Tool.<\/p>\n<p>There is a machine learning tool that looks as if I could stumble my way through it and I intend to give that a try too.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was looking through 101-useful-websites article and came across AlternativeTo.net and used it to look up alternatives to say &#8220;Revit&#8221; and &#8220;AutoCad&#8221; and other tools I use. I then typed in KNIME which I use for data mining, data analysis and it came up with Orange as a free alternative.&nbsp; So I looked at some [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,3,36,5,33,34,12],"tags":[],"class_list":["post-3486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analysis","category-data-extraction","category-databases","category-graphs","category-knime-orange-rapidminer","category-python","category-visualisation"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/06\/imm01.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/3486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3486"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/3486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/3494"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}