[PDF] Python Business Intelligence Cookbook eBook

Author : Robert Dempsey
Publisher : Packt Publishing Ltd
Page : 202 pages
File Size : 44,26 MB
Release : 2015-12-22
Category : Computers
ISBN : 1785289667

GET 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.

Author : Gopi Subramanian
Publisher : Packt Publishing
Page : 438 pages
File Size : 17,53 MB
Release : 2015-11-11
Category : Computers
ISBN : 9781784396404

GET BOOK

Over 60 practical recipes to help you explore Python and its robust data science capabilitiesAbout This Book• The book is packed with simple and concise Python code examples to effectively demonstrate advanced concepts in action• Explore concepts such as programming, data mining, data analysis, data visualization, and machine learning using Python• Get up to speed on machine learning algorithms with the help of easy-to-follow, insightful recipesWho This Book Is ForThis book is intended for all levels of Data Science professionals, both students and practitioners, starting from novice to experts. Novices can spend their time in the first five chapters getting themselves acquainted with Data Science. Experts can refer to the chapters starting from 6 to understand how advanced techniques are implemented using Python. People from non-Python backgrounds can also effectively use this book, but it would be helpful if you have some prior basic programming experience.What You Will Learn• Explore the complete range of Data Science algorithms• Get to know the tricks used by industry engineers to create the most accurate data science models• Manage and use Python libraries such as numpy, scipy, scikit learn, and matplotlib effectively• Create meaningful features to solve real-world problems• Take a look at Advanced Regression methods for model building and variable selection• Get a thorough understanding of the underlying concepts and implementation of Ensemble methods• Solve real-world problems using a variety of different datasets from numerical and text data modalities• Get accustomed to modern state-of-the art algorithms such as Gradient Boosting, Random Forest, Rotation Forest, and so onIn DetailPython is increasingly becoming the language for data science. It is overtaking R in terms of adoption, it is widely known by many developers, and has a strong set of libraries such as Numpy, Pandas, scikit-learn, Matplotlib, Ipython and Scipy, to support its usage in this field. Data Science is the emerging new hot tech field, which is an amalgamation of different disciplines including statistics, machine learning, and computer science. It's a disruptive technology changing the face of today's business and altering the economy of various verticals including retail, manufacturing, online ventures, and hospitality, to name a few, in a big way.This book will walk you through the various steps, starting from simple to the most complex algorithms available in the Data Science arsenal, to effectively mine data and derive intelligence from it. At every step, we provide simple and efficient Python recipes that will not only show you how to implement these algorithms, but also clarify the underlying concept thoroughly.The book begins by introducing you to using Python for Data Science, followed by working with Python environments. You will then learn how to analyse your data with Python. The book then teaches you the concepts of data mining followed by an extensive coverage of machine learning methods. It introduces you to a number of Python libraries available to help implement machine learning and data mining routines effectively. It also covers the principles of shrinkage, ensemble methods, random forest, rotation forest, and extreme trees, which are a must-have for any successful Data Science Professional.Style and approachThis is a step-by-step recipe-based approach to Data Science algorithms, introducing the math philosophy behind these algorithms.

Author : Ivan Idris
Publisher : Packt Publishing Ltd
Page : 462 pages
File Size : 41,93 MB
Release : 2016-07-22
Category : Computers
ISBN : 1785283855

GET BOOK

Over 140 practical recipes to help you make sense of your data with ease and build production-ready data apps About This Book Analyze Big Data sets, create attractive visualizations, and manipulate and process various data types Packed with rich recipes to help you learn and explore amazing algorithms for statistics and machine learning Authored by Ivan Idris, expert in python programming and proud author of eight highly reviewed books Who This Book Is For This book teaches Python data analysis at an intermediate level with the goal of transforming you from journeyman to master. Basic Python and data analysis skills and affinity are assumed. What You Will Learn Set up reproducible data analysis Clean and transform data Apply advanced statistical analysis Create attractive data visualizations Web scrape and work with databases, Hadoop, and Spark Analyze images and time series data Mine text and analyze social networks Use machine learning and evaluate the results Take advantage of parallelism and concurrency In Detail Data analysis is a rapidly evolving field and Python is a multi-paradigm programming language suitable for object-oriented application development and functional design patterns. As Python offers a range of tools and libraries for all purposes, it has slowly evolved as the primary language for data science, including topics on: data analysis, visualization, and machine learning. Python Data Analysis Cookbook focuses on reproducibility and creating production-ready systems. You will start with recipes that set the foundation for data analysis with libraries such as matplotlib, NumPy, and pandas. You will learn to create visualizations by choosing color maps and palettes then dive into statistical data analysis using distribution algorithms and correlations. You'll then help you find your way around different data and numerical problems, get to grips with Spark and HDFS, and then set up migration scripts for web mining. In this book, you will dive deeper into recipes on spectral analysis, smoothing, and bootstrapping methods. Moving on, you will learn to rank stocks and check market efficiency, then work with metrics and clusters. You will achieve parallelism to improve system performance by using multiple threads and speeding up your code. By the end of the book, you will be capable of handling various data analysis techniques in Python and devising solutions for problem scenarios. Style and Approach The book is written in “cookbook” style striving for high realism in data analysis. Through the recipe-based format, you can read each recipe separately as required and immediately apply the knowledge gained.

