'What merge type to use in this scenario [duplicate]

I want to merge these two dataframes on the Administrative port, and include the Longitude and Latitude from df2 in df1 with the correct port.

What type of merge would i use?df1

pandas dataframe merge

Solution 1:^[1]

You could try this.

df3 = pd.merge(df1, df2, how='left', on=['Administrative Port'])

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Manjunath K Mayya