Advanced Techniques for Exploring Data Sets with Pandas [Video]

Advanced Techniques for Exploring Data Sets with Pandas [Video]

Harish Garg

Explore popular datasets in R, while mastering advanced techniques used for them
Mapt Subscription
FREE
€29.98/m after trial
Video
€121.38
RRP €142.78
Save 14%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
€0.00
€121.38
€29.98p/m after trial
RRP €142.78
Subscription
Video
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Video Details

ISBN 139781788397599
Course Length1 hour 45 minutes

Video Description

In this course, you will learn how to start using pandas from end-to-end: from getting your data into pandas; using pandas to manipulate, transform, analyze, and visualize data; to ultimately taking your transformed data out of pandas into any number of formats.

This course will get you (or anyone who has never used pandas) started on using it as a complete end-to-end data analysis workflow. You will start by setting up Python, pandas, and Jupyter notebooks. You will learn how to use Jupyter notebooks to run Python code. We will then show how to get data into pandas and do some exploratory analysis. You will learn how to manipulate and reshape data using pandas methods. You will also learn how to deal with missing data from your datasets, how to draw charts and plots using pandas and Matplotlib, and how to create some cool visualizations for your audience. Finally, you will wrap-up your newly gained pandas knowledge by learning how to get data out of pandas into some popular file formats.

Style and Approach

This video course, which as a standalone course in itself, will begin by introducing a concept and very quickly the user can follow-on and start attempting code examples.

Table of Contents

Working with Different Kinds of Datasets
The Course Overview
Using Advanced Options While Reading Data from CSV Files
Reading Data from Excel Files
Reading Data from Some Other Popular Formats
Data Selection
Using Pandas Series Data Structure to Select a Subset of the Data
Selecting Multiple Rows and Columns from a Pandas DataFrame
Sorting a Pandas DataFrame or a Series
Filtering Rows of a Pandas DataFrame by Column Value
Applying Multiple Filter Criteria to a Pandas DataFrame
Using the "axis" Parameter in Pandas
Using String Methods in Pandas
Changing the Data Type of a Pandas Series
Manipulating, Transforming, and Reshaping Data
Modifying a Pandas DataFrame “inplace”
Using the "groupby" Method
Handling Missing Values in Pandas
Indexing in Pandas DataFrames
Renaming Columns in a Pandas DataFrame
Removing Columns from a Pandas DataFrame
Working with Dates and Times Data
Handling SettingWithCopyWarning
Applying a Function to a Pandas Series or DataFrame
Merging and Concatenating Multiple DataFrames into One
Visualizing Data Like a Pro
Controlling Plot Aesthetics
Choosing the Colors for the Plots
Plotting Categorical Data
Plotting with Data Aware Grids

What You Will Learn

  • Learn how to read different kinds of data into pandas DataFrames for data analysis
  • Practice how to manipulate, transform and apply formulas on data imported into pandas DataFrames
  • Master analyzing and visualizing different kinds of data using pandas to gain real-world insights
  • Use pandas to make predictions using Machine Learning and Scikit-learn
  • Work with big data using pandas
  • Manipulate quantitative financial data and model time-series data, perform algorithmic trading, derive results on fixed and moving windows, and more
  • Advance to the next level in pandas by learning complex techniques
  • Take transformed data out of pandas DataFrames and into the formats your application expects

Authors

Table of Contents

Working with Different Kinds of Datasets
The Course Overview
Using Advanced Options While Reading Data from CSV Files
Reading Data from Excel Files
Reading Data from Some Other Popular Formats
Data Selection
Using Pandas Series Data Structure to Select a Subset of the Data
Selecting Multiple Rows and Columns from a Pandas DataFrame
Sorting a Pandas DataFrame or a Series
Filtering Rows of a Pandas DataFrame by Column Value
Applying Multiple Filter Criteria to a Pandas DataFrame
Using the "axis" Parameter in Pandas
Using String Methods in Pandas
Changing the Data Type of a Pandas Series
Manipulating, Transforming, and Reshaping Data
Modifying a Pandas DataFrame “inplace”
Using the "groupby" Method
Handling Missing Values in Pandas
Indexing in Pandas DataFrames
Renaming Columns in a Pandas DataFrame
Removing Columns from a Pandas DataFrame
Working with Dates and Times Data
Handling SettingWithCopyWarning
Applying a Function to a Pandas Series or DataFrame
Merging and Concatenating Multiple DataFrames into One
Visualizing Data Like a Pro
Controlling Plot Aesthetics
Choosing the Colors for the Plots
Plotting Categorical Data
Plotting with Data Aware Grids

Video Details

ISBN 139781788397599
Course Length1 hour 45 minutes
Read More

Read More Reviews

Recommended for You

Advanced Techniques for Data Analysis with Scala [Video] Book Cover
Advanced Techniques for Data Analysis with Scala [Video]
€ 142.78
€ 121.38
Mastering Python Data Analysis with Pandas [Video] Book Cover
Mastering Python Data Analysis with Pandas [Video]
€ 142.78
€ 121.38
Advanced Data Mining projects with R [Video] Book Cover
Advanced Data Mining projects with R [Video]
€ 142.78
€ 121.38
Advanced Data Analysis with Haskell [Video] Book Cover
Advanced Data Analysis with Haskell [Video]
€ 130.78
€ 111.18
From 0 to 1 : Spark for Data Science with Python [Video] Book Cover
From 0 to 1 : Spark for Data Science with Python [Video]
€ 38.38
€ 32.64
Getting Started with R for Data Science [Video] Book Cover
Getting Started with R for Data Science [Video]
€ 93.58
€ 79.56