Author : Rehan Guha
Publisher : BPB Publications
Page : 319 pages
File Size : 26,20 MB
Release : 2020-11-12
Category : Computers
ISBN : 9389898005

GET BOOK

A Cookbook that will help you implement Machine Learning algorithms and techniques by building real-world projects Ê KEY FEATURESÊ Learn how to handle an entire Machine Learning Pipeline supported with adequate mathematics. Create Predictive Models and choose the right model for various types of Datasets. Learn the art of tuning a model to improve accuracy as per Business requirements. Get familiar with concepts related to Data Analytics with Visualization, Data Science and Machine Learning. DESCRIPTION Machine Learning does not have to be intimidating at all. This book focuses on the concepts of Machine Learning and Data Analytics with mathematical explanations and programming examples. All the codes are written in Python as it is one of the most popular programming languages used for Data Science and Machine Learning. Here I have leveraged multiple libraries like NumPy, Pandas, scikit-learn, etc. to ease our task and not reinvent the wheel. There are five projects in total, each addressing a unique problem. With the recipes in this cookbook, one will learn how to solve Machine Learning problems for real-time data and perform Data Analysis and Analytics, Classification, and beyond. The datasets used are also unique and will help one to think, understand the problem and proceed towards the goal. The book is not saturated with Mathematics, but mostly all the Mathematical concepts are covered for the important topics. Every chapter typically starts with some theory and prerequisites, and then it gradually dives into the implementation of the same concept using Python, keeping a project in the background.Ê Ê WHAT WILL YOU LEARN Understand the working of the O.S.E.M.N. framework in Data Science.Ê Get familiar with the end-to-end implementation of Machine Learning Pipeline. Learn how to implement Machine Learning algorithms and concepts using Python. Learn how to build a Predictive Model for a Business case. WHO THIS BOOK IS FORÊ This cookbook is meant for anybody who is passionate enough to get into the World of Machine Learning and has a preliminary understanding of the Basics of Linear Algebra, Calculus, Probability, and Statistics. This book also serves as a reference guidebook for intermediate Machine Learning practitioners. Ê TABLE OF CONTENTS 1. Boston Crime 2. World Happiness Report 3. Iris Species 4. Credit Card Fraud Detection 5. Heart Disease UCI

Author : Michael Walker
Publisher : Packt Publishing Ltd
Page : 437 pages
File Size : 38,5 MB
Release : 2020-12-11
Category : Computers
ISBN : 1800564597

GET BOOK

Discover how to describe your data in detail, identify data issues, and find out how to solve them using commonly used techniques and tips and tricks Key FeaturesGet well-versed with various data cleaning techniques to reveal key insightsManipulate data of different complexities to shape them into the right form as per your business needsClean, monitor, and validate large data volumes to diagnose problems before moving on to data analysisBook Description Getting clean data to reveal insights is essential, as directly jumping into data analysis without proper data cleaning may lead to incorrect results. This book shows you tools and techniques that you can apply to clean and handle data with Python. You'll begin by getting familiar with the shape of data by using practices that can be deployed routinely with most data sources. Then, the book teaches you how to manipulate data to get it into a useful form. You'll also learn how to filter and summarize data to gain insights and better understand what makes sense and what does not, along with discovering how to operate on data to address the issues you've identified. Moving on, you'll perform key tasks, such as handling missing values, validating errors, removing duplicate data, monitoring high volumes of data, and handling outliers and invalid dates. Next, you'll cover recipes on using supervised learning and Naive Bayes analysis to identify unexpected values and classification errors, and generate visualizations for exploratory data analysis (EDA) to visualize unexpected values. Finally, you'll build functions and classes that you can reuse without modification when you have new data. By the end of this Python book, you'll be equipped with all the key skills that you need to clean data and diagnose problems within it. What you will learnFind out how to read and analyze data from a variety of sourcesProduce summaries of the attributes of data frames, columns, and rowsFilter data and select columns of interest that satisfy given criteriaAddress messy data issues, including working with dates and missing valuesImprove your productivity in Python pandas by using method chainingUse visualizations to gain additional insights and identify potential data issuesEnhance your ability to learn what is going on in your dataBuild user-defined functions and classes to automate data cleaningWho this book is for This book is for anyone looking for ways to handle messy, duplicate, and poor data using different Python tools and techniques. The book takes a recipe-based approach to help you to learn how to clean and manage data. Working knowledge of Python programming is all you need to get the most out of the book.

