. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 471 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 483 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise as row wise and database-like join/merge operations are pro- vided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 471 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 483 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise as row wise and database-like join/merge operations are pro- vided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 556 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise and row wise as database-like join/merge operations are provided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 518 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 520 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 533 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 534 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise and row wise as database-like join/merge operations are pro- vided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 542 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 544 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 558 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise and row wise as database-like join/merge operations are provided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 476 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 478 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise as row wise and database-like join/merge operations are pro- vided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 476 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 478 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise as row wise and database-like join/merge operations are pro- vided to combine multiple tables of data. To introduction tutorial

595641 B 1.266032 -0.051595 two A 0.462841 0.321594 B 2.705132 -0.580920 Pivot tables See the section on Pivot Tables. In [101]: df = pd.DataFrame({'A': ['one', 'one', 'two', 'three'] * 3, .....: 'B': 037506 10 two B bar -0.038648 -0.311520 11 three C bar 0.790319 -0.105583 We can produce pivot tables from this data very easily: In [103]: pd.pivot_table(df, values='D', index=['A', 'B'], columns=['C']) DataFrame({'key': ['B', 'D', 'D', 'E'], ....: 'value': np.random.randn(4)}) ....: Assume we have two database tables of the same name and structure as our DataFrames. Now let’s go over the various types of JOINs.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 558 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise and row wise as database-like join/merge operations are provided to combine multiple tables of data. To introduction tutorial

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541 2.8 Reshaping and pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543 2.8.1 Reshaping with stats and GroupBy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 2.8.5 Pivot tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 558 2.8.6 Straight to tutorial... Multiple tables can be concatenated both column wise and row wise as database-like join/merge operations are provided to combine multiple tables of data. To introduction tutorial