{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
   "name": "FIFA.ipynb",
   "provenance": [],
   "collapsed_sections": []
},
"kernelspec": {
   "name": "python3",
   "display_name": "Python 3"
}
},
"cells": [
{
   "cell_type": "code",
   "metadata": {
   "id": "Ofj0BNbqq3Pa",
   "colab_type": "code",
   "colab": {}
   },
   "source": [
   "import pandas as pd\n",
   "import numpy as np\n",
   "import matplotlib.pyplot as plt"
   ],
   "execution_count": 1,
   "outputs": []
},
{
   "cell_type": "code",
   "metadata": {
   "id": "_XWaYABarO4H",
   "colab_type": "code",
   "colab": {}
   },
   "source": [
   "df = pd.read_excel('FIFA.xlsx')"
   ],
   "execution_count": 2,
   "outputs": []
},
{
   "cell_type": "markdown",
   "metadata": {
   "id": "wY_BUc2HpEGP",
   "colab_type": "text"
   },
   "source": [
   "# FIFA 2018 Data Analysis\n",
   "\n",
   "\n",
   "\n",
   "Overview:\n",
   "\n",
   "In this project, we will be looking at the player data provided by FIFA which contains information such as personal details, wages, physical attributes, technical skills, potential and their positional strengths. This is primarily data of FIFA 2018.Through this project, you will get a glimpse of\n",
   "insights behind the beautiful game and the kind of information and decisions a football manager goes through."
   ]
},