Author : Chris Albon
Publisher : "O'Reilly Media, Inc."
Page : 305 pages
File Size : 26,23 MB
Release : 2018-03-09
Category : Computers
ISBN : 1491989335

GET BOOK

This practical guide provides nearly 200 self-contained recipes to help you solve machine learning challenges you may encounter in your daily work. If you’re comfortable with Python and its libraries, including pandas and scikit-learn, you’ll be able to address specific problems such as loading data, handling text or numerical data, model selection, and dimensionality reduction and many other topics. Each recipe includes code that you can copy and paste into a toy dataset to ensure that it actually works. From there, you can insert, combine, or adapt the code to help construct your application. Recipes also include a discussion that explains the solution and provides meaningful context. This cookbook takes you beyond theory and concepts by providing the nuts and bolts you need to construct working machine learning applications. You’ll find recipes for: Vectors, matrices, and arrays Handling numerical and categorical data, text, images, and dates and times Dimensionality reduction using feature extraction or feature selection Model evaluation and selection Linear and logical regression, trees and forests, and k-nearest neighbors Support vector machines (SVM), naïve Bayes, clustering, and neural networks Saving and loading trained models

Author : Donabel Santos
Publisher : Packt Publishing Ltd
Page : 476 pages
File Size : 21,44 MB
Release : 2016-11-30
Category : Computers
ISBN : 1786469731

GET BOOK

Create powerful, effective visualizations to help analyze your data with Tableau 10 by your side About This Book Cook your favorite Tableau 10 business intelligence recipe with the help of this easy-to-follow book Build beautiful, interactive dashboards and visualizations in Tableau 10 that help you make informed decisions This rich collection of independent recipes cover everything needed to become an advanced Tableau user and get an edge over other Tableau users Who This Book Is For This book is targeted to business, data, and analytics professionals who want to build rich interactive visualizations using Tableau. Familiarity with previous versions of Tableau would be helpful, but is not necessary. What You Will Learn Become familiar with the Tableau interface Build basic to more advanced charts with step-by-step recipes Use filters, calculated fields, parameters, and actions to add interactivity to charts and dashboards Prepare and transform data for analysis using Tableau's built-in tools and functions Create effective and compelling dashboards and story points Leverage Tableau's mapping capabilities to visualize location and shape data Integrate analytics and forecasting to enhance data analysis Get to know tips and tricks to work more quickly and effectively in Tableau Increase your confidence and competence in creating rich, interactive visualizations in Tableau In Detail Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations. This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered. By the end of this book, you'll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau. Style and approach This book is a collection of independent recipes that cover a wide range of options for data visualization on offer with Tableau. With the help of the recipes in this book, you can explore Tableau and pick the business intelligence solution that's best suited for your needs.

Author : Igor Milovanovic
Publisher : Packt Publishing Ltd
Page : 302 pages
File Size : 48,30 MB
Release : 2015-11-30
Category : Computers
ISBN : 1784394947

GET BOOK

Over 70 recipes to get you started with popular Python libraries based on the principal concepts of data visualization About This Book Learn how to set up an optimal Python environment for data visualization Understand how to import, clean and organize your data Determine different approaches to data visualization and how to choose the most appropriate for your needs Who This Book Is For If you already know about Python programming and want to understand data, data formats, data visualization, and how to use Python to visualize data then this book is for you. What You Will Learn Introduce yourself to the essential tooling to set up your working environment Explore your data using the capabilities of standard Python Data Library and Panda Library Draw your first chart and customize it Use the most popular data visualization Python libraries Make 3D visualizations mainly using mplot3d Create charts with images and maps Understand the most appropriate charts to describe your data Know the matplotlib hidden gems Use plot.ly to share your visualization online In Detail Python Data Visualization Cookbook will progress the reader from the point of installing and setting up a Python environment for data manipulation and visualization all the way to 3D animations using Python libraries. Readers will benefit from over 60 precise and reproducible recipes that will guide the reader towards a better understanding of data concepts and the building blocks for subsequent and sometimes more advanced concepts. Python Data Visualization Cookbook starts by showing how to set up matplotlib and the related libraries that are required for most parts of the book, before moving on to discuss some of the lesser-used diagrams and charts such as Gantt Charts or Sankey diagrams. Initially it uses simple plots and charts to more advanced ones, to make it easy to understand for readers. As the readers will go through the book, they will get to know about the 3D diagrams and animations. Maps are irreplaceable for displaying geo-spatial data, so this book will also show how to build them. In the last chapter, it includes explanation on how to incorporate matplotlib into different environments, such as a writing system, LaTeX, or how to create Gantt charts using Python. Style and approach A step-by-step recipe based approach to data visualization. The topics are explained sequentially as cookbook recipes consisting of a code snippet and the resulting visualization.

