by Theodore Petrou | Released May 2018 | ISBN: 9781789343205

Get idiomatic solutions to common data problems while working on real-world datasets and get surprising insights from the pandas libraryAbout This VideoEnhance your data exploration and machine learning skills by gaining surprising insights from pandas and using expert tips and tricks.Solve most complex scientific computing problems with ease using the power of pandasLeverage fast, robust data structures in pandas to gain useful insights from your dataIn DetailAre you looking for a gigantic boost in your productivity? Are you searching for some interesting and fun tricks to solve your data problems? If so, then this course is indeed a perfect choice for you. This course provides you with unique, idiomatic, and amazing solutions for both fundamental and advanced data manipulation tasks with pandas.Some solutions focus on achieving a deeper understanding of basic principles, or comparing and contrasting two similar operations. A few others will delve into a particular dataset, and let you uncover 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 as one would do during an actual analysis. This course 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 solutions combine several different features across the pandas library to generate results.The code bundle for the video course is available at - https://github.com/PacktPublishing/Data-Analysis-and-Exploration-with-Pandas Show and hide more Publisher Resources Download Example Code

1. Chapter 1 : Pandas Foundations
   • The Course Overview 00:04:29
   • Dissecting the Anatomy of a DataFrame 00:04:32
   • Accessing the Main DataFrame Components 00:03:13
   • Understanding Data Types 00:03:17
   • Selecting a Single Column of Data as a Series 00:02:54
   • Calling Series Methods 00:05:51
   • Working with Operators on a Series 00:04:47
   • Chaining Series Methods Together 00:03:49
   • Making the Index Meaningful 00:02:18
   • Renaming Row and Column Names 00:02:31
   • Creating and Deleting Columns 00:05:06
2. Chapter 2 : Essential DataFrame Operations
   • Selecting Multiple DataFrame Columns 00:03:42
   • Selecting Columns with Methods 00:03:42
   • Ordering Column Names Sensibly 00:03:18
   • Operating on the Entire DataFrame 00:02:50
   • Chaining DataFrame Methods Together 00:02:35
   • Working with Operators on a DataFrame 00:04:46
   • Comparing Missing Values 00:03:09
   • Transposing the Direction of a DataFrame Operation 00:02:34
   • Determining College Campus Diversity 00:05:24
3. Chapter 3 : Beginning Data Analysis
   • Developing a Data Analysis Routine 00:05:08
   • Reducing Memory by Changing Data Types 00:04:49
   • Selecting the Smallest of the Largest 00:01:56
   • Selecting the Largest of Each Group by Sorting 00:02:22
   • Replicating nlargest with sort_values 00:02:27
4. Chapter 4 : Selecting Subsets of Data
   • Selecting Series Data 00:05:00
   • Selecting DataFrame Rows 00:02:33
   • Selecting DataFrame Rows and Columns Simultaneously 00:03:18
   • Selecting Data with Both Integers and Labels 00:03:13
   • Speeding Up Scalar Selection 00:03:11
   • Slicing Rows Lazily 00:03:08
   • Slicing Lexicographically 00:02:34
5. Chapter 5 : Boolean Indexing
   • Calculating Boolean Statistics 00:05:36
   • Constructing Multiple Boolean Conditions 00:02:57
   • Filtering with Boolean Indexing 00:02:33
   • Replicating Boolean Indexing with Index Selection 00:02:29
   • Selecting with Unique and Sorted Indexes 00:03:02
   • Gaining Perspective on Stock Prices 00:03:15
   • Translating SQL WHERE Clauses 00:03:07
   • Determining the Normality of Stock Market Returns 00:03:54
   • Improving Readability of Boolean Indexing with the Query Method 00:02:30
   • Preserving Series with the WHERE Method 00:03:54
   • Masking DataFrame Rows 00:04:03
   • Selecting with Booleans, Integer Location, and Labels 00:04:38
6. Chapter 6 : Index Alignment
   • Examining the Index Object 00:02:46
   • Producing Cartesian Products 00:04:26
   • Exploding Indexes 00:02:55
   • Filling Values with Unequal Indexes 00:03:18
   • Appending Columns from Different DataFrames 00:02:41
   • Highlighting the Maximum Value from Each Column 00:04:06
   • Replicating idxmax with Method Chaining 00:04:32
   • Finding the Most Common Maximum 00:02:32
7. Chapter 7 : Grouping for Aggregation, Filtration, and Transformation
   • Defining an Aggregation 00:06:00
   • Grouping and Aggregating with Multiple Columns and Functions 00:02:25
   • Removing the MultiIndex After Grouping 00:02:52
   • Customizing an Aggregation Function 00:03:22
   • Customizing Aggregating Functions with *args and **kwargs 00:02:07
   • Examining the groupby Object 00:02:57
   • Filtering for States with a Minority Majority 00:03:23
   • Transforming through a Weight Loss Bet 00:05:08
   • Calculating Weighted Mean SAT Scores Per State with Apply 00:04:50
   • Grouping By Continuous Variables 00:03:16
   • Counting the Total Number of Flights Between Cities 00:03:41
   • Finding the Longest Streak of On-Time Flights 00:06:42
8. Chapter 8 : Restructuring Data into a Tidy Form
   • Tidying Variable Values as Column Names with Stack 00:05:06
   • Tidying Variable Values as Column Names with Melt 00:02:48
   • Stacking Multiple Groups of Variables Simultaneously 00:04:28
   • Inverting Stacked Data 00:03:12
   • Unstacking After a groupby Aggregation 00:02:40
   • Replicating pivot_table with a groupby Aggregation 00:03:02
   • Renaming Axis Levels for Easy Reshaping 00:03:38
   • Tidying When Multiple Variables are Stored as Column Names 00:03:16
   • Tidying When Multiple Variables are Stored as Column Values 00:02:53
   • Tidying When Two or More Values are Stored in the Same Cell 00:02:45
   • Tidying When Variables are Stored in Column Names and Values 00:01:42
   • Tidying When Multiple Observational Units are Stored in the Same Table 00:05:12
9. Chapter 9 : Combining Pandas Objects
   • Appending New Rows to DataFrames 00:07:50
   • Concatenating Multiple DataFrames Together 00:03:15
   • Comparing President Trump's and Obama's Approval Ratings 00:15:45
   • Understanding the Differences Between concat, join, and merge 00:09:08
   • Connecting to SQL Databases 00:05:46
Show and hide more