Introduction to Pandas for Developers

Video description

In this Introduction to Pandas for Developers training course, expert author Matt Harrison will teach you how to load data in Pandas data structures. This course is designed for users that are already familiar with Python.

You will start by learning about Python lists, Pandas series, and boolean arrays, then jump into learning about dataframes. From there, Matt will teach you about relational algebra, tweaking dataframes, and joins. This video tutorial also covers filtering dataframes, grouping, serialization, plotting, and time series. Finally, you will learn about machine learning and using Pandas with scikit-learn.

Once you have completed this computer based training course, you will have learned about basic workflows and gotchas of crawling, munging, and plotting data.

Table of contents

  1. Introduction
    1. What Is Pandas?
    2. About The Author
    3. Installation
    4. Pandas Vs. Other Platforms
  2. Basic Series
    1. Python Lists
    2. Numpy 1D Arrays
    3. Pandas Series
    4. Boolean Arrays
    5. Series Index
  3. More Series
    1. Data Types
    2. Iteration
    3. Broadcasting Operations
    4. Crud Operations Reading
    5. Crud Operations Update
    6. Crud Operations Deletion
    7. Summary Statistics
    8. Dealing With Duplicates
    9. Dealing With Nan
    10. Plotting
    11. Serialization
  4. Dataframe Basics
    1. Columnar Data
    2. Similarities To Python Dictionaries
    3. Creation From Lists And Dicts
    4. Reading CSV Files
  5. Relational Algebra
    1. Selection
    2. Projection
    3. Cartesian Product
    4. Union
    5. Difference
  6. More Dataframes
    1. Exploring Data
    2. Axes Of Dataframes
    3. Index And Columns
    4. Summary Statistics
    5. Histograms
    6. Transposing Data
  7. Tweaking Dataframes
    1. Adding Rows
    2. Adding Columns
    3. Applying Functions To Columns
    4. Removing Columns
    5. Sorting Data
    6. Iteration Over Data
    7. Setting Data
  8. Joins
    1. Concat With Rows
    2. Concat With Cols
    3. Inner Join
    4. Outer Join
    5. Left Join
    6. Right Join
    7. Join On Index
  9. Filtering Dataframes
    1. Filtering Columns
    2. Boolean Arrays
    3. Filtering Rows
    4. Using Functions To Filter
    5. Boolean Operations For Filtering
    6. Dealing With Nan
  10. Grouping
    1. Basic Grouping
    2. More Grouping
    3. Pivoting
    4. Stacking/Unstacking
  11. Serialization
    1. CSV Reading And Writing
    2. JSON
    3. Pickle
    4. Numpy
    5. Excel
  12. Plotting
    1. Basic Plotting
    2. Histograms
    3. Bar Plots
    4. Line Plots
    5. Faceting
  13. Time Series
    1. Date Manipulation
    2. Window Functions
    3. Plotting
  14. Machine Learning
    1. Using Pandas With Scikit-Learn
    2. Sample Regression
  15. Sample Application
    1. Crawling Data
    2. Crawling Data - Part 2
    3. Munging Data
    4. Munging Data - Part 2
    5. Plotting Data
    6. Creating An Infographic
    7. Creating An Infographic - Part 2
  16. Conclusion
    1. Conclusion

Product information

  • Title: Introduction to Pandas for Developers
  • Author(s): Matt Harrison
  • Release date: February 2016
  • Publisher(s): Infinite Skills
  • ISBN: 9781771375764