martj42 / international_results

https://www.kaggle.com/martj42/international-football-results-from-1872-to-2017
Creative Commons Zero v1.0 Universal
133 stars 29 forks source link

correcting match results csv #29

Closed 16bravo closed 7 months ago

16bravo commented 7 months ago

While using this dataset, I noticed some errors that were returning surprising results. I therefore corrected the following erroneous matches:

04/04/2000 : Syria - Maldives 2 - 1 ==> 6 - 0 15/11/2006 : Bolivia - El Salvador 4 - 1 ==> 5 - 1 20/05/2007 : Guadeloupe - Dominica 0 - 0 ==> 1 - 1 12/10/2010 : Equatorial Guinea - Botswana 2 - 1 ==> 0 - 2 09/02/2011 : Senegal - Guinea 4 - 0 ==> 3 - 0 20/05/2011 : Guyana - Barbados 0 - 1 ==> 1 - 0 29/05/2011 : Barbados - Guyana 1 - 0 ==> 1 - 1 03/09/2011 : Cameroon - Mauritius 6 - 0 ==> 5 - 0 08/10/2011 : Liberia - Mali 1 - 2 ==> 2 - 2 25/12/2014 : Uzbekistan - Iraq 0 - 1 ==> 1 - 0 02/12/2017 : Vanuatu - New Caledonia 1 - 2 ==> 2 - 1 15/12/2017 : Fiji - New Caledonia 2 - 3 ==> 4 - 1 26/03/2019 : Japan - Bolivia 0 - 1 ==> 1 - 0 02/06/2019 : Turkey - Uzbekistan 0 - 0 ==> 2 - 0 18/07/2019 : Tahiti - Eastern Samoa 0 - 8 ==> 8 - 1 16/11/2020 : United Arab Emirates - Bahrain 1 - 0 ==> 1 - 3 01/06/2022 : Kuwait - Singapore 0 - 0 ==> 2 - 0 12/09/2023 : Japan - Turkey 4 - 4 ==> 4 - 2

Even though I've already done it myself, you can check that all these results are correct. I've only done the matches after 2000 and I haven't edited the matches won by forfeit (which automatically gives a 3-0 victory).

martj42 commented 7 months ago

Great, thanks!

I think the Tahiti - American Samoa one should be 8-1, not 8-0 though.

16bravo commented 7 months ago

Ah, yes! I've just fixed it, it should be fine now