Author : Theodore Petrou
Publisher : Packt Publishing Ltd
Page : 534 pages
File Size : 24,57 MB
Release : 2017-10-23
Category : Computers
ISBN : 1784393347

GET BOOK

Over 95 hands-on recipes to leverage the power of pandas for efficient scientific computation and data analysis About This Book Use the power of pandas to solve most complex scientific computing problems with ease Leverage fast, robust data structures in pandas to gain useful insights from your data Practical, easy to implement recipes for quick solutions to common problems in data using pandas Who This Book Is For This book is for data scientists, analysts and Python developers who wish to explore data analysis and scientific computing in a practical, hands-on manner. The recipes included in this book are suitable for both novice and advanced users, and contain helpful tips, tricks and caveats wherever necessary. Some understanding of pandas will be helpful, but not mandatory. What You Will Learn Master the fundamentals of pandas to quickly begin exploring any dataset Isolate any subset of data by properly selecting and querying the data Split data into independent groups before applying aggregations and transformations to each group Restructure data into tidy form to make data analysis and visualization easier Prepare real-world messy datasets for machine learning Combine and merge data from different sources through pandas SQL-like operations Utilize pandas unparalleled time series functionality Create beautiful and insightful visualizations through pandas direct hooks to Matplotlib and Seaborn In Detail This book will provide you with unique, idiomatic, and fun recipes for both fundamental and advanced data manipulation tasks with pandas. Some recipes focus on achieving a deeper understanding of basic principles, or comparing and contrasting two similar operations. Other recipes will dive deep into a particular dataset, uncovering new and unexpected insights along the way. The pandas library is massive, and it's common for frequent users to be unaware of many of its more impressive features. The official pandas documentation, while thorough, does not contain many useful examples of how to piece together multiple commands like one would do during an actual analysis. This book guides you, as if you were looking over the shoulder of an expert, through practical situations that you are highly likely to encounter. Many advanced recipes combine several different features across the pandas library to generate results. Style and approach The author relies on his vast experience teaching pandas in a professional setting to deliver very detailed explanations for each line of code in all of the recipes. All code and dataset explanations exist in Jupyter Notebooks, an excellent interface for exploring data.

Author : Michael Diener
Publisher : Packt Publishing Ltd
Page : 310 pages
File Size : 49,62 MB
Release : 2015-11-30
Category : Computers
ISBN : 1783555084

GET BOOK

Over 60 recipes to work with topology, overlays, indoor routing, and web application analysis with Python About This Book Explore the practical process of using geospatial analysis to solve simple to complex problems with reusable recipes Concise step-by-step instructions to teach you about projections, vector, raster, overlay, indoor routing and topology analysis Create a basic indoor routing application with geodjango Who This Book Is For If you are a student, teacher, programmer, geospatial or IT administrator, GIS analyst, researcher, or scientist looking to do spatial analysis, then this book is for you. Anyone trying to answer simple to complex spatial analysis questions will get a working demonstration of the power of Python with real-world data. Some of you may be beginners with GIS, but most of you will probably have a basic understanding of geospatial analysis and programming. What You Will Learn Discover the projection and coordinate system information of your data and learn how to transform that data into different projections Import or export your data into different data formats to prepare it for your application or spatial analysis Use the power of PostGIS with Python to take advantage of the powerful analysis functions Execute spatial analysis functions on vector data including clipping, spatial joins, measuring distances, areas, and combining data to new results Create your own set of topology rules to perform and ensure quality assurance rules in Python Find the shortest indoor path with network analysis functions in easy, extensible recipes revolving around all kinds of network analysis problems Visualize your data on a map using the visualization tools and methods available to create visually stunning results Build an indoor routing web application with GeoDjango to include your spatial analysis tools built from the previous recipes In Detail Geospatial development links your data to places on the Earth's surface. Its analysis is used in almost every industry to answer location type questions. Combined with the power of the Python programming language, which is becoming the de facto spatial scripting choice for developers and analysts worldwide, this technology will help you to solve real-world spatial problems. This book begins by tackling the installation of the necessary software dependencies and libraries needed to perform spatial analysis with Python. From there, the next logical step is to prepare our data for analysis; we will do this by building up our tool box to deal with data preparation, transformations, and projections. Now that our data is ready for analysis, we will tackle the most common analysis methods for vector and raster data. To check or validate our results, we will explore how to use topology checks to ensure top-quality results. This is followed with network routing analysis focused on constructing indoor routes within buildings, over different levels. Finally, we put several recipes together in a GeoDjango web application that demonstrates a working indoor routing spatial analysis application. The round trip will provide you all the pieces you need to accomplish your own spatial analysis application to suit your requirements. Style and approach Easy-to-follow, step-by-step recipes, explaining from start to finish how to accomplish real-world tasks.