{"id":1121,"date":"2015-04-24T17:18:59","date_gmt":"2015-04-25T00:18:59","guid":{"rendered":"https:\/\/blogs.ubc.ca\/coetoolbox\/?p=1121"},"modified":"2015-06-15T13:41:30","modified_gmt":"2015-06-15T20:41:30","slug":"summer-bootcamp","status":"publish","type":"post","link":"https:\/\/blogs.ubc.ca\/coetoolbox\/2015\/04\/24\/summer-bootcamp\/","title":{"rendered":"Summer Bootcamp"},"content":{"rendered":"<p>Welcome to the project season, padawans! You&#8217;ve learned quite a bit of theory during the last months and now you are ready to face some real world OR problems. Before diving into the projects we will spend a couple of days brushing up some practical skills that will be useful during the project season and beyond. Until you get started with your project, you will work in teams with your office mates towards the following objectives: <!--more--><\/p>\n<ul>\n<li>Get introduced to \u201ctext analytics\u201d, an increasingly important topic in our field.<\/li>\n<li>Analyze text data using SQL Server,\u00a0COE&#8217;s database management software.<\/li>\n<li>Get prepared to code in Python, one of the most common languages to do text analytics.<\/li>\n<\/ul>\n<p>Here is how we&#8217;ll do it:<\/p>\n<h3>Activity 1: Get introduced to \u201ctext analytics\u201d<\/h3>\n<p>Read the post <a title=\"Let\u2019s talk about Text Analytics\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/2015\/03\/25\/lets-talk-about-text-analytics\/\">Let\u2019s talk about text analytics<\/a> and make a contribution by sharing a technique or application you find interesting (mentioned in the article or a new one). You can add a comment to the post or write a new one (one per group). Please explain clearly and include references\/links accordingly.<\/p>\n<h3>Activity 2: Analyze text data using SQL Server<\/h3>\n<p>Set up a database with <a href=\"https:\/\/snap.stanford.edu\/data\/web-FineFoods.html\" target=\"_blank\">food product reviews from Amazon<\/a> (ask further directions). Do some descriptive statistics to refresh <a title=\"Queries Basics\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/databases\/queries\/\" target=\"_blank\">query basics<\/a>. Then try to apply some of the techniques mentioned in the post such as stemming or word counting to get some insights from the reviews (<a title=\"Comparison Keywords\" href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/databases\/comparison-keywords\/\">comparison keywords<\/a> might be handy). For instance, are there words with higher correlation with positive or negative product reviews? Don&#8217;t get too fancy, but try to see if you can get something interesting. Put your findings in a blog post (one per group), explaining briefly how you crunched the data. Don&#8217;t forget the <a href=\"https:\/\/blogs.ubc.ca\/coetoolbox\/summarizing-data\/data-visualization\/\">data visualization<\/a> tips (or your post might not be published).<\/p>\n<h3>Activity 3: Get prepared to code in Python<\/h3>\n<p>Get Python set up in your computer and do <a href=\"https:\/\/developers.google.com\/edu\/python\/\" target=\"_blank\">Google&#8217;s Python Class<\/a>. This is a 2 day tutorial and you might need to start working\u00a0on your project before you finish, but try to get as far as you can. Alternatively, you can do the <a href=\"http:\/\/www.codecademy.com\/en\/tracks\/python\" target=\"_blank\">Python course in Codecademy<\/a>, doesn&#8217;t require to install anything and is very easy to follow. Even if you don&#8217;t use Python, the coding skills will be handy sooner than you think. If you feel confident and prepared for new challenges, try to parse <a href=\"https:\/\/snap.stanford.edu\/data\/web-FineFoods.html\" target=\"_blank\">the<\/a><a href=\"https:\/\/snap.stanford.edu\/data\/web-FineFoods.html\" target=\"_blank\"> original <\/a><a href=\"https:\/\/snap.stanford.edu\/data\/web-FineFoods.html\" target=\"_blank\"> food review dataset<\/a> using Python.<\/p>\n<p>Good luck&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"http:\/\/kadebg.com\/wp-content\/uploads\/2014\/01\/yoda.jpg\" alt=\"\" width=\"304\" height=\"229\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the project season, padawans! You&#8217;ve learned quite a bit of theory during the last months and now you are ready to face some real world OR problems. Before diving into the projects we will spend a couple of days brushing up some practical skills that will be useful during the project season and [&hellip;]<\/p>\n","protected":false},"author":22982,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1054146,1054145],"class_list":["post-1121","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-industry-projects","tag-mmor"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/1121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/users\/22982"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/comments?post=1121"}],"version-history":[{"count":15,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/1121\/revisions"}],"predecessor-version":[{"id":1212,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/posts\/1121\/revisions\/1212"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/categories?post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/tags?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}