Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

merge on a Key: What an Inner Join Keeps and Drops

Lesson 10 of 22 Lab 🔒 Locked

Lessons in this course

  1. First Look: Sum, Mean & value_counts on a Real Orders TableLabFree
  2. Boolean Masks: Filtering Rows with &, | and ~Lab Locked
  3. groupby Basics: size, sum and mean per RegionLab Locked
  4. size vs count: Groups with Missing ValuesLab Locked
  5. Named Aggregation: min, max and nunique in One ReportLab Locked
  6. Two Keys and unstack: From MultiIndex to Cross-TableLab Locked
  7. transform: Group Totals and Shares on Every RowLab Locked
  8. Filtering Whole Groups: groupby().filter() as HAVINGLab Locked
  9. Ranking Inside Groups: rank, cumcount and Top-NLab Locked
  10. merge on a Key: What an Inner Join Keeps and DropsLab Locked
  11. Left Joins, indicator=True and the Duplicate-Key TrapLab Locked
  12. concat and drop_duplicates: Combining Overlapping ExportsLab Locked
  13. pivot_table: Default mean, aggfunc and marginsLab Locked
  14. melt: From Wide Spreadsheets to Tidy Long DataLab Locked
  15. Missing Values: isna, fillna and dropna Without Fooling YourselfLab Locked
  16. Gaps in a Series: ffill, bfill and interpolateLab Locked
  17. Dates with the .dt Accessor: Weekdays, Weekends and NamesLab Locked
  18. resample: Weekly Totals, Counts and Means from Raw OrdersLab Locked
  19. Rolling Windows: Moving Averages and min_periodsLab Locked
  20. shift, diff and pct_change: Month-over-Month GrowthLab Locked
  21. Plotting with pandas: Line for Time, Bars for CategoriesLab Locked
  22. Final Project: Merge, Filter, Group and Rank a Margin ReportLab Locked