Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Practical Data Analysis Using Jupyter Notebook
  • Toc
  • feedback
Practical Data Analysis Using Jupyter Notebook

Practical Data Analysis Using Jupyter Notebook

By : Marc Wintjen
3.9 (9)
close
Practical Data Analysis Using Jupyter Notebook

Practical Data Analysis Using Jupyter Notebook

3.9 (9)
By: Marc Wintjen

Overview of this book

Data literacy is the ability to read, analyze, work with, and argue using data. Data analysis is the process of cleaning and modeling your data to discover useful information. This book combines these two concepts by sharing proven techniques and hands-on examples so that you can learn how to communicate effectively using data. After introducing you to the basics of data analysis using Jupyter Notebook and Python, the book will take you through the fundamentals of data. Packed with practical examples, this guide will teach you how to clean, wrangle, analyze, and visualize data to gain useful insights, and you'll discover how to answer questions using data with easy-to-follow steps. Later chapters teach you about storytelling with data using charts, such as histograms and scatter plots. As you advance, you'll understand how to work with unstructured data using natural language processing (NLP) techniques to perform sentiment analysis. All the knowledge you gain will help you discover key patterns and trends in data using real-world examples. In addition to this, you will learn how to handle data of varying complexity to perform efficient data analysis using modern Python libraries. By the end of this book, you'll have gained the practical skills you need to analyze data with confidence.
Table of Contents (18 chapters)
close
close
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
1
Section 1: Data Analysis Essentials
Section 1: Data Analysis Essentials
Free Chapter
2
Fundamentals of Data Analysis
Fundamentals of Data Analysis
The evolution of data analysis and why it is important
What makes a good data analyst?
Understanding data types and their significance
Data classifications and data attributes explained
Understanding data literacy
Summary
Further reading
3
Overview of Python and Installing Jupyter Notebook
Overview of Python and Installing Jupyter Notebook
Technical requirements
Installing Python and using Jupyter Notebook
Storing and retrieving data files
Hello World! – running your first Python code
Exploring Python packages
Summary
Future reading
4
Getting Started with NumPy
Getting Started with NumPy
Technical requirements
Understanding a Python NumPy array and its importance
Making your first NumPy array
Practical use cases of NumPy and arrays
Summary
Further reading
5
Creating Your First pandas DataFrame
Creating Your First pandas DataFrame
Technical requirements
Techniques for manipulating tabular data
Understanding pandas and DataFrames
Handling essential data formats
Data dictionaries and data types
Creating our first DataFrame
Summary
Further reading
6
Gathering and Loading Data in Python
chevron up
Gathering and Loading Data in Python
Technical requirements
Introduction to SQL and relational databases
From SQL to pandas DataFrames
Data about your data explained
The importance of data lineage
Summary
Further reading
7
Section 2: Solutions for Data Discovery
Section 2: Solutions for Data Discovery
8
Visualizing and Working with Time Series Data
Visualizing and Working with Time Series Data
Technical requirements
Data modeling for results
Anatomy of a chart and data viz best practices
Comparative analysis
The shape of the curve
Summary
Further reading
9
Exploring, Cleaning, Refining, and Blending Datasets
Exploring, Cleaning, Refining, and Blending Datasets
Technical requirements
Retrieving, viewing, and storing tabular data
Learning how to restrict, sort, and sift through data
Cleaning, refining, and purifying data using Python
Combining and binning data
Summary
Further reading
10
Understanding Joins, Relationships, and Aggregates
Understanding Joins, Relationships, and Aggregates
Technical requirements
Foundations of join relationships
Join types in action
Explaining data aggregation
Summary statistics and outliers
Summary
Further reading<a href="https://matplotlib.org/index.html">
11
Plotting, Visualization, and Storytelling
Plotting, Visualization, and Storytelling
Technical requirements
Explaining distribution analysis
Understanding outliers and trends
Geoanalytical techniques and tips
Finding patterns in data
Summary
Further reading
12
Section 3: Working with Unstructured Big Data
Section 3: Working with Unstructured Big Data
13
Exploring Text Data and Unstructured Data
Exploring Text Data and Unstructured Data
Technical requirements
Preparing to work with unstructured data
Tokenization explained
Counting words and exploring results
Normalizing text techniques
Excluding words from analysis
Summary
Further reading
14
Practical Sentiment Analysis
Practical Sentiment Analysis
Technical requirements
Why sentiment analysis is important
Elements of an NLP model
Sentiment analysis packages
Sentiment analysis in action
Summary
Further reading
15
Bringing It All Together
Bringing It All Together
Technical requirements
Discovering real-world datasets
Reporting results
The Capstone project
Summary
Further reading
16
Works Cited
Works Cited
17
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Gathering and Loading Data in Python

This chapter will explain what SQL isand why it is important for data analysis by teaching you how to use and access databases using SQLite for our examples. An overview of relational database technology will be provided along with insightful information on database systems to help to improve your data literacy when communicating with experts. You will also learn how to run SQLSELECTqueries from the Jupyter Notebook and how to load them into DataFrames. Basic statistics, data lineage, and metadata (data about data) will be explained using thepandaslibrary.

We will cover the following topics in this chapter:

  • Introduction to SQL and relational databases
  • From SQL to pandas DataFrames
  • Data about your data explained
  • The importance of data lineage

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 1
Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete