0

I have two data frames with different sizes.

dataframe 1

Text                Topic
-----------------|------------------
"hello world"    |        5
                 |
"Good morning"   |        7
                 |
"String example" |        8
                 |  
"Yes or nor"     |        9

dataframe2

Tweet               Other columns
-----------------|------------------
"hello world"    |        ...
                 |
"Good morning"   |        ...
                 |
"String example" |        ...
                 |  
"Yes or nor"     |        ...
                 |
"Nice to meet "  |        ...
                 |
"Super"          |        ...

I would like to merge the dataframe1 and dataframe 2 based on the column Text(dataframe1) and Tweet(dataframe2).

coding
  • 541
  • 1
  • 5
  • 17
  • `df1.merge(df2, left_on='Text', right_on='Tweet')` or something like that. You haven't explained what kind of merge you're looking for. – Henry Ecker Sep 21 '21 at 23:27

0 Answers0