20_Pandas_Functions_for_80_of_your_Data_Science Tasks.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/youssefHosni/Efficient-Python-for-Data-Scientists/blob/main/20_Pandas_Functions_for_80_of_your_Data_Science%C2%A0Tasks.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NNX5Y1LoIf21"
      },
      "source": [
        "# 20 Pandas Functions for 80% of your Data Science Tasks\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Q8PL50VfIf24"
      },
      "source": [
        "Pandas is one of the most widely used libraries in the data science community and it’s a powerful tool that can help you with data manipulation, cleaning, and analysis. Whether you’re a beginner or an experienced data scientist, this article will provide valuable insights into the most commonly used Pandas functions and how to use them practically.\n",
        "\n",
        "We will cover everything from basic data manipulation to advanced data analysis techniques, and by the end of this article, you will have a solid understanding of how to use Pandas to make your data science workflow more efficient."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tDqYOeA7If27"
      },
      "source": [
        "## 1. pd.read_csv()\n",
        "**pd.read_csv()** is a function in the panda's library in Python that is used to read a CSV (Comma Separated Values) file and convert it into a pandas DataFrame."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "SRvNJjIQIf29"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "df = pd.read_csv('Popular_Baby_Names.csv')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8gpX4j1-If2_"
      },
      "source": [
        "In this example, the pd.read_csv function reads the file ‘data.csv’ and converts it into a DataFrame, which is then assigned to the variable ‘data’. The contents of the DataFrame can then be printed using the print function.\n",
        "\n",
        "It has many options like sep, header, index_col, skiprows, na_values etc.\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Phf3urZ3If3A"
      },
      "outputs": [],
      "source": [
        "df_no_columns = pd.read_csv('Popular_Baby_Names.csv', sep=';', header=0, index_col=0, skiprows=5, na_values='N/A')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "LgLPMgrnIf3B"
      },
      "source": [
        "This example reads the CSV file data.csv, with ; as a separator, the first row as the header, the first column as an index, skipping the first 5 rows and replacing N/A with NaN.\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "fdxAdgsvIf3C"
      },
      "source": [
        "# 2. df.describe()\n",
        "\n",
        "The **df.describe()** method in pandas is used to generate summary statistics of various features of a DataFrame. It returns a new DataFrame that contains the count, mean, standard deviation, minimum, 25th percentile, median, 75th percentile, and maximum of each numerical column in the original DataFrame."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": true,
        "id": "zQtb1pOhIf3C",
        "outputId": "cac5bd76-5120-442b-cee0-204dc0af9d1e"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "       Year of Birth         Count          Rank\n",
            "count   11345.000000  11345.000000  11345.000000\n",
            "mean     2013.552578     32.836844     57.656765\n",
            "std         1.746367     36.981866     25.186882\n",
            "min      2011.000000     10.000000      1.000000\n",
            "25%      2012.000000     13.000000     38.000000\n",
            "50%      2014.000000     20.000000     59.000000\n",
            "75%      2015.000000     35.000000     79.000000\n",
            "max      2016.000000    387.000000    102.000000\n"
          ]
        }
      ],
      "source": [
        "print(df.describe())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PiUHGQMoIf3F"
      },
      "source": [
        "You can also include or exclude certain columns and also include non-numerical columns by passing appropriate arguments to the method.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": true,
        "id": "bKOYvs_yIf3G",
        "outputId": "63b5b38b-9df2-49f6-91fe-f8d005eb33d5"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>11345.000000</td>\n",
              "      <td>11345</td>\n",
              "      <td>11345</td>\n",
              "      <td>11345</td>\n",
              "      <td>11345.000000</td>\n",
              "      <td>11345.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>7</td>\n",
              "      <td>3016</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>NaN</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Avery</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>NaN</td>\n",
              "      <td>5756</td>\n",
              "      <td>3365</td>\n",
              "      <td>24</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>2013.552578</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32.836844</td>\n",
              "      <td>57.656765</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>1.746367</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>36.981866</td>\n",
              "      <td>25.186882</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>2011.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10.000000</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>2012.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>13.000000</td>\n",
              "      <td>38.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>2014.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20.000000</td>\n",
              "      <td>59.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>2015.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>35.000000</td>\n",
              "      <td>79.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>2016.000000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>387.000000</td>\n",
              "      <td>102.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Year of Birth  Gender           Ethnicity Child's First Name  \\\n",
              "count    11345.000000   11345               11345              11345   \n",
              "unique            NaN       3                   7               3016   \n",
              "top               NaN  FEMALE  WHITE NON HISPANIC              Avery   \n",
              "freq              NaN    5756                3365                 24   \n",
              "mean      2013.552578     NaN                 NaN                NaN   \n",
              "std          1.746367     NaN                 NaN                NaN   \n",
              "min       2011.000000     NaN                 NaN                NaN   \n",
              "25%       2012.000000     NaN                 NaN                NaN   \n",
              "50%       2014.000000     NaN                 NaN                NaN   \n",
              "75%       2015.000000     NaN                 NaN                NaN   \n",
              "max       2016.000000     NaN                 NaN                NaN   \n",
              "\n",
              "               Count          Rank  \n",
              "count   11345.000000  11345.000000  \n",
              "unique           NaN           NaN  \n",
              "top              NaN           NaN  \n",
              "freq             NaN           NaN  \n",
              "mean       32.836844     57.656765  \n",
              "std        36.981866     25.186882  \n",
              "min        10.000000      1.000000  \n",
              "25%        13.000000     38.000000  \n",
              "50%        20.000000     59.000000  \n",
              "75%        35.000000     79.000000  \n",
              "max       387.000000    102.000000  "
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.describe(include='all')  # include all columns"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ajy1TNrtIf3H"
      },
      "source": [
        "You can also exclude some of the columns using the exclude method:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "EfOmnWk1If3H",
        "outputId": "7f91e378-5325-4e4d-8481-256bff0e362b"
      },
      "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>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>11345</td>\n",
              "      <td>11345</td>\n",
              "      <td>11345</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>unique</th>\n",
              "      <td>3</td>\n",
              "      <td>7</td>\n",
              "      <td>3016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>top</th>\n",
              "      <td>FEMALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Avery</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>freq</th>\n",
              "      <td>5756</td>\n",
              "      <td>3365</td>\n",
              "      <td>24</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Gender           Ethnicity Child's First Name\n",
              "count    11345               11345              11345\n",
              "unique       3                   7               3016\n",
              "top     FEMALE  WHITE NON HISPANIC              Avery\n",
              "freq      5756                3365                 24"
            ]
          },
          "execution_count": 5,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.describe(exclude='number') # exclude numerical columns"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PfshxOTrIf3I"
      },
      "source": [
        "## 3. df.info()\n",
        "\n",
        "**df.info()** is a method in pandas that is used to get a concise summary of the DataFrame, including the number of non-null values in each column, the data types of each column, and the memory usage of the DataFrame.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "fEbisBMaIf3J",
        "outputId": "8071ed97-67f0-4af9-db2d-d5c2b3be675f"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 11345 entries, 0 to 11344\n",
            "Data columns (total 6 columns):\n",
            " #   Column              Non-Null Count  Dtype \n",
            "---  ------              --------------  ----- \n",
            " 0   Year of Birth       11345 non-null  int64 \n",
            " 1   Gender              11345 non-null  object\n",
            " 2   Ethnicity           11345 non-null  object\n",
            " 3   Child's First Name  11345 non-null  object\n",
            " 4   Count               11345 non-null  int64 \n",
            " 5   Rank                11345 non-null  int64 \n",
            "dtypes: int64(3), object(3)\n",
            "memory usage: 531.9+ KB\n",
            "None\n"
          ]
        }
      ],
      "source": [
        "print(df.info())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "StjaMgQYIf3J"
      },
      "source": [
        "## 4. df.plot()\n",
        "\n",
        "**df.plot()** is a method in pandas that is used to create various types of plots from a DataFrame. By default, it creates a line plot of all numerical columns in the DataFrame. But you can also pass the argument kind to specify the type of plot you want to create. Available options are line, bar, barh, hist, box, kde, density, area, pie, scatter, and hexbin.\n",
        "\n",
        "In the examples below I will use the .plot() method to plot numerical and categorical variables. For the categorical variable, I will plot bar and pie plots and for the numerical variable, I will plot box plots. You can try a different types of plots by yourself.\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Wdf0kP0cIf3K",
        "outputId": "3339c239-7af4-4578-c780-fd68001c3ded"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "<AxesSubplot:>"
            ]
          },
          "execution_count": 7,
          "metadata": {},
          "output_type": "execute_result"
        },
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAEYCAYAAACwQCa4AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAATIklEQVR4nO3df+xd933X8eerTpuabVkT5Rsrsp3aHWbgRE27fAkeBbE1QDwVlggW4YwRCyIZRWHtAGmyYYhtkiHANLFIJJIZIw6MRmY/iNUuLZFpNqFlTb/ZsiZ2asVrssTYi92Oru6QQu2++eN+wu6+uf5+7ze1z/XXn+dDujrnvM85976vj/S6x59z7v2mqpAk9eEds25AkjQcQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSNThX6S9yT5hSRfSPJiku9Ock2SJ5O81KZXj22/J8mxJEeT3D5WvyXJ823dg0lyMd6UJGmyac/0fwb4VFX9aeBm4EVgN3CoqrYAh9oySbYCO4Abge3AQ0nWtOd5GNgFbGmP7RfofUiSppDlvpyV5Crgt4H31djGSY4C31NVJ5NcDzxVVd+ZZA9AVf3Ltt2ngR8HXgE+0z44SHJ32//vL/X61157bW3atOntvTtJ6tSzzz77paqaW1y/Yop93wecBv5jkpuBZ4GPAeuq6iRAC/7r2vbrgd8Y2/94q329zS+uL2nTpk0sLCxM0aYk6U1JfndSfZrhnSuA7wIerqoPAn9IG8o532tNqNUS9bc+QbIryUKShdOnT0/RoiRpGtOE/nHgeFV9ti3/AqMPgdfbsA5temps+41j+28ATrT6hgn1t6iqfVU1X1Xzc3Nv+d+JJOltWjb0q+r3gNeSfGcr3QYcAQ4CO1ttJ/B4mz8I7EhyZZLNjC7YPtOGgs4k2dbu2rlnbB9J0gCmGdMH+GHg55O8C/gi8HcZfWAcSHIv8CpwF0BVHU5ygNEHw1ng/qo6157nPuARYC3wRHtIkgay7N07szY/P19eyJWklUnybFXNL677jVxJ6oihL0kdMfQlqSPTXsjtxqbdn5x1CxfNKw98ZNYtSJoxz/QlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqI9+nrsnE5f8cC/J6FLgzP9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SerIVKGf5JUkzyd5LslCq12T5MkkL7Xp1WPb70lyLMnRJLeP1W9pz3MsyYNJcuHfkiTpfFZypv+9VfWBqppvy7uBQ1W1BTjUlkmyFdgB3AhsBx5Ksqbt8zCwC9jSHtu/+bcgSZrWNzO8cwewv83vB+4cqz9WVW9U1cvAMeDWJNcDV1XV01VVwKNj+0iSBjBt6Bfw35M8m2RXq62rqpMAbXpdq68HXhvb93irrW/zi+uSpIFM+zdyP1RVJ5JcBzyZ5AtLbDtpnL6WqL/1CUYfLLsAbrjhhilblCQtZ6oz/ao60aangF8GbgVeb0M2tOmptvlxYOPY7huAE62+YUJ90uvtq6r5qpqfm5ub/t1Ikpa0bOgn+ZYk3/bmPPBXgReAg8DOttlO4PE2fxDYkeTKJJsZXbB9pg0BnUmyrd21c8/YPpKkAUwzvLMO+OV2d+UVwH+pqk8l+RxwIMm9wKvAXQBVdTjJAeAIcBa4v6rOtee6D3gEWAs80R6SpIEsG/pV9UXg5gn1LwO3nWefvcDeCfUF4KaVtylJuhD8Rq4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1JGpQz/JmiS/leQTbfmaJE8mealNrx7bdk+SY0mOJrl9rH5LkufbugeT5MK+HUnSUlZypv8x4MWx5d3AoaraAhxqyyTZCuwAbgS2Aw8lWdP2eRjYBWxpj+3fVPeSpBWZKvSTbAA+AvzsWPkOYH+b3w/cOVZ/rKreqKqXgWPArUmuB66qqqerqoBHx/aRJA1g2jP9fwv8KPCNsdq6qjoJ0KbXtfp64LWx7Y632vo2v7guSRrIsqGf5K8Bp6rq2Smfc9I4fS1Rn/Sau5IsJFk4ffr0lC8rSVrONGf6HwK+P8krwGPAh5P8Z+D1NmRDm55q2x8HNo7tvwE40eobJtTfoqr2VdV8Vc3Pzc2t4O1IkpaybOhX1Z6q2lBVmxhdoP0fVfVDwEFgZ9tsJ/B4mz8I7EhyZZLNjC7YPtOGgM4k2dbu2rlnbB9J0gCu+Cb2fQA4kORe4FXgLoCqOpzkAHAEOAvcX1Xn2j73AY8Aa4En2kOSNJAVhX5VPQU81ea/DNx2nu32Ansn1BeAm1bapCTpwvAbuZLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSR5YN/STvTvJMkt9OcjjJT7T6NUmeTPJSm149ts+eJMeSHE1y+1j9liTPt3UPJsnFeVuSpEmmOdN/A/hwVd0MfADYnmQbsBs4VFVbgENtmSRbgR3AjcB24KEka9pzPQzsAra0x/YL91YkSctZNvRr5Gtt8Z3tUcAdwP5W3w/c2ebvAB6rqjeq6mXgGHBrkuuBq6rq6aoq4NGxfSRJA5hqTD/JmiTPAaeAJ6vqs8C6qjoJ0KbXtc3XA6+N7X681da3+cV1SdJApgr9qjpXVR8ANjA6a79pic0njdPXEvW3PkGyK8lCkoXTp09P06IkaQorununqr4CPMVoLP71NmRDm55qmx0HNo7ttgE40eobJtQnvc6+qpqvqvm5ubmVtChJWsI0d+/MJXlPm18L/GXgC8BBYGfbbCfweJs/COxIcmWSzYwu2D7ThoDOJNnW7tq5Z2wfSdIArphim+uB/e0OnHcAB6rqE0meBg4kuRd4FbgLoKoOJzkAHAHOAvdX1bn2XPcBjwBrgSfaQ5I0kGVDv6o+D3xwQv3LwG3n2WcvsHdCfQFY6nqAJOki8hu5ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHlg39JBuTfCbJi0kOJ/lYq1+T5MkkL7Xp1WP77ElyLMnRJLeP1W9J8nxb92CSXJy3JUmaZJoz/bPAP66qPwNsA+5PshXYDRyqqi3AobZMW7cDuBHYDjyUZE17roeBXcCW9th+Ad+LJGkZy4Z+VZ2sqt9s82eAF4H1wB3A/rbZfuDONn8H8FhVvVFVLwPHgFuTXA9cVVVPV1UBj47tI0kawIrG9JNsAj4IfBZYV1UnYfTBAFzXNlsPvDa22/FWW9/mF9clSQOZOvSTfCvwi8CPVNVXl9p0Qq2WqE96rV1JFpIsnD59etoWJUnLmCr0k7yTUeD/fFX9Uiu/3oZsaNNTrX4c2Di2+wbgRKtvmFB/i6raV1XzVTU/Nzc37XuRJC1jmrt3AvwH4MWq+umxVQeBnW1+J/D4WH1HkiuTbGZ0wfaZNgR0Jsm29pz3jO0jSRrAFVNs8yHg7wDPJ3mu1f4J8ABwIMm9wKvAXQBVdTjJAeAIozt/7q+qc22/+4BHgLXAE+0hSRrIsqFfVf+TyePxALedZ5+9wN4J9QXgppU0KEm6cPxGriR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUkWVDP8nPJTmV5IWx2jVJnkzyUptePbZuT5JjSY4muX2sfkuS59u6B5Pkwr8dSdJSpjnTfwTYvqi2GzhUVVuAQ22ZJFuBHcCNbZ+Hkqxp+zwM7AK2tMfi55QkXWTLhn5V/Rrw+4vKdwD72/x+4M6x+mNV9UZVvQwcA25Ncj1wVVU9XVUFPDq2jyRpIG93TH9dVZ0EaNPrWn098NrYdsdbbX2bX1yXJA3oQl/InTROX0vUJz9JsivJQpKF06dPX7DmJKl3bzf0X29DNrTpqVY/Dmwc224DcKLVN0yoT1RV+6pqvqrm5+bm3maLkqTF3m7oHwR2tvmdwONj9R1JrkyymdEF22faENCZJNvaXTv3jO0jSRrIFcttkOTjwPcA1yY5Dvxz4AHgQJJ7gVeBuwCq6nCSA8AR4Cxwf1Wda091H6M7gdYCT7SHJGlAy4Z+Vd19nlW3nWf7vcDeCfUF4KYVdSdJuqD8Rq4kdcTQl6SOGPqS1BFDX5I6YuhLUkcMfUnqiKEvSR0x9CWpI4a+JHXE0Jekjhj6ktQRQ1+SOmLoS1JHDH1J6oihL0kdMfQlqSOGviR1xNCXpI4Y+pLUEUNfkjpi6EtSRwx9SeqIoS9JHTH0Jakjhr4kdcTQl6SOGPqS1JHBQz/J9iRHkxxLsnvo15ekng0a+knWAP8O+D5gK3B3kq1D9iBJPbti4Ne7FThWVV8ESPIYcAdwZOA+JF1iNu3+5KxbuKheeeAjs24BGH54Zz3w2tjy8VaTJA1g6DP9TKjVWzZKdgG72uLXkhy9qF3N1rXAl4Z4ofyrIV6lK4MdO/D4XQSX+/F776Ti0KF/HNg4trwBOLF4o6raB+wbqqlZSrJQVfOz7kMr57Fb3Xo9fkMP73wO2JJkc5J3ATuAgwP3IEndGvRMv6rOJvkHwKeBNcDPVdXhIXuQpJ4NPbxDVf0K8CtDv+4lrIthrMuUx2516/L4peot11ElSZcpf4ZBkjpi6EtSRwx9SeqIoT+gJD86Nn/XonX/YviONC2PnS4Xhv6wdozN71m0bvuQjWjFPHarXJI/leRQkhfa8vuT/Nis+xqaoT+snGd+0rIuLR671e/fM/rA/jpAVX2eP/5h3gVDf1h1nvlJy7q0eOxWvz9RVc8sqp2dSSczNPiXszp3c5KvMjozXNvmacvvnl1bmoLHbvX7UpLvoH1IJ/kB4ORsWxqeX86S1IUk72P0Ldw/D/xv4GXgh6rqlVn2NTRD/xKR5NWqumHWfWjlPHarS5JvAd5RVWdm3cssOLxz6fBi4OrlsbuEJflH56kDUFU/PWhDM2boXzr8L9fq5bG7tH3brBu4lBj6AzrfGQejM8VvHbIXrYzHbvWqqp+YdQ+XEkN/WEudcfzMYF3o7fDYrXJJ3g3cC9zI2B1XVfX3ZtbUDHgh9xKR5M9W1edm3YdWzmO3OiT5r8AXgB8EfhL428CLVfWxmTY2MEN/hpJsZfSNwLuBP+jx73WuVh671SfJb1XVB5N8vqren+SdwKer6sOz7m1IDu8MLMl7GQXF3Yy+DfheYL63e4VXI4/dqvf1Nv1KkpuA3wM2za6d2fBnGAaU5NcZ/anIdwI/UFW3AGcMjUufx+6ysC/J1cA/Aw4CR4B/PduWhueZ/rBOAxuAdcAc8BLe7rdaeOxWuar62Tb7q8D7ZtnLLDmmP7Ak3w78TUZDBH8SeA9w+4QfgtIlxmO3uiV5D3APoyGd/3/CW1UfnVFLM2Hoz1CSdcDfYnRBcGNVbZxxS5qSx271aUN0vwE8D3zjzXpV7Z9ZUzNg6F8ikry3qn531n1o5Tx2q0OS36yq75p1H7Nm6A8oycGl1lfV9w/Vi1bGY7f6JfmHwNeATwBvvFmvqt+fWVMz4IXcYX038BrwceCz+ENdq4nHbvX7v8C/Af4pf3QRvujsoq5n+gNKsgb4K4wuBL4f+CTw8ao6PNPGtCyP3eqX5HeAP1dVX5p1L7PkffoDqqpzVfWpqtoJbAOOAU8l+eEZt6ZleOwuC4eB/zPrJmbN4Z2BJbkS+AijM8ZNwIPAL82yJ03HY7fqnQOeS/IZ/viYvrds6uJIsh+4CXgCeKyqXphxS5qSx271S7JzUt1bNnXRJPkG8IdtcfwfPkBV1VXDd6VpeOwuD0nWAjdU1dFZ9zIrhr6kLiT568BPAe+qqs1JPgD8ZG+323ohd0BJPjw2v3nRur8xfEdSV34cuBX4CkBVPQdsPv/mlydDf1g/NTb/i4vW/diQjUgdOltVf7Co1t1Qh3fvDCvnmZ+0LOnCeiHJDwJrkmwBPgr8+ox7Gpxn+sOq88xPWpZ0AST5T232dxj9fdw3GH2z+qvAj8yorZnxQu6AknwF+DVGZ/V/sc3Tlv9CVV09o9aky1aSI8D3MfrDKd+7eH1vv71j6A8oyV9aan1V/epQvUi9SPJR4D5Gv7Hzv8ZXMbrd1t/e0cWR5IaqenXWfUg9SvJwVd036z5mzTH9Yf23N2eSLL57R9JFZOCPGPrDGr9Dp6v/Ukq6NBj6w1rq7h1Juugc0x9QknOMfr8lwFr+6Gde/f0WSYMw9CWpIw7vSFJHDH1J6oihL0kdMfQlqSOGviR15P8BE7FsT2TrWYUAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "needs_background": "light"
          },
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['Gender'].value_counts().plot(kind='bar')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "iYlG2SMIIf3K",
        "outputId": "89260f3d-ec7b-4aa1-e9b1-0bb36c06e70c"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "<AxesSubplot:ylabel='Gender'>"
            ]
          },
          "execution_count": 8,
          "metadata": {},
          "output_type": "execute_result"
        },
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAQsAAADnCAYAAAAJpHMfAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXAklEQVR4nO3deZhkVX3G8e+vumfp2WoQWdQAF8VoZEAQAwKPiYmCSCniOiwBFVFUFDASKAjGGyRaMbigEbc8KmKAiEZhLBY3GMGwuAGDBgSdEjCGAAMF093V68kf5w4UTU/37e6qOnVvvZ/nqae7qqu73oLpt8+5y7nmnENEZDaF0AFEJBtUFiKSispCRFJRWYhIKioLEUlFZSEiqagsRCQVlYWIpKKyEJFUVBYikorKQkRSUVmISCoqCxFJRWUhIqmoLDrAzCbM7JamW2RmLzOz+pTHX5E835nZhU3f329mD5jZd6f83MvM7IYpj8VmdmqKDOV2vV/Jp/7QAXrEsHNur+YHzCwCrnPOvXqa5w8Ca8xswDk3DBwE/GHK968GXgRsNrNdnXMb55pBZC40suheVwKl5PMjgYunfP0NwDrgEuCIDuaSHqWy6IyBpuH/t5sef+mUqcFzmr52CXCEmS0F9gRumvIztxTIxcnnc8lwi5mtXcgbkt6jaUhnbG0KsLVpCM6525KpypHAFc1fM7MdgN2A651zzszGzWyNc+72eWQQSUUji+52OXAuT52CrAW2ATaaWQ2I0FRE2kxl0d2+DJztnNsw5fEjgUOcc5FzLgL2QWUhbaayCGvqNos3Nn/ROXefc+685seSqcnOwI1Nz9sIPGpm+yUPnWVm9225JY9N3WZRad/bkjwyXQpARNLQyEJEUlFZiEgqKgsRSUVlISKp6KCsnIrK1W3xx1/s0vRxJ6AILEtuA8ASwPB/OArAGLAJeDC5PTTl8weA3wK1WqWkreM9RHtDMi4qV58OHADsD+zBE8Wwos0v/RhwO7ABuC25bahVSo+0+XUlEJVFhkTlagHYHV8OW267BQ31VPcCvwC+B1xZq5RmOxtWMkJl0eWicvVpwOuA1wMH4qcRWfIb/Bm0VwHX1iqlRuA8Mk8qiy7UVBBvAl5OfrYtDQPr8SfGXVqrlP43cB6ZA5VFl8hxQWzNOHA18FXg8lqlNBo2jsxGZRFYVK7uC5yEL4nFgeOEsgm4APhcrVK6K3QYmZ7KIoCoXO0H3gycDOwbOE43ccAPgM/iRxv6x9lFVBYdFJWrA8DxwAfwuzdl6zYAH6pVSt+e9ZnSESqLDojK1WXAKcltu6BhsufnwD/UKqUrZn2mtJXKos2icvUo4J+BPwmdJeNuAD5Yq5R+GDpIr1JZtElUrv45cB7+yEppnWuAM2uV0o2zPlNaSmXRYlG5+kzgo8Ax+HMupPUc8Hng9Fql9FjoML1CZdEiUbm6BDgVOANYHjhOr7gXeJe2Z3SGyqIFonJ1d/wK3HuEztKjLgJOrlVKD4YOkmdaz2KBonL1vcDPUFGEdBTw66hcTXOxJZknjSzmKSpXtwO+whOXGJTusA54W61Seih0kLxRWcxDVK6+En9Ow46Bo8j0NgKvq1VKt4YOkicqizmIytXF+GMmTkZ7OrrdEHB8rVKaejU3mSeVRUpRuboNcBnw0tBZZE4+AZxWq5QmQgfJOpVFClG5GuEXcHl+4CgyPz8E1mo7xsJob8gsonJ1H/yhxiqK7Ho58LOoXN0rdJAsU1nMICpXS/iVnbQhM/si4MdRufqXoYNklcpiK6Jy9Z34bRQ6GjM/VgJXRuXqoaGDZJHKYhpRufph4AtAX+gs0nIDwHeicvXNoYNkjcpiiqhcPRs4K3QOaatFwEVRubo2dJAs0d6QJlG5egbwkdA5pGMmgCNrldKloYNkgcoiEZWrJwOfCp1DOm4cOKJWKX0rdJBup7IAonL1b4CvoaMye9Uo8IpapXRd6CDdrOfLIjnPYx1+Hiu960Fgv1ql9LvQQbpVT5dFsvTdNWj3qHi/BvavVUqPhg7SjXp2b0hUru6AjqOQJ3sB8B9Ruapd5tPoybJIrkZ+EfCM0Fmk6xwCfDx0iG7Uk2UB/CPw16FDSNc6OSpXTwgdotv03DaLqFw9BH8Vb+35kJmM4/eQrA8dpFv0VFlE5epOwC+BbUNnkUy4B9hDGzy9npmGROXqIuAbqCgkvZ3RgXqP65mywC+H95LQISRz3haVq68OHaIb9MQ0JCpXDwSuQ9spZH7+F9i9ViltCh0kpNyPLKJytR9/qTsVhczXjsD5oUOElvuyAN4PrAkdQjJvba+f0p7raUhUru6MP4RXR2lKKzyEn47cHzpICHkfWXwaFYW0zrbA2aFDhJLbkUVUrh6GP/dDpJUmgDW1SumO0EE6LZcji6hcXYYfVYi0Wh/w0dAhQshlWQCnAruEDiG5dXiyO76n5K4sonJ1JXBK6BySex8LHaDTclcWwInANqFDSO4dEJWrrwsdopNytYEz2VZRA7YLHEV6w534jZ3joYN0Qt5GFiegopDOeR5wbOgQnZKbsojK1SX4DZsinfT+0AE6JTdlARwHPDN0COk5a6Jy9aDQITohF2WRrFVxeugc0rN6YnSRi7IADkfHVUg4h0Tl6p+GDtFueSmLt4cOID3NgHeGDtFumd91mpxZupH8FJ9k00PAs2qV0kjoIO2Sh1+wt5KP9yHZti3w+tAh2ikPv2Q9s59bul6up8OZnoZE5eq+wE2hc4gkxoHta5XSw6GDtEPWRxZHhQ4g0qQfODR0iHbJbFkk1yt9c+gcIlO8NnSAdslsWeCvAaILG0u3OSQqVxeHDtEOWS6Ll4cOIDKNlcBfhQ7RDlkuC10FXbpVLqcimdwbEpWrS4FHgCWBo4hM5w/ATrVKKXu/XDPI6sjiQFQU0r2eBewdOkSrZbUsNAWRbndA6ACtprIQaY99QgdotcyVRbJ694tD5xCZRe7+jWauLPDbK/pDhxCZxZ8lC0jnRhbLQldElyzoA/YKHaKVZi0LM+szsx90IkxKzw8dQCSlXE1FZi0L59wEMGRmxQ7kSeN5oQOIpJSrskg7928AG8zs+8Dglgedcye1JdXMNLKQrMjVHpFUR3Ca2Vume9w5d0HLE80gKle3BR7s5GuKLMAEsLhWKU2GDtIKqUYWzrkLzGwA2Nk5d2ebM81EUxDJkj5gB+CPoYO0Qqq9IWb2GuAW4Krk/l5mdnkbc22NpiCSNblZRiHtrtMY2Bd/8hbOuVuAXduSaGYaWUjW5OYqeWnLYtw5V5/yWIgz6nYK8JoiC5Gbski7N+R2MzsK6DOz5wInAf/VvlhbtSrAa4osRM9NQ94H7A6MABcDjwKntCnTTFQWkjW9NbJwzg0Bf5/cQlJZSNb0RlmY2Tpm2DbhnDus5YlmtrLDryeyULmZhsw2sjg3+fh6YEfg68n9I4FamzLNRCMLyZrcnHk6Y1k459YDmNmHnXN/0fSldWb247Ymm57KQrIm9XIKZnYS8G7gF865o1sdxMxiYLNz7tzZnjudtG9kOzN7tnPud8mL7gpsN58XnK/kWgy5vB6D5Npc1l55D/Aq59zGdoVZiLRv5P3AtWb2u+R+BJzQlkRbp+0VkkWpfsfM7PPAs4HLzewS4DnAHsn3x865y8zsrcDh+MPI1wAfx/8BPQa/p/JQ59wmM3sH8M7ka3cDxyQ7KZpf7znAZ/F/9IeAdzjn7ljwG3HOXZUcX7HlcOs7nHMjab63hXK1rPpC9TM+toLhwZU2PLSSoeFVNjiyiqGRog2OFxkcW22bJ4oMTq6yQVYxxAobtuU0+pbT6Ftqo4uWMrZ4EWNL+plY2sfk0kmgYTY2YoXREbOx4UJhYthstGE20bDC+HDBJoatMNEo2OSQFSYbZpPDhYIbNnPDBXMNMxpmjFjBRgwbMbNRs8KYWWHUKIyZFcaN/nGjbwLrnzD6J6F/0ljkYJGDxQ7XD1jo/7atZY9BadZnOefeZWaH4C9Q9LfAj5xzx5nZauDmpjVl1uBXDl+KL4LTnXN7m9kngWOBTwH/6Zz7EoCZnYO/uvtnprzkF4F3OefuMrP9gPOZZW3buQyR9sGPKPqBF5oZzrmvzeH7F6rRwddqGWNychkjQysYHlppQ8OrGGoUbXCkyODoKhscKzI4WbTBiSKDzv9iD9sKGy4so1EYsNFFSxldtJixxYsYX9rH5ECByWUGy8xYBKxObgvWByzCsdJN+loOcJ7kJEyOGaMNs9FRs5ERs9ERs7GGFcYaZuONgo03zMYbZhPDZhPDhcLksNlEo2Bu2GyyYUajUHC+tIwRsy2lZSNmfY+XFtbni8v6J6B/EuufNBZN+tJa4vxf5CWYLVr4u3KDsz/nKQ4GDjOzU5P7S4Gdk8+vcc49BjxmZnVgXfL4BmDP5PM1SUmsBlYAVzf/cDNbgV99/FKzx7t51ktrpB0iXYgfFt2CP+0W/D+pTpZF20cySxhtLKcxtNKGhlcyNFy0oZFVDI6uts1jqxgaK9rgZJHNk0UbYiVDrLShwnIahQFG+gZsdPES/0u95a/1gOGWmzGA/x+2ot35s64AhSWOpUucW9oNA0kHbtQYGTEbGU2Ky5eXjQ1bYbxRsLHm8mr48ppsmE0mBeYmzOazpIIBb5h6hncyAmj+PZhsuj/JE7/PXwUOd87dmkxdXjbl5xeAR5xze80lVNqRxYuBF7iAly+rVUoTUbk6AfQVmJxYwdDgChqDK22osYqhkVXJX+vVNjhetM0TqxiaKCZD8JU2ZCsYLixjpG/ARvqXMLZ4MWNLFjGxZMtfa2C5GUvxLS6CgbWgvG6bx/dcDbzPzN7nnHNmtrdz7pdz+P6VwB/Nj4yOxl8h7XHOuUfNbKOZvck5d6n54cWezrlbZ/qhqc8NwR9nEfS8/N8uOfreAu4ZZizB70bVrlTpdvOZhnwYv+3htuQXuQa8eg7f/0HgJuD3+OnJdDsHjgY+Z2ZnAYuAS4AZyyLtSlnX4FcqvpmmYVDHj+CMi7/nibmbSBZ8n7h+cOgQrZB2ZBG3M8QcPILKQrJlc+gArZJ21+l6M9sFeK5z7gdmtgy/Ab3THg7wmiIL8T+hA7RK2mX13gF8E/hC8tCzgO+0KdNMHgjwmiILUQsdoFXSrmdxIv6ygY8COOfuArZvV6gZ3B3gNUUWohY6QKukLYsR59zoljtm1k+YHeF3BXhNkYWohQ7QKmnLYr2ZnQkMmNlBwKU8ceRYJ6ksJGtqoQO0StqyKOO3F2zAn6BSdc6FWDVL0xDJks3E9dxcFGvGsjCz15rZic65yeTElF3wR3OeaWZv7EjCZnH9j+RoV5Tk3u9DB2il2UYWpwHNFxNajD+h7GX4RTpC0OhCsqIWOkArzVYWi51z9zbdv945t8k5dw+wvI25ZqLtFpIVG0IHaKXZymKb5jvOufc23e3oSllNQl5rVWQuQlxbp21mK4ubkgOynsTMTsCfJxLCDYFeV2SubgwdoJVmPJHMzLbHH6k5AvwieXgf/EIZhzvn7m93wKeIi6uATYQ53FwkrbuJ688NHaKVZhxZOOf+zzl3AP6U2VpyO9s5t3+QogCI648yy6m0Il0gV1MQSH8i2Y+AH7U5y1z8GHhR6BAiM8jddDntQVndZn3oACKzyN3IIqtlcR3dsEijyPQew68ulyvZLIu4/hDw69AxRLbiWuJ6gPXR2yubZeFdGzqAyFZ8M3SAdshyWXwrdACRaYzx5FMkciPLZbGeHC1ZJrnxQ+L6I6FDtEN2y8LPCb8ROobIFLmcgkCWy8K7OHQAkSbjhFmbtiOyXRZx/Wbgt6FjiCTWJ3vqcinbZeFdEjqASCK3UxDIR1loKiLdYIicb0PLflnE9V8Bc7lorEg7XEhc3xQ6RDtlvyy8T4YOID3NAeeFDtFueSmLS4B7Z32WSHt8j7j+36FDtFs+yiKuj+EvUS8SQu5HFZCXsvC+BNRDh5CecydwVegQnZCfsojrjwGfDx1Des6nies9sVxCfsrCOw8YnfVZIq3xEHBB6BCdkq+y8Fcs+3roGNIzziGuD4YO0Sn5KgvvHPxq5CLtdDfw2dAhOil/ZRHXNwKfCB1Dcq+c7IXrGfkrC+8jaK0LaZ+fENd7bvGlfJZFXN8MnBE6huTWB0IHCCGfZeFdCNwUOoTkzjeI6z357yq/ZeH3fZ+ELhkgrTMKlEOHCCW/ZQFbFse5MHQMyY0PJRvQe1K+y8I7DXggdAjJvJ8AHwsdIqT8l0Vcvx94e+gYkmmDwFvyeOGguch/WQDE9XXA50LHkMw6lbje82u99kZZeB9AlzyUubuKuK4TFOmlsojrw8BR6FBwSe9hNIV9XO+UBUBcvxUdrCXpvYe4riOBE71VFt6ngKtDh5Cudy5xXZeZaNJ7ZeEP1joaf9agyHTWAaeHDtFtzLkePcAxLu4G3AA8PXQU6Sq3AQcm5xdJk94bWWwR1+8GDgMaoaNI17gfeI2KYnq9WxYAcf0G4Bh0/oj4PxqHE9fvCR2kW/V2WQDE9W8Cfxc6hgT3duL6jaFDdDOVBUBc/zg9tkSaPMlpxPWLQofodiqLJ5xMzi9sK9M6g7j+L6FDZIHKYou4PoE/wvPfQ0eRjvkgcb0SOkRWqCya+cI4lh66FkQPO5O4fk7oEFmispjKn4b8NnSWal75FdTi+kdDB8ma3j0oK424GAMfCh1DWmYSOJ64/pXQQbJIZTGbuHgi8Gk0Csu6OnA0cb0aOkhWqSzSiIuvwa/lWQwdReblDvwBV3eGDpJl+muZhl9pax/8eQOSLd8F9lNRLJzKIi2/rNpL0GrhWfJPwGuJ64+GDpIHmobMR1x8N35djMWBk8j0BoG3JofyS4uoLOYrLu4HXArsFDqKPMkvgWOJ67eHDpI3mobMl7+E3YsArabUHUaBDwL7qijaQyOLVoiLhwLnA7uEjtKjfgocp5JoL40sWiGuXwHsDnwSmAicppeM4K89ur+Kov00smi1uLgP8CVg79BRcu4G/GjijtBBeoVGFq0W138O7ItfUEe77FrvN8Ba/DqZKooO0siineLi0/BXQjsJWBE4Tdb9ATgb+DJxfTx0mF6ksuiEuPh0/EjjRGB54DRZ8zBQAT6TXFVOAlFZdFJc3B44DXgPMBA4Tbd7DPhX4GPE9UcCZxFUFmHExR2BU/DrZmwfNkzX2YDfDf11LcnfXVQWIcXFRfhrlxwPHEzvbnAeBb4FnE9cvz50GJmeyqJbxMWdgeOSW68cQn4P8EXg34jr94cOIzNTWXSbuFgAXonfPXgIsEPYQC33K+By4DLg5uTas5IBKotuFhcNf/7Jq4BDgf3I3lRlArgeXw6XJ6f6SwapLLLEH7dxML48XgpEgIWMNI0GcCv+fI0bgSuJ65vCRpJWUFlkWVxcBbwwue2VfFwDLO1QgjH83oufJbefArfroKl8UlnkTVzsA56X3HbA75qd7uPqGX7KOP4krU34IyfvSz5O/fxe4vpoO96GdB+VRa/ypdKP3wZiyccxYFQbHWU6KgsRSSVrW9ZFJBCVhYikorIQkVRUFvIkZubM7MKm+/1m9oCZfXfK8y4zsxumPBab2anT/MwJM7ul6VZu3zuQdukPHUC6ziCwxswGnHPDwEH43aSPM7PV+CNLN5vZrs65jbP8zGHn3F7tCCudo5GFTOdKoJR8fiRw8ZSvvwFYh78MwhEdzCUBqSxkOpcAR5jZUmBP4KYpX99SIBcnn89mYMo0ZG1r40onaBoiT+Gcu83MInwRXNH8NTPbAdgNuN4558xs3MzWOOdmWopf05Ac0MhCtuZy4FyeOgVZC2wDbDSzGv5kNk1FeoDKQrbmy8DZzrkNUx4/EjjEORc55yJgH1QWPUFlIdNyzt3nnDuv+bFkarIz/tTzLc/bCDxqZvslD51lZvdtuSWPTd1mUenEe5DW0rkhIpKKRhYikorKQkRSUVmISCoqCxFJRWUhIqmoLEQkFZWFiKSishCRVFQWIpKKykJEUlFZiEgqKgsRSUVlISKpqCxEJBWVhYik8v/yLr1f2jAVYAAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {},
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['Gender'].value_counts().plot(kind='pie')"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ue_KqcYlIf3L",
        "outputId": "9cfc8c5b-bfe1-44c9-ff2a-cde8f0c0f8dd"
      },
      "outputs": [
        {
          "data": {
            "text/plain": [
              "<AxesSubplot:>"
            ]
          },
          "execution_count": 9,
          "metadata": {},
          "output_type": "execute_result"
        },
        {
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD5CAYAAADcDXXiAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAV2UlEQVR4nO3df3BV5Z3H8fcnMSQUI+oYXCCMcTo4G2Ar3b1lOqu7I9ouWjsb3RlbmG6HHdilO6v0h+5ULH9Y/mBk2drW6S7t0NUpM6tQtK2yWttaGtel7ojBpUpMHdkSJcJCUrQgU2ISvvtHDniBm+Tkx+XmnnxeM5lzznOec+43f+TD4bnPOUcRgZmZZUtFqQswM7Ox53A3M8sgh7uZWQY53M3MMsjhbmaWQQ53M7MMuiBtR0mVQAvwVkR8UtKlwPeBBqAd+FREvJ30vQdYDvQBn4+Inw527ssuuywaGhpGUr+Z2YS1a9euroioK7QvdbgDXwDagIuS7VXA9ohYJ2lVsn23pDnAYmAuMAP4uaSrIqJvoBM3NDTQ0tIyjFLMzEzSGwPtSzUsI6keuBn4t7zmJmBTsr4JuCWvfUtEdEfEPmAvsGCYNZuZ2SikHXP/JvBl4GRe2+URcRAgWU5L2mcC+/P6dSRtZ5C0QlKLpJbOzs7h1m1mZoMYMtwlfRI4HBG7Up5TBdrOecZBRGyMiFxE5OrqCg4ZmZnZCKUZc78G+EtJnwBqgIsk/TtwSNL0iDgoaTpwOOnfAczKO74eODCWRZuZ2eCGvHKPiHsioj4iGuj/ovQXEfHXwDZgadJtKfBEsr4NWCypWtKVwGxg55hXbmZmAxrNPPd1wMclvQ58PNkmIlqBrcCrwE+A2webKWM2Xm3evJl58+ZRWVnJvHnz2Lx5c6lLMkttOFMhiYhngWeT9d8CNwzQby2wdpS1mZXM5s2bWb16NQ8++CDXXnstO3bsYPny5QAsWbKkxNWZDU3j4XnuuVwuPM/dxpN58+bxrW99i4ULF55ua25uZuXKlezZs6eElZm9T9KuiMgV3OdwNztXZWUlJ06coKqq6nRbT08PNTU19PV5lNHGh8HC3c+WMSugsbGRHTt2nNG2Y8cOGhsbS1SR2fA43M0KWL16NcuXL6e5uZmenh6am5tZvnw5q1evLnVpZqkM6wtVs4ni1JemK1eupK2tjcbGRtauXesvU61seMzdzKxMeczdzGyCcbibmWWQw93MLIMc7mZmGeRwNzPLIIe7mVkGOdzNzDLI4W5mlkEOd7MB+HnuVs78+AGzAvw8dyt3fvyAWQF+nruVg1E9fkBSjaSdkn4lqVXSmqT9q5LekrQ7+flE3jH3SNor6TVJi8buVzE7P9ra2ujo6DhjWKajo4O2trZSl2aWSpphmW7g+oh4V1IVsEPS08m+b0TE1/I7S5pD/4u05wIzgJ9LusrvUbVyMmPGDO6++24efvjh08Myn/nMZ5gxY0apSzNLZcgr9+j3brJZlfwMNpbTBGyJiO6I2AfsBRaMulKz8+zsIcvxMIRpllaq2TKSKiXtBg4Dz0TEC8muOyS9LOkhSZckbTOB/XmHdyRtZmXjwIEDrF+/npUrV1JTU8PKlStZv349Bw4cKHVpZqmkCveI6IuI+UA9sEDSPODbwAeB+cBB4P6kuwqd4uwGSSsktUhq6ezsHEHpZsXT2NhIfX09e/bsoa+vjz179lBfX+/X7FnZGNY894h4B3gWuDEiDiWhfxL4Lu8PvXQAs/IOqwfOudyJiI0RkYuIXF1d3UhqNysav2bPyl2a2TJ1ki5O1icDHwN+LWl6XrdbgVPzw7YBiyVVS7oSmA3sHNOqzYpsyZIl3Hzzzdx0001MmjSJm266iZtvvtlz3K1spLlynw40S3oZeJH+MfcngfWSXknaFwJfAoiIVmAr8CrwE+B2z5SxcrN582aeeuopnn76ad577z2efvppnnrqKd+lamXDNzGZFeCbmKwcDHYTk8PdrIDKykpOnDhBVVXV6baenh5qamro6/N/RG188AuyzYapsbGRNWvWnHGH6po1azxbxsqGw92sgIULF3LffffR1dXFyZMn6erq4r777jtjmMZsPHO4mxXw+OOPU1tby+TJk6moqGDy5MnU1tby+OOPl7o0s1Qc7mYFdHR08Oijj7Jv3z76+vrYt28fjz76KB0dHaUuzSwVh7uZWQY53M0KqK+vZ+nSpWfcobp06VLq6+tLXZpZKg53swLWr19Pb28vy5Yto6amhmXLltHb28v69etLXZpZKg53swKWLFnCAw88wJQpUwCYMmUKDzzwgB8/YGXDNzGZmZUp38RkZjbBONzNzDLI4W42gFNvYZJ0+m1MZuXC4W5WwMqVK9mwYQMXX3wxABdffDEbNmxwwFvZ8BeqZgVUVVVRUVFBRNDT00NVVRWSOHnyJD09PaUuzwzwF6pmw9bb20tvby/r1q3j+PHjrFu37nSbWTnwlbtZAZJoaGjg4MGDdHd3U11dzfTp02lvb2c8/M2Yga/czUakvb2dRYsW0dnZyaJFi2hvby91SWapXTBUB0k1wHNAddL/sYi4V9KlwPeBBqAd+FREvJ0ccw+wHOgDPh8RPy1K9WZFtm3bNurq6kpdhtmwpbly7wauj4irgfnAjZI+CqwCtkfEbGB7so2kOcBiYC5wI7BBUmURajczswEMGe7R791ksyr5CaAJ2JS0bwJuSdabgC0R0R0R+4C9wIKxLNrsfKmsrDxjaVYuUo25S6qUtBs4DDwTES8Al0fEQYBkOS3pPhPYn3d4R9J29jlXSGqR1NLZ2TmKX8GseNavX8/x48f9NEgrO6nCPSL6ImI+UA8skDRvkO4qdIoC59wYEbmIyHlM08ajmpoa7rrrLqZMmcJdd91FTU1NqUsyS21Ys2Ui4h3gWfrH0g9Jmg6QLA8n3TqAWXmH1QMHRluo2fl24sQJ5s6dyxtvvMHcuXM5ceJEqUsyS23IcJdUJ+niZH0y8DHg18A2YGnSbSnwRLK+DVgsqVrSlcBsYOcY1212XrS2tnLFFVfQ2tpa6lLMhmXIqZDAdGBTMuOlAtgaEU9K+m9gq6TlwJvAbQAR0SppK/Aq0AvcHhF9xSnfrHguvPBCuru7Tz9+oLq6mnfffXfoA83GgSHDPSJeBj5coP23wA0DHLMWWDvq6sxK6EMf+hC//OUvT29fc801PP/88yWsyCw936FqNoDnn3+epqYmurq6aGpqcrBbWUkzLGM24cydO5fDhw+fcYdqXV0d06ZNG+JIs/HBV+5mBSxcuJCurq4zbmLq6upi4cKFJa7MLB2Hu1kBjzzyCBFBX1//XIC+vj4igkceeaTElZml43A3K+DIkSNUVFRw//33c/z4ce6//34qKio4cuRIqUszS8XhbjaAZcuWceedd/KBD3yAO++8k2XLlpW6JLPUHO5mA3jsscdobm6mp6eH5uZmHnvssVKXZJaaZ8uYFVBZWck777zD9ddff067WTnwlbtZATNmzBhWu9l443A3K2D//v1IZz7gVBL79+8f4Aiz8cXhbjaI/NkyZuVE4+FN7rlcLlpaWkpdhtlpkrjooos4duwYEYEkamtrOXr0KOPhb8YMQNKuiMgV2ucrd7MBHD16lEmTJlFRUcGkSZM4evRoqUsyS82zZcwG0d3dfcbSrFz4yt3MLIMc7mZmGeRwNzPLoDTvUJ0lqVlSm6RWSV9I2r8q6S1Ju5OfT+Qdc4+kvZJek7SomL+AmZmdK80Xqr3AXRHxkqRaYJekZ5J934iIr+V3ljQHWAzMBWYAP5d0ld+jauWotraW48ePM2XKFI4dO1bqcsxSG/LKPSIORsRLyfoxoA2YOcghTcCWiOiOiH3AXmDBWBRrdr4dO3aMkydPOtit7AxrzF1SA/0vy34habpD0suSHpJ0SdI2E8i/R7uDAv8YSFohqUVSS2dn5/ArNzOzAaUOd0kXAj8AvhgRR4FvAx8E5gMHgVP3Z6vA4efc0hcRGyMiFxG5U++oNBsvpkyZMqx2s/EmVbhLqqI/2B+OiB8CRMShiOiLiJPAd3l/6KUDmJV3eD1wYOxKNiu+6urqYbWbjTdpZssIeBBoi4iv57VPz+t2K7AnWd8GLJZULelKYDawc+xKNiu+I0eOnPPs9srKSr9mz8pGmtky1wCfBV6RtDtp+wqwRNJ8+odc2oHPAUREq6StwKv0z7S53TNlrBz19fVRUVHByZMnqaioOP2ybLNyMGS4R8QOCo+j/3iQY9YCa0dRl9m4MHXqVN555x2mTp3K22+/XepyzFLzg8PMBnEq0B3sVm78+AEzswxyuJuZZZDD3cwsgxzuZmYZ5HA3M8sgh7uZWQY53M3MMsjhbmaWQQ53M7MMcribmWWQw93MLIMc7mZmGeRwNzPLIIe7mVkGOdzNzDLI4W5mlkFp3qE6S1KzpDZJrZK+kLRfKukZSa8ny0vyjrlH0l5Jr0laVMxfwMzMzpXmyr0XuCsiGoGPArdLmgOsArZHxGxge7JNsm8xMBe4EdggqbLgmc3MrCiGDPeIOBgRLyXrx4A2YCbQBGxKum0CbknWm4AtEdEdEfuAvcCCMa7bzMwGMawxd0kNwIeBF4DLI+Ig9P8DAExLus0E9ucd1pG0nX2uFZJaJLV0dnaOoHQzMxtI6nCXdCHwA+CLEXF0sK4F2uKchoiNEZGLiFxdXV3aMszMLIVU4S6piv5gfzgifpg0H5I0Pdk/HTictHcAs/IOrwcOjE25ZueXpDOWZuUizWwZAQ8CbRHx9bxd24ClyfpS4Im89sWSqiVdCcwGdo5dyWbnT0ScsTQrFxek6HMN8FngFUm7k7avAOuArZKWA28CtwFERKukrcCr9M+0uT0i+sa6cDMzG9iQ4R4ROyg8jg5wwwDHrAXWjqIuMzMbBd+hamaWQQ53M7MMcribmWWQw93MLIMc7mZmGeRwNzPLIIe7mVkGOdzNzDLI4W5mlkEOdzOzDHK4m5llkMPdzCyDHO5mZhnkcDczyyCHu5lZBjnczcwyyOFuZpZBad6h+pCkw5L25LV9VdJbknYnP5/I23ePpL2SXpO0qFiFm5nZwNJcuX8PuLFA+zciYn7y82MASXOAxcDc5JgNkirHqlgzM0tnyHCPiOeAIynP1wRsiYjuiNgH7AUWjKI+MzMbgdGMud8h6eVk2OaSpG0msD+vT0fSZmZm59FIw/3bwAeB+cBB4P6kXQX6RqETSFohqUVSS2dn5wjLMDOzQkYU7hFxKCL6IuIk8F3eH3rpAGblda0HDgxwjo0RkYuIXF1d3UjKMDOzAYwo3CVNz9u8FTg1k2YbsFhStaQrgdnAztGVaGZmw3XBUB0kbQauAy6T1AHcC1wnaT79Qy7twOcAIqJV0lbgVaAXuD0i+opSuZmZDUgRBYfEz6tcLhctLS2lLsPsNKnQ10f9xsPfjBmApF0RkSu0z3eompllkMPdzCyDHO5mZhnkcDczyyCHu5lZBjnczcwyyOFuZpZBDnczswxyuJuZZZDD3cwsgxzuZmYZ5HA3M8sgh7uZWQY53M3MMsjhbmaWQQ53M7MMcribmWXQkOEu6SFJhyXtyWu7VNIzkl5Plpfk7btH0l5Jr0laVKzCzcxsYGmu3L8H3HhW2ypge0TMBrYn20iaAywG5ibHbJBUOWbVmplZKkOGe0Q8Bxw5q7kJ2JSsbwJuyWvfEhHdEbEP2AssGJtSzcwsrZGOuV8eEQcBkuW0pH0msD+vX0fSZmZm59FYf6Fa6JXxBV8VL2mFpBZJLZ2dnWNchpnZxDbScD8kaTpAsjyctHcAs/L61QMHCp0gIjZGRC4icnV1dSMsw8zMChlpuG8DlibrS4En8toXS6qWdCUwG9g5uhLNzGy4Lhiqg6TNwHXAZZI6gHuBdcBWScuBN4HbACKiVdJW4FWgF7g9IvqKVLuZmQ1gyHCPiCUD7LphgP5rgbWjKcrMzEbHd6iamWWQw93MLIMc7mZmGeRwNzPLIIe7mVkGOdzNzDLI4W5mlkEOdzOzDHK4m5llkMPdzCyDHO5mZhnkcDczy6AhHxxmliVSoffJjP05Igq+o8bsvHG424SSNnQHC3AHt5UDD8uYFTBQgDvYrVw43M0GEBFEBFfc/eTpdbNy4XA3M8sgh7uZWQaN6gtVSe3AMaAP6I2InKRLge8DDUA78KmIeHt0ZZqZ2XCMxZX7woiYHxG5ZHsVsD0iZgPbk20zMzuPijEs0wRsStY3AbcU4TPMzGwQow33AH4maZekFUnb5RFxECBZTit0oKQVkloktXR2do6yDDMzyzfam5iuiYgDkqYBz0j6ddoDI2IjsBEgl8t5jpmZ2Rga1ZV7RBxIloeBHwELgEOSpgMky8OjLdLMzIZnxOEuaYqk2lPrwF8Ae4BtwNKk21LgidEWaWZmwzOaYZnLgR8lz+C4AHgkIn4i6UVgq6TlwJvAbaMv08zMhmPE4R4RvwGuLtD+W+CG0RRlZmaj4ztUzcwyyOFuZpZBfp67lbWr1/yM3/2+p+if07DqqaKef+rkKn51718U9TNsYnG4W1n73e97aF93c6nLGLVi/+NhE4+HZczMMsjhbmaWQQ53M7MMcribmWWQw93MLIMc7mZmGeSpkFbWahtX8Uebyv9lX7WNAOU/pdPGD4e7lbVjbes8z92sAA/LmJllkK/crexl4ap36uSqUpdgGeNwt7J2PoZkGlY9lYmhH5tYHO42oSQvlxn+cf80vP4Rfi2wlZbD3SYUh65NFEX7QlXSjZJek7RXUvnPVTMzKyNFCXdJlcC/AjcBc4AlkuYU47PMzOxcxbpyXwDsjYjfRMR7wBagqUifZWZmZylWuM8E9udtdyRtp0laIalFUktnZ2eRyjAzm5iKFe6FpiSc8U1WRGyMiFxE5Orq6opUhpnZxFSscO8AZuVt1wMHivRZZmZ2lmKF+4vAbElXSpoELAa2FemzzMzsLEWZ5x4RvZLuAH4KVAIPRURrMT7LzMzOpfFwU4ekTuCNUtdhNoDLgK5SF2FWwBURUfBLy3ER7mbjmaSWiMiVug6z4fAjf83MMsjhbmaWQQ53s6FtLHUBZsPlMXczswzylbuZWQY53M3MMsjhbhOGpD+QtEXS/0p6VdKPJV01hue/TtKfjtX5zEbD4W4Tgvrfr/cj4NmI+GBEzAG+Alw+hh9zHeBwt3HB4W4TxUKgJyK+c6ohInYDOyT9s6Q9kl6R9Gk4fRX+5Km+kv5F0t8k6+2S1kh6KTnmDyU1AH8PfEnSbkl/dh5/N7Nz+B2qNlHMA3YVaP8rYD5wNf2PGXhR0nMpztcVEX8s6R+Af4yIv5X0HeDdiPjaWBVtNlK+creJ7lpgc0T0RcQh4D+Bj6Q47ofJchfQUKTazEbM4W4TRSvwJwXaC71YBqCXM/8+as7a350s+/D/gG0ccrjbRPELoFrS351qkPQR4G3g05IqJdUBfw7spP8ppXMkVUuaCtyQ4jOOAbVjX7rZ8PmKwyaEiAhJtwLflLQKOAG0A18ELgR+Rf+rIL8cEf8HIGkr8DLwOvA/KT7mP4DHJDUBKyPiv8b69zBLy48fMDPLIA/LmJllkMPdzCyDHO5mZhnkcDczyyCHu5lZBjnczcwyyOFuZpZB/w/iBO7SVsdcUgAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "needs_background": "light"
          },
          "output_type": "display_data"
        }
      ],
      "source": [
        "df['Count'].plot(kind='box')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "04LqG53wIf3M"
      },
      "source": [
        "It also supports many other options like title, xlabel, ylabel, legend, grid, xlim, ylim, xticks, yticks etc. to customize the plot. You can also use plt.xlabel(), plt.ylabel(), plt.title() etc. after the plot to customize it.\n",
        "\n",
        "Please keep in mind that df.plot() is just a convenient wrapper around the matplotlib.pyplot library, so the same customization options available in matplotlib are available for df.plot().\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kDrfbumSIf3N"
      },
      "source": [
        "## 5. df.iloc()\n",
        "\n",
        "Pandas’ **.iloc()** function is used to select rows and columns by their integer-based index in a DataFrame. It is used to select rows and columns by their integer-based location.\n",
        "\n",
        "Here are some examples of how you can use it:\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ssNei-wOIf3O",
        "outputId": "ec23c2de-718c-4ed9-d4c4-8fc70e5ff6f2"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Year of Birth                               2011\n",
            "Gender                                    FEMALE\n",
            "Ethnicity             ASIAN AND PACIFIC ISLANDER\n",
            "Child's First Name                        SOPHIA\n",
            "Count                                        119\n",
            "Rank                                           1\n",
            "Name: 0, dtype: object\n"
          ]
        }
      ],
      "source": [
        "# Select the first row\n",
        "print(df.iloc[0])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "W0iKj3PyIf3P",
        "outputId": "a2fa9a77-7bc3-4ee2-d40a-65625ae279f1"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "   Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
            "0           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
            "1           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
            "\n",
            "   Count  Rank  \n",
            "0    119     1  \n",
            "1    106     2  \n"
          ]
        }
      ],
      "source": [
        "# Select the first two rows\n",
        "print(df.iloc[:2])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": true,
        "id": "37N18P_hIf3Q",
        "outputId": "93a27681-8de6-4841-a29f-74297291b38b"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "0        2011\n",
            "1        2011\n",
            "2        2011\n",
            "3        2011\n",
            "4        2011\n",
            "         ... \n",
            "11340    2016\n",
            "11341    2016\n",
            "11342    2016\n",
            "11343    2016\n",
            "11344    2016\n",
            "Name: Year of Birth, Length: 11345, dtype: int64\n"
          ]
        }
      ],
      "source": [
        "# Select the first column\n",
        "print(df.iloc[:, 0])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "F8je3qNNIf3Q",
        "outputId": "e634f4cc-52f4-4c0a-d7c5-11ac81c8f7c2"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "       Year of Birth  Gender\n",
            "0               2011  FEMALE\n",
            "1               2011  FEMALE\n",
            "2               2011  FEMALE\n",
            "3               2011  FEMALE\n",
            "4               2011  FEMALE\n",
            "...              ...     ...\n",
            "11340           2016  FEMALE\n",
            "11341           2016  FEMALE\n",
            "11342           2016  FEMALE\n",
            "11343           2016  FEMALE\n",
            "11344           2016  FEMALE\n",
            "\n",
            "[11345 rows x 2 columns]\n"
          ]
        }
      ],
      "source": [
        "# Select the first two columns\n",
        "print(df.iloc[:, :2])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "1oHo7o4bIf3R",
        "outputId": "8dbddf52-27ba-4e41-9135-857e7e889552"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "FEMALE\n"
          ]
        }
      ],
      "source": [
        "# Select the (1, 1) element\n",
        "print(df.iloc[1, 1])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "cUV64mOBIf3S"
      },
      "source": [
        "In the above examples, df.iloc[0] selects the first row of the dataframe, df.iloc[:2] selects the first two rows, df.iloc[:, 0] selects the first column, df.iloc[:, :2] selects the first two columns, and df.iloc[1, 1] selects the element at the (1, 1) position of the dataframe (second row, second column).\n",
        "\n",
        "Keep in mind that .iloc() only selects rows and columns based on their integer-based index, so if you want to select rows and columns based on their labels you should use .loc() method instead as will be shown next.\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "hZ7h2tgGIf3S"
      },
      "source": [
        "## 6. df.loc()\n",
        "\n",
        "Pandas’ **.loc()** function is used to select rows and columns by their label-based index in a DataFrame. It is used to select rows and columns by their label-based location.\n",
        "\n",
        "Here are some examples of how you can use it:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "gI2TBCxIIf3T",
        "outputId": "567c35ca-7000-423f-8c68-e676d13fa00b"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "0        FEMALE\n",
            "1        FEMALE\n",
            "2        FEMALE\n",
            "3        FEMALE\n",
            "4        FEMALE\n",
            "          ...  \n",
            "11340    FEMALE\n",
            "11341    FEMALE\n",
            "11342    FEMALE\n",
            "11343    FEMALE\n",
            "11344    FEMALE\n",
            "Name: Gender, Length: 11345, dtype: object\n"
          ]
        }
      ],
      "source": [
        "# Select the column name 'Gender'\n",
        "print(df.loc[:,'Gender'])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "jC7nUyldIf3U",
        "outputId": "a0ffef61-807d-4d6c-e542-ee6ee7a0349d"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "       Year of Birth  Gender\n",
            "0               2011  FEMALE\n",
            "1               2011  FEMALE\n",
            "2               2011  FEMALE\n",
            "3               2011  FEMALE\n",
            "4               2011  FEMALE\n",
            "...              ...     ...\n",
            "11340           2016  FEMALE\n",
            "11341           2016  FEMALE\n",
            "11342           2016  FEMALE\n",
            "11343           2016  FEMALE\n",
            "11344           2016  FEMALE\n",
            "\n",
            "[11345 rows x 2 columns]\n"
          ]
        }
      ],
      "source": [
        "# Select the columns named 'Year of Birth' and 'Gender'\n",
        "print(df.loc[:, ['Year of Birth', 'Gender']])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "x26YgR54If3V"
      },
      "source": [
        "In the above example, we used df.loc[:, 'Gender'] to select the column named 'Gender', and df.loc[:, ['Year of Birth', 'Gender']] selects the columns named 'Year of Birth' and 'Gender'."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tS0YbE3xIf3W"
      },
      "source": [
        "## 7. df.assign()\n",
        "\n",
        "Pandas’ .assign() function is used to add new columns to a DataFrame, based on the computation of existing columns. It allows you to add new columns to a DataFrame without modifying the original dataframe. The function returns a new DataFrame with the added columns.\n",
        "\n",
        "Here is an example of how you can use it:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "bWQxSiGKIf3W",
        "outputId": "3fb3d903-74b8-497f-f89f-7b05e3eb0902"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "      <th>count_plus_5</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "      <td>124</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "      <td>111</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "      <td>98</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "      <td>94</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</td>\n",
              "      <td>80</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "0           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "1           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "2           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4           2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "\n",
              "   Count  Rank  count_plus_5  \n",
              "0    119     1           124  \n",
              "1    106     2           111  \n",
              "2     93     3            98  \n",
              "3     89     4            94  \n",
              "4     75     5            80  "
            ]
          },
          "execution_count": 17,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_new = df.assign(count_plus_5=df['Count'] + 5)\n",
        "df_new.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "b4OabfUBIf3X"
      },
      "source": [
        "In the above example, the first time df.assign() is used to create a new column named 'count_plus_5' with the value of count + 5.\n",
        "\n",
        "It’s important to note that the original DataFrame df remains unchanged and the new DataFrame df_new is returned with the new columns added.\n",
        "\n",
        "The .assign() method can be used multiple times in a chain, allowing you to add multiple new columns to a DataFrame in one line of code.\n",
        "\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "DvTVzUWbIf3X"
      },
      "source": [
        "## 8. df.query()\n",
        "Pandas’ .query() function allows you to filter a DataFrame based on a Boolean expression. It allows you to select rows from a DataFrame using a query string similar to SQL. The function returns a new DataFrame containing only the rows that satisfy the Boolean expression.\n",
        "\n",
        "Here is an example of how you can use it:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "3GhG3NJGIf3Y",
        "outputId": "cc3902c1-ffec-4976-8a88-08581f5636e5"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "0           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "1           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "2           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4           2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "\n",
              "   Count  Rank  \n",
              "0    119     1  \n",
              "1    106     2  \n",
              "2     93     3  \n",
              "3     89     4  \n",
              "4     75     5  "
            ]
          },
          "execution_count": 18,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Select rows where age is greater than 30 and income is less than 65000\n",
        "df_query = df.query('Count > 30 and Rank < 20')\n",
        "df_query.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "kPnUDVKAIf3Y",
        "outputId": "b5eeaaa1-f1de-47b0-a8e4-378c5982498d"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>993</th>\n",
              "      <td>2011</td>\n",
              "      <td>MALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ETHAN</td>\n",
              "      <td>177</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>994</th>\n",
              "      <td>2011</td>\n",
              "      <td>MALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>JAYDEN</td>\n",
              "      <td>173</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>995</th>\n",
              "      <td>2011</td>\n",
              "      <td>MALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>RYAN</td>\n",
              "      <td>150</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>996</th>\n",
              "      <td>2011</td>\n",
              "      <td>MALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>JUSTIN</td>\n",
              "      <td>110</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>997</th>\n",
              "      <td>2011</td>\n",
              "      <td>MALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>LUCAS</td>\n",
              "      <td>103</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Year of Birth Gender                   Ethnicity Child's First Name  \\\n",
              "993           2011   MALE  ASIAN AND PACIFIC ISLANDER              ETHAN   \n",
              "994           2011   MALE  ASIAN AND PACIFIC ISLANDER             JAYDEN   \n",
              "995           2011   MALE  ASIAN AND PACIFIC ISLANDER               RYAN   \n",
              "996           2011   MALE  ASIAN AND PACIFIC ISLANDER             JUSTIN   \n",
              "997           2011   MALE  ASIAN AND PACIFIC ISLANDER              LUCAS   \n",
              "\n",
              "     Count  Rank  \n",
              "993    177     1  \n",
              "994    173     2  \n",
              "995    150     3  \n",
              "996    110     4  \n",
              "997    103     5  "
            ]
          },
          "execution_count": 19,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Select rows where gender is Male\n",
        "df_query = df.query(\"Gender == 'MALE'\")\n",
        "df_query.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "s1TED38EIf3Z"
      },
      "source": [
        "In the above example, the first time df.query() is used to select rows where the count is greater than 30 and the rank is less than 30, and the second time df.query() is used to select rows where gender is 'MALE'.\n",
        "\n",
        "It’s important to note that the original DataFrame df remains unchanged and the new DataFrame df_query is returned with the filtered rows.\n",
        "\n",
        "The .query() method can be used with any valid Boolean expression and it's useful when you want to filter a DataFrame based on multiple conditions or when the conditions are complex and hard to express using the standard indexing operators.\n",
        "\n",
        "Also, keep in mind that the .query() method is slower than boolean indexing, so if performance is critical, you should use boolean indexing instead."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "UhXbpEJ7If3a"
      },
      "source": [
        "## 9. df.sort_values()\n",
        "Pandas’ .sort_values() function allows you to sort a DataFrame by one or multiple columns. It sorts the DataFrame based on the values of one or more columns, in ascending or descending order. The function returns a new DataFrame sorted by the specified column(s).\n",
        "\n",
        "Here is an example of how you can use it:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "iGo61cr-If3a",
        "outputId": "0406dbc5-6005-4038-fe38-01d795dd9f2e"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>5672</th>\n",
              "      <td>2014</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>Priscilla</td>\n",
              "      <td>10</td>\n",
              "      <td>40</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4344</th>\n",
              "      <td>2013</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>HISPANIC</td>\n",
              "      <td>Raquel</td>\n",
              "      <td>10</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4343</th>\n",
              "      <td>2013</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>HISPANIC</td>\n",
              "      <td>Rachel</td>\n",
              "      <td>10</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4342</th>\n",
              "      <td>2013</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>HISPANIC</td>\n",
              "      <td>Paula</td>\n",
              "      <td>10</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4341</th>\n",
              "      <td>2013</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>HISPANIC</td>\n",
              "      <td>Nyah</td>\n",
              "      <td>10</td>\n",
              "      <td>78</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "5672           2014  FEMALE  ASIAN AND PACIFIC ISLANDER          Priscilla   \n",
              "4344           2013  FEMALE                    HISPANIC             Raquel   \n",
              "4343           2013  FEMALE                    HISPANIC             Rachel   \n",
              "4342           2013  FEMALE                    HISPANIC              Paula   \n",
              "4341           2013  FEMALE                    HISPANIC               Nyah   \n",
              "\n",
              "      Count  Rank  \n",
              "5672     10    40  \n",
              "4344     10    78  \n",
              "4343     10    78  \n",
              "4342     10    78  \n",
              "4341     10    78  "
            ]
          },
          "execution_count": 20,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sort by age in ascending order\n",
        "df_sorted = df.sort_values(by='Count')\n",
        "df_sorted.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "bwPFUf3cIf3b",
        "outputId": "1c95e69d-3d34-47e0-e5a4-20546f795ab3"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>7236</th>\n",
              "      <td>2014</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Yidel</td>\n",
              "      <td>10</td>\n",
              "      <td>102</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7224</th>\n",
              "      <td>2014</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Erik</td>\n",
              "      <td>10</td>\n",
              "      <td>102</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7235</th>\n",
              "      <td>2014</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Shraga</td>\n",
              "      <td>10</td>\n",
              "      <td>102</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7234</th>\n",
              "      <td>2014</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Nico</td>\n",
              "      <td>10</td>\n",
              "      <td>102</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7233</th>\n",
              "      <td>2014</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Myles</td>\n",
              "      <td>10</td>\n",
              "      <td>102</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Year of Birth Gender           Ethnicity Child's First Name  Count  Rank\n",
              "7236           2014   MALE  WHITE NON HISPANIC              Yidel     10   102\n",
              "7224           2014   MALE  WHITE NON HISPANIC               Erik     10   102\n",
              "7235           2014   MALE  WHITE NON HISPANIC             Shraga     10   102\n",
              "7234           2014   MALE  WHITE NON HISPANIC               Nico     10   102\n",
              "7233           2014   MALE  WHITE NON HISPANIC              Myles     10   102"
            ]
          },
          "execution_count": 21,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sort by income in descending order\n",
        "df_sorted = df.sort_values(by='Rank', ascending=False)\n",
        "df_sorted.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "WnE0nJBAIf3b",
        "outputId": "a853f5d2-3187-4729-9c41-c858eb9f4a32"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>141</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>AIZA</td>\n",
              "      <td>10</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>142</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ALEXA</td>\n",
              "      <td>10</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>143</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ALISHA</td>\n",
              "      <td>10</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>144</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ANGIE</td>\n",
              "      <td>10</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>145</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ANNABELLE</td>\n",
              "      <td>10</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "141           2011  FEMALE  ASIAN AND PACIFIC ISLANDER               AIZA   \n",
              "142           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              ALEXA   \n",
              "143           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             ALISHA   \n",
              "144           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              ANGIE   \n",
              "145           2011  FEMALE  ASIAN AND PACIFIC ISLANDER          ANNABELLE   \n",
              "\n",
              "     Count  Rank  \n",
              "141     10    38  \n",
              "142     10    38  \n",
              "143     10    38  \n",
              "144     10    38  \n",
              "145     10    38  "
            ]
          },
          "execution_count": 22,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sort by multiple columns\n",
        "df_sorted = df.sort_values(by=['Count', 'Rank'])\n",
        "df_sorted.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CyMBmLD_If3d"
      },
      "source": [
        "In the above example, the first time df.sort_values() is used to sort the DataFrame by 'Count' in ascending order, the second time is used to sort by 'Rank' in descending order, and the last time it's used to sort by multiple columns 'Count' and 'Rank'.\n",
        "\n",
        "It’s important to note that the original DataFrame df remains unchanged and the new DataFrame df_sorted is returned with the sorted values.\n",
        "\n",
        "The .sort_values() method can be used with any column(s) of the DataFrame and it's useful when you want to sort the DataFrame based on multiple columns, or when you want to sort the DataFrame by a column in descending order."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "8_C0m44QIf3e"
      },
      "source": [
        "## 10. df.sample()\n",
        "Pandas’ .sample() function allows you to randomly select rows from a DataFrame. It returns a new DataFrame containing the randomly selected rows. The function takes several parameters that allow you to control the sampling process, such as the number of rows to return, and whether or not to sample with replacement and seed for reproducibility.\n",
        "\n",
        "Here is an example of how you can use it:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Z7akitEmIf3f",
        "outputId": "c17c9004-29f7-42bc-8b82-8a0f393ab518"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>10441</th>\n",
              "      <td>2016</td>\n",
              "      <td>MALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>Grant</td>\n",
              "      <td>22</td>\n",
              "      <td>87</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8113</th>\n",
              "      <td>2015</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>Alexandra</td>\n",
              "      <td>13</td>\n",
              "      <td>40</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "10441           2016    MALE          WHITE NON HISPANIC              Grant   \n",
              "8113            2015  FEMALE  ASIAN AND PACIFIC ISLANDER          Alexandra   \n",
              "\n",
              "       Count  Rank  \n",
              "10441     22    87  \n",
              "8113      13    40  "
            ]
          },
          "execution_count": 23,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sample 2 rows without replacement\n",
        "df_sample = df.sample(n=2, replace=False, random_state=1)\n",
        "df_sample"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "FB9HMn2XIf3g",
        "outputId": "3bfe461e-9cfc-423a-c101-d9f0f21fd180"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>235</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>ANIYA</td>\n",
              "      <td>19</td>\n",
              "      <td>36</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5192</th>\n",
              "      <td>2013</td>\n",
              "      <td>MALE</td>\n",
              "      <td>HISPANIC</td>\n",
              "      <td>Ezequiel</td>\n",
              "      <td>11</td>\n",
              "      <td>94</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>905</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>WHITE NON HISPANIC</td>\n",
              "      <td>GOLDA</td>\n",
              "      <td>14</td>\n",
              "      <td>77</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Year of Birth  Gender           Ethnicity Child's First Name  Count  \\\n",
              "235            2011  FEMALE  BLACK NON HISPANIC              ANIYA     19   \n",
              "5192           2013    MALE            HISPANIC           Ezequiel     11   \n",
              "905            2011  FEMALE  WHITE NON HISPANIC              GOLDA     14   \n",
              "\n",
              "      Rank  \n",
              "235     36  \n",
              "5192    94  \n",
              "905     77  "
            ]
          },
          "execution_count": 24,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sample 3 rows with replacement\n",
        "df_sample = df.sample(n=3, replace=True, random_state=1)\n",
        "df_sample"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": false,
        "id": "RsSxu5AFIf3h",
        "outputId": "ef4878c4-9108-48d4-f1e5-51b9982bda66"
      },
      "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>Ethnicity</th>\n",
              "      <th>Gender</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11340</th>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11341</th>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11342</th>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11343</th>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11344</th>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11345 rows × 2 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                        Ethnicity  Gender\n",
              "0      ASIAN AND PACIFIC ISLANDER  FEMALE\n",
              "1      ASIAN AND PACIFIC ISLANDER  FEMALE\n",
              "2      ASIAN AND PACIFIC ISLANDER  FEMALE\n",
              "3      ASIAN AND PACIFIC ISLANDER  FEMALE\n",
              "4      ASIAN AND PACIFIC ISLANDER  FEMALE\n",
              "...                           ...     ...\n",
              "11340          BLACK NON HISPANIC  FEMALE\n",
              "11341          BLACK NON HISPANIC  FEMALE\n",
              "11342          BLACK NON HISPANIC  FEMALE\n",
              "11343          BLACK NON HISPANIC  FEMALE\n",
              "11344          BLACK NON HISPANIC  FEMALE\n",
              "\n",
              "[11345 rows x 2 columns]"
            ]
          },
          "execution_count": 25,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Sample 2 rows without replacement with specific column to be chosen\n",
        "df_sample = df.sample(n=2, replace=False, random_state=1, axis=1)\n",
        "df_sample"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "k7IIm-zSIf3h"
      },
      "source": [
        "In the above example, the first time df.sample() is used to randomly select 2 rows without replacement, the second time is used to randomly select 3 rows with replacement and the last time is used to randomly select 2 columns without replacement.\n",
        "\n",
        "It’s important to note that the original DataFrame df remains unchanged and the new DataFrame df_sample is returned with the randomly selected rows.\n",
        "\n",
        "The .sample() method can be useful when you want to randomly select a subset of the data for testing or validation, or when you want to randomly select a sample of rows for further analysis. The random_state parameter is useful for reproducibility and the axis=1 parameter allows you to select columns."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GcXcYB1sIf3i"
      },
      "source": [
        "## 11. df.isnull()\n",
        "The isnull() method in Pandas returns a DataFrame of the same shape as the original DataFrame, but with True or False values indicating whether each value in the original DataFrame is missing or not. Missing values, such as NaN or None, will be True in the resulting DataFrame, while non-missing values will be False.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "qQsNqyNCIf3i",
        "outputId": "b86b1ae2-d216-4d55-dec7-da2f7c24b612"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11340</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11341</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11342</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11343</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11344</th>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "      <td>False</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11345 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Year of Birth  Gender  Ethnicity  Child's First Name  Count   Rank\n",
              "0              False   False      False               False  False  False\n",
              "1              False   False      False               False  False  False\n",
              "2              False   False      False               False  False  False\n",
              "3              False   False      False               False  False  False\n",
              "4              False   False      False               False  False  False\n",
              "...              ...     ...        ...                 ...    ...    ...\n",
              "11340          False   False      False               False  False  False\n",
              "11341          False   False      False               False  False  False\n",
              "11342          False   False      False               False  False  False\n",
              "11343          False   False      False               False  False  False\n",
              "11344          False   False      False               False  False  False\n",
              "\n",
              "[11345 rows x 6 columns]"
            ]
          },
          "execution_count": 26,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df.isnull()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "JU-Dv7N1If3j"
      },
      "source": [
        "## 12. df.fillna()\n",
        "\n",
        "The **fillna()** method in Pandas is used to fill in missing values in a DataFrame with a specified value or method. By default, it replaces missing values with NaN, but you can specify a different value to use instead as shown below:\n",
        "\n",
        "* value: Specifies the value to use to fill in the missing values. Can be a scalar value or a dict of values for different columns.\n",
        "* method: Specifies the method to use for filling in missing values. Can be 'ffill' (forward-fill) or 'bfill' (backward-fill) or 'interpolate'(interpolate values) or 'pad' or 'backfill'\n",
        "* axis: Specifies the axis along which to fill in missing values. It can be 0 (rows) or 1 (columns).\n",
        "* inplace: Whether to fill in the missing values in place (modifying the original DataFrame) or to return a new DataFrame with the missing values filled in.\n",
        "* limit: Specifies the maximum number of consecutive missing values to fill.\n",
        "* downcast: Specifies a dictionary of values to use to downcast the data types of columns.\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "ZEZCzCBCIf3j",
        "outputId": "2b743e71-3a9a-4fe3-f688-b33931ec57ef"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11340</th>\n",
              "      <td>2016</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>Saniyah</td>\n",
              "      <td>10</td>\n",
              "      <td>43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11341</th>\n",
              "      <td>2016</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>Skye</td>\n",
              "      <td>10</td>\n",
              "      <td>43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11342</th>\n",
              "      <td>2016</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>Tiana</td>\n",
              "      <td>10</td>\n",
              "      <td>43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11343</th>\n",
              "      <td>2016</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>Violet</td>\n",
              "      <td>10</td>\n",
              "      <td>43</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11344</th>\n",
              "      <td>2016</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>Zahra</td>\n",
              "      <td>10</td>\n",
              "      <td>43</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11345 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "0               2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "1               2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "2               2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3               2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4               2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "...              ...     ...                         ...                ...   \n",
              "11340           2016  FEMALE          BLACK NON HISPANIC            Saniyah   \n",
              "11341           2016  FEMALE          BLACK NON HISPANIC               Skye   \n",
              "11342           2016  FEMALE          BLACK NON HISPANIC              Tiana   \n",
              "11343           2016  FEMALE          BLACK NON HISPANIC             Violet   \n",
              "11344           2016  FEMALE          BLACK NON HISPANIC              Zahra   \n",
              "\n",
              "       Count  Rank  \n",
              "0        119     1  \n",
              "1        106     2  \n",
              "2         93     3  \n",
              "3         89     4  \n",
              "4         75     5  \n",
              "...      ...   ...  \n",
              "11340     10    43  \n",
              "11341     10    43  \n",
              "11342     10    43  \n",
              "11343     10    43  \n",
              "11344     10    43  \n",
              "\n",
              "[11345 rows x 6 columns]"
            ]
          },
          "execution_count": 27,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# fill missing values with 0\n",
        "df.fillna(0)\n",
        "\n",
        "# forward-fill missing values (propagates last valid observation forward to next)\n",
        "df.fillna(method='ffill')\n",
        "\n",
        "# backward-fill missing values (propagates next valid observation backward to last)\n",
        "df.fillna(method='bfill')\n",
        "\n",
        "# fill missing values using interpolation\n",
        "df.interpolate()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "yiMspIU5If3k"
      },
      "source": [
        "It is important to note that the fillna() method returns a new DataFrame with the missing values filled in and does not modify the original DataFrame in place. If you want to modify the original DataFrame, you can use the inplace parameter and set it to True."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-xOwUDZlIf3k"
      },
      "outputs": [],
      "source": [
        "# fill missing values in place\n",
        "df.fillna(0, inplace=True)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kIgn8fV1If3l"
      },
      "source": [
        "## 13. df.dropna()\n",
        "**df.dropna()** is a method used in the Pandas library to remove missing or null values from a DataFrame. It removes rows or columns from the DataFrame where at least one element is missing.\n",
        "\n",
        "You can remove all rows containing at least one missing value by calling df.dropna().\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "2RnOpVKEIf3m"
      },
      "outputs": [],
      "source": [
        "df_drop_na = df.dropna()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CBlbgd-oIf3m"
      },
      "source": [
        "If you want to remove only the columns that contain at least one missing value you can use df.dropna(axis=1)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "MK-68lKcIf3n"
      },
      "outputs": [],
      "source": [
        "df_drop_na = df.dropna(axis=1)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "skPloHmKIf3n"
      },
      "source": [
        "You can also set thresh parameter to keep only the rows/columns that have at least thresh non-NA/null values."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Ghp306QuIf3o"
      },
      "outputs": [],
      "source": [
        "df_drop_na = df.dropna(thresh=2)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "59tQopiSIf3o"
      },
      "source": [
        "## 14. df.drop()\n",
        "\n",
        "**df.drop()** is a method used in the Pandas library to remove rows or columns from a DataFrame by specifying the corresponding labels. It can be used to drop one or multiple rows or columns based on their labels.\n",
        "\n",
        "You can remove a specific row by calling df.drop() and passing the index label of the row you want to remove, and the axis parameter set to 0 (default is 0)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "qe-lzCobIf3p"
      },
      "outputs": [],
      "source": [
        "df_drop = df.drop(0)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SENnFwNbIf3q"
      },
      "source": [
        "This would remove the first row of the DataFrame.\n",
        "\n",
        "You can also drop multiple rows by passing a list of index labels:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "THE8bHX6If3q"
      },
      "outputs": [],
      "source": [
        "df_drop = df.drop([0,1])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "mVCfZnAnIf3r"
      },
      "source": [
        "This would remove the first and second rows of the DataFrame.\n",
        "\n",
        "Similarly, you can drop columns by passing the labels of the columns you want to remove and setting the axis parameter to 1:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "wq1J2phkIf3s"
      },
      "outputs": [],
      "source": [
        "df_drop = df.drop(['Count', 'Rank'], axis=1)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3VlN6CzyIf3s"
      },
      "source": [
        "## 15. pd.pivot_table()\n",
        "\n",
        "**pd.pivot_table()** is a method in the Pandas library that is used to create a pivot table from a DataFrame. A pivot table is a table that summarizes and aggregates data in a more meaningful and organized way, by creating a new table with one or more columns as the index, one or more columns as values, and one or more columns as attributes.\n",
        "\n",
        "In the example below we will create a pivot table with Ethnicity as the index and aggregate the sum of the count. This is used to know the count of each Ethnicity in the dataset.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "qWNV9dkTIf3u",
        "outputId": "9bb01bdd-1268-40f0-85ba-829ff4a52e98"
      },
      "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>Count</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Ethnicity</th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>ASIAN AND PACI</th>\n",
              "      <td>9185</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ASIAN AND PACIFIC ISLANDER</th>\n",
              "      <td>41500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLACK NON HISP</th>\n",
              "      <td>8802</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>BLACK NON HISPANIC</th>\n",
              "      <td>45179</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>HISPANIC</th>\n",
              "      <td>122805</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Count\n",
              "Ethnicity                         \n",
              "ASIAN AND PACI                9185\n",
              "ASIAN AND PACIFIC ISLANDER   41500\n",
              "BLACK NON HISP                8802\n",
              "BLACK NON HISPANIC           45179\n",
              "HISPANIC                    122805"
            ]
          },
          "execution_count": 35,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pivot_table = pd.pivot_table(df, index='Ethnicity', values='Count', aggfunc='sum')\n",
        "pivot_table.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "XBYVkZQJIf3v"
      },
      "source": [
        "You can also include more columns in the pivot table by specifying multiple index and values parameters and also include multiple aggfunc functions.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "8KgfloIKIf3w",
        "outputId": "43607612-a6a9-49f4-c4f6-923fffddf7ae"
      },
      "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 tr th {\n",
              "        text-align: left;\n",
              "    }\n",
              "\n",
              "    .dataframe thead tr:last-of-type th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>sum</th>\n",
              "      <th>count</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th>Count</th>\n",
              "      <th>Count</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Gender</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">ASIAN AND PACI</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>4072</td>\n",
              "      <td>171</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>5113</td>\n",
              "      <td>164</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"3\" valign=\"top\">ASIAN AND PACIFIC ISLANDER</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>17055</td>\n",
              "      <td>777</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>23467</td>\n",
              "      <td>835</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>female</th>\n",
              "      <td>978</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">BLACK NON HISP</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>3693</td>\n",
              "      <td>159</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>5109</td>\n",
              "      <td>169</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">BLACK NON HISPANIC</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>19288</td>\n",
              "      <td>848</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>25891</td>\n",
              "      <td>856</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">HISPANIC</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>52225</td>\n",
              "      <td>1704</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>70580</td>\n",
              "      <td>1610</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">WHITE NON HISP</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>10954</td>\n",
              "      <td>341</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>12850</td>\n",
              "      <td>296</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th rowspan=\"2\" valign=\"top\">WHITE NON HISPANIC</th>\n",
              "      <th>FEMALE</th>\n",
              "      <td>56700</td>\n",
              "      <td>1756</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>MALE</th>\n",
              "      <td>64559</td>\n",
              "      <td>1609</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                     sum count\n",
              "                                   Count Count\n",
              "Ethnicity                  Gender             \n",
              "ASIAN AND PACI             FEMALE   4072   171\n",
              "                           MALE     5113   164\n",
              "ASIAN AND PACIFIC ISLANDER FEMALE  17055   777\n",
              "                           MALE    23467   835\n",
              "                           female    978    50\n",
              "BLACK NON HISP             FEMALE   3693   159\n",
              "                           MALE     5109   169\n",
              "BLACK NON HISPANIC         FEMALE  19288   848\n",
              "                           MALE    25891   856\n",
              "HISPANIC                   FEMALE  52225  1704\n",
              "                           MALE    70580  1610\n",
              "WHITE NON HISP             FEMALE  10954   341\n",
              "                           MALE    12850   296\n",
              "WHITE NON HISPANIC         FEMALE  56700  1756\n",
              "                           MALE    64559  1609"
            ]
          },
          "execution_count": 36,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "pivot_table = pd.pivot_table(df, index=['Ethnicity','Gender'], values= 'Count' , aggfunc=['sum','count'])\n",
        "pivot_table.head(20)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "qzevVXt1If3w"
      },
      "source": [
        "## 16. df.groupby()\n",
        "\n",
        "**df.groupby()** is a method in the Pandas library that is used to group rows of a DataFrame based on one or multiple columns. This allows you to perform aggregate operations on the groups, such as calculating the mean, sum, or count of the values in each group.\n",
        "\n",
        "df.groupby() returns a GroupBy object, which you can then use to perform various operations on the groups, such as calculating the sum, mean, or count of the values in each group.\n",
        "\n",
        "Let's see an example using the birth names dataset:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "6sDrcjDgIf3x",
        "outputId": "87d907f4-e968-4feb-866c-3c5eee15ad17"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "        Year of Birth      Count       Rank\n",
            "Gender                                     \n",
            "FEMALE    2013.569493  28.489750  52.716470\n",
            "MALE      2013.558043  37.474093  63.052537\n",
            "female    2011.000000  19.560000  28.640000\n"
          ]
        }
      ],
      "source": [
        "grouped = df.groupby('Gender')\n",
        "# Print the mean of each group\n",
        "print(grouped.mean())\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "sxTQUP9gIf3y",
        "outputId": "1dde3cd4-9e75-4334-a8e0-1d5404c1f53f"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "                                   Year of Birth  Count    Rank\n",
            "Gender Ethnicity                                               \n",
            "FEMALE ASIAN AND PACI                     344052   4072    5741\n",
            "       ASIAN AND PACIFIC ISLANDER        1564965  17055   24097\n",
            "       BLACK NON HISP                     319908   3693    5516\n",
            "       BLACK NON HISPANIC                1707706  19288   26878\n",
            "       HISPANIC                          3430969  52225  103488\n",
            "       WHITE NON HISP                     686092  10954   22414\n",
            "       WHITE NON HISPANIC                3536414  56700  115302\n",
            "MALE   ASIAN AND PACI                     329968   5113    7383\n",
            "       ASIAN AND PACIFIC ISLANDER        1681670  23467   35389\n",
            "       BLACK NON HISP                     340028   5109    7528\n",
            "       BLACK NON HISPANIC                1723760  25891   38857\n",
            "       HISPANIC                          3241744  70580  117006\n",
            "       WHITE NON HISP                     595552  12850   20932\n",
            "       WHITE NON HISPANIC                3240376  64559  122153\n",
            "female ASIAN AND PACIFIC ISLANDER         100550    978    1432\n"
          ]
        }
      ],
      "source": [
        "grouped = df.groupby(['Gender', 'Ethnicity'])\n",
        "\n",
        "# Print the sum of each group\n",
        "print(grouped.sum())"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "0NLA2gG3If3y",
        "outputId": "29083ddf-cb56-40c2-f020-35d0a8073d73"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Empty DataFrame\n",
            "Columns: [Year of Birth, Count, Rank]\n",
            "Index: []\n"
          ]
        }
      ],
      "source": [
        "grouped = df.groupby({'Gender':'MALE'})\n",
        "\n",
        "# Print the sum of each group\n",
        "print(grouped.sum())"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GllyRcEPIf3z"
      },
      "source": [
        "## 17. df.transpose()\n",
        "**df.transpose()** is a method in the Pandas library used to transpose the rows and columns of a DataFrame? This means that the rows become columns and the columns become rows.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "scrolled": true,
        "id": "F5xGMquQIf30",
        "outputId": "4cfed056-7634-4bcf-d35d-49adb3058b00"
      },
      "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>...</th>\n",
              "      <th>11335</th>\n",
              "      <th>11336</th>\n",
              "      <th>11337</th>\n",
              "      <th>11338</th>\n",
              "      <th>11339</th>\n",
              "      <th>11340</th>\n",
              "      <th>11341</th>\n",
              "      <th>11342</th>\n",
              "      <th>11343</th>\n",
              "      <th>11344</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Year of Birth</th>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>...</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gender</th>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>...</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Ethnicity</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>...</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Child's First Name</th>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>ISABELLA</td>\n",
              "      <td>TIFFANY</td>\n",
              "      <td>ASHLEY</td>\n",
              "      <td>FIONA</td>\n",
              "      <td>ANGELA</td>\n",
              "      <td>...</td>\n",
              "      <td>Mikayla</td>\n",
              "      <td>Mila</td>\n",
              "      <td>Milan</td>\n",
              "      <td>Sanaa</td>\n",
              "      <td>Sanai</td>\n",
              "      <td>Saniyah</td>\n",
              "      <td>Skye</td>\n",
              "      <td>Tiana</td>\n",
              "      <td>Violet</td>\n",
              "      <td>Zahra</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Count</th>\n",
              "      <td>119</td>\n",
              "      <td>106</td>\n",
              "      <td>93</td>\n",
              "      <td>89</td>\n",
              "      <td>75</td>\n",
              "      <td>67</td>\n",
              "      <td>54</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>47</td>\n",
              "      <td>...</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 11345 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                         0                           1      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                      SOPHIA                       CHLOE   \n",
              "Count                                      119                         106   \n",
              "\n",
              "                                         2                           3      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                       EMILY                      OLIVIA   \n",
              "Count                                       93                          89   \n",
              "\n",
              "                                         4                           5      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                        EMMA                    ISABELLA   \n",
              "Count                                       75                          67   \n",
              "\n",
              "                                         6                           7      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                     TIFFANY                      ASHLEY   \n",
              "Count                                       54                          52   \n",
              "\n",
              "                                         8                           9      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                       FIONA                      ANGELA   \n",
              "Count                                       48                          47   \n",
              "\n",
              "                    ...               11335               11336  \\\n",
              "Year of Birth       ...                2016                2016   \n",
              "Gender              ...              FEMALE              FEMALE   \n",
              "Ethnicity           ...  BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name  ...             Mikayla                Mila   \n",
              "Count               ...                  10                  10   \n",
              "\n",
              "                                 11337               11338  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name               Milan               Sanaa   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11339               11340  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name               Sanai             Saniyah   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11341               11342  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name                Skye               Tiana   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11343               11344  \n",
              "Year of Birth                     2016                2016  \n",
              "Gender                          FEMALE              FEMALE  \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC  \n",
              "Child's First Name              Violet               Zahra  \n",
              "Count                               10                  10  \n",
              "\n",
              "[5 rows x 11345 columns]"
            ]
          },
          "execution_count": 40,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Transpose the DataFrame\n",
        "df_transposed = df.transpose()\n",
        "\n",
        "# Print the transposed DataFrame\n",
        "df_transposed.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YwFTwIpwIf30"
      },
      "source": [
        "It can also be done using T attributes on the dataframe. df.T will do the same as df.transpose()."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "epl3JvpDIf31",
        "outputId": "ae6b4a16-5df8-46a9-8186-84557b3cc97d"
      },
      "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>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>...</th>\n",
              "      <th>11335</th>\n",
              "      <th>11336</th>\n",
              "      <th>11337</th>\n",
              "      <th>11338</th>\n",
              "      <th>11339</th>\n",
              "      <th>11340</th>\n",
              "      <th>11341</th>\n",
              "      <th>11342</th>\n",
              "      <th>11343</th>\n",
              "      <th>11344</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Year of Birth</th>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>2011</td>\n",
              "      <td>...</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "      <td>2016</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gender</th>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>...</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>FEMALE</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Ethnicity</th>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>...</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "      <td>BLACK NON HISPANIC</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Child's First Name</th>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>ISABELLA</td>\n",
              "      <td>TIFFANY</td>\n",
              "      <td>ASHLEY</td>\n",
              "      <td>FIONA</td>\n",
              "      <td>ANGELA</td>\n",
              "      <td>...</td>\n",
              "      <td>Mikayla</td>\n",
              "      <td>Mila</td>\n",
              "      <td>Milan</td>\n",
              "      <td>Sanaa</td>\n",
              "      <td>Sanai</td>\n",
              "      <td>Saniyah</td>\n",
              "      <td>Skye</td>\n",
              "      <td>Tiana</td>\n",
              "      <td>Violet</td>\n",
              "      <td>Zahra</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Count</th>\n",
              "      <td>119</td>\n",
              "      <td>106</td>\n",
              "      <td>93</td>\n",
              "      <td>89</td>\n",
              "      <td>75</td>\n",
              "      <td>67</td>\n",
              "      <td>54</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>47</td>\n",
              "      <td>...</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 11345 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                         0                           1      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                      SOPHIA                       CHLOE   \n",
              "Count                                      119                         106   \n",
              "\n",
              "                                         2                           3      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                       EMILY                      OLIVIA   \n",
              "Count                                       93                          89   \n",
              "\n",
              "                                         4                           5      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                        EMMA                    ISABELLA   \n",
              "Count                                       75                          67   \n",
              "\n",
              "                                         6                           7      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                     TIFFANY                      ASHLEY   \n",
              "Count                                       54                          52   \n",
              "\n",
              "                                         8                           9      \\\n",
              "Year of Birth                             2011                        2011   \n",
              "Gender                                  FEMALE                      FEMALE   \n",
              "Ethnicity           ASIAN AND PACIFIC ISLANDER  ASIAN AND PACIFIC ISLANDER   \n",
              "Child's First Name                       FIONA                      ANGELA   \n",
              "Count                                       48                          47   \n",
              "\n",
              "                    ...               11335               11336  \\\n",
              "Year of Birth       ...                2016                2016   \n",
              "Gender              ...              FEMALE              FEMALE   \n",
              "Ethnicity           ...  BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name  ...             Mikayla                Mila   \n",
              "Count               ...                  10                  10   \n",
              "\n",
              "                                 11337               11338  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name               Milan               Sanaa   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11339               11340  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name               Sanai             Saniyah   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11341               11342  \\\n",
              "Year of Birth                     2016                2016   \n",
              "Gender                          FEMALE              FEMALE   \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC   \n",
              "Child's First Name                Skye               Tiana   \n",
              "Count                               10                  10   \n",
              "\n",
              "                                 11343               11344  \n",
              "Year of Birth                     2016                2016  \n",
              "Gender                          FEMALE              FEMALE  \n",
              "Ethnicity           BLACK NON HISPANIC  BLACK NON HISPANIC  \n",
              "Child's First Name              Violet               Zahra  \n",
              "Count                               10                  10  \n",
              "\n",
              "[5 rows x 11345 columns]"
            ]
          },
          "execution_count": 41,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_transposed = df.T\n",
        "df_transposed.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SexqxlWWIf32"
      },
      "source": [
        "## 18. df.merge()\n",
        "\n",
        "**df.merge()** is a pandas function that allows you to combine two DataFrames based on one or more common columns. It is similar to SQL JOINs. The function returns a new DataFrame that contains only the rows where the values in the specified columns match between the two DataFrames.\n",
        "\n",
        "Here is an example of how to use df.merge() to combine two DataFrames based on a common column:\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "RaD4EJyPIf33",
        "outputId": "77a4836c-e488-4165-dd40-4d54e7e84c27"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "  key  value_x  value_y\n",
            "0   B        2        5\n",
            "1   D        4        6\n"
          ]
        }
      ],
      "source": [
        "# Create the first DataFrame\n",
        "df1 = pd.DataFrame({'key': ['A', 'B', 'C', 'D'],\n",
        "                   'value': [1, 2, 3, 4]})\n",
        "\n",
        "# Create the second DataFrame\n",
        "df2 = pd.DataFrame({'key': ['B', 'D', 'E', 'F'],\n",
        "                   'value': [5, 6, 7, 8]})\n",
        "\n",
        "# Merge the two DataFrames on the 'key' column\n",
        "merged_df = df1.merge(df2, on='key')\n",
        "\n",
        "# Print the merged DataFrame\n",
        "print(merged_df)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "E45_jSrtIf34"
      },
      "source": [
        "## 19. df.rename()\n",
        "**df.rename()** is a pandas function that allows you to change the name of one or more columns or rows in a DataFrame. You can use the columns parameter to change the column names, and the index parameter to change the row names.\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "vTn0q1SlIf35",
        "outputId": "f281c2b5-585e-49a8-f5a2-870aca84e36c"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "0           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "1           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "2           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4           2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "\n",
              "   count  Rank  \n",
              "0    119     1  \n",
              "1    106     2  \n",
              "2     93     3  \n",
              "3     89     4  \n",
              "4     75     5  "
            ]
          },
          "execution_count": 43,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Rename column 'Count' to 'count'\n",
        "df_rename = df.rename(columns={'Count': 'count'})\n",
        "df_rename.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "9XFX7cKkIf36"
      },
      "source": [
        "You can also use a dictionary to rename multiple columns at once:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "9a-8-wddIf36",
        "outputId": "af26529c-7c25-469e-e7f6-09d6cda12b4d"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>count</th>\n",
              "      <th>rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "0           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "1           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "2           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3           2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4           2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "\n",
              "   count  rank  \n",
              "0    119     1  \n",
              "1    106     2  \n",
              "2     93     3  \n",
              "3     89     4  \n",
              "4     75     5  "
            ]
          },
          "execution_count": 44,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_rename = df.rename(columns={'Count': 'count', 'Rank':'rank'})\n",
        "df_rename.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aZg1ry8sIf37"
      },
      "source": [
        "You can also rename the index similarly:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Py7rd2XLIf37",
        "outputId": "00231669-4fd7-4ea7-82fc-bfbf73e6fb20"
      },
      "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>Year of Birth</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Ethnicity</th>\n",
              "      <th>Child's First Name</th>\n",
              "      <th>Count</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>first</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>SOPHIA</td>\n",
              "      <td>119</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>second</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>CHLOE</td>\n",
              "      <td>106</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>third</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMILY</td>\n",
              "      <td>93</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>OLIVIA</td>\n",
              "      <td>89</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2011</td>\n",
              "      <td>FEMALE</td>\n",
              "      <td>ASIAN AND PACIFIC ISLANDER</td>\n",
              "      <td>EMMA</td>\n",
              "      <td>75</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "        Year of Birth  Gender                   Ethnicity Child's First Name  \\\n",
              "first            2011  FEMALE  ASIAN AND PACIFIC ISLANDER             SOPHIA   \n",
              "second           2011  FEMALE  ASIAN AND PACIFIC ISLANDER              CHLOE   \n",
              "third            2011  FEMALE  ASIAN AND PACIFIC ISLANDER              EMILY   \n",
              "3                2011  FEMALE  ASIAN AND PACIFIC ISLANDER             OLIVIA   \n",
              "4                2011  FEMALE  ASIAN AND PACIFIC ISLANDER               EMMA   \n",
              "\n",
              "        Count  Rank  \n",
              "first     119     1  \n",
              "second    106     2  \n",
              "third      93     3  \n",
              "3          89     4  \n",
              "4          75     5  "
            ]
          },
          "execution_count": 45,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "df_rename = df.rename(index={0:'first',1:'second',2:'third'})\n",
        "df_rename.head()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PjcJ6Hs2If38"
      },
      "source": [
        "## 20. df.to_csv()\n",
        "**df.to_csv()** is a method used in the Pandas library to export a DataFrame to a CSV file. CSV stands for \"Comma Separated Values\" and it is a popular file format for storing data in a tabular form.\n",
        "\n",
        "For example, let’s say we want to save df that you want to export to a CSV file. You can export the DataFrame to a CSV file by calling df.to_csv() and passing the file name as a string:"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "AixIK5RJIf38"
      },
      "outputs": [],
      "source": [
        "df.to_csv('data.csv')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "itOr5Ma0If39"
      },
      "source": [
        "You can also specify the separator used in the CSV file by passing the sep parameter. By default, it’s set to “,”."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "wHhFqw-xIf39"
      },
      "outputs": [],
      "source": [
        "df.to_csv('path/to/data.csv', sep='\\t')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "58W-gfJvIf3-"
      },
      "source": [
        "It is also possible to only save specific columns of the DataFrame by passing the list of column names to the columns parameter, and also to save only specific rows by passing a boolean mask to the index parameter."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "gHQX2QDqIf3_"
      },
      "outputs": [],
      "source": [
        "df.to_csv('path/to/data.csv', columns=['Rank','Count'])"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pkWlvQOGIf4A"
      },
      "source": [
        "You can also use the index parameter to specify whether to include or exclude the index of the dataframe in the exported CSV file."
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "qjohDJWkIf4B"
      },
      "source": [
        "This will exclude the index of the dataframe in the exported CSV file.\n",
        "\n",
        "You can also use na_rep parameter to replace missing values in the exported CSV file with a specific value."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "XW67DFU2If4B"
      },
      "outputs": [],
      "source": [
        "df.to_csv('path/to/data.csv', na_rep='NULL')"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "I3jXcLaMIf4C"
      },
      "source": [
        "In summary here are the 20 pandas functions that can be used to accomplish most of your data tasks:\n",
        "\n",
        "* pd.read_csv()\n",
        "* df.describe()\n",
        "* df.info()\n",
        "* df.plot()\n",
        "* df.iloc()\n",
        "* df.loc()\n",
        "* df.assign()\n",
        "* df.query()\n",
        "* df.sort_values()\n",
        "* df.sample()\n",
        "* df.isnull()\n",
        "* df.fillna()\n",
        "* df.dropna()\n",
        "* df.drop()\n",
        "* pd.pivot_table()\n",
        "* df.groupby()\n",
        "* df.transpose()\n",
        "* df.merge()\n",
        "* df.rename()\n",
        "* df.to_csv()"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "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.7.9"
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}