How can I "automate" a search for global gross based on movie name and put my search results into my dataframe?

My team and I (first year cs uni students) are currently doing a project based on IMDB 5000 dataset obtained from kaggle : https://www.kaggle.com/datasets/carolzhangdc/imdb-5000-movie-dataset

While doing EDA, we realised that the gross entries are inconsistent, for example, some movies like My Date with Drew has a gross of 85222, which, we found, was based on its opening weekend.

Then we have movies like Compliance which has gross of 318622, but this refers to Gross US Canada.

My question is, how can we standardise this gross? I was thinking if we could create a search algorithm for each movie, and append a new column with its corresponding global gross, that would help to standardise it.

Thank you in advance!