Python Business Intelligence Cookbook
eBook - ePub

Python Business Intelligence Cookbook

Robert Dempsey

Share book
  1. 202 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Python Business Intelligence Cookbook

Robert Dempsey

Book details
Book preview
Table of contents
Citations

About This Book

Leverage the computational power of Python with more than 60 recipes that arm you with the required skills to make informed business decisions

About This Book

  • 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
  • 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
  • Learn to explore and analyze business data, and build business intelligence dashboards with the help of various insightful recipes

Who This Book Is For

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.

What You Will Learn

  • Install Anaconda, MongoDB, and everything you need to get started with your data analysis
  • Prepare data for analysis by querying cleaning and standardizing data
  • Explore your data by creating a Pandas data frame from MongoDB
  • Gain powerful insights, both statistical and predictive, to make informed business decisions
  • Visualize your data by building dashboards and generating reports
  • Create a complete data processing and business intelligence system

In Detail

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.

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.

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.

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.

Style and approach

This is a step-by-step guide to help you prepare, explore, analyze and report data, written in a conversational tone to make it easy to grasp. Whether you're new to BI or are looking for a better way to work, you'll find the knowledge and skills here to get your job done efficiently.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on ā€œCancel Subscriptionā€ - itā€™s as simple as that. After you cancel, your membership will stay active for the remainder of the time youā€™ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlegoā€™s features. The only differences are the price and subscription period: With the annual plan youā€™ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Python Business Intelligence Cookbook an online PDF/ePUB?
Yes, you can access Python Business Intelligence Cookbook by Robert Dempsey in PDF and/or ePUB format, as well as other popular books in Computer Science & Programming in Python. We have over one million books available in our catalogue for you to explore.

Information

Year
2015
ISBN
9781785287466
Edition
1

Python Business Intelligence Cookbook


Table of Contents

Python Business Intelligence Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Sections
Getting ready
How to do itā€¦
How it worksā€¦
There's moreā€¦
See also
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Getting Set Up to Gain Business Intelligence
Introduction
Installing Anaconda
Getting ready
How to do itā€¦
Mac OS X 10.10.4
Windows 8.1
Linux Ubuntu server 14.04.2 LTS
How it worksā€¦
Learn about the Python libraries we will be using
Installing, configuring, and running MongoDB
Getting ready
How to do itā€¦
Mac OS X
Windows
Linux
How it worksā€¦
Installing Rodeo
Getting ready
How to do itā€¦
How it worksā€¦
Starting Rodeo
Getting ready
How to do itā€¦
Installing Robomongo
Getting ready
How to do itā€¦
Mac OS X
Windows
Using Robomongo to query MongoDB
Getting ready
How to do itā€¦
Downloading the UK Road Safety Data dataset
How to do itā€¦
How it worksā€¦
Why we are using this dataset
2. Making Your Data All It Can Be
Importing a CSV file into MongoDB
Getting ready
How to do itā€¦
How it worksā€¦
There's moreā€¦
Importing an Excel file into MongoDB
Getting ready
How to do itā€¦
How it worksā€¦
Importing a JSON file into MongoDB
Getting ready
How to do itā€¦
Importing a plain text file into MongoDB
How to do itā€¦
How it worksā€¦
Retrieving a single record using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Retrieving multiple records using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Inserting a single record using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Inserting multiple records using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Updating a single record using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Updating multiple records using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Deleting a single record using pymongo
Getting ready
How to do itā€¦
How it worksā€¦
Deleting multiple records using PyMongo
Getting ready
How to do itā€¦
How it worksā€¦
Importing a CSV file into a Pandas DataFrame
Getting ready
How to do itā€¦
How it worksā€¦
There's moreā€¦
Renaming column headers in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Filling in missing values in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Removing punctuation in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Removing whitespace in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Removing any string from within a string in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Merging two datasets in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Titlecasing anything
Getting ready
How to do itā€¦
How it worksā€¦
Uppercasing a column in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Updating values in place in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Standardizing a Social Security number in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Standardizing dates in Pandas
Getting ready
How to do itā€¦
How it worksā€¦
Converting categories to numbers in Pandas for a speed boost
Getting ready
How to do itā€¦
How it worksā€¦
3. Learning What Your Data Truly Holds
Creating a Pandas DataFrame from a MongoDB query
Getting ready
How to do itā€¦
How it worksā€¦
Creating a Pandas DataFrame from a CSV file
How to do itā€¦
How it worksā€¦
Creating a Pandas DataFrame from an Excel file
How to do itā€¦
How it worksā€¦
Creating a Pandas DataFrame from a JSON file
How to do itā€¦
How it worksā€¦
Creating a data quality report
Getting ready
How to do itā€¦
How it worksā€¦
Generating summary statistics for the entire dataset
How to do itā€¦
How it worksā€¦
Generating summary statistics for object type columns
How to do itā€¦
How it worksā€¦
Getting the mode of the entire dataset
How to do itā€¦
How it worksā€¦
Generating summary statistics for a single column
How to do itā€¦
How it worksā€¦
Getting a count of unique values for a single column
How to do itā€¦
How it worksā€¦
Additional Arguments
Getting the minimum and maximum values of a single column
How to do itā€¦
How it worksā€¦
Generating quantiles for a single column
How to do itā€¦
How it worksā€¦
Getting the mean, median, mode, and range for a single column
How to do itā€¦
How it worksā€¦
Generating a frequency table for a single column by date
Getting ready
How to do itā€¦
How it worksā€¦
Generating a frequency table of two variables
Getting ready
How to do itā€¦
How...

Table of contents