
{
   "cell_type": "code",
   "metadata": {
   "id": "3ESa4aR5r765",
   "colab_type": "code",
   "colab": {
      "base_uri": "https://localhost:8080/",
      "height": 394
   },
   "outputId": "0bd177e3-4bd0-4214-f976-2aed3aeed3ae"
   },
   "source": [
   "df.head()"
   ],
   "execution_count": 3,
   "outputs": [
   {
      "output_type": "execute_result",
      "data": {
         "text/html": [
         "<div>\n",
         "<style scoped>\n",
         " .dataframe tbody tr th:only-of-type {\n",
         "    vertical-align: middle;\n",
         " }\n",
         "\n",
         " .dataframe tbody tr th {\n",
         "    vertical-align: top;\n",
         " }\n",
         "\n",
         " .dataframe thead th {\n",
         "    text-align: right;\n",
         " }\n",
         "</style>\n",
         "<table border=\"1\" class=\"dataframe\">\n",
         " <thead>\n",
         " <tr style=\"text-align: right;\">\n",
         "    <th></th>\n",
         "    <th>Unnamed: 0</th>\n",
         "    <th>Name</th>\n",
         "    <th>Age</th>\n",
         "    <th>Photo</th>\n",
         "    <th>Nationality</th>\n",
         "    <th>Flag</th>\n",
         "    <th>Overall</th>\n",
         "    <th>Potential</th>\n",
         "    <th>Club</th>\n",
         "    <th>Club Logo</th>\n",
         "    <th>Value</th>\n",
         "    <th>Wage</th>\n",
         "    <th>Special</th>\n",
         "    <th>Acceleration</th>\n",
         "    <th>Aggression</th>\n",
         "    <th>Agility</th>\n",
         "    <th>Balance</th>\n",
         "    <th>Ball control</th>\n",
         "    <th>Composure</th>\n",
         "    <th>Crossing</th>\n",
         "    <th>Curve</th>\n",
         "    <th>Dribbling</th>\n",
         "    <th>Finishing</th>\n",
         "    <th>Free kick accuracy</th>\n",
         "    <th>GK diving</th>\n",
         "    <th>GK handling</th>\n",
         "    <th>GK kicking</th>\n",
         "    <th>GK positioning</th>\n",
         "    <th>GK reflexes</th>\n",
         "    <th>Heading accuracy</th>\n",
         "    <th>Interceptions</th>\n",
         "    <th>Jumping</th>\n",
         "    <th>Long passing</th>\n",
         "    <th>Long shots</th>\n",
         "    <th>Marking</th>\n",
         "    <th>Penalties</th>\n",
         "    <th>Positioning</th>\n",
         "    <th>Reactions</th>\n",
         "    <th>Short passing</th>\n",
         "    <th>Shot power</th>\n",
         "    <th>Sliding tackle</th>\n",
         "    <th>Sprint speed</th>\n",
         "    <th>Stamina</th>\n",
         "    <th>Standing tackle</th>\n",
         "    <th>Strength</th>\n",
         "    <th>Vision</th>\n",
         "    <th>Volleys</th>\n",
         "    <th>CAM</th>\n",
         "    <th>CB</th>\n",
         "    <th>CDM</th>\n",
         "    <th>CF</th>\n",
         "    <th>CM</th>\n",
         "    <th>LAM</th>\n",
         "    <th>LB</th>\n",
         "    <th>LCB</th>\n",
         "    <th>LCM</th>\n",
         "    <th>LDM</th>\n",
         "    <th>LF</th>\n",
         "    <th>LM</th>\n",
         "    <th>LS</th>\n",
         "    <th>LW</th>\n",
         "    <th>LWB</th>\n",
         "    <th>Preferred Positions</th>\n",
         "    <th>RAM</th>\n",
         "    <th>RB</th>\n",
         "    <th>RCB</th>\n",
         "    <th>RCM</th>\n",
         "    <th>RDM</th>\n",
         "    <th>RF</th>\n",
         "    <th>RM</th>\n",
         "    <th>RS</th>\n",
         "    <th>RW</th>\n",
         "    <th>RWB</th>\n",
         "    <th>ST</th>\n",
         " </tr>\n",
         " </thead>\n",
         " <tbody>\n",
         " <tr>\n",
         "    <th>0</th>\n",
         "    <td>0</td>\n",
         "    <td>Cristiano Ronaldo</td>\n",
         "    <td>32</td>\n",
         "    <td>https://cdn.sofifa.org/48/18/players/20801.png</td>\n",
         "    <td>Portugal</td>\n",
         "    <td>https://cdn.sofifa.org/flags/38.png</td>\n",
         "    <td>94</td>\n",
         "    <td>94</td>\n",
         "    <td>Real Madrid CF</td>\n",
         "    <td>https://cdn.sofifa.org/24/18/teams/243.png</td>\n",
         "    <td>95.5M</td>\n",
         "    <td>565K</td>\n",
         "    <td>2228</td>\n",
         "    <td>89</td>\n",
         "    <td>63</td>\n",
         "    <td>89</td>\n",
         "    <td>63</td>\n",
         "    <td>93</td>\n",
         "    <td>95</td>\n",
         "    <td>85</td>\n",
         "    <td>81</td>\n",
         "    <td>91</td>\n",
         "    <td>94</td>\n",
         "    <td>76</td>\n",
         "    <td>7</td>\n",
         "    <td>11</td>\n",
         "    <td>15</td>\n",
         "    <td>14</td>\n",
         "    <td>11</td>\n",
         "    <td>88</td>\n",
         "    <td>29</td>\n",
         "    <td>95</td>\n",
         "    <td>77</td>\n",
         "    <td>92</td>\n",
         "    <td>22</td>\n",
         "    <td>85</td>\n",
         "    <td>95</td>\n",
         "    <td>96</td>\n",
         "    <td>83</td>\n",
         "    <td>94</td>\n",
         "    <td>23</td>\n",
         "    <td>91</td>\n",
         "    <td>92</td>\n",
         "    <td>31</td>\n",
         "    <td>80</td>\n",
         "    <td>85</td>\n",
         "    <td>88</td>\n",
         "    <td>89.0</td>\n",
         "    <td>53.0</td>\n",
         "    <td>62.0</td>\n",
         "    <td>91.0</td>\n",
         "    <td>82.0</td>\n",
         "    <td>89.0</td>\n",
         "    <td>61.0</td>\n",
         "    <td>53.0</td>\n",
         "    <td>82.0</td>\n",
         "    <td>62.0</td>\n",
         "    <td>91.0</td>\n",
         "    <td>89.0</td>\n",
         "    <td>92.0</td>\n",
         "    <td>91.0</td>\n",
         "    <td>66.0</td>\n",
         "    <td>ST LW</td>\n",
         "    <td>89.0</td>\n",
         "    <td>61.0</td>\n",
         "    <td>53.0</td>\n",
         "    <td>82.0</td>\n",
         "    <td>62.0</td>\n",
         "    <td>91.0</td>\n",
         "    <td>89.0</td>\n",
         "    <td>92.0</td>\n",
         "    <td>91.0</td>\n",
         "    <td>66.0</td>\n",
         "    <td>92.0</td>\n",
         " </tr>\n",
         " <tr>\n",
         "    <th>1</th>\n",
         "    <td>1</td>\n",
         "    <td>L. Messi</td>\n",
         "    <td>30</td>\n",
         "    <td>https://cdn.sofifa.org/48/18/players/158023.png</td>\n",
         "    <td>Argentina</td>\n",
         "    <td>https://cdn.sofifa.org/flags/52.png</td>\n",
         "    <td>93</td>\n",
         "    <td>93</td>\n",
         "    <td>FC Barcelona</td>\n",
         "    <td>https://cdn.sofifa.org/24/18/teams/241.png</td>\n",
         "    <td>105M</td>\n",
         "    <td>565K</td>\n",
         "    <td>2154</td>\n",
         "    <td>92</td>\n",
         "    <td>48</td>\n",
         "    <td>90</td>\n",
         "    <td>95</td>\n",
         "    <td>95</td>\n",
         "    <td>96</td>\n",
         "    <td>77</td>\n",
         "    <td>89</td>\n",
         "    <td>97</td>\n",
         "    <td>95</td>\n",
         "    <td>90</td>\n",
         "    <td>6</td>\n",
         "    <td>11</td>\n",
         "    <td>15</td>\n",
         "    <td>14</td>\n",
         "    <td>8</td>\n",
         "    <td>71</td>\n",
         "    <td>22</td>\n",
         "    <td>68</td>\n",
         "    <td>87</td>\n",
         "    <td>88</td>\n",
         "    <td>13</td>\n",
         "    <td>74</td>\n",
         "    <td>93</td>\n",
         "    <td>95</td>\n",
         "    <td>88</td>\n",
         "    <td>85</td>\n",
         "    <td>26</td>\n",
         "    <td>87</td>\n",
         "    <td>73</td>\n",
         "    <td>28</td>\n",
         "    <td>59</td>\n",
         "    <td>90</td>\n",

Write a program that writes a series of random numbers to a file. E...