Merging and reshaping

merge is the pandas join: name the key and the kind of join you want. left keeps every row on the left, inner keeps only matches.

pivot_table reshapes long data into a matrix, aggregating duplicates as it goes.

melt does the reverse, turning wide columns back into rows.