reading rows and columns from a csv file.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "9c7f1c96-834a-482f-a43f-46c9be1123a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8183be57-8dcd-47d6-915f-b08546386897",
   "metadata": {},
   "outputs": [
    {
     "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>ID</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>...</th>\n",
       "      <th>StandingTackle</th>\n",
       "      <th>SlidingTackle</th>\n",
       "      <th>GKDiving</th>\n",
       "      <th>GKHandling</th>\n",
       "      <th>GKKicking</th>\n",
       "      <th>GKPositioning</th>\n",
       "      <th>GKReflexes</th>\n",
       "      <th>Best Position</th>\n",
       "      <th>Best Overall Rating</th>\n",
       "      <th>Release Clause</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>176580</td>\n",
       "      <td>L. Suárez</td>\n",
       "      <td>30</td>\n",
       "      <td>https://cdn.sofifa.com/players/176/580/18_60.png</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>https://cdn.sofifa.com/flags/uy.png</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>https://cdn.sofifa.com/teams/241/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>45.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>CF</td>\n",
       "      <td>88.0</td>\n",
       "      <td>€198.9M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>178518</td>\n",
       "      <td>R. Nainggolan</td>\n",
       "      <td>29</td>\n",
       "      <td>https://cdn.sofifa.com/players/178/518/18_60.png</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>https://cdn.sofifa.com/flags/be.png</td>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>Roma</td>\n",
       "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>CDM</td>\n",
       "      <td>84.0</td>\n",
       "      <td>€72.3M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>203551</td>\n",
       "      <td>A. Florenzi</td>\n",
       "      <td>26</td>\n",
       "      <td>https://cdn.sofifa.com/players/203/551/18_60.png</td>\n",
       "      <td>Italy</td>\n",
       "      <td>https://cdn.sofifa.com/flags/it.png</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "      <td>Roma</td>\n",
       "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>79.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>CF</td>\n",
       "      <td>81.0</td>\n",
       "      <td>€37.3M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>197445</td>\n",
       "      <td>D. Alaba</td>\n",
       "      <td>25</td>\n",
       "      <td>https://cdn.sofifa.com/players/197/445/18_60.png</td>\n",
       "      <td>Austria</td>\n",
       "      <td>https://cdn.sofifa.com/flags/at.png</td>\n",
       "      <td>85</td>\n",
       "      <td>87</td>\n",
       "      <td>FC Bayern München</td>\n",
       "      <td>https://cdn.sofifa.com/teams/21/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>82.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>LB</td>\n",
       "      <td>82.0</td>\n",
       "      <td>€66.4M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>195864</td>\n",
       "      <td>P. Pogba</td>\n",
       "      <td>24</td>\n",
       "      <td>https://cdn.sofifa.com/players/195/864/18_60.png</td>\n",
       "      <td>France</td>\n",
       "      <td>https://cdn.sofifa.com/flags/fr.png</td>\n",
       "      <td>88</td>\n",
       "      <td>92</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>https://cdn.sofifa.com/teams/11/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>70.0</td>\n",
       "      <td>68.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>CM</td>\n",
       "      <td>85.0</td>\n",
       "      <td>€146.3M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17922</th>\n",
       "      <td>240757</td>\n",
       "      <td>A. Viscovo</td>\n",
       "      <td>18</td>\n",
       "      <td>https://cdn.sofifa.com/players/240/757/18_60.png</td>\n",
       "      <td>Italy</td>\n",
       "      <td>https://cdn.sofifa.com/flags/it.png</td>\n",
       "      <td>51</td>\n",
       "      <td>70</td>\n",
       "      <td>Crotone</td>\n",
       "      <td>https://cdn.sofifa.com/teams/110734/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>GK</td>\n",
       "      <td>50.0</td>\n",
       "      <td>€146K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17923</th>\n",
       "      <td>237463</td>\n",
       "      <td>A. Kelsey</td>\n",
       "      <td>17</td>\n",
       "      <td>https://cdn.sofifa.com/players/237/463/18_60.png</td>\n",
       "      <td>England</td>\n",
       "      <td>https://cdn.sofifa.com/flags/gb-eng.png</td>\n",
       "      <td>46</td>\n",
       "      <td>63</td>\n",
       "      <td>Scunthorpe United</td>\n",
       "      <td>https://cdn.sofifa.com/teams/1949/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>GK</td>\n",
       "      <td>45.0</td>\n",
       "      <td>€119K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17924</th>\n",
       "      <td>240790</td>\n",
       "      <td>A. Giacomel</td>\n",
       "      <td>18</td>\n",
       "      <td>https://cdn.sofifa.com/players/240/790/18_60.png</td>\n",
       "      <td>Italy</td>\n",
       "      <td>https://cdn.sofifa.com/flags/it.png</td>\n",
       "      <td>49</td>\n",
       "      <td>64</td>\n",
       "      <td>Empoli</td>\n",
       "      <td>https://cdn.sofifa.com/teams/1746/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>GK</td>\n",
       "      <td>48.0</td>\n",
       "      <td>€111K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17925</th>\n",
       "      <td>241206</td>\n",
       "      <td>D. Maekawa</td>\n",
       "      <td>22</td>\n",
       "      <td>https://cdn.sofifa.com/players/241/206/18_60.png</td>\n",
       "      <td>Japan</td>\n",
       "      <td>https://cdn.sofifa.com/flags/jp.png</td>\n",
       "      <td>54</td>\n",
       "      <td>61</td>\n",
       "      <td>Vissel Kobe</td>\n",
       "      <td>https://cdn.sofifa.com/teams/101146/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>GK</td>\n",
       "      <td>53.0</td>\n",
       "      <td>€102K</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17926</th>\n",
       "      <td>243202</td>\n",
       "      <td>A. Jones</td>\n",
       "      <td>16</td>\n",
       "      <td>https://cdn.sofifa.com/players/243/202/18_60.png</td>\n",
       "      <td>England</td>\n",
       "      <td>https://cdn.sofifa.com/flags/gb-eng.png</td>\n",
       "      <td>48</td>\n",
       "      <td>66</td>\n",
       "      <td>Milton Keynes Dons</td>\n",
       "      <td>https://cdn.sofifa.com/teams/1798/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>GK</td>\n",
       "      <td>47.0</td>\n",
       "      <td>€119K</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17927 rows × 64 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           ID            Name  Age  \\\n",
       "0      176580       L. Suárez   30   \n",
       "1      178518   R. Nainggolan   29   \n",
       "2      203551     A. Florenzi   26   \n",
       "3      197445        D. Alaba   25   \n",
       "4      195864        P. Pogba   24   \n",
       "...       ...             ...  ...   \n",
       "17922  240757      A. Viscovo   18   \n",
       "17923  237463       A. Kelsey   17   \n",
       "17924  240790     A. Giacomel   18   \n",
       "17925  241206      D. Maekawa   22   \n",
       "17926  243202        A. Jones   16   \n",
       "\n",
       "                                                  Photo Nationality  \\\n",
       "0      https://cdn.sofifa.com/players/176/580/18_60.png     Uruguay   \n",
       "1      https://cdn.sofifa.com/players/178/518/18_60.png     Belgium   \n",
       "2      https://cdn.sofifa.com/players/203/551/18_60.png       Italy   \n",
       "3      https://cdn.sofifa.com/players/197/445/18_60.png     Austria   \n",
       "4      https://cdn.sofifa.com/players/195/864/18_60.png      France   \n",
       "...                                                 ...         ...   \n",
       "17922  https://cdn.sofifa.com/players/240/757/18_60.png       Italy   \n",
       "17923  https://cdn.sofifa.com/players/237/463/18_60.png     England   \n",
       "17924  https://cdn.sofifa.com/players/240/790/18_60.png       Italy   \n",
       "17925  https://cdn.sofifa.com/players/241/206/18_60.png       Japan   \n",
       "17926  https://cdn.sofifa.com/players/243/202/18_60.png     England   \n",
       "\n",
       "                                          Flag  Overall  Potential  \\\n",
       "0          https://cdn.sofifa.com/flags/uy.png       92         92   \n",
       "1          https://cdn.sofifa.com/flags/be.png       86         86   \n",
       "2          https://cdn.sofifa.com/flags/it.png       82         83   \n",
       "3          https://cdn.sofifa.com/flags/at.png       85         87   \n",
       "4          https://cdn.sofifa.com/flags/fr.png       88         92   \n",
       "...                                        ...      ...        ...   \n",
       "17922      https://cdn.sofifa.com/flags/it.png       51         70   \n",
       "17923  https://cdn.sofifa.com/flags/gb-eng.png       46         63   \n",
       "17924      https://cdn.sofifa.com/flags/it.png       49         64   \n",
       "17925      https://cdn.sofifa.com/flags/jp.png       54         61   \n",
       "17926  https://cdn.sofifa.com/flags/gb-eng.png       48         66   \n",
       "\n",
       "                     Club                                         Club Logo  \\\n",
       "0            FC Barcelona     https://cdn.sofifa.com/teams/241/light_30.png   \n",
       "1                    Roma      https://cdn.sofifa.com/teams/52/light_30.png   \n",
       "2                    Roma      https://cdn.sofifa.com/teams/52/light_30.png   \n",
       "3       FC Bayern München      https://cdn.sofifa.com/teams/21/light_30.png   \n",
       "4       Manchester United      https://cdn.sofifa.com/teams/11/light_30.png   \n",
       "...                   ...                                               ...   \n",
       "17922             Crotone  https://cdn.sofifa.com/teams/110734/light_30.png   \n",
       "17923   Scunthorpe United    https://cdn.sofifa.com/teams/1949/light_30.png   \n",
       "17924              Empoli    https://cdn.sofifa.com/teams/1746/light_30.png   \n",
       "17925         Vissel Kobe  https://cdn.sofifa.com/teams/101146/light_30.png   \n",
       "17926  Milton Keynes Dons    https://cdn.sofifa.com/teams/1798/light_30.png   \n",
       "\n",
       "       ... StandingTackle SlidingTackle  GKDiving GKHandling  GKKicking  \\\n",
       "0      ...           45.0          38.0      27.0       25.0       31.0   \n",
       "1      ...           86.0          88.0      11.0       11.0       14.0   \n",
       "2      ...           79.0          78.0       9.0        8.0       10.0   \n",
       "3      ...           82.0          80.0       5.0        7.0       14.0   \n",
       "4      ...           70.0          68.0       5.0        6.0        2.0   \n",
       "...    ...            ...           ...       ...        ...        ...   \n",
       "17922  ...           11.0          13.0      58.0       46.0       57.0   \n",
       "17923  ...           11.0          10.0      46.0       47.0       49.0   \n",
       "17924  ...           12.0          10.0      45.0       55.0       48.0   \n",
       "17925  ...           11.0           8.0      55.0       51.0       44.0   \n",
       "17926  ...           12.0          12.0      56.0       43.0       42.0   \n",
       "\n",
       "       GKPositioning  GKReflexes Best Position Best Overall Rating  \\\n",
       "0               33.0        37.0            CF                88.0   \n",
       "1                8.0        11.0           CDM                84.0   \n",
       "2               11.0        10.0            CF                81.0   \n",
       "3               15.0         9.0            LB                82.0   \n",
       "4                4.0         3.0            CM                85.0   \n",
       "...              ...         ...           ...                 ...   \n",
       "17922           52.0        47.0            GK                50.0   \n",
       "17923           42.0        48.0            GK                45.0   \n",
       "17924           45.0        56.0            GK                48.0   \n",
       "17925           55.0        59.0            GK                53.0   \n",
       "17926           39.0        52.0            GK                47.0   \n",
       "\n",
       "      Release Clause  \n",
       "0            €198.9M  \n",
       "1             €72.3M  \n",
       "2             €37.3M  \n",
       "3             €66.4M  \n",
       "4            €146.3M  \n",
       "...              ...  \n",
       "17922          €146K  \n",
       "17923          €119K  \n",
       "17924          €111K  \n",
       "17925          €102K  \n",
       "17926          €119K  \n",
       "\n",
       "[17927 rows x 64 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('FIFA.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "aa008336-2267-4cc0-b156-8e3edc7be57d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         L. Suárez\n",
       "1     R. Nainggolan\n",
       "2       A. Florenzi\n",
       "3          D. Alaba\n",
       "4          P. Pogba\n",
       "Name: Name, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# reading columns\n",
    "column_name = df['Name']\n",
    "column_name.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "98407a8c-5f22-4282-8409-102b6e2126e2",
   "metadata": {},
   "outputs": [
    {
     "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>ID</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>...</th>\n",
       "      <th>StandingTackle</th>\n",
       "      <th>SlidingTackle</th>\n",
       "      <th>GKDiving</th>\n",
       "      <th>GKHandling</th>\n",
       "      <th>GKKicking</th>\n",
       "      <th>GKPositioning</th>\n",
       "      <th>GKReflexes</th>\n",
       "      <th>Best Position</th>\n",
       "      <th>Best Overall Rating</th>\n",
       "      <th>Release Clause</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>176580</td>\n",
       "      <td>L. Suárez</td>\n",
       "      <td>30</td>\n",
       "      <td>https://cdn.sofifa.com/players/176/580/18_60.png</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>https://cdn.sofifa.com/flags/uy.png</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>https://cdn.sofifa.com/teams/241/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>45.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>CF</td>\n",
       "      <td>88.0</td>\n",
       "      <td>€198.9M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>178518</td>\n",
       "      <td>R. Nainggolan</td>\n",
       "      <td>29</td>\n",
       "      <td>https://cdn.sofifa.com/players/178/518/18_60.png</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>https://cdn.sofifa.com/flags/be.png</td>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>Roma</td>\n",
       "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>CDM</td>\n",
       "      <td>84.0</td>\n",
       "      <td>€72.3M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>203551</td>\n",
       "      <td>A. Florenzi</td>\n",
       "      <td>26</td>\n",
       "      <td>https://cdn.sofifa.com/players/203/551/18_60.png</td>\n",
       "      <td>Italy</td>\n",
       "      <td>https://cdn.sofifa.com/flags/it.png</td>\n",
       "      <td>82</td>\n",
       "      <td>83</td>\n",
       "      <td>Roma</td>\n",
       "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>79.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>CF</td>\n",
       "      <td>81.0</td>\n",
       "      <td>€37.3M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3 rows × 64 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID            Name  Age  \\\n",
       "0  176580       L. Suárez   30   \n",
       "1  178518   R. Nainggolan   29   \n",
       "2  203551     A. Florenzi   26   \n",
       "\n",
       "                                              Photo Nationality  \\\n",
       "0  https://cdn.sofifa.com/players/176/580/18_60.png     Uruguay   \n",
       "1  https://cdn.sofifa.com/players/178/518/18_60.png     Belgium   \n",
       "2  https://cdn.sofifa.com/players/203/551/18_60.png       Italy   \n",
       "\n",
       "                                  Flag  Overall  Potential          Club  \\\n",
       "0  https://cdn.sofifa.com/flags/uy.png       92         92  FC Barcelona   \n",
       "1  https://cdn.sofifa.com/flags/be.png       86         86          Roma   \n",
       "2  https://cdn.sofifa.com/flags/it.png       82         83          Roma   \n",
       "\n",
       "                                       Club Logo  ... StandingTackle  \\\n",
       "0  https://cdn.sofifa.com/teams/241/light_30.png  ...           45.0   \n",
       "1   https://cdn.sofifa.com/teams/52/light_30.png  ...           86.0   \n",
       "2   https://cdn.sofifa.com/teams/52/light_30.png  ...           79.0   \n",
       "\n",
       "  SlidingTackle  GKDiving GKHandling  GKKicking  GKPositioning  GKReflexes  \\\n",
       "0          38.0      27.0       25.0       31.0           33.0        37.0   \n",
       "1          88.0      11.0       11.0       14.0            8.0        11.0   \n",
       "2          78.0       9.0        8.0       10.0           11.0        10.0   \n",
       "\n",
       "  Best Position Best Overall Rating Release Clause  \n",
       "0            CF                88.0        €198.9M  \n",
       "1           CDM                84.0         €72.3M  \n",
       "2            CF                81.0         €37.3M  \n",
       "\n",
       "[3 rows x 64 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# reading rows\n",
    "row_data = df.loc[0:2]\n",
    "row_data.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "c3721053-f61c-4dc9-9299-001157b096f2",
   "metadata": {},
   "outputs": [
    {
     "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>ID</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>...</th>\n",
       "      <th>StandingTackle</th>\n",
       "      <th>SlidingTackle</th>\n",
       "      <th>GKDiving</th>\n",
       "      <th>GKHandling</th>\n",
       "      <th>GKKicking</th>\n",
       "      <th>GKPositioning</th>\n",
       "      <th>GKReflexes</th>\n",
       "      <th>Best Position</th>\n",
       "      <th>Best Overall Rating</th>\n",
       "      <th>Release Clause</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>176580</td>\n",
       "      <td>L. Suárez</td>\n",
       "      <td>30</td>\n",
       "      <td>https://cdn.sofifa.com/players/176/580/18_60.png</td>\n",
       "      <td>Uruguay</td>\n",
       "      <td>https://cdn.sofifa.com/flags/uy.png</td>\n",
       "      <td>92</td>\n",
       "      <td>92</td>\n",
       "      <td>FC Barcelona</td>\n",
       "      <td>https://cdn.sofifa.com/teams/241/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>45.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>CF</td>\n",
       "      <td>88.0</td>\n",
       "      <td>€198.9M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>178518</td>\n",
       "      <td>R. Nainggolan</td>\n",
       "      <td>29</td>\n",
       "      <td>https://cdn.sofifa.com/players/178/518/18_60.png</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>https://cdn.sofifa.com/flags/be.png</td>\n",
       "      <td>86</td>\n",
       "      <td>86</td>\n",
       "      <td>Roma</td>\n",
       "      <td>https://cdn.sofifa.com/teams/52/light_30.png</td>\n",
       "      <td>...</td>\n",
       "      <td>86.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>CDM</td>\n",
       "      <td>84.0</td>\n",
       "      <td>€72.3M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 64 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID            Name  Age  \\\n",
       "0  176580       L. Suárez   30   \n",
       "1  178518   R. Nainggolan   29   \n",
       "\n",
       "                                              Photo Nationality  \\\n",
       "0  https://cdn.sofifa.com/players/176/580/18_60.png     Uruguay   \n",
       "1  https://cdn.sofifa.com/players/178/518/18_60.png     Belgium   \n",
       "\n",
       "                                  Flag  Overall  Potential          Club  \\\n",
       "0  https://cdn.sofifa.com/flags/uy.png       92         92  FC Barcelona   \n",
       "1  https://cdn.sofifa.com/flags/be.png       86         86          Roma   \n",
       "\n",
       "                                       Club Logo  ... StandingTackle  \\\n",
       "0  https://cdn.sofifa.com/teams/241/light_30.png  ...           45.0   \n",
       "1   https://cdn.sofifa.com/teams/52/light_30.png  ...           86.0   \n",
       "\n",
       "  SlidingTackle  GKDiving GKHandling  GKKicking  GKPositioning  GKReflexes  \\\n",
       "0          38.0      27.0       25.0       31.0           33.0        37.0   \n",
       "1          88.0      11.0       11.0       14.0            8.0        11.0   \n",
       "\n",
       "  Best Position Best Overall Rating Release Clause  \n",
       "0            CF                88.0        €198.9M  \n",
       "1           CDM                84.0         €72.3M  \n",
       "\n",
       "[2 rows x 64 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "row_data1 = df.iloc[0:2]\n",
    "row_data1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9d38cde6-a659-465f-8db0-57c92c573e82",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}