.. DO NOT EDIT.
.. THIS FILE WAS AUTOMATICALLY GENERATED BY SPHINX-GALLERY.
.. TO MAKE CHANGES, EDIT THE SOURCE PYTHON FILE:
.. "11_demos\python_packages\pandas\demo_categoricals.py"
.. LINE NUMBERS ARE GIVEN BELOW.

.. only:: html

    .. note::
        :class: sphx-glr-download-link-note

        :ref:`Go to the end <sphx_glr_download_11_demos_python_packages_pandas_demo_categoricals.py>`
        to download the full example code.

.. rst-class:: sphx-glr-example-title

.. _sphx_glr_11_demos_python_packages_pandas_demo_categoricals.py:

Categoricals
===============

.. GENERATED FROM PYTHON SOURCE LINES 5-13

.. code-block:: Python


    import pandas as pd


    dataFrame = pd.DataFrame(
        {"id": [1, 2, 3, 4, 5, 6], "raw_grade": ["a", "b", "b", "a", "a", "e"]}
    )








.. GENERATED FROM PYTHON SOURCE LINES 15-17

.. code-block:: Python

    dataFrame["grade"] = dataFrame["raw_grade"].astype("category")








.. GENERATED FROM PYTHON SOURCE LINES 18-24

.. code-block:: Python

    dataFrame["grade"].cat.rename_categories(["very good", "good", "very bad"])
    dataFrame["grade"] = dataFrame["grade"].cat.set_categories(
        ["very bad", "bad", "medium", "good", "very good"]
    )
    dataFrame["grade"]





.. rst-class:: sphx-glr-script-out

 .. code-block:: none


    0    NaN
    1    NaN
    2    NaN
    3    NaN
    4    NaN
    5    NaN
    Name: grade, dtype: category
    Categories (5, object): ['very bad', 'bad', 'medium', 'good', 'very good']



.. GENERATED FROM PYTHON SOURCE LINES 25-27

.. code-block:: Python

    dataFrame.sort_values(by="grade")






.. raw:: html

    <div class="output_subarea output_html rendered_html output_result">
    <div>
    <style scoped>
        .dataframe tbody tr th:only-of-type {
            vertical-align: middle;
        }

        .dataframe tbody tr th {
            vertical-align: top;
        }

        .dataframe thead th {
            text-align: right;
        }
    </style>
    <table border="1" class="dataframe">
      <thead>
        <tr style="text-align: right;">
          <th></th>
          <th>id</th>
          <th>raw_grade</th>
          <th>grade</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th>0</th>
          <td>1</td>
          <td>a</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>1</th>
          <td>2</td>
          <td>b</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>2</th>
          <td>3</td>
          <td>b</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>3</th>
          <td>4</td>
          <td>a</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>4</th>
          <td>5</td>
          <td>a</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>5</th>
          <td>6</td>
          <td>e</td>
          <td>NaN</td>
        </tr>
      </tbody>
    </table>
    </div>
    </div>
    <br />
    <br />

.. GENERATED FROM PYTHON SOURCE LINES 28-30

.. code-block:: Python

    dataFrame.groupby("grade").size()





.. rst-class:: sphx-glr-script-out

 .. code-block:: none

    C:\Workspace\itom_development_VS2019_Qt5.15.2_x64\itomProject\itom\demo\python_packages\pandas\demo_categoricals.py:28: FutureWarning:

    The default of observed=False is deprecated and will be changed to True in a future version of pandas. Pass observed=False to retain current behavior or observed=True to adopt the future default and silence this warning.


    grade
    very bad     0
    bad          0
    medium       0
    good         0
    very good    0
    dtype: int64




.. rst-class:: sphx-glr-timing

   **Total running time of the script:** (0 minutes 0.020 seconds)


.. _sphx_glr_download_11_demos_python_packages_pandas_demo_categoricals.py:

.. only:: html

  .. container:: sphx-glr-footer sphx-glr-footer-example

    .. container:: sphx-glr-download sphx-glr-download-jupyter

      :download:`Download Jupyter notebook: demo_categoricals.ipynb <demo_categoricals.ipynb>`

    .. container:: sphx-glr-download sphx-glr-download-python

      :download:`Download Python source code: demo_categoricals.py <demo_categoricals.py>`

    .. container:: sphx-glr-download sphx-glr-download-zip

      :download:`Download zipped: demo_categoricals.zip <demo_categoricals.zip>`