0
$\begingroup$

First dataframeI've added the images of both the dataframes here. Now I need to combine the two dataframes on the basis of two conditions:

Condition 1: The element in the 'arrivalTS' column in the first dataframe(flight_weather) and the element in the 'weatherTS' column element in the second dataframe(weatherdataatl) must be equal.

condition 2: The element in the 'DEST' column in the first dataframe(flight_weather) and the element in the 'place' column in the second dataframe(weatherdataatl) must be equal.

I tried the joins function but wasn't able to add both the conditions to it. it will be helpful if you could help me join them with the join/merge function. Thanks in advance.

first [![second dataframedataframe]3]3

Improve this question
$\endgroup$

1 Answer 1

Reset to default
2
$\begingroup$

Follow mentioned link for your problems.

https://www.shanelynn.ie/merge-join-dataframes-python-pandas-index-1/

Improve this answer
$\endgroup$
0

Not the answer you're looking for? Browse other questions tagged or ask your own question.