I have a dataset (df) that contains the company name and country, I have about 900 such lines.
| № | Company | Country |
|---|---|---|
| 1 | OAO1 | United States |
| 2 | OAA2 | Three |
In another dataset (district) I have the name of the country and its location, about 162 lines
| № | Country | Location |
|---|---|---|
| 1 | Fiji | MULTIPOLYGON (((180 |
| 2 | Canada | POLYGON (((33 |
How can I merge these two datasets into one so that each company and its country will be associated to the location from the dataset district?
I need it for the future steps with geopandas.
