Index
A
- Anaconda
- installing / Installing Anaconda, Getting ready
- URL / Getting ready
- installing, on Mac OS X 10.10.4 / Mac OS X 10.10.4
- installing, on Windows 8.1 / Windows 8.1
- installing, on Linux Ubuntu server 14.04.2 LTS / Linux Ubuntu server 14.04.2 LTS, How it works…
- astype() method
- about / How it works…
B
- bar chart
- creating, for single column over time / Creating a basic bar chart for a single column over time, How to do it…, How it works…
- business intelligence (BI)
C
- categorical variable analysis
- performing / Performing categorical variable analysis, How to do it…, How it works…
- categories
- converting to numbers, in Pandas / Converting categories to numbers in Pandas for a speed boost, How it works…
- column
- uppercasing, in Pandas / Uppercasing a column in Pandas, How it works…
- summary statistics, generating / Generating summary statistics for a single column, How it works…
- unique value count, obtaining / Getting a count of unique values for a single column, How it works…
- minimum value, obtaining / Getting the minimum and maximum values of a single column
- maximum value, obtaining / Getting the minimum and maximum values of a single column
- quantiles, generating / Generating quantiles for a single column, How it works…
- mean, obtaining / Getting the mean, median, mode, and range for a single column, How to do it…, How it works…
- median, obtaining / Getting the mean, median, mode, and range for a single column, How to do it…, How it works…
- mode, obtaining / Getting the mean, median, mode, and range for a single column, How to do it…, How it works…
- range, obtaining / Getting the mean, median, mode, and range for a single column, How it works…
- frequency table, generating by date / Generating a frequency table for a single column by date, How it works…
- histogram, creating / Creating a histogram for a column, How to do it…, How it works…
- bar chart, creating / Creating a basic bar chart for a single column over time, How to do it…, How it works…
- column headers
- renaming, in Pandas / Renaming column headers in Pandas, How it works…
- Create Read Update Delete (CRUD) functionality
- CSV file
- importing, into MongoDB / Importing a CSV file into MongoDB, How to do it…, There's more…
- importing, into Pandas DataFrame / Importing a CSV file into a Pandas DataFrame, Getting ready, How it works…
- Pandas DataFrame, creating from / Creating a Pandas DataFrame from a CSV file, How it works…
- cumulative distribution function
- customizable Excel reports
- creating, XlsxWriter used / Creating customizable Excel reports using XlsxWriter, How to do it…, How it works…
- customized box plot
- creating, with Whiskers / Creating a customized box plot with whiskers, How to do it…, How it works…
D
- data quality report
- creating / Creating a data quality report, How to do it…, How it works…
- datasets
- merging, in Pandas / Merging two datasets in Pandas, How it works…
- summary statistics, generating / Generating summary statistics for the entire dataset, How to do it…, How it works…
- mode, obtaining / Getting the mode of the entire dataset
- dates
- standardizing, in Pandas / Standardizing dates in Pandas, Getting ready, How it works…
- distribution analysis
- performing / Performing a distribution analysis, How to do it…, How it works…
E
- Excel file
- importing, into MongoDB / Importing an Excel file into MongoDB, How to do it…
- Pandas DataFrame, creating from / Creating a Pandas DataFrame from an Excel file, How it works…
- Excel report
- creating, from Pandas DataFrame / Creating reports in Excel directly from a Pandas DataFrame, How it works…
F
- Flask
- URL / Building your First Flask application in 10 minutes or less
- references / See Also..
- Flask application
- building / Getting Set Up…, How to do it…, How it works…
- Flask BI Dashboard
- plots, creating / Creating and saving your plots for your Flask BI dashboard, How to do it…, How it works…
- plots, saving / Creating and saving your plots for your Flask BI dashboard, How to do it…, How it works…
- building / Building a business intelligence dashboard in Flask, How to do it…, How it works…
- frequency table
- generating, by date / Generating a frequency table for a single column by date, How it works…
- generating, of two variables / Generating a frequency table of two variables, How to do it…, How it works…
H
- histogram
- creating, for column / Creating a histogram for a column, How to do it…, How it works…
- displaying, as stepped line / Showing the histogram as a stepped line, How it works…
- HTML
- iPython Notebook Dashboard, exporting / Exporting an IPython Notebook Dashboard to HTML, How it works…
- HTML slideshow
- iPython Notebook Dashboard, exporting / Exporting an IPython Notebook Dashboard to an HTML slideshow, How it works…
I
- iPython Notebook
- used, for building shareable Dashboard / Building a shareable dashboard using IPython Notebook and matplotlib, Getting Set Up…, How to do it…, How it works…
- IPython Notebook (Jupyter)
- iPython Notebook Dashboard
- exporting, to HTML / Exporting an IPython Notebook Dashboard to HTML, How it works…
- exporting, to PDF / Exporting an IPython Notebook Dashboard to PDF, Method 2…
- exporting, to HTML slideshow / Exporting an IPython Notebook Dashboard to an HTML slideshow, How it works…
J
- JavaScript Object Notation (JSON)
- JSON file
- importing, into MongoDB / Importing a JSON file into MongoDB
- Pandas DataFrame, creating from / Creating a Pandas DataFrame from a JSON file, How it works…
L
- LaTeX
- URL / Method one…
- linear regression
- performing / Performing a linear regression, How to do it…, How it works…
- Linux
- Linux Ubuntu server 14.04.2 LTS
- Anaconda, installing on / Linux Ubuntu server 14.04.2 LTS, How it works…
- logistic regression
- used, for creating predictive model / Creating a predictive model using logistic regression, How to do it…, How it works…
M
- Mac OS X
- Mac OS X 10.10.4
- Anaconda, installing on / Mac OS X 10.10.4
- MacTeX
- URL / Method one…
- matplotlib
- used, for building shareable Dashboard / Building a shareable dashboard using IPython Notebook and matplotlib, Getting Set Up…, How to do it…, How it works…
- Matplotlib
- MongoDB
- installing / Installing, configuring, and running MongoDB
- configuring / Installing, configuring, and running MongoDB
- running / Installing, configuring, and running MongoDB
- installing, on Mac OS X / Mac OS X
- configuring, on Mac OS X / Mac OS X
- running, on Mac OS X / Mac OS X
- running, on Windows / Windows
- installing, on Windows / Windows
- configuring, on Windows / Windows
- configuring, on Linux / Linux
- installing, on Linux / Linux
- running, on Linux / Linux
- URL / Linux
- querying, Robomongo used / Using Robomongo to query MongoDB
- CSV file, importing into / Importing a CSV file into MongoDB, How to do it…, There's more…
- Excel file, importing into / Importing an Excel file into MongoDB, How to do it…
- JSON file, importing into / Importing a JSON file into MongoDB
- text file, importing into / Importing a plain text file into MongoDB, How to do it…
- MongoDB query
- used, for creating Pandas DataFrame / Creating a Pandas DataFrame from a MongoDB query, How to do it…
- multiple records
- retrieving, Pymongo used / Retrieving multiple records using PyMongo, How it works…
- inserting, PyMongo used / Inserting multiple records using PyMongo, How it works…
- updating, PyMongo used / Updating multiple records using PyMongo, How it works…
- deleting, PyMongo used / Deleting multiple records using PyMongo
- multivariate outlier
- about / Performing outlier detection
N
- nbconvert
- URL / See Also…
- Numpy
O
- object type columns
- summary statistics, generating for / Generating summary statistics for object type columns, How it works…
- outlier detection
- performing / Performing outlier detection, How to do it…, How it works…
P
- Pandas
- about / Learn about the Python libraries we will be using
- column headers, renaming / Renaming column headers in Pandas, How it works…
- missing values, filling / Filling in missing values in Pandas, How it works…
- punctuation, removing / Removing punctuation in Pandas, How it works…
- whitespace, removing in / Removing whitespace in Pandas, How it works…
- characters, removing from string / Removing any string from within a string in Pandas, How it works…
- datasets, merging / Merging two datasets in Pandas, How it works…
- column, uppercasing / Uppercasing a column in Pandas, How it works…
- values, updating / Updating values in place in Pandas, How to do it…, How it works…
- social security number, standardizing / Standardizing a Social Security number in Pandas, How it works…
- dates, standardizing / Standardizing dates in Pandas, Getting ready, How it works…
- categories, converting to numbers / Converting categories to numbers in Pandas for a speed boost, How it works…
- URL / How it works…
- Pandas DataFrame
- CSV file, importing into / Importing a CSV file into a Pandas DataFrame, Getting ready, How it works…
- creating, from MongoDB query / Creating a Pandas DataFrame from a MongoDB query, How to do it…
- creating, from CSV file / Creating a Pandas DataFrame from a CSV file, How it works…
- creating, from Excel file / Creating a Pandas DataFrame from an Excel file, How it works…
- creating, from JSON file / Creating a Pandas DataFrame from a JSON file, How it works…
- Excel report, creating / How to do it…, How it works…
- Pandoc
- URL / Method one…
- about / Method one…
- PDF
- iPython Notebook Dashboard, exporting / Exporting an IPython Notebook Dashboard to PDF, Method 2…
- predictive model
- creating, logistic regression used / Creating a predictive model using logistic regression, How to do it…, How it works…
- creating, random forest used / Creating a predictive model using a random forest, How to do it…, How it works…
- creating, Support Vector Machines (SVM) used / Creating a predictive model using Support Vector Machines, How to do it…, How it works…
- saving / Getting Ready, How it works…
- probability distribution
- data, plotting as / Plotting the data as a probability distribution, How it works…
- two sets of values, plotting / Plotting two sets of values in a probability distribution, How to do it…, How it works…
- punctuation
- removing, in Pandas / Removing punctuation in Pandas, How it works…
- Pymongo
- used, for retrieving single record / Retrieving a single record using PyMongo, How it works…
- used, for retrieving multiple records / Retrieving multiple records using PyMongo, How it works…
- PyMongo
- about / Learn about the Python libraries we will be using
- used, for inserting single record / Inserting a single record using PyMongo, How it works…
- used, for inserting multiple records / Inserting multiple records using PyMongo, How it works…
- used, for updating single record / Updating a single record using PyMongo, How it works…
- used, for updating multiple records / Updating multiple records using PyMongo, How it works…
- used, for deleting single record / Getting ready, How it works…
- used, for deleting multiple records / Deleting multiple records using PyMongo
- Python
- URL / How it works…
- Python libraries
- Pandas / Learn about the Python libraries we will be using
- Scikit-learn / Learn about the Python libraries we will be using
- Numpy / Learn about the Python libraries we will be using
- Matplotlib / Learn about the Python libraries we will be using
- PyMongo / Learn about the Python libraries we will be using
- Xlswriter / Learn about the Python libraries we will be using
- IPython Notebook (Jupyter) / Learn about the Python libraries we will be using
Q
- quantiles
- generating, for single column / Generating quantiles for a single column, How it works…
R
- random forest
- used, for creating predictive model / Creating a predictive model using a random forest, How to do it…, How it works…
- reveal.js library
- Robomongo
- installing / Installing Robomongo
- URL / Getting ready
- installing, on Mac OS X / Mac OS X
- installing, on Windows / Windows
- used, for querying MongoDB / Using Robomongo to query MongoDB
- Rodeo
- installing / Installing Rodeo
- starting / Starting Rodeo, How to do it…
S
- Scikit-learn
- shareable Dashboard
- building, iPython Notebook used / Building a shareable dashboard using IPython Notebook and matplotlib, Getting Set Up…, How to do it…, How it works…
- building, matplotlib used / Building a shareable dashboard using IPython Notebook and matplotlib, Getting Set Up…, How to do it…, How it works…
- single record
- retrieving, Pymongo used / Retrieving a single record using PyMongo, How it works…
- inserting, PyMongo used / Inserting a single record using PyMongo, How it works…
- updating, PyMongo used / Updating a single record using PyMongo, How it works…
- deleting, PyMongo used / Getting ready, How it works…
- social security number
- standardizing, in Pandas / Standardizing a Social Security number in Pandas, How it works…
- string
- characters removing, in Pandas / Removing any string from within a string in Pandas, How it works…
- summary statistics
- generating, for entire dataset / Generating summary statistics for the entire dataset, How to do it…, How it works…
- generating, for object type columns / Generating summary statistics for object type columns, How it works…
- generating, for single column / Generating summary statistics for a single column, How it works…
- Support Vector Machines (SVM)
- used, for creating predictive model / Creating a predictive model using Support Vector Machines, How to do it…, How it works…
T
- text file
- importing, into MongoDB / Importing a plain text file into MongoDB, How to do it…
- time-series analysis
- performing / Performing a time-series analysis, How to do it…, How it works…
- titlecasing
- about / Titlecasing anything, How it works…
U
- UK Road Safety Data dataset
- downloading / Downloading the UK Road Safety Data dataset, How it works…
- URL / How to do it…
- using / Why we are using this dataset
- unique value count
- obtaining, for single column / Getting a count of unique values for a single column, How it works…
- univariate outlier
- about / Performing outlier detection
- update operators
- URL / How it works…
W
- Whiskers
- customized box plot, creating with / Creating a customized box plot with whiskers, How to do it…, How it works…
- whitespace
- removing, in Pandas / Removing whitespace in Pandas, How it works…
- Windows
- Windows 8.1
- Anaconda, installing on / Windows 8.1
- wkhtmltopdf
X
- Xlswriter
- XlsxWriter
- used, for creating customizable Excel reports / Creating customizable Excel reports using XlsxWriter, How to do it…, How it works…