0

I have the below data in a MySQL table: enter image description here

As you can see, there is a lot of missing data in the final five columns. I was able to find another source for this data and put it into a Pandas dataframe as shown below:

enter image description here

So I'm wondering if there's an easy way to impute the data from the Pandas data frame by doing a lookup on the player_first_name and player_last_name columns. I'm able to load the database table into Python and upload new data into it via Python, but not sure of a simple solution here. Any suggestions are welcome!

Sam Hoppen
  • 355
  • 2
  • 9
  • 1
    Does this answer your question? [Pandas Merging 101](https://stackoverflow.com/questions/53645882/pandas-merging-101) You will also want to merge on the `tournament_id` `year` and `round_number` not just the first and last name. – It_is_Chris Jan 18 '23 at 14:25

0 Answers0