Reference¶

https://pandas.pydata.org/pandas-docs/stable/merging.html

http://stackoverflow.com/questions/22676081/pandas-the-difference-between-join-and-merge

Comment¶

1. You are able to specify (via left_on and right_on) which columns to join in each data frame.

2. Columns that appear in both data frames but not used in joining are distinguished using suffixes.

DataFrame.pivot vs pandas.pivot_table¶

1. Both DataFrame.pivot and pandas.pivot_table can generate pivot tables. pandas.pivot_table aggregate values while DataFrame.pivot not.