In [1]:
import requests
import bs4
import csv
from datetime import datetime
In [2]:
def remove_all_whitespace(x):
"""
Returns a string with any blank spaces removed.
"""
try:
x = x.replace(" ", "")
except:
pass
return x
In [3]:
def trim_the_ends(x):
"""
Returns a string with space on the left and right removed.
"""
try:
x = x.strip(' \t\n\r')
except:
pass
return x
In [4]:
def remove_unneeded_chars(x):
"""
Returns the string without the unneeded chars
"""
try:
x = x.replace("$", "").replace("RRP", "")
except:
pass
return x
In [5]:
URL = ("https://www.packtpub.com/application-development/"
"python-business-intelligence-cookbook")
response = requests.get(URL)
In [7]:
response.text
Out[7]:
'<!DOCTYPE html>\n<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">\n\t<head>\n\t\t<title>Python Business Intelligence Cookbook | PACKT Books</title>\n\t\t<script>\n\t\t\tdataLayer = [];\n\t\t</script>\n\t\t<script type="text/javascript">\n\t\t\tvar GRANIFY_SITE_ID = 1318;(function(e,t,n){var r,i,s,o,u;u=false;try{o=new RegExp("(?:^|\\\\W)_gr_test_url=([^;]*)");s=document.cookie.match(o);if(s){if(s[1]==="1")u=true}else{r=Math.random();if(r>.95)u=true;i=new Date(+(new Date)+1e3*60*60*24*2);document.cookie="_gr_test_url="+ +u+";expires="+i.toGMTString()+";path=/"}}catch(a){}if(u)e.replace("javascript.js","javascript.next.js");try{o=new RegExp("(?:^|\\\\W)_gr_ep=([^;]*)");s=document.cookie.match(o);if(!s){document.cookie="_gr_ep_sent=;expires=Thu, 01-Jan-1970 00:00:01 GMT;path=/";document.cookie="_gr_er_sent=;expires=Thu, 01-Jan-1970 00:00:01 GMT;path=/";if(!window.location.origin){if(window.location.port)port=":"+window.location.port;else port="";window.location.origin=window.location.protocol+"//"+window.location.hostname+port}path=window.location.toString().replace(window.location.origin,"");referrer=document.referrer;i=new Date(+(new Date)+1e3*60*30);document.cookie="_gr_ep="+path+";expires="+i.toGMTString()+";path=/";document.cookie="_gr_er="+referrer+";expires="+i.toGMTString()+";path=/"}}catch(a){}a=new Date;a=""+a.getUTCFullYear()+(a.getUTCMonth()+1)+a.getUTCDate();e=e+"?id="+t+"&v="+a;window.Granify=n;n._stack=[];n.init=function(e,t,r){function i(e,t){e[t]=function(){Granify._stack.push([t].concat(Array.prototype.slice.call(arguments,0)))}}var s=n;h=["on","identify","addTag","trackPageView","trackCart","trackOrder"];for(a=0;a<h.length;a++)i(s,h[a])};n.init();var f,l,c,p=document.createElement("iframe");p.src="javascript:false";p.title="";p.role="presentation";(p.frameElement||p).style.cssText="width: 0 !important; height: 0 !important; border: 0 !important; overflow: hidden !important; position: absolute !important; top: -1000px !important; left: -1000px !important;";c=document.getElementsByTagName("script");c=c[c.length-1];c.parentNode.insertBefore(p,c);try{l=p.contentWindow.document}catch(a){f=document.domain;p.src="javascript:var d=document.open();d.domain=\'"+f+"\';void(0);";l=p.contentWindow.document}l.open()._l=function(){var t=this.createElement("script");if(f)this.domain=f;t.id="js-iframe-async";t.src=e;this.body.appendChild(t)};l.write(\'<body onload="document._l();">\');l.close()})("//cdn.granify.com/assets/javascript.js",GRANIFY_SITE_ID,[])\n\t\t</script>\n\t\t\t\t<script type="text/javascript">\n\t\t\tGranify.trackPageView({\n\t\t\t page_type: "product"\n\t\t\t});\n\t\t</script>\n\t\t<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />\n<link rel="shortcut icon" href="//d1ldz4te4covpm.cloudfront.net/misc/favicon.ico" type="image/x-icon" />\n<meta name="description" content="Leverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions" />\n<meta name="revisit-after" content="1 day" />\n\t\t<link rel="canonical" href="www.packtpub.com/application-development/python-business-intelligence-cookbook" />\n\t\t\t\t<meta http-equiv="X-UA-Compatible" content="IE=edge" />\n\t\t<meta id="viewport" name="viewport" content="width=320, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">\n\t\t<!-- <link href="//fonts.googleapis.com/css?family=Ubuntu:300,400,500,700,300italic,400italic,500italic,700italic" rel="stylesheet" type="text/css">-->\n\t\t <link href="/sites/all/themes/packt_v4/fonts/ubuntu.css" rel="stylesheet" type="text/css">\n\t\t<!--[if lt IE 10]>\n\t\t\t<link href="/sites/all/themes/packt_v4/css/core/packtpub_ie.css" rel="stylesheet" type="text/css">\n\t\t\t<![endif]-->\n\t\t\t<link type="text/css" rel="stylesheet" media="all" href="/sites/default/files/css/14531254790af9a780/6d76251933f115761f7b3782916f72ad.css" />\n<link type="text/css" rel="stylesheet" media="print" href="/sites/default/files/css/14531254790af9a780/6e295a6eb8f64cef4e07d9b1f02d46e8.css" />\n \n\t\t\t<script type="text/javascript" src="/sites/default/files/js/145312547998c14ffa/8420d359404024567b5aefda1231af24.js"></script>\n<script type="text/javascript">\n<!--//--><![CDATA[//><!--\njQuery.extend(Drupal.settings, { "basePath": "\\u002F", "dhtmlMenu": [ "doubleclick", "clone" ] });\n//--><!]]>\n</script>\n\t\t\t<script type="text/javascript">\n\t\t\t\tvar Packt = Packt || {}; Packt.user = {"cart":[],"newsletters":[],"country_code":"US","selected_currency":"USD","currency":"USD","currency_symbol":"$","uid":0};\n\t\t\t</script>\n\t\t\t<link rel="alternate" type="application/rss+xml" href="/rss.xml" title="Packt Publishing News" >\n\t\t\t<script>\n\t\t\t\t(function(i,s,o,g,r,a,m){i["GoogleAnalyticsObject"]=r;i[r]=i[r]||function(){\n\t\t\t\t\t(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\n\t\t\t\t\tm=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\n\t\t\t\t})(window,document,"script","//www.google-analytics.com/analytics.js","ga");\n\t\t\t\tga("create", "UA-284627-1", "packtpub.com", {"siteSpeedSampleRate": 100});\n\t\t\t\tga("require", "displayfeatures");\n\t\t\t\tga(\'require\', \'ec\');\n\t\t\t\tga("send", "pageview");\n\t\t\t\t\t\t\t\t//ga("require", "ecommerce", "ecommerce.js");\n\n\t\t\t\t\n\t\t\t</script>\n\t</head>\n\t\n\t<body id="ppv4" class="with-logo">\n\t\t<noscript><iframe src="//www.googletagmanager.com/ns.html?id=GTM-NJWZFW"\n\t\t\theight="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>\n\t\t\t<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({\'gtm.start\':\n\t\t\t\tnew Date().getTime(),event:\'gtm.js\'});var f=d.getElementsByTagName(s)[0],\n\t\t\tj=d.createElement(s),dl=l!=\'dataLayer\'?\'&l=\'+l:\'\';j.async=true;j.src=\n\t\t\t\'//www.googletagmanager.com/gtm.js?id=\'+i+dl;f.parentNode.insertBefore(j,f);\n\t\t})(window,document,\'script\',\'dataLayer\',\'GTM-NJWZFW\');Packt.dataLayer.init();</script>\n\n\t\t<div id="page" class="" checkout="">\n\t\t\t<div id="page-header">\n\t\t\t\t\t\t\t<div id="account-bar" class="cf">\n\t\t\t\t<div class="section-inner">\n\t\t\t\t\t<div id="account-bar-status" class="cf">\n\t\t\t\t\t\t<div id="account-bar-currency-selector">\n\t\t\t\t\t\t\t<form accept-charset="UTF-8" method="post" id="packt-currency-select-form" class="float-left">\n\t\t\t\t\t\t\t\t<div class="form-item" id="edit-currency-wrapper">\n\t\t\t\t\t\t\t\t\t<select name="currency" class="form-select packt-currency-select-box selectBox" id="edit-currency" style="display:none">\n\t\t\t\t\t\t\t\t\t\t<option value="GBP" >GBP £</option>\n\t\t\t\t\t\t\t\t\t\t<option value="USD" >US $</option>\n\t\t\t\t\t\t\t\t\t\t<option value="EUR" >EUR €</option>\n\t\t\t\t\t\t\t\t\t\t<option value="AUD" >AU $</option>\n\t\t\t\t\t\t\t\t\t</select>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<input type="submit" name="op" value="" style="display: none;" class="form-submit">\t\t\t\n\t\t\t\t\t\t\t\t<input type="hidden" name="form_id" id="edit-packt-currency-select" value="packt_currency_select_form">\n\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t</div>\t\t\t\t\n\t\t\t\t\t\t<div class="account-bar-divider float-left">|</div>\t\t\n\t\t\t\t\t\t<div id="account-bar-status-security"></div>\n\t\t\t\t\t\t<noscript>\n\t\t\t\t\t\t\t<div id="account-bar-login-register-ns">\n\t\t\t\t\t\t\t\t<a href="/account">My Account</a>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</noscript>\n\t\t\t\t\t\t<div id="account-bar-login-register">\n\t\t\t\t\t\t\t<a href="#" class="login-popup"><div class="float-left">Log in</div></a>\n\t\t\t\t\t\t\t<div class="account-bar-divider float-left">|</div>\t\n\t\t\t\t\t\t\t<a href="/register"><div class="float-left">Register</div></a>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div id="account-bar-logged-in">\n\t\t\t\t\t\t\t<a href="/account">\n\t\t\t\t\t\t\t\t<div class="float-left"><strong>My Account</strong></div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<div class="account-bar-divider float-left">|</div>\t\n\t\t\t\t\t\t\t<a href="/logout"><div class="float-left">Sign out</div></a>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div id="account-bar-form">\n\t\t\t\t\t\t<div id="account-bar-form-login" class="cf">\n\t\t\t\t\t\t\t<div class="account-bar-form-left">\n\t\t\t\t\t\t\t\t<h4>Log in to your account</h4>\n\t\t\t\t\t\t\t\t<form accept-charset="UTF-8" method="post" id="packt-user-login-form">\n<div><div id="login-form" class="cf">\n\t<div id="login-form-email">\n\t\t<div class="form-item" id="email-wrapper">\n <input type="text" maxlength="128" name="email" id="email" size="24" value="" placeholder="E-mail address" class="form-text required" />\n</div>\n\t</div>\n\t<div id="login-form-pass">\n\t\t<div class="form-item" id="password-wrapper">\n <input type="password" name="password" id="password" maxlength="128" size="24" placeholder="Password" class="form-text required" />\n</div>\n\t</div>\n\t<div id="login-form-submit">\n\t\t<input type="submit" name="op" id="edit-submit-1" value="Login" class=" form-submit" />\n\t</div>\n\t<br />\n</div>\n<a href="https://www.packtpub.com/account/password">Forgotten your password?</a>\n\n\n\n<input type="hidden" name="form_build_id" id="form-a09234e2aa0ec1acd583e3aa6707d2e3" value="form-a09234e2aa0ec1acd583e3aa6707d2e3" />\n\n<input type="hidden" name="form_id" id="edit-packt-user-login-form" value="packt_user_login_form" />\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n</div></form>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t<div class="account-bar-form-right">\n\t\t\t\t\t\t\t\t<h4>Not yet a member?</h4>\n\t\t\t\t\t\t\t\t<p>Register for an account and access leading-edge content on emerging technologies.</p>\n\t\t\t\t\t\t\t\t<p><a class="account-bar-toggle register" href="/register">Register now</a></p>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\t\t\t\t\t\t\n\t\t\t\t\t\t<div id="account-bar-form-close"><a href="#">Close</a></div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<div id="menu-bar">\n\t\t\t\t<div class="section-inner cf">\n\t\t\t\t\t<div id="menuIcon"></div>\n\t\t\t\t\t<div id="menu-links" class="">\n\t\t\t\t\t\t<a href="/">\n\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t<div class="menu-item-text dummy" id="menu-packt-logo">\n\t\t\t\t\t\t\t\t\t<span class="alt">Packt Logo</span>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<a href="/all">\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-text" id="menu-books">\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text">Books & Videos</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<a href="/books/content/blogs">\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-text" id="menu-blog">\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text">Blog</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<a href="/books/info/packt/about">\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-text" id="menu-packt">\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text">Packt</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<a href="/books/content/support">\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-text" id="menu-support">\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text">Support</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<a href="/packtlib">\n\t\t\t\t\t\t\t<div class="menu-item-tab menu-item-tab pl-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-text" id="menu-packtlib">\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text pl"><img id="pl-img" src="//dz13w8afd47il.cloudfront.net/sites/all/themes/packt_v4/images/packtlib-logo-dark.png"></span>\n\t\t\t\t\t\t\t\t\t\t<span class="menu-text mob-pl"><img id="pl-img" src="//dz13w8afd47il.cloudfront.net/sites/all/themes/packt_v4/images/packtlib-logo-light.png"></span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t<div id="menu-icons" class="">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<a href="#">\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-icon" id="menu-search">\n\t\t\t\t\t\t\t\t\t\t<span class="alt">Search</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<a href="/collection">\n\t\t\t\t\t\t\t\t<div class="menu-item-tab">\n\t\t\t\t\t\t\t\t\t<div class="menu-item-icon dummy" id="menu-collection">\n\t\t\t\t\t\t\t\t\t\t<span class="alt">My Collection</span>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href="https://www.packtpub.com/cart/checkout">\n\t\t\t\t\t\t\t<div class="menu-item-tab last">\n\t\t\t\t\t\t\t\t<div class="menu-item-icon" id="menu-cart">\n\t\t\t\t\t\t\t\t\t<div id="cart-icon-count" class="cart-icon-count"></div>\n\t\t\t\t\t\t\t\t\t<span class="alt">Cart</span>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</a>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t\n\t\t\t<div id="menu-bar-popup" class="cf">\t\n\t\t\t\t<div id="menu-bar-popup-inner" class="cf"></div>\t\n\t\t\t\t<div class="section-inner cf">\t\n\n\t\t\t\t\t\t\t\t\t\t\t<div class="menu-bar-popup-menu threecol cf" id="menu-books-popup">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left threecol">\n\t\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">Book & Video Categories</p>\n\t\t\t\t\t\t\t\t\t<div id="books-menu">\n\t\t\t\t\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\'books-menu-column categories \'><div class=\'inner\'><p><a href="/web-development">Web Development</a></p><p><a href="/big-data-and-business-intelligence">Big Data & Business Intelligence</a></p><p><a href="/application-development">Application Development</a></p><p><a href="/virtualization-and-cloud">Virtualization & Cloud</a></p></div></div><div class=\'books-menu-column categories \'><div class=\'inner\'><p><a href="/game-development">Game Development</a></p><p><a href="/networking-and-servers">Networking & Servers</a></p><p><a href="/hardware-and-creative">Hardware & Creative</a></p><p><a href="/business">Business</a></p></div></div><div class=\'books-menu-column categories last\'><div class=\'inner\'><p><a href="/all">All Books</a></p><p><a href="/video">All Videos</a></p><p><a href="/latest-releases">Latest Releases</a></p></div></div>\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="menu-bar-popup-section-right threecol">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="menu-bar-popup-section-right-inner cf">\n\t\t\t\t\t\t\t\t\t<div id="deal-of-the-day-banner" class="cf">\n\t\t\t\t\t\t\t\t\t\t<div id="menu-bar-dotd-preview-thumb">\n\t\t\t\t\t\t\t\t\t\t\t<a href="/books/deal-of-the-day">\n\t\t\t\t\t\t\t\t\t\t\t\t<img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookretailers/9781784397982.jpg" alt="Go for Web Development [Video]" title="" width="150" height="185" class="lazyload-disabled imagecache imagecache-featured_book_block"/>\t\t\t\t\t\t\t\t\t\t\t\t<div class="menu-bar-dotd-percentage">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="menu-bar-dotd-percentage-text">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t80<sup class="dotd-sup">%</sup><div class="dotd-sub">off</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<div id="menu-bar-dotd-preview-text">\n\t\t\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title"><a href="/books/deal-of-the-day">Deal of the Day</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p>Find out how Go makes web development fast and enjoyable by developing a full stack web project</p>\n\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="cf deal-of-the-day-in-header">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class="dots-main-book-price float-left">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-top-pricing-main-price">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-top-pricing-main-ebook-price ">$15.00</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="dotd-rrp-price">RRP $74.99</div>\n\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t\t\t\t\t\t\t<form action="/add_to_cart/24227" accept-charset="UTF-8" method="post" id="packt-libraries-add-to-cart-form" class="packt-libraries-add-to-cart-form">\n<div>\n<div class="book-top-addtocart-inner">\t\n\t<div class="book-top-addtocart-logo"></div>\n\t<div class="book-top-addtocart-separator"></div>\n\t\n\t<input type="submit" name="submit-24227" id="submit-24227" value="Add to Cart" class=" form-submit" />\n\t<input type="hidden" name="nids" id="nids" value="24227" />\n\n<input type="hidden" name="qtys" id="qtys" value="1" />\n\n<input type="hidden" name="upsell" id="edit-upsell" value="1" />\n\n\n\n\n\n\n<input type="hidden" name="form_build_id" id="form-6e5ecfb7acb7b981374c0fa1748e7c60" value="form-6e5ecfb7acb7b981374c0fa1748e7c60" />\n\n<input type="hidden" name="form_id" id="edit-packt-libraries-add-to-cart-form" value="packt_libraries_add_to_cart_form" />\n\n\n\n\n\n\n\n\n\n\n\n\n</div>\n\n</div></form>\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<div class="cf newsletter-signup-form" newsletter_id=280>\n\t\t\t\t\t\t\t\t\t\t\t<div class="dotd-signup-text"><strong>Sign up here to get these deals straight to your inbox</strong></div> \n\t\t\t\t\t\t\t\t\t\t\t<form accept-charset="UTF-8" method="post" id="packt-v3-subscribtion-dotd-form">\n<div><div class="form-item">\n \n</div>\n<div class="form-item" id="edit-mail-wrapper">\n <input type="text" maxlength="128" name="mail" id="edit-mail" size="60" value="" placeholder="Enter your email address" class="form-text" />\n</div>\n<input type="hidden" name="newsletter_id" id="edit-newsletter-id" value="" />\n<input type="submit" name="op" id="edit-submit-3" value="Submit" class=" form-submit" />\n<input type="hidden" name="form_build_id" id="form-9f18f2384ef69daebdd70a8c10b36929" value="form-9f18f2384ef69daebdd70a8c10b36929" />\n<input type="hidden" name="form_id" id="edit-packt-v3-subscribtion-dotd-form" value="packt_v3_subscribtion_dotd_form" />\n\n</div></form>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t<div class="menu-bar-popup-menu twocol cf" id="menu-blog-popup">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left twocol">\n\t\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">Blog</p>\n\t\t\t\t\t\t\t\t\t<div class="packt-menu cf">\n\t\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/blogs">Blogs</a></p>\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/tech-hub">Tech Hub</a></p>\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/article-network">Articles</a></p>\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-right twocol">\n\t\t\t\t\t\t\t\t<div class="menu-bar-popup-section-right-inner cf">\n\t\t\t\t\t\t\t\t\t<div id="menu-bar-article-preview-thumb">\n\t\t\t\t\t\t\t\t\t\t<img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" alt="Firebase and React" title="" width="240" height="114" class="lazyload-disabled imagecache imagecache-ppv4_header_article_thumb"/>\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t<div id="menu-bar-article-preview-text">\n\t\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title"><a href="/books/content/firebase-and-react">Firebase and React</a></p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-article-one-liner">In this post we will explore creating a React application with a Firebase backend. We will take a look at how we can use Firebase as a Flux store to drive our UI.</p>\n\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/blogs">Read all our blogs</a></p>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\n\n\t\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-packt-popup">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left twocol">\n\t\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">Packt Publishing</p>\n\t\t\t\t\t\t\t\t\t<div class="packt-menu cf">\n\t\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/about">About Us</a></p>\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/authors">Our Authors</a></p>\n\t\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/trade-partners">Trade & Partners</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<!--<p><a href="/blog-network">Blog</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/techprimer-network">Technology Primers</a></p>-->\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/contact-us">Contact Us</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/careers-with-packt">Careers</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<!--<p><a href="/article-network">Articles</a></p>-->\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\t\t\t\t\t\t\n\t\t\t\t\t\t<!--<div class="menu-bar-popup-section-right twocol">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-right-inner cf">\n\t\t\t\t\t\t\t\t<div id="menu-bar-article-preview-thumb">\n\t\t\t\t\t\t\t\t\t<noscript><img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" alt="Firebase and React" title="" width="240" height="114" class=" imagecache imagecache-ppv4_header_article_thumb"/></noscript><img src="/sites/default/files/blank.gif" alt="Firebase and React" title="" width="240" height="114" data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" class=" imagecache imagecache-ppv4_header_article_thumb"/>\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div id="menu-bar-article-preview-text">\n\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title"><a href="/books/content/firebase-and-react">Firebase and React</a></p>\n\t\t\t\t\t\t\t\t\t<p id="menu-bar-article-one-liner"></p>\n\t\t\t\t\t\t\t\t\t<p><a href="/articles">Read all our articles</a></p>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>-->\n\t\t\t\t\t</div>\n\n\n\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-support-popup">\n\t\t\t\t\t\t<div class="menu-bar-popup-section-left twocol">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">Support</p>\n\t\t\t\t\t\t\t\t<div class="packt-menu cf">\n\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/faq">FAQs</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/ordering">Ordering Information</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/info/packt/terms-and-conditions">Terms & Conditions</a></p>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/support">Code Downloads & Errata</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/content/errata">Submit Errata</a></p>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\t\t\t\t\t\t\t\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\n\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-packtlib-popup">\n\t\t\t\t\t\t<div class="menu-bar-popup-section-left twocol">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">PacktLib</p>\n\t\t\t\t\t\t\t\t<div class="packt-menu cf">\n\t\t\t\t\t\t\t\t\t<div class="books-menu-column">\n\t\t\t\t\t\t\t\t\t\t<div class="inner">\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/subscription/packtlib">Subscribe</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/books/subscription/packtlib-business">PacktLib For Business</a></p>\n\t\t\t\t\t\t\t\t\t\t\t<p><a href="/packtlib">Take me to the Library</a></p>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\n\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-search-popup">\n\t\t\t\t\t\t<div class="menu-bar-popup-search-inner">\n\t\t\t\t\t\t\t<form accept-charset="UTF-8" method="post" id="packt-libraries-main-search-form">\n<div>\n<div id="menu-bar-search" class="cf">\n\t<div id="menu-bar-search-title">\n\t\t<div class="form-item">Search</div>\n\t</div>\n\t<div id="menu-bar-search-box">\n\t\t<div class="form-item" id="main-search-keys-wrapper">\n <input type="text" name="keys" id="main-search-keys" size="49" value="" placeholder="Enter your search terms..." class="form-text" />\n</div>\n\t</div>\n\t<div id="menu-bar-search-button">\n\t\t<input type="submit" name="op" id="edit-submit-5" value="Search" class=" form-submit" />\n\t</div>\n\t<input type="hidden" name="sort" id="edit-sort" value="0" />\n\n<input type="hidden" name="types" id="edit-types" value="0" />\n\n<input type="hidden" name="forthcoming" id="edit-forthcoming" value="1" />\n\n<input type="hidden" name="available" id="edit-available" value="1" />\n\n<input type="hidden" name="count" id="edit-count" value="20" />\n\n\n\n\n<input type="hidden" name="form_build_id" id="form-2d8e0f533354c27ad949d7cc2a8cfbb5" value="form-2d8e0f533354c27ad949d7cc2a8cfbb5" />\n\n<input type="hidden" name="form_id" id="edit-packt-libraries-main-search-form" value="packt_libraries_main_search_form" />\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n</div>\n<div class="facet-search-cross facet-search-cross-autocomplete"></div>\n</div></form>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t\n\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-cart-popup">\n\t\t\t\t\t\t<div class="menu-bar-popup-section-left even">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-left-inner cf">\n\t\t\t\t\t\t\t\t<div id="menu-bar-popup-cart-preview">\n\t\t\t\t\t\t\t\t\t<div id="menu-bar-popup-cart-item-preview">\n\n\t\t\t\t\t\t\t\t\t\t<div id="menu-bar-popup-cart-item-preview-image">\n\t\t\t\t\t\t\t\t\t\t\t<img src="" />\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<p class="menu-bar-popup-title">Added to Cart</p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-cart-item-preview-title"></p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-cart-item-preview-oneliner"></p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-cart-item-preview-additional">...and <span></span> more</p>\n\t\t\t\t\t\t\t\t\t\t<p class="price"><span id="menu-bar-popup-cart-item-preview-currency"></span><span id="menu-bar-popup-cart-item-preview-price"></span></p>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<p id="menu-bar-popup-cart-empty-preview">\n\t\t\t\t\t\t\t\t\tYou don\'t have anything in your cart right now.\n\t\t\t\t\t\t\t\t</p>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div class="menu-bar-popup-section-right even">\n\t\t\t\t\t\t\t<div class="menu-bar-popup-section-right-inner cf">\n\t\t\t\t\t\t\t\t<div id="menu-bar-popup-content">\n\t\t\t\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-subtotal-title" class="menu-bar-popup-title float-left">Subtotal</p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-subtotal-value" class="menu-bar-popup-title float-right price"> 0.00</p>\n\t\t\t\t\t\t\t\t\t\t<p id="menu-bar-popup-subtotal-currency" class="menu-bar-popup-title float-right price"></p>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t<p><strong>Free shipping</strong> on print orders for US, UK, Europe and selected Asian countries</p>\n\t\t\t\t\t\t\t\t\t<form>\n\t\t\t\t\t\t\t\t\t\t<a href="https://www.packtpub.com/cart/checkout" class="button-link grey">View Cart</a>\n\t\t\t\t\t\t\t\t\t\t<span></span>\n\t\t\t\t\t\t\t\t\t\t<a href="https://www.packtpub.com/cart/checkout/?checkout_step=payment" class="button-link">Check Out</a>\n\t\t\t\t\t\t\t\t\t</form>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div id="checkout-close" onclick="Packt.headerMenu.hideMenuPopup()"></div>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="menu-bar-popup-menu cf" id="menu-cart-small">\n\t\t\t\t\t\t<div>\n\t\t\t\t\t\t\t<div class="small-popup-outer float-right">\n\t\t\t\t\t\t\t\t<div class="small-popup-tick">\n\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="small-popup-text">\n\t\t\t\t\t\t\t\t\t<strong>\n\t\t\t\t\t\t\t\t\t\tTitle added to cart\n\t\t\t\t\t\t\t\t\t</strong>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="small-popup-seperator">\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="small-popup-arrows">\n \n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t<div id="menu-bar-popup-inner-bottom" class="cf"></div>\n\t\t</div>\n\t\t\t</div>\n\t\t\t\t\t\t<div id="main-container" class="not-front not-logged-in page-node node-type-books no-sidebars page-application-development-python-business-intelligence-cookbook section-application-development node-full-view ">\n\t\t\t\t<div id="main" class="">\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t <!-- #content -->\n\t\t\t\t\t \t<div id="content">\n\t\t\t\t\t\t \t\t\t\t\t\t\t \t\n\t\t\t\t\t \t\t\t\t\t\t\t \t\t\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t \t\t\t<div class="section-inner cf">\n\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t<div id="messages-container">\n\t\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\t</div>\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t \t\t\t</div>\n\t\t\t\t\t\t \t\t\t\t\t\t\t \t\t\n\t\t\t\t\t \t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<a name="main-content" id="main-content"></a>\n\t\t\t\t\t\t\t\n<div id="main-book" class="cf" itemscope itemtype="http://schema.org/Book">\n\t<div class="book-top-block-wrapper cf">\n\t\t<div class="book-top-block cf section-inner">\n\t\n\t<div id="mobile-book-info" class="onlyMobile">\n\t\t<div class="book-top-block-info-title float-left">\n\t\t\t<h1 itemprop="name">Python Business Intelligence Cookbook</h1>\n\t\t</div>\n\t\t<div class="book-top-block-info-one-liner cf">\n\t\t\tLeverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions\t\t</div>\n\t</div>\n\n\t<div id="mobile-book-container">\n\n\t\t<div class="book-top-block-image left">\n\t\t\t<div class="product-image">\n\t\t\t\t<span itemprop="image" itemtype="http://schema.org/URL" itemscope>\n\t\t\t\t\t<a class="fancybox" href="/sites/default/files/7466OS_4786_Python Business Intelligence Cookbook.jpg">\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t<img src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/ppv4_main_book_cover/7466OS_4786_Python Business Intelligence Cookbook.jpg" class="bookimage" />\n\t\t\t\t\t</a>\n\t\t\t\t</span>\n\t\t\t\t\t\t\t</div>\n\t\t\t\n<div class="share-buttons-line share-buttons-small">\n\t<div class="share-icon-background">\n\t\t<a class="share-link" target="_blank" href="http://www.linkedin.com/shareArticle?mini=true&url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook&title=Python+Business+Intelligence+Cookbook&source=Packt+Publishing&summary=Python+Business+Intelligence+Cookbook">\n\t\t\t<div class="share-icon linkedin"></div>\n\t\t</a>\n\t</div>\n\t<div class="share-icon-background">\n\t\t<a class="share-link" target="_blank" href="https://www.twitter.com/share?url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook&text=Python Business Intelligence Cookbook">\n\t\t\t<div class="share-icon twitter"></div>\n\t\t</a>\n\t</div>\n\t<div class="share-icon-background">\n\t\t<a class="share-link" target="_blank" href="http://www.facebook.com/sharer.php?u=https://www.packtpub.com/application-development/python-business-intelligence-cookbook">\n\t\t\t<div class="share-icon facebook"></div>\n\t\t</a>\n\t</div>\n\t<div class="share-icon-background last">\n\t\t<a class="share-link" target="_blank" href="https://plusone.google.com/_/+1/confirm?hl=en&url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook">\n\t\t\t<div class="share-icon google-plus"></div>\n\t\t</a>\n\t</div>\n</div>\t\t</div>\n\t\t<div class="book-top-block-info left">\n\t\t\t<div class="book-top-block-info-title float-left">\n\t\t\t\t<h1 itemprop="name">Python Business Intelligence Cookbook</h1>\n\t\t\t</div>\n\t\t\t<div class="book-top-block-info-level show-level-info cf float-right">\n\t\t\t\t<div class="book-level-information float-right"></div>\n\t\t\t\t<div class="book-level-text-info float-right">\n\t\t\t\t\tCookbook\t\t\t\t</div>\n\t\t\t\t<div class="book-level-2 float-right"></div>\n\t\t\t\t\n\t\t\t</div>\n\t\t\t<div class="book-top-block-info-anl">\n\t\t\t\t<div class="book-top-block-info-authors left">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tRobert Dempsey<br />\n\t\t\t\t\t\t\t\t\t\t<time itemprop="datePublished" datetime="2015-12-22">December 2015</time><br />\n\t\t\t\t\t\t\t\t\t\t<div class="book-top-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<!--div class="book-top-block-info-level show-level-info float-right"-->\n\t\t\t\t\t\t\t\t\t<!--/div-->\n\t\t\t</div>\n\t\t\t<div class="book-top-block-info-one-liner cf">\n\t\t\t\tLeverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions\t\t\t</div>\n\t\t\t\t\t\t\t\n\n\t\t\t\n<div class="book-top-pricing-block" itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t<meta itemprop="priceCurrency" content="USD"/>\n\t<div class="book-top-pricing-price">\n\t\t<div class="book-top-pricing-main-price">\n\t\t\t\t\t\t\t<meta itemprop="price" content="31.99"/>\n\t\t\t\t<div class="book-top-pricing-main-ebook-price ">\n\t\t\t\t\t$31.99\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<div class="book-top-pricing-main-book-price ">\n\t\t\t\t\t$39.99\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t<div class="book-top-pricing-rrp">\n\t\t\t\t\t\t\t<div class="book-top-pricing-rrp-ebook">\n\t\t\t\t\tRRP $31.99\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t<div class="book-top-pricing-rrp-book">\n\t\t\t\t\tRRP $39.99\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t</div>\n\t\n\t\t\t<div class="book-top-type-selection">\n\t\t\t<div class="book-type-select-ebook" type="ebooks">\n\t\t\t\t<div class="book-type-select-dot-outer active-checkbox">\n\t\t\t\t\t<div class="book-type-select-dot-inner">\n\t\t\t\t\t\t<div class="book-type-select-dot-inner-active"></div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<span itemprop="itemOffered">eBook</span>\n\t\t\t</div>\n\t\t\t\t\t\t\t<div class="book-type-select-print book-type-disabled" type="books">\n\t\t\t\t\t<div class="book-type-select-dot-outer">\n\t\t\t\t\t\t<div class="book-type-select-dot-inner">\n\t\t\t\t\t\t\t<div class="book-type-select-dot-inner-active"></div>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\tPrint + eBook\n\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\n</div>\n\n\t<span itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t<meta itemprop="itemOffered" content="Print + eBook" />\n\t\t<meta itemprop="price" content="39.99" />\n\t\t<meta itemprop="priceCurrency" content="USD" />\n\t</span>\n\t\t\n\t\t</div>\n\n\t</div>\n\t\n\t\t<div class="book-top-addtocart">\n\t\t\t\t\t\t<div class="digital-product " data-product="true" data-product-id="23147" data-product-price="31.99" data-product-title="Python Business Intelligence Cookbook" data-product-type="ebooks" data-product-brand="Packt Publishing" data-product-category="Application Development">\n\t\t\t\t<form action="/add_to_cart/23147" accept-charset="UTF-8" method="post" id="packt-libraries-add-to-cart-form-ebook" class="packt-libraries-add-to-cart-form">\n<div>\n<div class="book-top-addtocart-inner">\t\n\t<div class="book-top-addtocart-logo"></div>\n\t<div class="book-top-addtocart-separator"></div>\n\t\n\t<input type="submit" name="submit-23147" id="submit-23147" value="Add to Cart" class=" form-submit" />\n\t<input type="hidden" name="nids" id="nids" value="23147" />\n\n<input type="hidden" name="qtys" id="qtys" value="1" />\n\n<input type="hidden" name="upsell" id="edit-upsell" value="1" />\n\n\n\n\n\n\n<input type="hidden" name="form_build_id" id="form-f235656557ac54b19453abdfe4d584ec" value="form-f235656557ac54b19453abdfe4d584ec" />\n\n<input type="hidden" name="form_id" id="edit-packt-libraries-add-to-cart-form-ebook" value="packt_libraries_add_to_cart_form_ebook" />\n\n\n\n\n\n\n\n\n\n\n\n\n</div>\n\n</div></form>\n\t\t\t</div>\n\t\t\t\t\t\t\t<div class="physical-product" data-product="true" data-product-id="23148" data-product-price="39.99" data-product-title="Python Business Intelligence Cookbook" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Application Development">\n\t\t\t\t<form action="/add_to_cart/23148/23147" accept-charset="UTF-8" method="post" id="packt-libraries-add-to-cart-form-ebook-1" class="packt-libraries-add-to-cart-form">\n<div>\n<div class="book-top-addtocart-inner">\t\n\t<div class="book-top-addtocart-logo"></div>\n\t<div class="book-top-addtocart-separator"></div>\n\t\n\t<input type="submit" name="submit-23148,23147" id="submit-23148,23147" value="Add to Cart" class=" form-submit" />\n\t<input type="hidden" name="nids" id="nids" value="23148,23147" />\n\n<input type="hidden" name="qtys" id="qtys" value="1,1" />\n\n<input type="hidden" name="upsell" id="edit-upsell-1" value="1" />\n\n\n\n\n\n\n<input type="hidden" name="form_build_id" id="form-5859f85d4eec3464daee27f432f766cc" value="form-5859f85d4eec3464daee27f432f766cc" />\n\n<input type="hidden" name="form_id" id="edit-packt-libraries-add-to-cart-form-ebook-1" value="packt_libraries_add_to_cart_form_ebook" />\n\n\n\n\n\n\n\n\n\n\n\n\n</div>\n\n</div></form>\n\t\t\t</div>\n\t\t\t\t</div>\n\t\n\t\t\n\t\t\t<div class="book-top-subscribe cf" itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t<meta itemprop="price" content="12.99" />\n\t\t<meta itemprop="priceCurrency" content="USD" />\n\t\t<div class="book-top-subscribe-upsell">\n\t\t\t<div class="book-top-subscribe-price-block cf">\n\t\t\t\t<div style="margin-top: 8px;"><span style="color: #4ba8af; font-size: 14px;"><span style="font-size: 2em; font-weight: 500;">$12.99</span> p/month</span></div>\t\t\t</div>\n\t\t\t<a id="subscription-upsell-button" href="/books/subscription/packtlib?=pp">\n\t\t\t\t<div class="book-top-subscribe-subscribe-button">\n\t\t\t\t\t<div class="book-top-subscribe-logo"><img src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/pl-logo.png" class="bookimage" /></div>\n\t\t\t\t\t<div class="book-top-subscribe-separator"></div>\n\t\t\t\t\t<div class="book-top-subscribe-text">\n\t\t\t\t\t\t<p style="color: #fff;">Get Access</p>\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</a>\n\t\t</div>\n\t\t<div class="book-top-subscribe-blurb">\n\t\t\t<h4 style="color: #333a40; font-size: 18.2000007629395px; font-family: Ubuntu, sans-serif;">Get <span style="font-weight: bold;">Unlimited Access</span> to every Packt eBook and Video course</h4>\t\t\t<div class="book-top-subscribe-blurb-text">\n\t\t\t\t<p><span style="font-size: 14px; font-family: Ubuntu, sans-serif; background-color: #eaeceb;">Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.</span></p>\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\n</div>\n\t</div>\n\n\t<div class="book-interaction-wrapper cf">\n\t\t<div class="section-inner book-interaction-inner">\n\t\t\t\n<div class="book-top-block-code book-button float-right ">\n\t\t\t<a href="/lcode_download/23148">\n\t\t\t\t<div class="book-top-block-code-button logged-in">\n\t\t\t<div class="book-top-block-code-logo"></div>\n\t\t\t<div class="book-top-block-code-text">\n\t\t\t\tCode Files\n\t\t\t</div>\n\t\t</div>\n\t\t</a>\n\t</div>\n\n<div class="book-top-block-collect book-button float-right booknotowned">\n\t<div class="book-top-block-collect-button not-in-collection" nid="23148" title="Python Business Intelligence Cookbook">\n\t\t<div class="book-top-block-collect-logo">\n\t\t</div>\n\t\t<div class="book-top-block-collect-text">\n\t\t\t+ Collection\t\t</div>\n\t</div>\n</div>\n<div class="book-top-block-readonline book-button float-right buttons-free-sample booknotowned ">\n\t<div class="book-top-block-readonline-button showPacktLibReaderNewWindow" \n\t\tnid="23148" \n\t\tcategory="Application Development" \n\t\tisbn="9781785287466" \n\t\ttype="book">\n\t\t<div class="book-top-block-readonline-logo "></div>\n\t\t<div class="book-top-block-readonline-text">\n Free Sample\t\t</div>\n\t\t\n\t</div>\n</div>\n\t\t</div>\n\t</div>\n\t<div class="book-info-outer cf">\n\t\t<div class="book-info-wrapper cf section-inner">\n\n\t\t\t<div class="book-info-details onlyDesktop">\n\t\t\t\t<h2>Book Details</h2>\n\t\t\t\t<div class="book-info-details-text">\n\t\t\t\t\t<div class="book-info-isbn13">\n\t\t\t\t\t\t<span class="label">ISBN 13</span><span itemprop="isbn">9781785287466</span>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-info-nb-page">\n\t\t\t\t\t\t<span class="label">Paperback</span><span itemprop="numberOfPages">202</span> pages\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\n\t\t\t<div class="book-info-about-audience float-right">\n\t\t\t\t<div class=\'book-info-about book-page-content\'>\n\t\t\t\t\t\t<h2>About This Book</h2>\n\t\t\t\t\t\t<div class=\'book-info-about-text\' itemprop=\'about\'><ul>\n<li><span style="line-height: 20.4px; background-color: transparent;">Want to minimize risk and optimize profits of your business? Learn to create efficient analytical reports with ease using this highly practical, easy-to-follow guide</span></li>\n<li><span style="line-height: 20.4px; background-color: transparent;">Learn to apply Python for business intelligence tasks—preparing, exploring, analyzing, visualizing and reporting—in order to make more informed business decisions using data at hand</span></li>\n<li>Learn to explore and analyze business data, and build business intelligence dashboards with the help of various insightful recipes</li>\n</ul>\n\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\t\t\t\t<div class=\'book-info-audience book-page-content\'>\n\t\t\t\t\t\t\t<h2>Who This Book Is For</h2>\n\t\t\t\t\t\t\t<div class=\'book-info-audience-text\' itemprop=\'audience\' itemscope itemtype=\'http://schema.org/Audience\'>\n\t\t\t\t\t\t\t\t<div itemprop=\'audienceType\'><p><span id="audience_c" class="sugar_field">This book is intended for data analysts, managers, and executives with a basic knowledge of Python, who now want to use Python for their BI tasks. If you have a good knowledge and understanding of BI applications and have a “working” system in place, this book will enhance your toolbox.</span></p>\n</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</div>\t\t\t</div>\n\t\t</div>\n\t</div>\n\t<div class="book-info-outer second-level-info cf">\n\t\t<div class="book-info-bottom-wrapper section-inner cf">\n\t\t\t<div id="book-info-toc" class="float-left onlyDesktop">\n\t\t\t\t<h2>Table of Contents</h2>\n\t\t\t\t<div class="book-info-toc-text">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>1: Getting Set Up to Gain Business Intelligence\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Introduction</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Anaconda</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Learn about the Python libraries we will be using</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing, configuring, and running MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Rodeo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Starting Rodeo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Robomongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Using Robomongo to query MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Downloading the UK Road Safety Data dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>2: Making Your Data All It Can Be\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a CSV file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing an Excel file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a JSON file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a plain text file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Retrieving a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Retrieving multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Inserting a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Inserting multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Deleting a single record using pymongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Deleting multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a CSV file into a Pandas DataFrame</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Renaming column headers in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Filling in missing values in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing punctuation in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing whitespace in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing any string from within a string in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Merging two datasets in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Titlecasing anything</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Uppercasing a column in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating values in place in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Standardizing a Social Security number in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Standardizing dates in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Converting categories to numbers in Pandas for a speed boost</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>3: Learning What Your Data Truly Holds\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a MongoDB query</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a CSV file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from an Excel file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a JSON file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a data quality report</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for the entire dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for object type columns</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the mode of the entire dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting a count of unique values for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the minimum and maximum values of a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating quantiles for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the mean, median, mode, and range for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating a frequency table for a single column by date</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating a frequency table of two variables</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a histogram for a column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting the data as a probability distribution</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting a cumulative distribution function</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Showing the histogram as a stepped line</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting two sets of values in a probability distribution</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a customized box plot with whiskers</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a basic bar chart for a single column over time</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>4: Performing Data Analysis for Non Data Analysts\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a distribution analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing categorical variable analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a linear regression</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a time-series analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing outlier detection</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using logistic regression</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using a random forest</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using Support Vector Machines</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Saving a predictive model for production use</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>5: Building a Business Intelligence Dashboard Quickly\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating reports in Excel directly from a Pandas DataFrame</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating customizable Excel reports using XlsxWriter</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building a shareable dashboard using IPython Notebook and matplotlib</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to HTML</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to PDF</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to an HTML slideshow</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building your First Flask application in 10 minutes or less</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating and saving your plots for your Flask BI dashboard</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building a business intelligence dashboard in Flask</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter"></div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<div id="book-info-will-learn" class="float-right book-page-content">\n\t\t\t\t\t<h2>What You Will Learn</h2>\n\t\t\t\t\t<div class="book-info-will-learn-text">\n\t\t\t\t\t\t<ul>\n<li><span style="line-height: 20.4px; background-color: transparent;">Install Anaconda, MongoDB, and everything you need to get started with your data analysis</span></li>\n<li><span style="line-height: 20.4px; background-color: transparent;">Prepare data for analysis by querying cleaning and standardizing data</span></li>\n<li>Explore your data by creating a Pandas data frame from MongoDB</li>\n<li>Gain powerful insights, both statistical and predictive, to make informed business decisions</li>\n<li>Visualize your data by building dashboards and generating reports</li>\n<li>Create a complete data processing and business intelligence system</li>\n</ul>\n\n\t\t\t\t\t</div>\n\t\t\t\t</div>\t\t\t<div class="book-info-bottom-indetail book-page-content float-right">\n\t\t\t\t\t\t\t\t\t<h2>In Detail</h2>\n\t\t\t\t\t\t\t\t\t<div class="book-info-bottom-indetail-text" itemprop="description">\n\t\t\t\t\t\t\t\t\t\t<p><span id="description" class="sugar_field">The amount of data produced by businesses and devices is going nowhere but up. In this scenario, the major advantage of Python is that it\'s a general-purpose language and gives you a lot of flexibility in data structures. Python is an excellent tool for more specialized analysis tasks, and is powered with related libraries to process data streams, to visualize datasets, and to carry out scientific calculations. Using Python for business intelligence (BI) can help you solve tricky problems in one go.</span></p>\n<p><span id="description" class="sugar_field">Rather than spending day after day scouring Internet forums for “how-to” information, here you’ll find more than 60 recipes that take you through the entire process of creating actionable intelligence from your raw data, no matter what shape or form it’s in. Within the first 30 minutes of opening this book, you’ll learn how to use the latest in Python and NoSQL databases to glean insights from data just waiting to be exploited.</span></p>\n<p><span id="description" class="sugar_field">We’ll begin with a quick-fire introduction to Python for BI and show you what problems Python solves. From there, we move on to working with a predefined data set to extract data as per business requirements, using the Pandas library and MongoDB as our storage engine.</span></p>\n<p><span id="description" class="sugar_field">Next, we will analyze data and perform transformations for BI with Python. Through this, you will gather insightful data that will help you make informed decisions for your business. The final part of the book will show you the most important task of BI—visualizing data by building stunning dashboards using Matplotlib, PyTables, and iPython Notebook.</span></p>\n\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>\t\t\t<div class="book-info-bottom-author book-page-content float-right">\n\t\t\t\t\t<h2>Authors</h2>\n\t\t\t\t\t<div class="book-info-bottom-author-text">\n\t\t\t\t\t\t<div itemprop="author" itemscope itemtype="http://schema.org/Person">\n\t\t\t\t\t\t<div class="book-info-bottom-author-title" >\n\t\t\t\t\t\t\t<h3 itemprop="name">Robert Dempsey</h3>\n\t\t\t\t\t\t</div>\n\n\t\t\t\t\t\t<div class="book-info-bottom-author-body" itemprop="description">\n\t\t\t\t\t\t\t<p>Robert Dempsey is a tested leader and technology professional who specializes in delivering solutions and products to solve tough business challenges. His experience of forming and leading agile teams, combined with more than 16 years of technology experience, enables him to solve complex problems while always keeping the bottom line in mind.</p>\r\n<p>Robert has founded and built three start-ups in tech and marketing, developed and sold two online applications, consulted for Fortune 500 and Inc. 500 companies, and has spoken nationally and internationally on software development and agile project management.</p>\r\n<p>He\'s the founder of Data Wranglers DC, a group that is dedicated to improving the craft of data engineering, as well as a board member of Data Community DC.</p>\r\n<p>In addition to spending time with his growing family, Robert geeks out on Raspberry Pi, Arduinos, and automating more of his life through hardware and software.</p>\r\n<p>Find him on his website at <a href="http://robertwdempsey.com">http://robertwdempsey.com</a>.</p>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t</div> \n\t\t\t<div id="book-info-toc" class="float-left onlyMobile">\n\t\t\t\t<h2>Table of Contents</h2>\n\t\t\t\t<div class="book-info-toc-text">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>1: Getting Set Up to Gain Business Intelligence\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Introduction</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Anaconda</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Learn about the Python libraries we will be using</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing, configuring, and running MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Rodeo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Starting Rodeo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Installing Robomongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Using Robomongo to query MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Downloading the UK Road Safety Data dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>2: Making Your Data All It Can Be\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a CSV file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing an Excel file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a JSON file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a plain text file into MongoDB</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Retrieving a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Retrieving multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Inserting a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Inserting multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating a single record using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Deleting a single record using pymongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Deleting multiple records using PyMongo</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Importing a CSV file into a Pandas DataFrame</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Renaming column headers in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Filling in missing values in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing punctuation in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing whitespace in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Removing any string from within a string in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Merging two datasets in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Titlecasing anything</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Uppercasing a column in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Updating values in place in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Standardizing a Social Security number in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Standardizing dates in Pandas</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Converting categories to numbers in Pandas for a speed boost</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>3: Learning What Your Data Truly Holds\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a MongoDB query</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a CSV file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from an Excel file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a JSON file</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a data quality report</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for the entire dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for object type columns</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the mode of the entire dataset</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating summary statistics for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting a count of unique values for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the minimum and maximum values of a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating quantiles for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Getting the mean, median, mode, and range for a single column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating a frequency table for a single column by date</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Generating a frequency table of two variables</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a histogram for a column</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting the data as a probability distribution</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting a cumulative distribution function</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Showing the histogram as a stepped line</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Plotting two sets of values in a probability distribution</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a customized box plot with whiskers</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a basic bar chart for a single column over time</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>4: Performing Data Analysis for Non Data Analysts\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a distribution analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing categorical variable analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a linear regression</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing a time-series analysis</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Performing outlier detection</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using logistic regression</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using a random forest</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating a predictive model using Support Vector Machines</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Saving a predictive model for production use</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter">\n\t\t\t\t\t\t\t\t<div class="book-toc-chapter-title">\n\t\t\t\t\t\t\t\t\t<span class="chapter">Chapter </span>5: Building a Business Intelligence Dashboard Quickly\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class="book-toc-sections-wrapper">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating reports in Excel directly from a Pandas DataFrame</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating customizable Excel reports using XlsxWriter</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building a shareable dashboard using IPython Notebook and matplotlib</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to HTML</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to PDF</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to an HTML slideshow</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building your First Flask application in 10 minutes or less</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Creating and saving your plots for your Flask BI dashboard</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section cf">\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-circle float-left"></div>\n\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-section-text float-left">Building a business intelligence dashboard in Flask</div>\n\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class="book-toc-chapter"></div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<div class="book-info-details onlyMobile">\n\t\t\t\t<h2>Book Details</h2>\n\t\t\t\t<div class="book-info-details-text">\n\t\t\t\t\t<div class="book-info-isbn13">\n\t\t\t\t\t\t<span class="label">ISBN 13</span><span itemprop="isbn">9781785287466</span>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-info-nb-page">\n\t\t\t\t\t\t<span class="label">Paperback</span><span itemprop="numberOfPages">202</span> pages\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t<div class="book-info-bottom-readmore cf">\n\t\t<div class="book-info-bottom-readmore-button">\n\t\t\tRead More\n\t\t</div>\n\t</div>\n\t<div class="book-info-outer book-info-outer-reviews cf">\n\t\t<div class="book-reviews section-inner cf">\n\t\t\t\t\t\t<div class="hero-blocks cf">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href="/books/deal-of-the-day">\n\t\n\t<div class="hero-block bg-d92238" style="background-color: #d92238; ">\n\t\t<div class="hero-block-body">\n\t\t\t<h3><strong>DEAL OF THE DAY</strong></h3>\r\n<p>Sign up here to get exclusive deep discounts on our latest and bestselling eBooks, delivered straight to your inbox every day.</p>\t\t</div>\n\t</div>\n</a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href="/packt/offers/free-learning">\n\t\n\t<div class="hero-block last bg-ffffff" style="background-color: #ffffff; background-image: url(/sites/default/files/free-learning-hero-book-page.png);">\n\t\t<div class="hero-block-body">\n\t\t\t<h3>FREE LEARNING FOREVER</h3>\r\n<p>Master new IT skills and unlock valuable software & web development knowledge with a FREE eBook every day.</p>\t\t</div>\n\t</div>\n</a>\n\t\t\t\t\t\t\t</div>\n\t\t</div>\n\t</div>\n\t<div class="book-to-consider cf">\n\t\t<div class="book-to-consider-inner section-inner">\n\t\t\t<div class="book-to-consider-text">\n\t\t\t\t<h3>Recommended for You\n\n\t\t\t\t</h3>\n\t\t\t</div>\n\t\t\t\t\t\t<div class="book-to-consider-books">\n\t\t\t\t<div class="book-to-consider-books-inner">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer " itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="16638" data-product-position="1" data-product-price="29.99" data-product-title="IPython Interactive Computing and Visualization Cookbook" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/4818OS_ Ipython Interactive Computing and Visualization Cookbook.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/4818OS_ Ipython Interactive Computing and Visualization Cookbook.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tIPython Interactive Computing and Visualization Cookbook\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="29.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 29.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/ipython-interactive-computing-and-visualization-cookbook">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>Harness IPython for powerful scientific computing and Python data visualization with this collection of more than 100 practical data science recipes</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="16638" title="IPython Interactive Computing and Visualization Cookbook">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="16638" action="/add_to_cart/16637" class="book-block-buy ">$29.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer book-block-position-2" itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="13533" data-product-position="2" data-product-price="23.99" data-product-title="Python Data Visualization Cookbook" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/3367OS.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/3367OS.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tPython Data Visualization Cookbook\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="23.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 23.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/python-data-visualization-cookbook">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>As a developer with knowledge of Python you are already in a great position to start using data visualization. This superb cookbook shows you how in plain language and practical recipes, culminating with 3D animations.</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="13533" title="Python Data Visualization Cookbook">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="13533" action="/add_to_cart/13532" class="book-block-buy ">$23.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer book-block-position-3" itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="19791" data-product-position="3" data-product-price="39.99" data-product-title="Mastering pandas" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1960OS_2060_Mastering Pandas.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1960OS_2060_Mastering Pandas.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tMastering pandas\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="39.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 39.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/mastering-pandas">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>Master the features and capabilities of pandas, a data analysis toolkit for Python</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="19791" title="Mastering pandas">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="19791" action="/add_to_cart/19789" class="book-block-buy ">$39.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer book-block-position-2 book-block-position-4" itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="5300" data-product-position="4" data-product-price="29.99" data-product-title="MySQL for Python" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/0189OS_MockupCover_0.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/0189OS_MockupCover_0.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tMySQL for Python\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="29.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 29.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/mysql-python">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>Integrating MySQL and Python can bring a whole new level of productivity to your applications. This practical tutorial shows you how with examples and explanations that clarify even the most difficult concepts.</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="5300" title="MySQL for Python">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="5300" action="/add_to_cart/5286" class="book-block-buy ">$29.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer book-block-position-5" itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="5702" data-product-position="5" data-product-price="23.99" data-product-title="Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1186EN_MockupCover.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1186EN_MockupCover.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tOracle Business Intelligence : The Condensed Guide to Analysis and Reporting\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="23.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 23.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/oracle-business-intelligence-condensed-guide-analysis-and-reporti">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>A fast track Oracle book and eBook guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder.</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="5702" title="Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="5702" action="/add_to_cart/5704" class="book-block-buy ">$23.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t<div class="end-of-shelf book-block-outer">\n\t\t\t\t\t\t \t\t\t\t\t\t\t\t\t\t\t\n\t\t\n\t<div class="book-block-outer book-block-position-2 book-block-position-3" itemscope itemtype="http://schema.org/Product" data-product="true" data-product-id="4216" data-product-position="6" data-product-price="26.99" data-product-title="Pentaho Reporting 3.5 for Java Developers" data-product-type="books" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence">\n\t\t<div class="book-block last">\n\t\t\t<div class="book-block-icon-books">\n\t\t\t</div>\n\t\t\t\t\t\t\t<noscript>\n\t\t\t\t\t<img src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookimages/3193_MockupCover.jpg" class="bookimage " />\n\t\t\t\t</noscript>\n\t\t\t\t<img src="/sites/default/files/blank.gif" data-original="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookimages/3193_MockupCover.jpg" class="bookimage " />\n\t\t\t\t\t\t<div class="book-block-title" itemprop="name">\n\t\t\t\tPentaho Reporting 3.5 for Java Developers\t\t\t</div>\n\t\t\t<div class="book-block-price " itemprop="offers" itemtype="http://schema.org/Offer" itemscope>\n\t\t\t\t<meta itemprop="price" content="26.99"/>\n\t\t\t\t<meta itemprop="price" content="USD"/>\n\t\t\t\t$ 26.99\t\t\t</div>\n\t\t\t<div class="book-block-overlay">\n\t\t\t\t<a href="/big-data-and-business-intelligence/pentaho-reporting-35-java-developers">\n\t\t\t\t\t<div class="book-block-one-liner ellipsis" itemprop="description">\n\t\t\t\t\t\t<div>Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting.</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-block-star-rating" itemprop="aggregateRating" itemtype="http://schema.org/AggregateRating" itemscope>\n\t\t\t\t\t\t<meta itemprop="ratingCount" content="0"/>\n\t\t\t\t\t\t<meta itemprop="ratingValue" content="" />\n\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t</a>\n\t\t\t\t<div class="book-block-buttons ">\n\t\t\t\t\t<button type="button" class="book-block-collection not-in-collection" nid="4216" title="Pentaho Reporting 3.5 for Java Developers">+ Collection</button>\n\t\t\t\t\t\t\t\t\t\t\t<button type="submit" nid="4216" action="/add_to_cart/3468" class="book-block-buy ">$26.99</button>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t</div>\n</div>\n\n\t\t\t\t\t \t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<!-- /#content -->\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t<!-- #footer -->\n\t\t\t<div id="footer" class="region region-footer">\n\t\t\t\t<div class="section-inner cf">\n\t\t\t\t\t<div class="footer-main-block">\n\t\t\t\t\t\t<div class="footer-section-inner">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h2>Contact Us</h2>\n\t\t\t\t\t\t\t<p>Get in touch <a href="/books/info/packt/contact-us">here</a> <span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">if you have any queries or issues.</span></p>\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-main-block middle-footer-block">\n\t\t\t\t\t\t<div class="footer-section-inner">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h2>Help & Support</h2>\n\t\t\t\t\t\t\t<p class="MsoNormal">Click <a href="/books/info/packt/faq">here</a> for FAQs, order information, T&Cs, errata and code downloads.</p>\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-main-block">\n\t\t\t\t\t\t<div class="footer-section-inner">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<h2>Alerts & Offers</h2>\n\t\t\t\t\t\t\t<p class="MsoNormal">Sign up to our emails for regular updates, bespoke offers, exclusive discounts and great free content.</p>\t\t\t\t\t\t\t<form accept-charset="UTF-8" method="post" id="packt-v3-subscribtion-dotd-form-1">\n<div><div class="form-item">\n \n</div>\n<div class="form-item" id="edit-mail-1-wrapper">\n <input type="text" maxlength="128" name="mail" id="edit-mail-1" size="60" value="" placeholder="Enter your email address" class="form-text" />\n</div>\n<input type="hidden" name="newsletter_id" id="edit-newsletter-id-1" value="" />\n<input type="submit" name="op" id="edit-submit-4" value="Submit" class=" form-submit" />\n<input type="hidden" name="form_build_id" id="form-b8b1d4070f5f1c5ce5d34f1d29a38c4f" value="form-b8b1d4070f5f1c5ce5d34f1d29a38c4f" />\n<input type="hidden" name="form_id" id="edit-packt-v3-subscribtion-dotd-form-1" value="packt_v3_subscribtion_dotd_form" />\n\n</div></form>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<!-- /#footer -->\n\n\t\t\t<!-- #footer-bottom -->\n\t\t\t<div id="footer-bottom" class="region region-footer-bottom">\n\t\t\t\t<div class="section-inner cf">\n\t\t\t\t\t<div class="footer-bottom-block">\n\t\t\t\t\t\t<div class="footer-bottom-block-left">\n\t\t\t\t\t\t\t© Packt Publishing Limited.\n\t\t\t\t\t\t\t<br />\n\t\t\t\t\t\t\tAll Rights Reserved\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-bottom-block footer-contact-us">\n\t\t\t\t\t\t<a href="/books/info/packt/contact-us">Contact Us</a>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-bottom-block">\n\t\t\t\t\t\tView our <a href="/books/info/packt/cookies">Cookie Policy</a>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-bottom-block">\n\t\t\t\t\t\tOur <a href="/books/info/packt/privacy">Privacy Policy</a>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="footer-bottom-block">\n\t\t\t\t\t\t<a target="_blank" href="http://www.linkedin.com/company/packt-publishing" class="footer-social linkedin"></a>\n\t\t\t\t\t\t<a target="_blank" href="http://twitter.com/packtpub" class="footer-social twitter"></a>\n\t\t\t\t\t\t<a target="_blank" href="http://www.facebook.com/packtpub" class="footer-social facebook"></a>\n\t\t\t\t\t\t<a target="_blank" href="https://plus.google.com/112328881995125817822" class="footer-social gplus"></a>\n\t\t\t\t\t\t<a target="_blank" href="https://www.youtube.com/user/packt1000" class="footer-social youtube"></a>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t\t<!-- /#footer-bottom -->\n\t\t\t<script>\n\t\t\t(function (w,i,d,g,e,t,s)\n\t\t\t{w[d] = w[d]||[];t= i.createElement(g); t.async=1;t.src=e;s=i.getElementsByTagName(g)[0];s.parentNode.insertBefore(t, s); }\n\t\t\t)(window, document, \'_gscq\',\'script\',\'//widgets.getsitecontrol.com/18511/script.js\');\n\t\t\t</script>\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t</div>\n\t\t<!-- /#page -->\n\t\t\n\t\t<div id="content-overlay"></div>\n\t\t\n\t\t\t\t\t<div id="book-level-overlay" style="display: none;">\t\n</div>\n<div id="book-level-lightbox" class="cf" style="display: none;">\n\t<div class="book-level-lightbox-inner">\n\t\t<div class="book-level-heading section-inner">\n\t\t\t<h2>Series & Level <div class="book-level-cross"></div></h2>\n\t\t</div>\n\t\t<div class="section-inner cf">\n\t\t\t<div class="book-level-underheading">\n\t\t\t\tWe understand your time is important. Uniquely amongst the major publishers, we seek to develop and publish the broadest range of learning and information products on each technology. Every Packt product delivers a specific learning pathway, broadly defined by the Series type. This structured approach enables you to select the pathway which best suits your knowledge level, learning style and task objectives.\t\t\t\n\t\t\t</div>\n\t\t</div>\n\t\t<div class="book-level-series">\n\t\t\t<div class="section-inner book-level-series-inner cf">\n\t\t\t\t<div class="three-book-series-row cf">\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Learning</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tAs a new user, these step-by-step tutorial guides will give you all the practical skills necessary to become competent and efficient.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Beginner\'s Guide</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tFriendly, informal tutorials that provide a practical introduction using examples, activities, and challenges.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Essentials</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tFast paced, concentrated introductions showing the quickest way to put the tool to work in the real world.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\t\t\t\t\t\n\t\t\t\t</div>\n\t\t\t\t<div class="three-book-series-row cf">\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Cookbook</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tA collection of practical self-contained recipes that all users of the technology will find useful for building more powerful and reliable systems.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Blueprints</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tGuides you through the most common types of project you\'ll encounter, giving you end-to-end guidance on how to build your specific solution quickly and reliably.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class="book-level-series-block">\n\t\t\t\t\t\t<div class="cf">\n\t\t\t\t\t\t\t<h3 class="float-left">Mastering</h3>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t<div class="book-level-series-text">\n\t\t\t\t\t\t\tTake your skills to the next level with advanced tutorials that will give you confidence to master the tool\'s most powerful features.\n\t\t\t\t\t\t</div>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\t\t<div class="book-level-level">\n\t\t\t<div class="section-inner cf">\n\t\t\t\t<div class="book-level-expo float-left">\n\t\t\t\t\t<h3>Starting</h3>\n\t\t\t\t\t<div class="book-level-text">\n\t\t\t\t\t\tAccessible to readers adopting the topic, these titles get you into the tool or technology so that you can become an effective user.\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class="book-level-gauges float-left">\n\t\t\t\t\t<div class="book-level-gauge-left"></div>\n\t\t\t\t\t<div class="book-level-line"></div>\n\t\t\t\t\t<!--div class="book-level-gauge-middle"></div>\n\t\t\t\t\t<div class="book-level-line"></div-->\n\t\t\t\t\t<div class="book-level-gauge-right"></div>\n\t\t\t\t</div>\n\t\t\t\t<div class="book-level-expo float-left">\n\t\t\t\t\t<h3>Progressing</h3>\n\t\t\t\t\t<div class="book-level-text">\n\t\t\t\t\t\tBuilding on core skills you already have, these titles share solutions and expertise so you become a highly productive power user.\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t</div>\n\t\t</div>\n\n\t</div>\n</div>\n\t\t\t\t\n\t</body>\n</html>\n'
In [8]:
soup = bs4.BeautifulSoup(response.text, "html.parser")
In [9]:
soup
Out[9]:
<!DOCTYPE html>
<html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Python Business Intelligence Cookbook | PACKT Books</title>
<script>
dataLayer = [];
</script>
<script type="text/javascript">
var GRANIFY_SITE_ID = 1318;(function(e,t,n){var r,i,s,o,u;u=false;try{o=new RegExp("(?:^|\\W)_gr_test_url=([^;]*)");s=document.cookie.match(o);if(s){if(s[1]==="1")u=true}else{r=Math.random();if(r>.95)u=true;i=new Date(+(new Date)+1e3*60*60*24*2);document.cookie="_gr_test_url="+ +u+";expires="+i.toGMTString()+";path=/"}}catch(a){}if(u)e.replace("javascript.js","javascript.next.js");try{o=new RegExp("(?:^|\\W)_gr_ep=([^;]*)");s=document.cookie.match(o);if(!s){document.cookie="_gr_ep_sent=;expires=Thu, 01-Jan-1970 00:00:01 GMT;path=/";document.cookie="_gr_er_sent=;expires=Thu, 01-Jan-1970 00:00:01 GMT;path=/";if(!window.location.origin){if(window.location.port)port=":"+window.location.port;else port="";window.location.origin=window.location.protocol+"//"+window.location.hostname+port}path=window.location.toString().replace(window.location.origin,"");referrer=document.referrer;i=new Date(+(new Date)+1e3*60*30);document.cookie="_gr_ep="+path+";expires="+i.toGMTString()+";path=/";document.cookie="_gr_er="+referrer+";expires="+i.toGMTString()+";path=/"}}catch(a){}a=new Date;a=""+a.getUTCFullYear()+(a.getUTCMonth()+1)+a.getUTCDate();e=e+"?id="+t+"&v="+a;window.Granify=n;n._stack=[];n.init=function(e,t,r){function i(e,t){e[t]=function(){Granify._stack.push([t].concat(Array.prototype.slice.call(arguments,0)))}}var s=n;h=["on","identify","addTag","trackPageView","trackCart","trackOrder"];for(a=0;a<h.length;a++)i(s,h[a])};n.init();var f,l,c,p=document.createElement("iframe");p.src="javascript:false";p.title="";p.role="presentation";(p.frameElement||p).style.cssText="width: 0 !important; height: 0 !important; border: 0 !important; overflow: hidden !important; position: absolute !important; top: -1000px !important; left: -1000px !important;";c=document.getElementsByTagName("script");c=c[c.length-1];c.parentNode.insertBefore(p,c);try{l=p.contentWindow.document}catch(a){f=document.domain;p.src="javascript:var d=document.open();d.domain='"+f+"';void(0);";l=p.contentWindow.document}l.open()._l=function(){var t=this.createElement("script");if(f)this.domain=f;t.id="js-iframe-async";t.src=e;this.body.appendChild(t)};l.write('<body onload="document._l();">');l.close()})("//cdn.granify.com/assets/javascript.js",GRANIFY_SITE_ID,[])
</script>
<script type="text/javascript">
Granify.trackPageView({
page_type: "product"
});
</script>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
<link href="//d1ldz4te4covpm.cloudfront.net/misc/favicon.ico" rel="shortcut icon" type="image/x-icon"/>
<meta content="Leverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions" name="description"/>
<meta content="1 day" name="revisit-after"/>
<link href="www.packtpub.com/application-development/python-business-intelligence-cookbook" rel="canonical"/>
<meta content="IE=edge" http-equiv="X-UA-Compatible"/>
<meta content="width=320, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" id="viewport" name="viewport">
<!-- <link href="//fonts.googleapis.com/css?family=Ubuntu:300,400,500,700,300italic,400italic,500italic,700italic" rel="stylesheet" type="text/css">-->
<link href="/sites/all/themes/packt_v4/fonts/ubuntu.css" rel="stylesheet" type="text/css">
<!--[if lt IE 10]>
<link href="/sites/all/themes/packt_v4/css/core/packtpub_ie.css" rel="stylesheet" type="text/css">
<![endif]-->
<link href="/sites/default/files/css/14531254790af9a780/6d76251933f115761f7b3782916f72ad.css" media="all" rel="stylesheet" type="text/css"/>
<link href="/sites/default/files/css/14531254790af9a780/6e295a6eb8f64cef4e07d9b1f02d46e8.css" media="print" rel="stylesheet" type="text/css"/>
<script src="/sites/default/files/js/145312547998c14ffa/8420d359404024567b5aefda1231af24.js" type="text/javascript"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(Drupal.settings, { "basePath": "\u002F", "dhtmlMenu": [ "doubleclick", "clone" ] });
//--><!]]>
</script>
<script type="text/javascript">
var Packt = Packt || {}; Packt.user = {"cart":[],"newsletters":[],"country_code":"US","selected_currency":"USD","currency":"USD","currency_symbol":"$","uid":0};
</script>
<link href="/rss.xml" rel="alternate" title="Packt Publishing News" type="application/rss+xml">
<script>
(function(i,s,o,g,r,a,m){i["GoogleAnalyticsObject"]=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,"script","//www.google-analytics.com/analytics.js","ga");
ga("create", "UA-284627-1", "packtpub.com", {"siteSpeedSampleRate": 100});
ga("require", "displayfeatures");
ga('require', 'ec');
ga("send", "pageview");
//ga("require", "ecommerce", "ecommerce.js");
</script>
</link></link></meta></head>
<body class="with-logo" id="ppv4">
<noscript><iframe height="0" src="//www.googletagmanager.com/ns.html?id=GTM-NJWZFW" style="display:none;visibility:hidden" width="0"></iframe></noscript>
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'//www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-NJWZFW');Packt.dataLayer.init();</script>
<div checkout="" class="" id="page">
<div id="page-header">
<div class="cf" id="account-bar">
<div class="section-inner">
<div class="cf" id="account-bar-status">
<div id="account-bar-currency-selector">
<form accept-charset="UTF-8" class="float-left" id="packt-currency-select-form" method="post">
<div class="form-item" id="edit-currency-wrapper">
<select class="form-select packt-currency-select-box selectBox" id="edit-currency" name="currency" style="display:none">
<option value="GBP">GBP £</option>
<option value="USD">US $</option>
<option value="EUR">EUR €</option>
<option value="AUD">AU $</option>
</select>
</div>
<input class="form-submit" name="op" style="display: none;" type="submit" value="">
<input id="edit-packt-currency-select" name="form_id" type="hidden" value="packt_currency_select_form">
</input></input></form>
</div>
<div class="account-bar-divider float-left">|</div>
<div id="account-bar-status-security"></div>
<noscript>
<div id="account-bar-login-register-ns">
<a href="/account">My Account</a>
</div>
</noscript>
<div id="account-bar-login-register">
<a class="login-popup" href="#"><div class="float-left">Log in</div></a>
<div class="account-bar-divider float-left">|</div>
<a href="/register"><div class="float-left">Register</div></a>
</div>
<div id="account-bar-logged-in">
<a href="/account">
<div class="float-left"><strong>My Account</strong></div>
</a>
<div class="account-bar-divider float-left">|</div>
<a href="/logout"><div class="float-left">Sign out</div></a>
</div>
</div>
<div id="account-bar-form">
<div class="cf" id="account-bar-form-login">
<div class="account-bar-form-left">
<h4>Log in to your account</h4>
<form accept-charset="UTF-8" id="packt-user-login-form" method="post">
<div><div class="cf" id="login-form">
<div id="login-form-email">
<div class="form-item" id="email-wrapper">
<input class="form-text required" id="email" maxlength="128" name="email" placeholder="E-mail address" size="24" type="text" value=""/>
</div>
</div>
<div id="login-form-pass">
<div class="form-item" id="password-wrapper">
<input class="form-text required" id="password" maxlength="128" name="password" placeholder="Password" size="24" type="password"/>
</div>
</div>
<div id="login-form-submit">
<input class=" form-submit" id="edit-submit-1" name="op" type="submit" value="Login"/>
</div>
<br/>
</div>
<a href="https://www.packtpub.com/account/password">Forgotten your password?</a>
<input id="form-a09234e2aa0ec1acd583e3aa6707d2e3" name="form_build_id" type="hidden" value="form-a09234e2aa0ec1acd583e3aa6707d2e3"/>
<input id="edit-packt-user-login-form" name="form_id" type="hidden" value="packt_user_login_form"/>
</div></form>
</div>
<div class="account-bar-form-right">
<h4>Not yet a member?</h4>
<p>Register for an account and access leading-edge content on emerging technologies.</p>
<p><a class="account-bar-toggle register" href="/register">Register now</a></p>
</div>
</div>
<div id="account-bar-form-close"><a href="#">Close</a></div>
</div>
</div>
</div>
<div id="menu-bar">
<div class="section-inner cf">
<div id="menuIcon"></div>
<div class="" id="menu-links">
<a href="/">
<div class="menu-item-tab">
<div class="menu-item-text dummy" id="menu-packt-logo">
<span class="alt">Packt Logo</span>
</div>
</div>
</a>
<a href="/all">
<div class="menu-item-tab">
<div class="menu-item-text" id="menu-books">
<span class="menu-text">Books & Videos</span>
</div>
</div>
</a>
<a href="/books/content/blogs">
<div class="menu-item-tab">
<div class="menu-item-text" id="menu-blog">
<span class="menu-text">Blog</span>
</div>
</div>
</a>
<a href="/books/info/packt/about">
<div class="menu-item-tab">
<div class="menu-item-text" id="menu-packt">
<span class="menu-text">Packt</span>
</div>
</div>
</a>
<a href="/books/content/support">
<div class="menu-item-tab">
<div class="menu-item-text" id="menu-support">
<span class="menu-text">Support</span>
</div>
</div>
</a>
<a href="/packtlib">
<div class="menu-item-tab menu-item-tab pl-tab">
<div class="menu-item-text" id="menu-packtlib">
<span class="menu-text pl"><img id="pl-img" src="//dz13w8afd47il.cloudfront.net/sites/all/themes/packt_v4/images/packtlib-logo-dark.png"/></span>
<span class="menu-text mob-pl"><img id="pl-img" src="//dz13w8afd47il.cloudfront.net/sites/all/themes/packt_v4/images/packtlib-logo-light.png"/></span>
</div>
</div>
</a>
</div>
<div class="" id="menu-icons">
<a href="#">
<div class="menu-item-tab">
<div class="menu-item-icon" id="menu-search">
<span class="alt">Search</span>
</div>
</div>
</a>
<a href="/collection">
<div class="menu-item-tab">
<div class="menu-item-icon dummy" id="menu-collection">
<span class="alt">My Collection</span>
</div>
</div>
</a>
<a href="https://www.packtpub.com/cart/checkout">
<div class="menu-item-tab last">
<div class="menu-item-icon" id="menu-cart">
<div class="cart-icon-count" id="cart-icon-count"></div>
<span class="alt">Cart</span>
</div>
</div>
</a>
</div>
</div>
</div>
<div class="cf" id="menu-bar-popup">
<div class="cf" id="menu-bar-popup-inner"></div>
<div class="section-inner cf">
<div class="menu-bar-popup-menu threecol cf" id="menu-books-popup">
<div class="menu-bar-popup-section-left threecol">
<div class="menu-bar-popup-section-left-inner cf">
<p class="menu-bar-popup-title">Book & Video Categories</p>
<div id="books-menu">
<div class="cf">
<div class="books-menu-column categories "><div class="inner"><p><a href="/web-development">Web Development</a></p><p><a href="/big-data-and-business-intelligence">Big Data & Business Intelligence</a></p><p><a href="/application-development">Application Development</a></p><p><a href="/virtualization-and-cloud">Virtualization & Cloud</a></p></div></div><div class="books-menu-column categories "><div class="inner"><p><a href="/game-development">Game Development</a></p><p><a href="/networking-and-servers">Networking & Servers</a></p><p><a href="/hardware-and-creative">Hardware & Creative</a></p><p><a href="/business">Business</a></p></div></div><div class="books-menu-column categories last"><div class="inner"><p><a href="/all">All Books</a></p><p><a href="/video">All Videos</a></p><p><a href="/latest-releases">Latest Releases</a></p></div></div> </div>
</div>
</div>
</div>
<div class="menu-bar-popup-section-right threecol">
<div class="menu-bar-popup-section-right-inner cf">
<div class="cf" id="deal-of-the-day-banner">
<div id="menu-bar-dotd-preview-thumb">
<a href="/books/deal-of-the-day">
<img alt="Go for Web Development [Video]" class="lazyload-disabled imagecache imagecache-featured_book_block" height="185" src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookretailers/9781784397982.jpg" title="" width="150"/> <div class="menu-bar-dotd-percentage">
<div class="menu-bar-dotd-percentage-text">
80<sup class="dotd-sup">%</sup><div class="dotd-sub">off</div>
</div>
</div>
</a>
</div>
<div id="menu-bar-dotd-preview-text">
<p class="menu-bar-popup-title"><a href="/books/deal-of-the-day">Deal of the Day</a></p>
<p>Find out how Go makes web development fast and enjoyable by developing a full stack web project</p>
</div>
<div class="cf deal-of-the-day-in-header">
<div class="dots-main-book-price float-left">
<div class="book-top-pricing-main-price">
<div class="book-top-pricing-main-ebook-price ">$15.00</div>
</div>
<div class="dotd-rrp-price">RRP $74.99</div>
</div>
<form accept-charset="UTF-8" action="/add_to_cart/24227" class="packt-libraries-add-to-cart-form" id="packt-libraries-add-to-cart-form" method="post">
<div>
<div class="book-top-addtocart-inner">
<div class="book-top-addtocart-logo"></div>
<div class="book-top-addtocart-separator"></div>
<input class=" form-submit" id="submit-24227" name="submit-24227" type="submit" value="Add to Cart"/>
<input id="nids" name="nids" type="hidden" value="24227"/>
<input id="qtys" name="qtys" type="hidden" value="1"/>
<input id="edit-upsell" name="upsell" type="hidden" value="1"/>
<input id="form-6e5ecfb7acb7b981374c0fa1748e7c60" name="form_build_id" type="hidden" value="form-6e5ecfb7acb7b981374c0fa1748e7c60"/>
<input id="edit-packt-libraries-add-to-cart-form" name="form_id" type="hidden" value="packt_libraries_add_to_cart_form"/>
</div>
</div></form>
</div>
</div>
<div class="cf newsletter-signup-form" newsletter_id="280">
<div class="dotd-signup-text"><strong>Sign up here to get these deals straight to your inbox</strong></div>
<form accept-charset="UTF-8" id="packt-v3-subscribtion-dotd-form" method="post">
<div><div class="form-item">
</div>
<div class="form-item" id="edit-mail-wrapper">
<input class="form-text" id="edit-mail" maxlength="128" name="mail" placeholder="Enter your email address" size="60" type="text" value=""/>
</div>
<input id="edit-newsletter-id" name="newsletter_id" type="hidden" value=""/>
<input class=" form-submit" id="edit-submit-3" name="op" type="submit" value="Submit"/>
<input id="form-9f18f2384ef69daebdd70a8c10b36929" name="form_build_id" type="hidden" value="form-9f18f2384ef69daebdd70a8c10b36929"/>
<input id="edit-packt-v3-subscribtion-dotd-form" name="form_id" type="hidden" value="packt_v3_subscribtion_dotd_form"/>
</div></form>
</div>
</div>
</div>
</div>
<div class="menu-bar-popup-menu twocol cf" id="menu-blog-popup">
<div class="menu-bar-popup-section-left twocol">
<div class="menu-bar-popup-section-left-inner cf">
<p class="menu-bar-popup-title">Blog</p>
<div class="packt-menu cf">
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/content/blogs">Blogs</a></p>
<p><a href="/books/content/tech-hub">Tech Hub</a></p>
<p><a href="/books/content/article-network">Articles</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="menu-bar-popup-section-right twocol">
<div class="menu-bar-popup-section-right-inner cf">
<div id="menu-bar-article-preview-thumb">
<img alt="Firebase and React" class="lazyload-disabled imagecache imagecache-ppv4_header_article_thumb" height="114" src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" title="" width="240"/> </div>
<div id="menu-bar-article-preview-text">
<p class="menu-bar-popup-title"><a href="/books/content/firebase-and-react">Firebase and React</a></p>
<p id="menu-bar-article-one-liner">In this post we will explore creating a React application with a Firebase backend. We will take a look at how we can use Firebase as a Flux store to drive our UI.</p>
<p><a href="/books/content/blogs">Read all our blogs</a></p>
</div>
</div>
</div>
</div>
<div class="menu-bar-popup-menu cf" id="menu-packt-popup">
<div class="menu-bar-popup-section-left twocol">
<div class="menu-bar-popup-section-left-inner cf">
<p class="menu-bar-popup-title">Packt Publishing</p>
<div class="packt-menu cf">
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/info/packt/about">About Us</a></p>
<p><a href="/books/info/packt/authors">Our Authors</a></p>
<p><a href="/books/info/packt/trade-partners">Trade & Partners</a></p>
<!--<p><a href="/blog-network">Blog</a></p>
<p><a href="/techprimer-network">Technology Primers</a></p>-->
</div>
</div>
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/info/packt/contact-us">Contact Us</a></p>
<p><a href="/books/info/packt/careers-with-packt">Careers</a></p>
<!--<p><a href="/article-network">Articles</a></p>-->
</div>
</div>
</div>
</div>
</div>
<!--<div class="menu-bar-popup-section-right twocol">
<div class="menu-bar-popup-section-right-inner cf">
<div id="menu-bar-article-preview-thumb">
<noscript><img src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" alt="Firebase and React" title="" width="240" height="114" class=" imagecache imagecache-ppv4_header_article_thumb"/></noscript><img src="/sites/default/files/blank.gif" alt="Firebase and React" title="" width="240" height="114" data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/ppv4_header_article_thumb/259_Cover Image.png" class=" imagecache imagecache-ppv4_header_article_thumb"/> </div>
<div id="menu-bar-article-preview-text">
<p class="menu-bar-popup-title"><a href="/books/content/firebase-and-react">Firebase and React</a></p>
<p id="menu-bar-article-one-liner"></p>
<p><a href="/articles">Read all our articles</a></p>
</div>
</div>
</div>-->
</div>
<div class="menu-bar-popup-menu cf" id="menu-support-popup">
<div class="menu-bar-popup-section-left twocol">
<div class="menu-bar-popup-section-left-inner cf">
<p class="menu-bar-popup-title">Support</p>
<div class="packt-menu cf">
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/info/packt/faq">FAQs</a></p>
<p><a href="/books/info/packt/ordering">Ordering Information</a></p>
<p><a href="/books/info/packt/terms-and-conditions">Terms & Conditions</a></p>
</div>
</div>
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/content/support">Code Downloads & Errata</a></p>
<p><a href="/books/content/errata">Submit Errata</a></p>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="menu-bar-popup-menu cf" id="menu-packtlib-popup">
<div class="menu-bar-popup-section-left twocol">
<div class="menu-bar-popup-section-left-inner cf">
<p class="menu-bar-popup-title">PacktLib</p>
<div class="packt-menu cf">
<div class="books-menu-column">
<div class="inner">
<p><a href="/books/subscription/packtlib">Subscribe</a></p>
<p><a href="/books/subscription/packtlib-business">PacktLib For Business</a></p>
<p><a href="/packtlib">Take me to the Library</a></p>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="menu-bar-popup-menu cf" id="menu-search-popup">
<div class="menu-bar-popup-search-inner">
<form accept-charset="UTF-8" id="packt-libraries-main-search-form" method="post">
<div>
<div class="cf" id="menu-bar-search">
<div id="menu-bar-search-title">
<div class="form-item">Search</div>
</div>
<div id="menu-bar-search-box">
<div class="form-item" id="main-search-keys-wrapper">
<input class="form-text" id="main-search-keys" name="keys" placeholder="Enter your search terms..." size="49" type="text" value=""/>
</div>
</div>
<div id="menu-bar-search-button">
<input class=" form-submit" id="edit-submit-5" name="op" type="submit" value="Search"/>
</div>
<input id="edit-sort" name="sort" type="hidden" value="0"/>
<input id="edit-types" name="types" type="hidden" value="0"/>
<input id="edit-forthcoming" name="forthcoming" type="hidden" value="1"/>
<input id="edit-available" name="available" type="hidden" value="1"/>
<input id="edit-count" name="count" type="hidden" value="20"/>
<input id="form-2d8e0f533354c27ad949d7cc2a8cfbb5" name="form_build_id" type="hidden" value="form-2d8e0f533354c27ad949d7cc2a8cfbb5"/>
<input id="edit-packt-libraries-main-search-form" name="form_id" type="hidden" value="packt_libraries_main_search_form"/>
</div>
<div class="facet-search-cross facet-search-cross-autocomplete"></div>
</div></form>
</div>
</div>
<div class="menu-bar-popup-menu cf" id="menu-cart-popup">
<div class="menu-bar-popup-section-left even">
<div class="menu-bar-popup-section-left-inner cf">
<div id="menu-bar-popup-cart-preview">
<div id="menu-bar-popup-cart-item-preview">
<div id="menu-bar-popup-cart-item-preview-image">
<img src=""/>
</div>
<p class="menu-bar-popup-title">Added to Cart</p>
<p id="menu-bar-popup-cart-item-preview-title"></p>
<p id="menu-bar-popup-cart-item-preview-oneliner"></p>
<p id="menu-bar-popup-cart-item-preview-additional">...and <span></span> more</p>
<p class="price"><span id="menu-bar-popup-cart-item-preview-currency"></span><span id="menu-bar-popup-cart-item-preview-price"></span></p>
</div>
</div>
<p id="menu-bar-popup-cart-empty-preview">
You don't have anything in your cart right now.
</p>
</div>
</div>
<div class="menu-bar-popup-section-right even">
<div class="menu-bar-popup-section-right-inner cf">
<div id="menu-bar-popup-content">
<div class="cf">
<p class="menu-bar-popup-title float-left" id="menu-bar-popup-subtotal-title">Subtotal</p>
<p class="menu-bar-popup-title float-right price" id="menu-bar-popup-subtotal-value"> 0.00</p>
<p class="menu-bar-popup-title float-right price" id="menu-bar-popup-subtotal-currency"></p>
</div>
<p><strong>Free shipping</strong> on print orders for US, UK, Europe and selected Asian countries</p>
<form>
<a class="button-link grey" href="https://www.packtpub.com/cart/checkout">View Cart</a>
<span></span>
<a class="button-link" href="https://www.packtpub.com/cart/checkout/?checkout_step=payment">Check Out</a>
</form>
</div>
<div id="checkout-close" onclick="Packt.headerMenu.hideMenuPopup()"></div>
</div>
</div>
</div>
<div class="menu-bar-popup-menu cf" id="menu-cart-small">
<div>
<div class="small-popup-outer float-right">
<div class="small-popup-tick">
</div>
<div class="small-popup-text">
<strong>
Title added to cart
</strong>
</div>
<div class="small-popup-seperator">
</div>
<div class="small-popup-arrows">
</div>
</div>
</div>
</div>
</div>
<div class="cf" id="menu-bar-popup-inner-bottom"></div>
</div>
</div>
<div class="not-front not-logged-in page-node node-type-books no-sidebars page-application-development-python-business-intelligence-cookbook section-application-development node-full-view " id="main-container">
<div class="" id="main">
<!-- #content -->
<div id="content">
<div class="section-inner cf">
<div id="messages-container">
</div>
</div>
<a id="main-content" name="main-content"></a>
<div class="cf" id="main-book" itemscope="" itemtype="http://schema.org/Book">
<div class="book-top-block-wrapper cf">
<div class="book-top-block cf section-inner">
<div class="onlyMobile" id="mobile-book-info">
<div class="book-top-block-info-title float-left">
<h1 itemprop="name">Python Business Intelligence Cookbook</h1>
</div>
<div class="book-top-block-info-one-liner cf">
Leverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions </div>
</div>
<div id="mobile-book-container">
<div class="book-top-block-image left">
<div class="product-image">
<span itemprop="image" itemscope="" itemtype="http://schema.org/URL">
<a class="fancybox" href="/sites/default/files/7466OS_4786_Python Business Intelligence Cookbook.jpg">
<img class="bookimage" src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/ppv4_main_book_cover/7466OS_4786_Python Business Intelligence Cookbook.jpg"/>
</a>
</span>
</div>
<div class="share-buttons-line share-buttons-small">
<div class="share-icon-background">
<a class="share-link" href="http://www.linkedin.com/shareArticle?mini=true&url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook&title=Python+Business+Intelligence+Cookbook&source=Packt+Publishing&summary=Python+Business+Intelligence+Cookbook" target="_blank">
<div class="share-icon linkedin"></div>
</a>
</div>
<div class="share-icon-background">
<a class="share-link" href="https://www.twitter.com/share?url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook&text=Python Business Intelligence Cookbook" target="_blank">
<div class="share-icon twitter"></div>
</a>
</div>
<div class="share-icon-background">
<a class="share-link" href="http://www.facebook.com/sharer.php?u=https://www.packtpub.com/application-development/python-business-intelligence-cookbook" target="_blank">
<div class="share-icon facebook"></div>
</a>
</div>
<div class="share-icon-background last">
<a class="share-link" href="https://plusone.google.com/_/+1/confirm?hl=en&url=https://www.packtpub.com/application-development/python-business-intelligence-cookbook" target="_blank">
<div class="share-icon google-plus"></div>
</a>
</div>
</div> </div>
<div class="book-top-block-info left">
<div class="book-top-block-info-title float-left">
<h1 itemprop="name">Python Business Intelligence Cookbook</h1>
</div>
<div class="book-top-block-info-level show-level-info cf float-right">
<div class="book-level-information float-right"></div>
<div class="book-level-text-info float-right">
Cookbook </div>
<div class="book-level-2 float-right"></div>
</div>
<div class="book-top-block-info-anl">
<div class="book-top-block-info-authors left">
Robert Dempsey<br/>
<time datetime="2015-12-22" itemprop="datePublished">December 2015</time><br/>
<div class="book-top-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="" itemprop="ratingValue"/>
<meta content="0" itemprop="ratingCount"/>
</div>
</div>
<!--div class="book-top-block-info-level show-level-info float-right"-->
<!--/div-->
</div>
<div class="book-top-block-info-one-liner cf">
Leverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions </div>
<div class="book-top-pricing-block" itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="USD" itemprop="priceCurrency"/>
<div class="book-top-pricing-price">
<div class="book-top-pricing-main-price">
<meta content="31.99" itemprop="price"/>
<div class="book-top-pricing-main-ebook-price ">
$31.99 </div>
<div class="book-top-pricing-main-book-price ">
$39.99 </div>
</div>
<div class="book-top-pricing-rrp">
<div class="book-top-pricing-rrp-ebook">
RRP $31.99 </div>
<div class="book-top-pricing-rrp-book">
RRP $39.99 </div>
</div>
</div>
<div class="book-top-type-selection">
<div class="book-type-select-ebook" type="ebooks">
<div class="book-type-select-dot-outer active-checkbox">
<div class="book-type-select-dot-inner">
<div class="book-type-select-dot-inner-active"></div>
</div>
</div>
<span itemprop="itemOffered">eBook</span>
</div>
<div class="book-type-select-print book-type-disabled" type="books">
<div class="book-type-select-dot-outer">
<div class="book-type-select-dot-inner">
<div class="book-type-select-dot-inner-active"></div>
</div>
</div>
Print + eBook
</div>
</div>
</div>
<span itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="Print + eBook" itemprop="itemOffered"/>
<meta content="39.99" itemprop="price"/>
<meta content="USD" itemprop="priceCurrency"/>
</span>
</div>
</div>
<div class="book-top-addtocart">
<div class="digital-product " data-product="true" data-product-brand="Packt Publishing" data-product-category="Application Development" data-product-id="23147" data-product-price="31.99" data-product-title="Python Business Intelligence Cookbook" data-product-type="ebooks">
<form accept-charset="UTF-8" action="/add_to_cart/23147" class="packt-libraries-add-to-cart-form" id="packt-libraries-add-to-cart-form-ebook" method="post">
<div>
<div class="book-top-addtocart-inner">
<div class="book-top-addtocart-logo"></div>
<div class="book-top-addtocart-separator"></div>
<input class=" form-submit" id="submit-23147" name="submit-23147" type="submit" value="Add to Cart"/>
<input id="nids" name="nids" type="hidden" value="23147"/>
<input id="qtys" name="qtys" type="hidden" value="1"/>
<input id="edit-upsell" name="upsell" type="hidden" value="1"/>
<input id="form-f235656557ac54b19453abdfe4d584ec" name="form_build_id" type="hidden" value="form-f235656557ac54b19453abdfe4d584ec"/>
<input id="edit-packt-libraries-add-to-cart-form-ebook" name="form_id" type="hidden" value="packt_libraries_add_to_cart_form_ebook"/>
</div>
</div></form>
</div>
<div class="physical-product" data-product="true" data-product-brand="Packt Publishing" data-product-category="Application Development" data-product-id="23148" data-product-price="39.99" data-product-title="Python Business Intelligence Cookbook" data-product-type="books">
<form accept-charset="UTF-8" action="/add_to_cart/23148/23147" class="packt-libraries-add-to-cart-form" id="packt-libraries-add-to-cart-form-ebook-1" method="post">
<div>
<div class="book-top-addtocart-inner">
<div class="book-top-addtocart-logo"></div>
<div class="book-top-addtocart-separator"></div>
<input class=" form-submit" id="submit-23148,23147" name="submit-23148,23147" type="submit" value="Add to Cart"/>
<input id="nids" name="nids" type="hidden" value="23148,23147"/>
<input id="qtys" name="qtys" type="hidden" value="1,1"/>
<input id="edit-upsell-1" name="upsell" type="hidden" value="1"/>
<input id="form-5859f85d4eec3464daee27f432f766cc" name="form_build_id" type="hidden" value="form-5859f85d4eec3464daee27f432f766cc"/>
<input id="edit-packt-libraries-add-to-cart-form-ebook-1" name="form_id" type="hidden" value="packt_libraries_add_to_cart_form_ebook"/>
</div>
</div></form>
</div>
</div>
<div class="book-top-subscribe cf" itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="12.99" itemprop="price"/>
<meta content="USD" itemprop="priceCurrency"/>
<div class="book-top-subscribe-upsell">
<div class="book-top-subscribe-price-block cf">
<div style="margin-top: 8px;"><span style="color: #4ba8af; font-size: 14px;"><span style="font-size: 2em; font-weight: 500;">$12.99</span> p/month</span></div> </div>
<a href="/books/subscription/packtlib?=pp" id="subscription-upsell-button">
<div class="book-top-subscribe-subscribe-button">
<div class="book-top-subscribe-logo"><img class="bookimage" src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/pl-logo.png"/></div>
<div class="book-top-subscribe-separator"></div>
<div class="book-top-subscribe-text">
<p style="color: #fff;">Get Access</p> </div>
</div>
</a>
</div>
<div class="book-top-subscribe-blurb">
<h4 style="color: #333a40; font-size: 18.2000007629395px; font-family: Ubuntu, sans-serif;">Get <span style="font-weight: bold;">Unlimited Access</span> to every Packt eBook and Video course</h4> <div class="book-top-subscribe-blurb-text">
<p><span style="font-size: 14px; font-family: Ubuntu, sans-serif; background-color: #eaeceb;">Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.</span></p> </div>
</div>
</div>
</div>
</div>
<div class="book-interaction-wrapper cf">
<div class="section-inner book-interaction-inner">
<div class="book-top-block-code book-button float-right ">
<a href="/lcode_download/23148">
<div class="book-top-block-code-button logged-in">
<div class="book-top-block-code-logo"></div>
<div class="book-top-block-code-text">
Code Files
</div>
</div>
</a>
</div>
<div class="book-top-block-collect book-button float-right booknotowned">
<div class="book-top-block-collect-button not-in-collection" nid="23148" title="Python Business Intelligence Cookbook">
<div class="book-top-block-collect-logo">
</div>
<div class="book-top-block-collect-text">
+ Collection </div>
</div>
</div>
<div class="book-top-block-readonline book-button float-right buttons-free-sample booknotowned ">
<div category="Application Development" class="book-top-block-readonline-button showPacktLibReaderNewWindow" isbn="9781785287466" nid="23148" type="book">
<div class="book-top-block-readonline-logo "></div>
<div class="book-top-block-readonline-text">
Free Sample </div>
</div>
</div>
</div>
</div>
<div class="book-info-outer cf">
<div class="book-info-wrapper cf section-inner">
<div class="book-info-details onlyDesktop">
<h2>Book Details</h2>
<div class="book-info-details-text">
<div class="book-info-isbn13">
<span class="label">ISBN 13</span><span itemprop="isbn">9781785287466</span>
</div>
<div class="book-info-nb-page">
<span class="label">Paperback</span><span itemprop="numberOfPages">202</span> pages
</div>
</div>
</div>
<div class="book-info-about-audience float-right">
<div class="book-info-about book-page-content">
<h2>About This Book</h2>
<div class="book-info-about-text" itemprop="about"><ul>
<li><span style="line-height: 20.4px; background-color: transparent;">Want to minimize risk and optimize profits of your business? Learn to create efficient analytical reports with ease using this highly practical, easy-to-follow guide</span></li>
<li><span style="line-height: 20.4px; background-color: transparent;">Learn to apply Python for business intelligence tasks—preparing, exploring, analyzing, visualizing and reporting—in order to make more informed business decisions using data at hand</span></li>
<li>Learn to explore and analyze business data, and build business intelligence dashboards with the help of various insightful recipes</li>
</ul>
</div>
</div> <div class="book-info-audience book-page-content">
<h2>Who This Book Is For</h2>
<div class="book-info-audience-text" itemprop="audience" itemscope="" itemtype="http://schema.org/Audience">
<div itemprop="audienceType"><p><span class="sugar_field" id="audience_c">This book is intended for data analysts, managers, and executives with a basic knowledge of Python, who now want to use Python for their BI tasks. If you have a good knowledge and understanding of BI applications and have a “working” system in place, this book will enhance your toolbox.</span></p>
</div>
</div>
</div> </div>
</div>
</div>
<div class="book-info-outer second-level-info cf">
<div class="book-info-bottom-wrapper section-inner cf">
<div class="float-left onlyDesktop" id="book-info-toc">
<h2>Table of Contents</h2>
<div class="book-info-toc-text">
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>1: Getting Set Up to Gain Business Intelligence </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Introduction</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Anaconda</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Learn about the Python libraries we will be using</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing, configuring, and running MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Rodeo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Starting Rodeo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Robomongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Using Robomongo to query MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Downloading the UK Road Safety Data dataset</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>2: Making Your Data All It Can Be </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a CSV file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing an Excel file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a JSON file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a plain text file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Retrieving a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Retrieving multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Inserting a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Inserting multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Deleting a single record using pymongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Deleting multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a CSV file into a Pandas DataFrame</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Renaming column headers in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Filling in missing values in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing punctuation in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing whitespace in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing any string from within a string in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Merging two datasets in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Titlecasing anything</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Uppercasing a column in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating values in place in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Standardizing a Social Security number in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Standardizing dates in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Converting categories to numbers in Pandas for a speed boost</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>3: Learning What Your Data Truly Holds </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a MongoDB query</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a CSV file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from an Excel file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a JSON file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a data quality report</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for the entire dataset</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for object type columns</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the mode of the entire dataset</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting a count of unique values for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the minimum and maximum values of a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating quantiles for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the mean, median, mode, and range for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating a frequency table for a single column by date</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating a frequency table of two variables</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a histogram for a column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting the data as a probability distribution</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting a cumulative distribution function</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Showing the histogram as a stepped line</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting two sets of values in a probability distribution</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a customized box plot with whiskers</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a basic bar chart for a single column over time</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>4: Performing Data Analysis for Non Data Analysts </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a distribution analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing categorical variable analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a linear regression</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a time-series analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing outlier detection</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using logistic regression</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using a random forest</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using Support Vector Machines</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Saving a predictive model for production use</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>5: Building a Business Intelligence Dashboard Quickly </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating reports in Excel directly from a Pandas DataFrame</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating customizable Excel reports using XlsxWriter</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building a shareable dashboard using IPython Notebook and matplotlib</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to HTML</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to PDF</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to an HTML slideshow</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building your First Flask application in 10 minutes or less</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating and saving your plots for your Flask BI dashboard</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building a business intelligence dashboard in Flask</div>
</div>
</div>
</div>
<div class="book-toc-chapter"></div>
</div>
</div>
<div class="float-right book-page-content" id="book-info-will-learn">
<h2>What You Will Learn</h2>
<div class="book-info-will-learn-text">
<ul>
<li><span style="line-height: 20.4px; background-color: transparent;">Install Anaconda, MongoDB, and everything you need to get started with your data analysis</span></li>
<li><span style="line-height: 20.4px; background-color: transparent;">Prepare data for analysis by querying cleaning and standardizing data</span></li>
<li>Explore your data by creating a Pandas data frame from MongoDB</li>
<li>Gain powerful insights, both statistical and predictive, to make informed business decisions</li>
<li>Visualize your data by building dashboards and generating reports</li>
<li>Create a complete data processing and business intelligence system</li>
</ul>
</div>
</div> <div class="book-info-bottom-indetail book-page-content float-right">
<h2>In Detail</h2>
<div class="book-info-bottom-indetail-text" itemprop="description">
<p><span class="sugar_field" id="description">The amount of data produced by businesses and devices is going nowhere but up. In this scenario, the major advantage of Python is that it's a general-purpose language and gives you a lot of flexibility in data structures. Python is an excellent tool for more specialized analysis tasks, and is powered with related libraries to process data streams, to visualize datasets, and to carry out scientific calculations. Using Python for business intelligence (BI) can help you solve tricky problems in one go.</span></p>
<p><span class="sugar_field" id="description">Rather than spending day after day scouring Internet forums for “how-to” information, here you’ll find more than 60 recipes that take you through the entire process of creating actionable intelligence from your raw data, no matter what shape or form it’s in. Within the first 30 minutes of opening this book, you’ll learn how to use the latest in Python and NoSQL databases to glean insights from data just waiting to be exploited.</span></p>
<p><span class="sugar_field" id="description">We’ll begin with a quick-fire introduction to Python for BI and show you what problems Python solves. From there, we move on to working with a predefined data set to extract data as per business requirements, using the Pandas library and MongoDB as our storage engine.</span></p>
<p><span class="sugar_field" id="description">Next, we will analyze data and perform transformations for BI with Python. Through this, you will gather insightful data that will help you make informed decisions for your business. The final part of the book will show you the most important task of BI—visualizing data by building stunning dashboards using Matplotlib, PyTables, and iPython Notebook.</span></p>
</div>
</div> <div class="book-info-bottom-author book-page-content float-right">
<h2>Authors</h2>
<div class="book-info-bottom-author-text">
<div itemprop="author" itemscope="" itemtype="http://schema.org/Person">
<div class="book-info-bottom-author-title">
<h3 itemprop="name">Robert Dempsey</h3>
</div>
<div class="book-info-bottom-author-body" itemprop="description">
<p>Robert Dempsey is a tested leader and technology professional who specializes in delivering solutions and products to solve tough business challenges. His experience of forming and leading agile teams, combined with more than 16 years of technology experience, enables him to solve complex problems while always keeping the bottom line in mind.</p>
<p>Robert has founded and built three start-ups in tech and marketing, developed and sold two online applications, consulted for Fortune 500 and Inc. 500 companies, and has spoken nationally and internationally on software development and agile project management.</p>
<p>He's the founder of Data Wranglers DC, a group that is dedicated to improving the craft of data engineering, as well as a board member of Data Community DC.</p>
<p>In addition to spending time with his growing family, Robert geeks out on Raspberry Pi, Arduinos, and automating more of his life through hardware and software.</p>
<p>Find him on his website at <a href="http://robertwdempsey.com">http://robertwdempsey.com</a>.</p>
</div>
</div>
</div>
</div>
<div class="float-left onlyMobile" id="book-info-toc">
<h2>Table of Contents</h2>
<div class="book-info-toc-text">
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>1: Getting Set Up to Gain Business Intelligence </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Introduction</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Anaconda</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Learn about the Python libraries we will be using</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing, configuring, and running MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Rodeo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Starting Rodeo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Installing Robomongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Using Robomongo to query MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Downloading the UK Road Safety Data dataset</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>2: Making Your Data All It Can Be </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a CSV file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing an Excel file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a JSON file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a plain text file into MongoDB</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Retrieving a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Retrieving multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Inserting a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Inserting multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating a single record using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Deleting a single record using pymongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Deleting multiple records using PyMongo</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Importing a CSV file into a Pandas DataFrame</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Renaming column headers in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Filling in missing values in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing punctuation in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing whitespace in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Removing any string from within a string in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Merging two datasets in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Titlecasing anything</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Uppercasing a column in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Updating values in place in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Standardizing a Social Security number in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Standardizing dates in Pandas</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Converting categories to numbers in Pandas for a speed boost</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>3: Learning What Your Data Truly Holds </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a MongoDB query</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a CSV file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from an Excel file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a Pandas DataFrame from a JSON file</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a data quality report</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for the entire dataset</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for object type columns</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the mode of the entire dataset</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating summary statistics for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting a count of unique values for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the minimum and maximum values of a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating quantiles for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Getting the mean, median, mode, and range for a single column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating a frequency table for a single column by date</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Generating a frequency table of two variables</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a histogram for a column</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting the data as a probability distribution</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting a cumulative distribution function</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Showing the histogram as a stepped line</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Plotting two sets of values in a probability distribution</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a customized box plot with whiskers</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a basic bar chart for a single column over time</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>4: Performing Data Analysis for Non Data Analysts </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a distribution analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing categorical variable analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a linear regression</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing a time-series analysis</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Performing outlier detection</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using logistic regression</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using a random forest</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating a predictive model using Support Vector Machines</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Saving a predictive model for production use</div>
</div>
</div>
</div>
<div class="book-toc-chapter">
<div class="book-toc-chapter-title">
<span class="chapter">Chapter </span>5: Building a Business Intelligence Dashboard Quickly </div>
<div class="book-toc-sections-wrapper">
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating reports in Excel directly from a Pandas DataFrame</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating customizable Excel reports using XlsxWriter</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building a shareable dashboard using IPython Notebook and matplotlib</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to HTML</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to PDF</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Exporting an IPython Notebook Dashboard to an HTML slideshow</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building your First Flask application in 10 minutes or less</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Creating and saving your plots for your Flask BI dashboard</div>
</div>
<div class="book-toc-section cf">
<div class="book-toc-section-circle float-left"></div>
<div class="book-toc-section-text float-left">Building a business intelligence dashboard in Flask</div>
</div>
</div>
</div>
<div class="book-toc-chapter"></div>
</div>
</div>
<div class="book-info-details onlyMobile">
<h2>Book Details</h2>
<div class="book-info-details-text">
<div class="book-info-isbn13">
<span class="label">ISBN 13</span><span itemprop="isbn">9781785287466</span>
</div>
<div class="book-info-nb-page">
<span class="label">Paperback</span><span itemprop="numberOfPages">202</span> pages
</div>
</div>
</div>
</div>
</div>
<div class="book-info-bottom-readmore cf">
<div class="book-info-bottom-readmore-button">
Read More
</div>
</div>
<div class="book-info-outer book-info-outer-reviews cf">
<div class="book-reviews section-inner cf">
<div class="hero-blocks cf">
<a href="/books/deal-of-the-day">
<div class="hero-block bg-d92238" style="background-color: #d92238; ">
<div class="hero-block-body">
<h3><strong>DEAL OF THE DAY</strong></h3>
<p>Sign up here to get exclusive deep discounts on our latest and bestselling eBooks, delivered straight to your inbox every day.</p> </div>
</div>
</a>
<a href="/packt/offers/free-learning">
<div class="hero-block last bg-ffffff" style="background-color: #ffffff; background-image: url(/sites/default/files/free-learning-hero-book-page.png);">
<div class="hero-block-body">
<h3>FREE LEARNING FOREVER</h3>
<p>Master new IT skills and unlock valuable software & web development knowledge with a FREE eBook every day.</p> </div>
</div>
</a>
</div>
</div>
</div>
<div class="book-to-consider cf">
<div class="book-to-consider-inner section-inner">
<div class="book-to-consider-text">
<h3>Recommended for You
</h3>
</div>
<div class="book-to-consider-books">
<div class="book-to-consider-books-inner">
<div class="book-block-outer">
<div class="book-block-outer " data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="16638" data-product-position="1" data-product-price="29.99" data-product-title="IPython Interactive Computing and Visualization Cookbook" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/4818OS_ Ipython Interactive Computing and Visualization Cookbook.jpg"/>
</noscript>
<img class="bookimage " data-original="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/4818OS_ Ipython Interactive Computing and Visualization Cookbook.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
IPython Interactive Computing and Visualization Cookbook </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="29.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 29.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/ipython-interactive-computing-and-visualization-cookbook">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>Harness IPython for powerful scientific computing and Python data visualization with this collection of more than 100 practical data science recipes</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="16638" title="IPython Interactive Computing and Visualization Cookbook" type="button">+ Collection</button>
<button action="/add_to_cart/16637" class="book-block-buy " nid="16638" type="submit">$29.99</button>
</div>
</div>
</div>
</div>
</div>
<div class="book-block-outer">
<div class="book-block-outer book-block-position-2" data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="13533" data-product-position="2" data-product-price="23.99" data-product-title="Python Data Visualization Cookbook" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/3367OS.jpg"/>
</noscript>
<img class="bookimage " data-original="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/3367OS.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
Python Data Visualization Cookbook </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="23.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 23.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/python-data-visualization-cookbook">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>As a developer with knowledge of Python you are already in a great position to start using data visualization. This superb cookbook shows you how in plain language and practical recipes, culminating with 3D animations.</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="13533" title="Python Data Visualization Cookbook" type="button">+ Collection</button>
<button action="/add_to_cart/13532" class="book-block-buy " nid="13533" type="submit">$23.99</button>
</div>
</div>
</div>
</div>
</div>
<div class="book-block-outer">
<div class="book-block-outer book-block-position-3" data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="19791" data-product-position="3" data-product-price="39.99" data-product-title="Mastering pandas" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1960OS_2060_Mastering Pandas.jpg"/>
</noscript>
<img class="bookimage " data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1960OS_2060_Mastering Pandas.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
Mastering pandas </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="39.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 39.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/mastering-pandas">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>Master the features and capabilities of pandas, a data analysis toolkit for Python</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="19791" title="Mastering pandas" type="button">+ Collection</button>
<button action="/add_to_cart/19789" class="book-block-buy " nid="19791" type="submit">$39.99</button>
</div>
</div>
</div>
</div>
</div>
<div class="book-block-outer">
<div class="book-block-outer book-block-position-2 book-block-position-4" data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="5300" data-product-position="4" data-product-price="29.99" data-product-title="MySQL for Python" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/0189OS_MockupCover_0.jpg"/>
</noscript>
<img class="bookimage " data-original="//d255esdrn735hr.cloudfront.net/sites/default/files/imagecache/featured_book_block/0189OS_MockupCover_0.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
MySQL for Python </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="29.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 29.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/mysql-python">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>Integrating MySQL and Python can bring a whole new level of productivity to your applications. This practical tutorial shows you how with examples and explanations that clarify even the most difficult concepts.</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="5300" title="MySQL for Python" type="button">+ Collection</button>
<button action="/add_to_cart/5286" class="book-block-buy " nid="5300" type="submit">$29.99</button>
</div>
</div>
</div>
</div>
</div>
<div class="book-block-outer">
<div class="book-block-outer book-block-position-5" data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="5702" data-product-position="5" data-product-price="23.99" data-product-title="Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1186EN_MockupCover.jpg"/>
</noscript>
<img class="bookimage " data-original="//dz13w8afd47il.cloudfront.net/sites/default/files/imagecache/featured_book_block/1186EN_MockupCover.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="23.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 23.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/oracle-business-intelligence-condensed-guide-analysis-and-reporti">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>A fast track Oracle book and eBook guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder.</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="5702" title="Oracle Business Intelligence : The Condensed Guide to Analysis and Reporting" type="button">+ Collection</button>
<button action="/add_to_cart/5704" class="book-block-buy " nid="5702" type="submit">$23.99</button>
</div>
</div>
</div>
</div>
</div>
<div class="end-of-shelf book-block-outer">
<div class="book-block-outer book-block-position-2 book-block-position-3" data-product="true" data-product-brand="Packt Publishing" data-product-category="Big Data & Business Intelligence" data-product-id="4216" data-product-position="6" data-product-price="26.99" data-product-title="Pentaho Reporting 3.5 for Java Developers" data-product-type="books" itemscope="" itemtype="http://schema.org/Product">
<div class="book-block last">
<div class="book-block-icon-books">
</div>
<noscript>
<img class="bookimage " src="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookimages/3193_MockupCover.jpg"/>
</noscript>
<img class="bookimage " data-original="//d1ldz4te4covpm.cloudfront.net/sites/default/files/imagecache/featured_book_block/bookimages/3193_MockupCover.jpg" src="/sites/default/files/blank.gif"/>
<div class="book-block-title" itemprop="name">
Pentaho Reporting 3.5 for Java Developers </div>
<div class="book-block-price " itemprop="offers" itemscope="" itemtype="http://schema.org/Offer">
<meta content="26.99" itemprop="price"/>
<meta content="USD" itemprop="price"/>
$ 26.99 </div>
<div class="book-block-overlay">
<a href="/big-data-and-business-intelligence/pentaho-reporting-35-java-developers">
<div class="book-block-one-liner ellipsis" itemprop="description">
<div>Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting.</div>
</div>
<div class="book-block-star-rating" itemprop="aggregateRating" itemscope="" itemtype="http://schema.org/AggregateRating">
<meta content="0" itemprop="ratingCount"/>
<meta content="" itemprop="ratingValue"/>
</div>
</a>
<div class="book-block-buttons ">
<button class="book-block-collection not-in-collection" nid="4216" title="Pentaho Reporting 3.5 for Java Developers" type="button">+ Collection</button>
<button action="/add_to_cart/3468" class="book-block-buy " nid="4216" type="submit">$26.99</button>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /#content -->
</div>
</div>
<!-- #footer -->
<div class="region region-footer" id="footer">
<div class="section-inner cf">
<div class="footer-main-block">
<div class="footer-section-inner">
<h2>Contact Us</h2>
<p>Get in touch <a href="/books/info/packt/contact-us">here</a> <span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">if you have any queries or issues.</span></p> </div>
</div>
<div class="footer-main-block middle-footer-block">
<div class="footer-section-inner">
<h2>Help & Support</h2>
<p class="MsoNormal">Click <a href="/books/info/packt/faq">here</a> for FAQs, order information, T&Cs, errata and code downloads.</p> </div>
</div>
<div class="footer-main-block">
<div class="footer-section-inner">
<h2>Alerts & Offers</h2>
<p class="MsoNormal">Sign up to our emails for regular updates, bespoke offers, exclusive discounts and great free content.</p> <form accept-charset="UTF-8" id="packt-v3-subscribtion-dotd-form-1" method="post">
<div><div class="form-item">
</div>
<div class="form-item" id="edit-mail-1-wrapper">
<input class="form-text" id="edit-mail-1" maxlength="128" name="mail" placeholder="Enter your email address" size="60" type="text" value=""/>
</div>
<input id="edit-newsletter-id-1" name="newsletter_id" type="hidden" value=""/>
<input class=" form-submit" id="edit-submit-4" name="op" type="submit" value="Submit"/>
<input id="form-b8b1d4070f5f1c5ce5d34f1d29a38c4f" name="form_build_id" type="hidden" value="form-b8b1d4070f5f1c5ce5d34f1d29a38c4f"/>
<input id="edit-packt-v3-subscribtion-dotd-form-1" name="form_id" type="hidden" value="packt_v3_subscribtion_dotd_form"/>
</div></form>
</div>
</div>
</div>
</div>
<!-- /#footer -->
<!-- #footer-bottom -->
<div class="region region-footer-bottom" id="footer-bottom">
<div class="section-inner cf">
<div class="footer-bottom-block">
<div class="footer-bottom-block-left">
© Packt Publishing Limited.
<br/>
All Rights Reserved
</div>
</div>
<div class="footer-bottom-block footer-contact-us">
<a href="/books/info/packt/contact-us">Contact Us</a>
</div>
<div class="footer-bottom-block">
View our <a href="/books/info/packt/cookies">Cookie Policy</a>
</div>
<div class="footer-bottom-block">
Our <a href="/books/info/packt/privacy">Privacy Policy</a>
</div>
<div class="footer-bottom-block">
<a class="footer-social linkedin" href="http://www.linkedin.com/company/packt-publishing" target="_blank"></a>
<a class="footer-social twitter" href="http://twitter.com/packtpub" target="_blank"></a>
<a class="footer-social facebook" href="http://www.facebook.com/packtpub" target="_blank"></a>
<a class="footer-social gplus" href="https://plus.google.com/112328881995125817822" target="_blank"></a>
<a class="footer-social youtube" href="https://www.youtube.com/user/packt1000" target="_blank"></a>
</div>
</div>
</div>
<!-- /#footer-bottom -->
<script>
(function (w,i,d,g,e,t,s)
{w[d] = w[d]||[];t= i.createElement(g); t.async=1;t.src=e;s=i.getElementsByTagName(g)[0];s.parentNode.insertBefore(t, s); }
)(window, document, '_gscq','script','//widgets.getsitecontrol.com/18511/script.js');
</script>
</div>
<!-- /#page -->
<div id="content-overlay"></div>
<div id="book-level-overlay" style="display: none;">
</div>
<div class="cf" id="book-level-lightbox" style="display: none;">
<div class="book-level-lightbox-inner">
<div class="book-level-heading section-inner">
<h2>Series & Level <div class="book-level-cross"></div></h2>
</div>
<div class="section-inner cf">
<div class="book-level-underheading">
We understand your time is important. Uniquely amongst the major publishers, we seek to develop and publish the broadest range of learning and information products on each technology. Every Packt product delivers a specific learning pathway, broadly defined by the Series type. This structured approach enables you to select the pathway which best suits your knowledge level, learning style and task objectives.
</div>
</div>
<div class="book-level-series">
<div class="section-inner book-level-series-inner cf">
<div class="three-book-series-row cf">
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Learning</h3>
</div>
<div class="book-level-series-text">
As a new user, these step-by-step tutorial guides will give you all the practical skills necessary to become competent and efficient.
</div>
</div>
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Beginner's Guide</h3>
</div>
<div class="book-level-series-text">
Friendly, informal tutorials that provide a practical introduction using examples, activities, and challenges.
</div>
</div>
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Essentials</h3>
</div>
<div class="book-level-series-text">
Fast paced, concentrated introductions showing the quickest way to put the tool to work in the real world.
</div>
</div>
</div>
<div class="three-book-series-row cf">
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Cookbook</h3>
</div>
<div class="book-level-series-text">
A collection of practical self-contained recipes that all users of the technology will find useful for building more powerful and reliable systems.
</div>
</div>
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Blueprints</h3>
</div>
<div class="book-level-series-text">
Guides you through the most common types of project you'll encounter, giving you end-to-end guidance on how to build your specific solution quickly and reliably.
</div>
</div>
<div class="book-level-series-block">
<div class="cf">
<h3 class="float-left">Mastering</h3>
</div>
<div class="book-level-series-text">
Take your skills to the next level with advanced tutorials that will give you confidence to master the tool's most powerful features.
</div>
</div>
</div>
</div>
</div>
<div class="book-level-level">
<div class="section-inner cf">
<div class="book-level-expo float-left">
<h3>Starting</h3>
<div class="book-level-text">
Accessible to readers adopting the topic, these titles get you into the tool or technology so that you can become an effective user.
</div>
</div>
<div class="book-level-gauges float-left">
<div class="book-level-gauge-left"></div>
<div class="book-level-line"></div>
<!--div class="book-level-gauge-middle"></div>
<div class="book-level-line"></div-->
<div class="book-level-gauge-right"></div>
</div>
<div class="book-level-expo float-left">
<h3>Progressing</h3>
<div class="book-level-text">
Building on core skills you already have, these titles share solutions and expertise so you become a highly productive power user.
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
In [10]:
# Extract the pricing data
price_ebook = soup.select('.book-top-pricing-main-ebook-price ')[1].get_text()
price_book = soup.select('.book-top-pricing-main-book-price ')[0].get_text()
price_rrp_ebook = soup.select('.book-top-pricing-rrp-ebook')[0].get_text()
price_rrp_book = soup.select('.book-top-pricing-rrp-book')[0].get_text()
In [11]:
price_rrp_ebook, price_book, price_rrp_ebook, price_rrp_book
Out[11]:
('\n\t\t\t\t\tRRP $31.99\t\t\t\t',
'\n\t\t\t\t\t$39.99\t\t\t\t',
'\n\t\t\t\t\tRRP $31.99\t\t\t\t',
'\n\t\t\t\t\tRRP $39.99\t\t\t\t')
In [12]:
# Clean the data
price_ebook = remove_all_whitespace(price_ebook)
price_ebook = trim_the_ends(price_ebook)
price_ebook = remove_unneeded_chars(price_ebook)
price_book = remove_all_whitespace(price_book)
price_book = trim_the_ends(price_book)
price_book = remove_unneeded_chars(price_book)
price_rrp_ebook = remove_all_whitespace(price_rrp_ebook)
price_rrp_ebook = trim_the_ends(price_rrp_ebook)
price_rrp_ebook = remove_unneeded_chars(price_rrp_ebook)
price_rrp_book = remove_all_whitespace(price_rrp_book)
price_rrp_book = trim_the_ends(price_rrp_book)
price_rrp_book = remove_unneeded_chars(price_rrp_book)
In [13]:
price_rrp_ebook, price_book, price_rrp_ebook, price_rrp_book
Out[13]:
('31.99', '39.99', '31.99', '39.99')
In [14]:
# Append the pricing data to the CSV file
pricing_file = ("/Users/robertdempsey/Dropbox/Private/"
"Art of Skill Hacking/Books/Python Business"
" Intelligence Cookbook/Pricing History/pricing_history.csv")
In [15]:
with open(pricing_file, 'a', newline='') as fp:
a = csv.writer(fp, delimiter=',')
data = [[datetime.now(),
URL,
price_ebook,
price_book,
price_rrp_ebook,
price_rrp_book]]
a.writerows(data)
In [16]:
system.open(pricing_file)
---------------------------------------------------------------------------
NameError Traceback (most recent call last)
<ipython-input-16-5e5aec709ff4> in <module>()
----> 1 system.open(pricing_file)
NameError: name 'system' is not defined
In [ ]:
import sys
Content source: rdempsey/python-for-sharing
Similar notebooks: