convert.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting pandas\n",
      "  Downloading pandas-2.2.1-cp312-cp312-macosx_11_0_arm64.whl.metadata (19 kB)\n",
      "Collecting numpy<2,>=1.26.0 (from pandas)\n",
      "  Using cached numpy-1.26.4-cp312-cp312-macosx_11_0_arm64.whl.metadata (61 kB)\n",
      "Requirement already satisfied: python-dateutil>=2.8.2 in ./.venv/lib/python3.12/site-packages (from pandas) (2.9.0.post0)\n",
      "Collecting pytz>=2020.1 (from pandas)\n",
      "  Downloading pytz-2024.1-py2.py3-none-any.whl.metadata (22 kB)\n",
      "Collecting tzdata>=2022.7 (from pandas)\n",
      "  Downloading tzdata-2024.1-py2.py3-none-any.whl.metadata (1.4 kB)\n",
      "Requirement already satisfied: six>=1.5 in ./.venv/lib/python3.12/site-packages (from python-dateutil>=2.8.2->pandas) (1.16.0)\n",
      "Downloading pandas-2.2.1-cp312-cp312-macosx_11_0_arm64.whl (11.3 MB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m11.3/11.3 MB\u001b[0m \u001b[31m4.9 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m00:01\u001b[0m00:01\u001b[0m\n",
      "\u001b[?25hUsing cached numpy-1.26.4-cp312-cp312-macosx_11_0_arm64.whl (13.7 MB)\n",
      "Downloading pytz-2024.1-py2.py3-none-any.whl (505 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m505.5/505.5 kB\u001b[0m \u001b[31m5.6 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0ma \u001b[36m0:00:01\u001b[0m\n",
      "\u001b[?25hDownloading tzdata-2024.1-py2.py3-none-any.whl (345 kB)\n",
      "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m345.4/345.4 kB\u001b[0m \u001b[31m2.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0ma \u001b[36m0:00:01\u001b[0m\n",
      "\u001b[?25hInstalling collected packages: pytz, tzdata, numpy, pandas\n",
      "Successfully installed numpy-1.26.4 pandas-2.2.1 pytz-2024.1 tzdata-2024.1\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "%pip install pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Year: 2014.0, Country: Germany, Goals: 104.0\n",
      "Year: 1954.0, Country: Hungary, Goals: 47.0\n",
      "Year: 1954.0, Country: Germany FR, Goals: 25.0\n",
      "Year: 1958.0, Country: France, Goals: 36.0\n",
      "Year: 1950.0, Country: Brazil, Goals: 42.0\n",
      "Year: 2014.0, Country: Netherlands, Goals: 91.0\n",
      "Year: 1970.0, Country: Brazil, Goals: 103.0\n",
      "Year: 2002.0, Country: Brazil, Goals: 191.0\n",
      "Year: 1930.0, Country: Argentina, Goals: 18.0\n",
      "Year: 1970.0, Country: Germany FR, Goals: 73.0\n",
      "Year: 1966.0, Country: Portugal, Goals: 17.0\n",
      "Year: 1954.0, Country: Austria, Goals: 24.0\n",
      "Year: 1974.0, Country: Poland, Goals: 21.0\n",
      "Year: 2010.0, Country: Germany, Goals: 75.0\n",
      "Year: 1958.0, Country: Brazil, Goals: 66.0\n",
      "Year: 1982.0, Country: France, Goals: 59.0\n",
      "Year: 1954.0, Country: Uruguay, Goals: 46.0\n",
      "Year: 1982.0, Country: Brazil, Goals: 134.0\n",
      "Year: 1994.0, Country: Sweden, Goals: 66.0\n",
      "Year: 1950.0, Country: Uruguay, Goals: 30.0\n",
      "Year: 1998.0, Country: France, Goals: 86.0\n",
      "Year: 1974.0, Country: Netherlands, Goals: 17.0\n",
      "Year: 1978.0, Country: Netherlands, Goals: 32.0\n",
      "Year: 1966.0, Country: Germany FR, Goals: 56.0\n",
      "Year: 2014.0, Country: Brazil, Goals: 225.0\n",
      "Year: 1978.0, Country: Argentina, Goals: 55.0\n",
      "Year: 1938.0, Country: Hungary, Goals: 20.0\n",
      "Year: 1990.0, Country: Germany FR, Goals: 131.0\n",
      "Year: 1930.0, Country: Uruguay, Goals: 15.0\n",
      "Year: 2014.0, Country: Colombia, Goals: 29.0\n",
      "Year: 1998.0, Country: Brazil, Goals: 173.0\n",
      "Year: 1938.0, Country: Brazil, Goals: 20.0\n",
      "Year: 1962.0, Country: Brazil, Goals: 80.0\n",
      "Year: 2006.0, Country: Germany, Goals: 59.0\n",
      "Year: 2002.0, Country: Germany, Goals: 45.0\n",
      "Year: 1986.0, Country: Argentina, Goals: 77.0\n",
      "Year: 1974.0, Country: Germany FR, Goals: 86.0\n",
      "Year: 1998.0, Country: Netherlands, Goals: 56.0\n",
      "Year: 1986.0, Country: Belgium, Goals: 27.0\n",
      "Year: 1982.0, Country: Hungary, Goals: 85.0\n",
      "Year: 1986.0, Country: France, Goals: 71.0\n",
      "Year: 1934.0, Country: Italy, Goals: 12.0\n",
      "Year: 2014.0, Country: France, Goals: 108.0\n",
      "Year: 2010.0, Country: Netherlands, Goals: 71.0\n",
      "Year: 1982.0, Country: Italy, Goals: 74.0\n",
      "Year: 1958.0, Country: Germany FR, Goals: 37.0\n",
      "Year: 1986.0, Country: Soviet Union, Goals: 49.0\n",
      "Year: 1982.0, Country: Germany FR, Goals: 108.0\n",
      "Year: 1958.0, Country: Sweden, Goals: 38.0\n",
      "Year: 1974.0, Country: Yugoslavia, Goals: 45.0\n",
      "Year: 2006.0, Country: Italy, Goals: 122.0\n",
      "Year: 1966.0, Country: England, Goals: 30.0\n",
      "Year: 1954.0, Country: Switzerland, Goals: 25.0\n",
      "Year: 1934.0, Country: Germany, Goals: 11.0\n",
      "Year: 1938.0, Country: Italy, Goals: 23.0\n",
      "Year: 2006.0, Country: Argentina, Goals: 113.0\n",
      "Year: 1998.0, Country: Croatia, Goals: 11.0\n",
      "Year: 2010.0, Country: Uruguay, Goals: 76.0\n",
      "Year: 1982.0, Country: Poland, Goals: 38.0\n",
      "Year: 1938.0, Country: Sweden, Goals: 15.0\n",
      "Year: 1986.0, Country: Spain, Goals: 37.0\n",
      "Year: 1950.0, Country: Sweden, Goals: 26.0\n",
      "Year: 1994.0, Country: Brazil, Goals: 159.0\n",
      "Year: 2006.0, Country: Brazil, Goals: 201.0\n",
      "Year: 1998.0, Country: Argentina, Goals: 100.0\n",
      "Year: 1990.0, Country: Czechoslovakia, Goals: 44.0\n",
      "Year: 1966.0, Country: Soviet Union, Goals: 24.0\n",
      "Year: 1994.0, Country: Spain, Goals: 53.0\n",
      "Year: 1994.0, Country: Bulgaria, Goals: 21.0\n",
      "Year: 1970.0, Country: Italy, Goals: 48.0\n",
      "Year: 1990.0, Country: Italy, Goals: 89.0\n",
      "Year: 1962.0, Country: Chile, Goals: 20.0\n",
      "Year: 1986.0, Country: Denmark, Goals: 10.0\n",
      "Year: 2002.0, Country: Spain, Goals: 71.0\n",
      "Year: 1954.0, Country: Turkey, Goals: 10.0\n",
      "Year: 1978.0, Country: Brazil, Goals: 119.0\n",
      "Year: 2010.0, Country: Argentina, Goals: 123.0\n",
      "Year: 1962.0, Country: Yugoslavia, Goals: 33.0\n",
      "Year: 1994.0, Country: Romania, Goals: 26.0\n",
      "Year: 2014.0, Country: Argentina, Goals: 133.0\n",
      "Year: 1950.0, Country: Spain, Goals: 14.0\n",
      "Year: 1978.0, Country: Germany FR, Goals: 96.0\n",
      "Year: 2002.0, Country: Turkey, Goals: 20.0\n",
      "Year: 1986.0, Country: Brazil, Goals: 144.0\n",
      "Year: 1978.0, Country: Italy, Goals: 62.0\n",
      "Year: 2006.0, Country: France, Goals: 95.0\n",
      "Year: 1998.0, Country: Denmark, Goals: 19.0\n",
      "Year: 1974.0, Country: Argentina, Goals: 40.0\n",
      "Year: 1962.0, Country: Soviet Union, Goals: 14.0\n",
      "Year: 1970.0, Country: Peru, Goals: 10.0\n",
      "Year: 1958.0, Country: Paraguay, Goals: 12.0\n",
      "Year: 1958.0, Country: Czechoslovakia, Goals: 23.0\n",
      "Year: 1934.0, Country: Czechoslovakia, Goals: 9.0\n",
      "Year: 2010.0, Country: Brazil, Goals: 210.0\n",
      "Year: 2006.0, Country: Spain, Goals: 80.0\n",
      "Year: 1994.0, Country: Germany, Goals: 23.0\n",
      "Year: 1994.0, Country: Argentina, Goals: 90.0\n",
      "Year: 1966.0, Country: Hungary, Goals: 70.0\n",
      "Year: 1990.0, Country: England, Goals: 55.0\n",
      "Year: 1994.0, Country: Italy, Goals: 97.0\n",
      "Year: 1998.0, Country: Spain, Goals: 61.0\n",
      "Year: 2010.0, Country: Spain, Goals: 88.0\n",
      "Year: 1990.0, Country: Yugoslavia, Goals: 55.0\n",
      "Year: 2014.0, Country: Algeria, Goals: 14.0\n",
      "Year: 2014.0, Country: Belgium, Goals: 54.0\n",
      "Year: 2002.0, Country: Korea Republic, Goals: 19.0\n",
      "Year: 1986.0, Country: Germany FR, Goals: 116.0\n",
      "Year: 1994.0, Country: Netherlands, Goals: 43.0\n",
      "Year: 1998.0, Country: Italy, Goals: 105.0\n",
      "Year: 1998.0, Country: Germany, Goals: 31.0\n",
      "Year: 1998.0, Country: Mexico, Goals: 39.0\n",
      "Year: 1954.0, Country: England, Goals: 10.0\n",
      "Year: 1982.0, Country: Argentina, Goals: 63.0\n",
      "Year: 1982.0, Country: Scotland, Goals: 20.0\n",
      "Year: 1962.0, Country: Hungary, Goals: 62.0\n",
      "Year: 1954.0, Country: Brazil, Goals: 50.0\n",
      "Year: 1998.0, Country: England, Goals: 62.0\n",
      "Year: 1990.0, Country: Cameroon, Goals: 8.0\n",
      "Year: 1930.0, Country: USA, Goals: 7.0\n",
      "Year: 1994.0, Country: Nigeria, Goals: 7.0\n",
      "Year: 1974.0, Country: Sweden, Goals: 47.0\n",
      "Year: 1982.0, Country: Soviet Union, Goals: 37.0\n",
      "Year: 1978.0, Country: Austria, Goals: 33.0\n",
      "Year: 1978.0, Country: Peru, Goals: 17.0\n",
      "Year: 1994.0, Country: Russia, Goals: 7.0\n",
      "Year: 2014.0, Country: Switzerland, Goals: 45.0\n",
      "Year: 1986.0, Country: England, Goals: 47.0\n",
      "Year: 2014.0, Country: Chile, Goals: 41.0\n",
      "Year: 1930.0, Country: Yugoslavia, Goals: 7.0\n",
      "Year: 1958.0, Country: Yugoslavia, Goals: 23.0\n",
      "Year: 2002.0, Country: Senegal, Goals: 7.0\n",
      "Year: 2006.0, Country: Portugal, Goals: 32.0\n",
      "Year: 1962.0, Country: Czechoslovakia, Goals: 30.0\n",
      "Year: 1958.0, Country: Hungary, Goals: 54.0\n",
      "Year: 2002.0, Country: USA, Goals: 25.0\n",
      "Year: 1950.0, Country: Yugoslavia, Goals: 14.0\n",
      "Year: 2010.0, Country: Portugal, Goals: 39.0\n",
      "Year: 1934.0, Country: Austria, Goals: 7.0\n",
      "Year: 1990.0, Country: Spain, Goals: 43.0\n",
      "Year: 2010.0, Country: Korea Republic, Goals: 28.0\n",
      "Year: 1970.0, Country: Mexico, Goals: 19.0\n",
      "Year: 1958.0, Country: Northern Ireland, Goals: 6.0\n",
      "Year: 2014.0, Country: USA, Goals: 38.0\n",
      "Year: 2006.0, Country: England, Goals: 74.0\n",
      "Year: 1978.0, Country: Poland, Goals: 27.0\n",
      "Year: 1954.0, Country: Italy, Goals: 33.0\n",
      "Year: 2002.0, Country: rn\">Republic of Ireland, Goals: 10.0\n",
      "Year: 1974.0, Country: Brazil, Goals: 109.0\n",
      "Year: 1998.0, Country: Nigeria, Goals: 13.0\n",
      "Year: 2002.0, Country: England, Goals: 68.0\n",
      "Year: 2014.0, Country: Croatia, Goals: 21.0\n",
      "Year: 1970.0, Country: Soviet Union, Goals: 30.0\n",
      "Year: 1986.0, Country: Mexico, Goals: 27.0\n",
      "Year: 2014.0, Country: Costa Rica, Goals: 18.0\n",
      "Year: 2002.0, Country: Belgium, Goals: 46.0\n",
      "Year: 2014.0, Country: Mexico, Goals: 58.0\n",
      "Year: 2002.0, Country: Portugal, Goals: 25.0\n",
      "Year: 1982.0, Country: England, Goals: 40.0\n",
      "Year: 2002.0, Country: Paraguay, Goals: 25.0\n",
      "Year: 1990.0, Country: Belgium, Goals: 33.0\n",
      "Year: 1950.0, Country: Chile, Goals: 10.0\n",
      "Year: 2010.0, Country: USA, Goals: 32.0\n",
      "Year: 1990.0, Country: Argentina, Goals: 82.0\n",
      "Year: 1958.0, Country: Soviet Union, Goals: 5.0\n",
      "Year: 2006.0, Country: Mexico, Goals: 48.0\n",
      "Year: 1930.0, Country: Brazil, Goals: 5.0\n",
      "Year: 1938.0, Country: Cuba, Goals: 5.0\n",
      "Year: 1938.0, Country: Czechoslovakia, Goals: 14.0\n",
      "Year: 1994.0, Country: Switzerland, Goals: 33.0\n",
      "Year: 1982.0, Country: Northern Ireland, Goals: 11.0\n",
      "Year: 1938.0, Country: Poland, Goals: 5.0\n",
      "Year: 1954.0, Country: Belgium, Goals: 8.0\n",
      "Year: 1958.0, Country: Argentina, Goals: 25.0\n",
      "Year: 1986.0, Country: Italy, Goals: 79.0\n",
      "Year: 1938.0, Country: Switzerland, Goals: 10.0\n",
      "Year: 2006.0, Country: Ukraine, Goals: 5.0\n",
      "Year: 2010.0, Country: Slovakia, Goals: 5.0\n",
      "Year: 1934.0, Country: Hungary, Goals: 5.0\n",
      "Year: 2010.0, Country: Ghana, Goals: 9.0\n",
      "Year: 1994.0, Country: Saudi Arabia, Goals: 5.0\n",
      "Year: 2002.0, Country: Japan, Goals: 6.0\n",
      "Year: 1998.0, Country: Chile, Goals: 31.0\n",
      "Year: 1998.0, Country: Morocco, Goals: 12.0\n",
      "Year: 2002.0, Country: Italy, Goals: 110.0\n",
      "Year: 1934.0, Country: Switzerland, Goals: 5.0\n",
      "Year: 2002.0, Country: Denmark, Goals: 24.0\n",
      "Year: 2002.0, Country: Costa Rica, Goals: 9.0\n",
      "Year: 1970.0, Country: Bulgaria, Goals: 7.0\n",
      "Year: 1974.0, Country: German DR, Goals: 5.0\n",
      "Year: 1998.0, Country: Yugoslavia, Goals: 60.0\n",
      "Year: 1974.0, Country: Italy, Goals: 53.0\n",
      "Year: 2002.0, Country: South Africa, Goals: 8.0\n",
      "Year: 1998.0, Country: Norway, Goals: 7.0\n",
      "Year: 1966.0, Country: Korea DPR, Goals: 5.0\n",
      "Year: 1978.0, Country: France, Goals: 43.0\n",
      "Year: 2002.0, Country: Sweden, Goals: 71.0\n",
      "Year: 1982.0, Country: Austria, Goals: 38.0\n",
      "Year: 1962.0, Country: England, Goals: 19.0\n",
      "Year: 1962.0, Country: Colombia, Goals: 5.0\n",
      "Year: 1930.0, Country: Chile, Goals: 5.0\n",
      "Year: 2006.0, Country: Australia, Goals: 5.0\n",
      "Year: 2006.0, Country: C�te d'Ivoire, Goals: 5.0\n",
      "Year: 1982.0, Country: Algeria, Goals: 5.0\n",
      "Year: 2006.0, Country: Ecuador, Goals: 7.0\n",
      "Year: 1978.0, Country: Scotland, Goals: 12.0\n",
      "Year: 2014.0, Country: Ghana, Goals: 13.0\n",
      "Year: 2002.0, Country: Uruguay, Goals: 65.0\n",
      "Year: 2014.0, Country: Uruguay, Goals: 80.0\n",
      "Year: 2014.0, Country: Portugal, Goals: 43.0\n",
      "Year: 1990.0, Country: Soviet Union, Goals: 53.0\n",
      "Year: 2002.0, Country: Mexico, Goals: 43.0\n",
      "Year: 1990.0, Country: Romania, Goals: 16.0\n",
      "Year: 2006.0, Country: Switzerland, Goals: 37.0\n",
      "Year: 1998.0, Country: Romania, Goals: 30.0\n",
      "Year: 1994.0, Country: Belgium, Goals: 37.0\n",
      "Year: 2002.0, Country: Russia, Goals: 11.0\n",
      "Year: 1994.0, Country: Colombia, Goals: 13.0\n",
      "Year: 2010.0, Country: Mexico, Goals: 52.0\n",
      "Year: 2014.0, Country: Spain, Goals: 92.0\n",
      "Year: 1994.0, Country: Korea Republic, Goals: 9.0\n",
      "Year: 2006.0, Country: Ghana, Goals: 4.0\n",
      "Year: 2010.0, Country: Japan, Goals: 12.0\n",
      "Year: 2010.0, Country: Italy, Goals: 126.0\n",
      "Year: 2010.0, Country: C�te d'Ivoire, Goals: 9.0\n",
      "Year: 2014.0, Country: C�te d'Ivoire, Goals: 13.0\n",
      "Year: 2014.0, Country: Greece, Goals: 6.0\n",
      "Year: 1994.0, Country: Mexico, Goals: 31.0\n",
      "Year: 2014.0, Country: rn\">Bosnia and Herzegovina, Goals: 4.0\n",
      "Year: 1990.0, Country: Costa Rica, Goals: 4.0\n",
      "Year: 1962.0, Country: Germany FR, Goals: 41.0\n",
      "Year: 1950.0, Country: Switzerland, Goals: 14.0\n",
      "Year: 1950.0, Country: Italy, Goals: 27.0\n",
      "Year: 1982.0, Country: Spain, Goals: 26.0\n",
      "Year: 1938.0, Country: Romania, Goals: 8.0\n",
      "Year: 1958.0, Country: England, Goals: 14.0\n",
      "Year: 1938.0, Country: France, Goals: 10.0\n",
      "Year: 1934.0, Country: Sweden, Goals: 4.0\n",
      "Year: 1934.0, Country: Spain, Goals: 4.0\n",
      "Year: 1958.0, Country: Scotland, Goals: 4.0\n",
      "Year: 1950.0, Country: USA, Goals: 12.0\n",
      "Year: 1970.0, Country: Uruguay, Goals: 56.0\n",
      "Year: 1958.0, Country: Wales, Goals: 4.0\n",
      "Year: 1970.0, Country: Romania, Goals: 12.0\n",
      "Year: 1986.0, Country: Paraguay, Goals: 16.0\n",
      "Year: 1986.0, Country: Korea Republic, Goals: 4.0\n",
      "Year: 1990.0, Country: Colombia, Goals: 9.0\n",
      "Year: 1962.0, Country: Uruguay, Goals: 50.0\n",
      "Year: 1970.0, Country: England, Goals: 34.0\n",
      "Year: 1930.0, Country: Mexico, Goals: 4.0\n",
      "Year: 1990.0, Country: Brazil, Goals: 148.0\n",
      "Year: 1966.0, Country: Argentina, Goals: 31.0\n",
      "Year: 1966.0, Country: Spain, Goals: 20.0\n",
      "Year: 1970.0, Country: Belgium, Goals: 12.0\n",
      "Year: 1966.0, Country: Brazil, Goals: 84.0\n",
      "Year: 1930.0, Country: France, Goals: 4.0\n",
      "Year: 1998.0, Country: Jamaica, Goals: 3.0\n",
      "Year: 1998.0, Country: Paraguay, Goals: 19.0\n",
      "Year: 2010.0, Country: Denmark, Goals: 27.0\n",
      "Year: 2010.0, Country: England, Goals: 77.0\n",
      "Year: 1954.0, Country: France, Goals: 13.0\n",
      "Year: 2010.0, Country: Chile, Goals: 34.0\n",
      "Year: 2010.0, Country: Australia, Goals: 8.0\n",
      "Year: 1978.0, Country: Hungary, Goals: 73.0\n",
      "Year: 1962.0, Country: Italy, Goals: 36.0\n",
      "Year: 2006.0, Country: Tunisia, Goals: 8.0\n",
      "Year: 1998.0, Country: South Africa, Goals: 3.0\n",
      "Year: 1974.0, Country: Scotland, Goals: 7.0\n",
      "Year: 2006.0, Country: Sweden, Goals: 74.0\n",
      "Year: 2006.0, Country: Netherlands, Goals: 59.0\n",
      "Year: 2006.0, Country: Costa Rica, Goals: 12.0\n",
      "Year: 2006.0, Country: Korea Republic, Goals: 22.0\n",
      "Year: 2002.0, Country: Poland, Goals: 42.0\n",
      "Year: 2006.0, Country: Czech Republic, Goals: 3.0\n",
      "Year: 1962.0, Country: Mexico, Goals: 12.0\n",
      "Year: 1982.0, Country: Belgium, Goals: 15.0\n",
      "Year: 1978.0, Country: Tunisia, Goals: 3.0\n",
      "Year: 1982.0, Country: Chile, Goals: 26.0\n",
      "Year: 1994.0, Country: USA, Goals: 17.0\n",
      "Year: 1990.0, Country: Netherlands, Goals: 35.0\n",
      "Year: 1990.0, Country: Sweden, Goals: 51.0\n",
      "Year: 2014.0, Country: Nigeria, Goals: 20.0\n",
      "Year: 1930.0, Country: Romania, Goals: 3.0\n",
      "Year: 2014.0, Country: Korea Republic, Goals: 31.0\n",
      "Year: 1994.0, Country: Cameroon, Goals: 11.0\n",
      "Year: 1986.0, Country: Morocco, Goals: 5.0\n",
      "Year: 2014.0, Country: Ecuador, Goals: 10.0\n",
      "Year: 1938.0, Country: Germany, Goals: 14.0\n",
      "Year: 2010.0, Country: South Africa, Goals: 11.0\n",
      "Year: 2010.0, Country: Slovenia, Goals: 5.0\n",
      "Year: 2014.0, Country: Australia, Goals: 11.0\n",
      "Year: 2010.0, Country: Paraguay, Goals: 30.0\n",
      "Year: 2010.0, Country: Nigeria, Goals: 17.0\n",
      "Year: 1998.0, Country: Austria, Goals: 43.0\n",
      "Year: 1998.0, Country: Belgium, Goals: 40.0\n",
      "Year: 1954.0, Country: Yugoslavia, Goals: 16.0\n",
      "Year: 1934.0, Country: Argentina, Goals: 20.0\n",
      "Year: 1934.0, Country: Egypt, Goals: 2.0\n",
      "Year: 1934.0, Country: Belgium, Goals: 2.0\n",
      "Year: 2014.0, Country: Italy, Goals: 128.0\n",
      "Year: 1962.0, Country: Spain, Goals: 16.0\n",
      "Year: 2014.0, Country: Japan, Goals: 14.0\n",
      "Year: 2010.0, Country: New Zealand, Goals: 4.0\n",
      "Year: 2006.0, Country: Croatia, Goals: 15.0\n",
      "Year: 1962.0, Country: Switzerland, Goals: 27.0\n",
      "Year: 1950.0, Country: Mexico, Goals: 6.0\n",
      "Year: 1950.0, Country: Paraguay, Goals: 3.0\n",
      "Year: 2014.0, Country: Russia, Goals: 13.0\n",
      "Year: 2010.0, Country: Greece, Goals: 2.0\n",
      "Year: 1934.0, Country: France, Goals: 6.0\n",
      "Year: 1962.0, Country: Argentina, Goals: 27.0\n",
      "Year: 2006.0, Country: USA, Goals: 27.0\n",
      "Year: 2006.0, Country: Iran, Goals: 5.0\n",
      "Year: 2014.0, Country: England, Goals: 79.0\n",
      "Year: 2010.0, Country: Cameroon, Goals: 17.0\n",
      "Year: 2006.0, Country: Japan, Goals: 8.0\n",
      "Year: 1954.0, Country: Mexico, Goals: 8.0\n",
      "Year: 1934.0, Country: Netherlands, Goals: 2.0\n",
      "Year: 1966.0, Country: France, Goals: 38.0\n",
      "Year: 2006.0, Country: Paraguay, Goals: 27.0\n",
      "Year: 2006.0, Country: Poland, Goals: 44.0\n",
      "Year: 2006.0, Country: Saudi Arabia, Goals: 9.0\n",
      "Year: 1958.0, Country: Austria, Goals: 26.0\n",
      "Year: 2006.0, Country: rn\">Serbia and Montenegro, Goals: 2.0\n",
      "Year: 2010.0, Country: Serbia, Goals: 2.0\n",
      "Year: 1950.0, Country: England, Goals: 2.0\n",
      "Year: 1966.0, Country: Chile, Goals: 22.0\n",
      "Year: 1986.0, Country: Portugal, Goals: 19.0\n",
      "Year: 1994.0, Country: rn\">Republic of Ireland, Goals: 4.0\n",
      "Year: 2002.0, Country: Croatia, Goals: 13.0\n",
      "Year: 1982.0, Country: Peru, Goals: 19.0\n",
      "Year: 2002.0, Country: Cameroon, Goals: 15.0\n",
      "Year: 1974.0, Country: Bulgaria, Goals: 9.0\n",
      "Year: 1982.0, Country: Yugoslavia, Goals: 47.0\n",
      "Year: 2002.0, Country: Argentina, Goals: 102.0\n",
      "Year: 1974.0, Country: Haiti, Goals: 2.0\n",
      "Year: 1982.0, Country: Honduras, Goals: 2.0\n",
      "Year: 1986.0, Country: Northern Ireland, Goals: 13.0\n",
      "Year: 1998.0, Country: Scotland, Goals: 25.0\n",
      "Year: 1998.0, Country: Saudi Arabia, Goals: 7.0\n",
      "Year: 1998.0, Country: Iran, Goals: 3.0\n",
      "Year: 1986.0, Country: Hungary, Goals: 87.0\n",
      "Year: 1994.0, Country: Morocco, Goals: 7.0\n",
      "Year: 1978.0, Country: Spain, Goals: 22.0\n",
      "Year: 1986.0, Country: Bulgaria, Goals: 11.0\n",
      "Year: 1998.0, Country: Korea Republic, Goals: 11.0\n",
      "Year: 1982.0, Country: New Zealand, Goals: 2.0\n",
      "Year: 2002.0, Country: Ecuador, Goals: 2.0\n",
      "Year: 1970.0, Country: Sweden, Goals: 40.0\n",
      "Year: 1966.0, Country: Italy, Goals: 38.0\n",
      "Year: 1998.0, Country: Cameroon, Goals: 13.0\n",
      "Year: 1990.0, Country: Scotland, Goals: 23.0\n",
      "Year: 2002.0, Country: Slovenia, Goals: 2.0\n",
      "Year: 1982.0, Country: Czechoslovakia, Goals: 34.0\n",
      "Year: 1990.0, Country: Austria, Goals: 40.0\n",
      "Year: 1966.0, Country: Uruguay, Goals: 52.0\n",
      "Year: 1970.0, Country: Czechoslovakia, Goals: 32.0\n",
      "Year: 1982.0, Country: Kuwait, Goals: 2.0\n",
      "Year: 1990.0, Country: USA, Goals: 14.0\n",
      "Year: 1990.0, Country: Uruguay, Goals: 61.0\n",
      "Year: 1970.0, Country: Morocco, Goals: 2.0\n",
      "Year: 1986.0, Country: Uruguay, Goals: 59.0\n",
      "Year: 1990.0, Country: rn\">Republic of Ireland, Goals: 2.0\n",
      "Year: 1990.0, Country: rn\">United Arab Emirates, Goals: 2.0\n",
      "Year: 1978.0, Country: Mexico, Goals: 21.0\n",
      "Year: 2010.0, Country: Switzerland, Goals: 38.0\n",
      "Year: 1986.0, Country: Algeria, Goals: 6.0\n",
      "Year: 1938.0, Country: Norway, Goals: 1.0\n",
      "Year: 1994.0, Country: Norway, Goals: 2.0\n",
      "Year: 2002.0, Country: Tunisia, Goals: 5.0\n",
      "Year: 1938.0, Country: Belgium, Goals: 3.0\n",
      "Year: 2014.0, Country: Cameroon, Goals: 18.0\n",
      "Year: 1934.0, Country: USA, Goals: 8.0\n",
      "Year: 1934.0, Country: Romania, Goals: 4.0\n",
      "Year: 1986.0, Country: Iraq, Goals: 1.0\n",
      "Year: 1986.0, Country: Poland, Goals: 39.0\n",
      "Year: 1934.0, Country: Brazil, Goals: 6.0\n",
      "Year: 2014.0, Country: Honduras, Goals: 3.0\n",
      "Year: 2014.0, Country: IR Iran, Goals: 2.0\n",
      "Year: 1986.0, Country: Scotland, Goals: 21.0\n",
      "Year: 1930.0, Country: Peru, Goals: 1.0\n",
      "Year: 1930.0, Country: Paraguay, Goals: 1.0\n",
      "Year: 1990.0, Country: Korea Republic, Goals: 5.0\n",
      "Year: 1994.0, Country: Bolivia, Goals: 1.0\n",
      "Year: 1982.0, Country: Cameroon, Goals: 1.0\n",
      "Year: 1982.0, Country: El Salvador, Goals: 1.0\n",
      "Year: 1978.0, Country: Iran, Goals: 1.0\n",
      "Year: 2006.0, Country: Angola, Goals: 1.0\n",
      "Year: 1966.0, Country: Mexico, Goals: 13.0\n",
      "Year: 1966.0, Country: Switzerland, Goals: 28.0\n",
      "Year: 2002.0, Country: Nigeria, Goals: 14.0\n",
      "Year: 1970.0, Country: Israel, Goals: 1.0\n",
      "Year: 1962.0, Country: Bulgaria, Goals: 1.0\n",
      "Year: 1974.0, Country: Chile, Goals: 23.0\n",
      "Year: 1958.0, Country: Mexico, Goals: 9.0\n",
      "Year: 1998.0, Country: USA, Goals: 18.0\n",
      "Year: 1998.0, Country: Tunisia, Goals: 4.0\n",
      "Year: 2006.0, Country: Togo, Goals: 1.0\n",
      "Year: 1998.0, Country: Bulgaria, Goals: 22.0\n",
      "Year: 1978.0, Country: IR Iran, Goals: 1.0\n",
      "Year: 1974.0, Country: Uruguay, Goals: 57.0\n",
      "Year: 1990.0, Country: Egypt, Goals: 3.0\n",
      "Year: 2010.0, Country: Korea DPR, Goals: 6.0\n",
      "Year: 1998.0, Country: Colombia, Goals: 14.0\n",
      "Year: 1966.0, Country: Bulgaria, Goals: 2.0\n",
      "Year: 1998.0, Country: Japan, Goals: 1.0\n",
      "Year: 2010.0, Country: France, Goals: 96.0\n",
      "Year: 1978.0, Country: Sweden, Goals: 48.0\n",
      "Year: 2006.0, Country: IR Iran, Goals: 1.0\n",
      "Year: 1930.0, Country: Bolivia, Goals: 0.0\n",
      "Year: 1950.0, Country: Bolivia, Goals: 0.0\n",
      "Year: 2002.0, Country: Saudi Arabia, Goals: 7.0\n",
      "Year: 1970.0, Country: El Salvador, Goals: 0.0\n",
      "Year: 2010.0, Country: Honduras, Goals: 2.0\n",
      "Year: 2002.0, Country: France, Goals: 86.0\n",
      "Year: 1938.0, Country: Dutch East Indies, Goals: 0.0\n",
      "Year: 1974.0, Country: Australia, Goals: 0.0\n",
      "Year: 1954.0, Country: Scotland, Goals: 0.0\n",
      "Year: 1954.0, Country: Czechoslovakia, Goals: 14.0\n",
      "Year: 1930.0, Country: Belgium, Goals: 0.0\n",
      "Year: 1938.0, Country: Netherlands, Goals: 2.0\n",
      "Year: 1954.0, Country: Korea Republic, Goals: 0.0\n",
      "Year: 1994.0, Country: Greece, Goals: 0.0\n",
      "Year: 1986.0, Country: Canada, Goals: 0.0\n",
      "Year: 1974.0, Country: Zaire, Goals: 0.0\n",
      "Year: 2006.0, Country: rn\">Trinidad and Tobago, Goals: 0.0\n",
      "Year: 2010.0, Country: Algeria, Goals: 6.0\n",
      "Year: 2002.0, Country: China PR, Goals: 0.0\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "def process_csv(csv_file):\n",
    "    # Read CSV file into a DataFrame\n",
    "    df = pd.read_csv(csv_file, delimiter=',', encoding='utf-8')\n",
    "    \n",
    "    # Rename columns for clarity\n",
    "    df.columns = [\n",
    "        'Year', 'DateTime', 'Stage', 'Stadium', 'City',\n",
    "        'Home_Team', 'Home_Goals', 'Away_Goals', 'Away_Team',\n",
    "        'ab', 'aa', 'a', 'b',\n",
    "        'c', 'd', 'e', 'f',\n",
    "        'g','h','bb'\n",
    "    ]\n",
    "    df = df[['Year', 'Home_Team', 'Home_Goals', 'Away_Goals', 'Away_Team']]\n",
    "    \n",
    "\n",
    "    # Group by country and year, summing up goals\n",
    "    goals_by_country = df.groupby(['Year', 'Home_Team'])['Home_Goals'].sum().reset_index()\n",
    "    goals_by_country = goals_by_country.rename(columns={'Home_Team': 'Country', 'Home_Goals': 'Goals'})\n",
    "    away_goals_by_country = df.groupby(['Year', 'Away_Team'])['Away_Goals'].sum().reset_index()\n",
    "    away_goals_by_country = away_goals_by_country.rename(columns={'Away_Team': 'Country', 'Away_Goals': 'Goals'})\n",
    "    goals_by_country = pd.concat([goals_by_country, away_goals_by_country], ignore_index=True)\n",
    "    goals_by_country = goals_by_country.groupby(['Year', 'Country'])['Goals'].sum().reset_index()\n",
    "    goals_by_country['Cumulative_Goals'] = goals_by_country.sort_values('Year').groupby('Country')['Goals'].cumsum()\n",
    "    return goals_by_country\n",
    "\n",
    "def print_results(goals_by_country):\n",
    "    # Sort countries by total goals scored\n",
    "    sorted_countries = goals_by_country.sort_values(by='Goals', ascending=False)\n",
    "\n",
    "    # Print results\n",
    "    for idx, row in sorted_countries.iterrows():\n",
    "        print(f\"Year: {row['Year']}, Country: {row['Country']}, Goals: {row['Cumulative_Goals']}\")\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    csv_file = \"data/WorldCupMatches.csv\"\n",
    "    goals_by_country = process_csv(csv_file)\n",
    "    print_results(goals_by_country)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Sort the DataFrame by 'Year'\n",
    "sorted_df = goals_by_country.sort_values(by='Year')\n",
    "\n",
    "# Write the DataFrame to a CSV file\n",
    "# Rename the columns\n",
    "sorted_df = sorted_df.rename(columns={'Year': 'date', 'Country': 'country', 'Cumulative_Goals': 'goals'})\n",
    "\n",
    "# Write the DataFrame to a CSV file\n",
    "sorted_df.to_csv('data/race_chart_data.csv', columns=['date', 'country', 'goals'], index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}