by Matt Harrison | Released February 2016 | ISBN: 9781771375764

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. Show and hide more Publisher resources Download Example Code

1. Introduction
   • What Is Pandas? 00:02:27
   • About The Author 00:00:43
   • Installation 00:03:52
   • Pandas Vs. Other Platforms 00:03:30
2. Basic Series
   • Python Lists 00:02:30
   • Numpy 1D Arrays 00:04:40
   • Pandas Series 00:02:48
   • Boolean Arrays 00:03:35
   • Series Index 00:03:23
3. More Series
   • Data Types 00:03:24
   • Iteration 00:03:30
   • Broadcasting Operations 00:06:01
   • Crud Operations Reading 00:07:01
   • Crud Operations Update 00:05:25
   • Crud Operations Deletion 00:02:23
   • Summary Statistics 00:04:42
   • Dealing With Duplicates 00:06:23
   • Dealing With Nan 00:05:59
   • Plotting 00:02:40
   • Serialization 00:04:47
4. Dataframe Basics
   • Columnar Data 00:03:54
   • Similarities To Python Dictionaries 00:05:00
   • Creation From Lists And Dicts 00:04:00
   • Reading CSV Files 00:01:49
5. Relational Algebra
   • Selection 00:08:16
   • Projection 00:03:30
   • Cartesian Product 00:06:55
   • Union 00:03:53
   • Difference 00:02:57
6. More Dataframes
   • Exploring Data 00:03:40
   • Axes Of Dataframes 00:02:02
   • Index And Columns 00:03:03
   • Summary Statistics 00:03:48
   • Histograms 00:05:09
   • Transposing Data 00:01:39
7. Tweaking Dataframes
   • Adding Rows 00:06:33
   • Adding Columns 00:02:58
   • Applying Functions To Columns 00:04:12
   • Removing Columns 00:02:35
   • Sorting Data 00:05:23
   • Iteration Over Data 00:05:33
   • Setting Data 00:05:34
8. Joins
   • Concat With Rows 00:03:08
   • Concat With Cols 00:01:44
   • Inner Join 00:02:23
   • Outer Join 00:03:29
   • Left Join 00:02:47
   • Right Join 00:01:24
   • Join On Index 00:01:49
9. Filtering Dataframes
   • Filtering Columns 00:02:47
   • Boolean Arrays 00:01:04
   • Filtering Rows 00:01:04
   • Using Functions To Filter 00:04:11
   • Boolean Operations For Filtering 00:02:38
   • Dealing With Nan 00:03:44
10. Grouping
    • Basic Grouping 00:03:16
    • More Grouping 00:03:58
    • Pivoting 00:04:04
    • Stacking/Unstacking 00:02:50
11. Serialization
    • CSV Reading And Writing 00:07:19
    • JSON 00:05:26
    • Pickle 00:01:33
    • Numpy 00:02:33
    • Excel 00:03:32
12. Plotting
    • Basic Plotting 00:05:20
    • Histograms 00:06:02
    • Bar Plots 00:02:44
    • Line Plots 00:03:09
    • Faceting 00:05:23
13. Time Series
    • Date Manipulation 00:05:07
    • Window Functions 00:05:30
    • Plotting 00:01:38
14. Machine Learning
    • Using Pandas With Scikit-Learn 00:05:39
    • Sample Regression 00:04:37
15. Sample Application
    • Crawling Data 00:08:53
    • Crawling Data - Part 2 00:05:33
    • Munging Data 00:07:51
    • Munging Data - Part 2 00:06:53
    • Plotting Data 00:09:09
    • Creating An Infographic 00:05:36
    • Creating An Infographic - Part 2 00:06:02
16. Conclusion
    • Conclusion 00:00:33
Show and hide more