Pandas DataFrame fuzzy/closest match merge

Asked Oct 02 '17 at 15:29

Active Oct 02 '17 at 15:29

Viewed 580 times

I have a Pandas DataFrame 1 (snippet below):

I have generated another Dataframe 2 with some similar headings. I need to match up and merge the rows in both df's under the columns "Date" (datetime object), Latitude and Longitude (integers).

I am aware of python's fuzzywuzzy module, but unsure of it's use.

asked Oct 02 '17 at 15:29

deanpwr

1

Can you post actual data/examples? – pazqo Oct 02 '17 at 15:30
Use `np.isclose`, – cs95 Oct 02 '17 at 15:34
go check `pandas.merge_asof` https://pandas.pydata.org/pandas-docs/stable/generated/pandas.merge_asof.html#pandas.merge_asof or library `fuzzywuzzy` – BENY Oct 02 '17 at 15:35

Pandas DataFrame fuzzy/closest match merge

0 Answers0