merge() joins two DataFrames on one or more key columns, like a SQL JOIN. The how parameter chooses the join type (inner, left, right, outer), on, left_on and right_on designate the keys, and suffixes tells apart columns with the same name.
Example
commandes.merge(clients, on='client_id', how='left')