Matching columns from one data frame to another

Question

I have two dataframes (T and S). They both share a column name called ID but S has a latitude and longitude column. I would like to go through both data frames and match each lat and long to their appropriate IDs (station IDs in each DF is not in the same order) in dataframe T. These DFs are not the same size but they are both very large with some duplicates.

Perhaps start [here](https://stackoverflow.com/questions/1299871/how-to-join-merge-data-frames-inner-outer-left-right). — Ritchie Sacramento, Mar 17 '20 at 23:36

score 0 · Answer 1 · edited Mar 18 '20 at 00:14

0

print pd.merge(T, S, on='long' 'lat', how='inner')

edited Mar 18 '20 at 00:14

Dharman

30,962
25
85
135

answered Mar 17 '20 at 23:43

Omotayo Samson

13
4

Matching columns from one data frame to another

1 Answers1