.. 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_reshaping.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_reshaping.py>`
        to download the full example code.

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

.. _sphx_glr_11_demos_python_packages_pandas_demo_reshaping.py:

Reshaping data
=================

.. GENERATED FROM PYTHON SOURCE LINES 5-22

.. code-block:: Python


    import pandas as pd
    import numpy as np


    tuples = list(
        zip(
            *[
                ["bar", "bar", "baz", "baz", "foo", "foo", "qux", "qux"],
                ["one", "two", "one", "two", "one", "two", "one", "two"],
            ]
        )
    )
    index = pd.MultiIndex.from_tuples(tuples, names=["first", "second"])
    dataFrame = pd.DataFrame(np.random.randn(8, 2), index=index, columns=["A", "B"])
    dataFrame2 = dataFrame[:4]








.. GENERATED FROM PYTHON SOURCE LINES 24-25

**Stack**

.. GENERATED FROM PYTHON SOURCE LINES 25-27

.. code-block:: Python

    stacked = dataFrame2.stack()








.. GENERATED FROM PYTHON SOURCE LINES 28-30

.. code-block:: Python

    stacked.unstack()






.. 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></th>
          <th>A</th>
          <th>B</th>
        </tr>
        <tr>
          <th>first</th>
          <th>second</th>
          <th></th>
          <th></th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th rowspan="2" valign="top">bar</th>
          <th>one</th>
          <td>-0.554887</td>
          <td>0.638492</td>
        </tr>
        <tr>
          <th>two</th>
          <td>1.603665</td>
          <td>1.977195</td>
        </tr>
        <tr>
          <th rowspan="2" valign="top">baz</th>
          <th>one</th>
          <td>-0.433228</td>
          <td>0.564101</td>
        </tr>
        <tr>
          <th>two</th>
          <td>0.739366</td>
          <td>-0.816024</td>
        </tr>
      </tbody>
    </table>
    </div>
    </div>
    <br />
    <br />

.. GENERATED FROM PYTHON SOURCE LINES 31-33

.. code-block:: Python

    stacked.unstack(1)






.. 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>second</th>
          <th>one</th>
          <th>two</th>
        </tr>
        <tr>
          <th>first</th>
          <th></th>
          <th></th>
          <th></th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th rowspan="2" valign="top">bar</th>
          <th>A</th>
          <td>-0.554887</td>
          <td>1.603665</td>
        </tr>
        <tr>
          <th>B</th>
          <td>0.638492</td>
          <td>1.977195</td>
        </tr>
        <tr>
          <th rowspan="2" valign="top">baz</th>
          <th>A</th>
          <td>-0.433228</td>
          <td>0.739366</td>
        </tr>
        <tr>
          <th>B</th>
          <td>0.564101</td>
          <td>-0.816024</td>
        </tr>
      </tbody>
    </table>
    </div>
    </div>
    <br />
    <br />

.. GENERATED FROM PYTHON SOURCE LINES 34-36

.. code-block:: Python

    stacked.unstack(0)






.. 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>first</th>
          <th>bar</th>
          <th>baz</th>
        </tr>
        <tr>
          <th>second</th>
          <th></th>
          <th></th>
          <th></th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th rowspan="2" valign="top">one</th>
          <th>A</th>
          <td>-0.554887</td>
          <td>-0.433228</td>
        </tr>
        <tr>
          <th>B</th>
          <td>0.638492</td>
          <td>0.564101</td>
        </tr>
        <tr>
          <th rowspan="2" valign="top">two</th>
          <th>A</th>
          <td>1.603665</td>
          <td>0.739366</td>
        </tr>
        <tr>
          <th>B</th>
          <td>1.977195</td>
          <td>-0.816024</td>
        </tr>
      </tbody>
    </table>
    </div>
    </div>
    <br />
    <br />

.. GENERATED FROM PYTHON SOURCE LINES 37-38

**Pivot tables**

.. GENERATED FROM PYTHON SOURCE LINES 38-48

.. code-block:: Python

    dataFrame = pd.DataFrame(
        {
            "A": ["one", "one", "two", "three"] * 3,
            "B": ["A", "B", "C"] * 4,
            "C": ["foo", "foo", "foo", "bar", "bar", "bar"] * 2,
            "D": np.random.randn(12),
            "E": np.random.randn(12),
        }
    )








.. GENERATED FROM PYTHON SOURCE LINES 49-51

.. code-block:: Python

    pd.pivot_table(dataFrame, values="D", index=["A", "B"], columns=["C"])






.. 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>C</th>
          <th>bar</th>
          <th>foo</th>
        </tr>
        <tr>
          <th>A</th>
          <th>B</th>
          <th></th>
          <th></th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th rowspan="3" valign="top">one</th>
          <th>A</th>
          <td>0.427408</td>
          <td>0.081922</td>
        </tr>
        <tr>
          <th>B</th>
          <td>0.732450</td>
          <td>-0.332109</td>
        </tr>
        <tr>
          <th>C</th>
          <td>-0.668688</td>
          <td>-0.644812</td>
        </tr>
        <tr>
          <th rowspan="3" valign="top">three</th>
          <th>A</th>
          <td>0.975939</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>B</th>
          <td>NaN</td>
          <td>0.025847</td>
        </tr>
        <tr>
          <th>C</th>
          <td>0.445298</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th rowspan="3" valign="top">two</th>
          <th>A</th>
          <td>NaN</td>
          <td>0.472312</td>
        </tr>
        <tr>
          <th>B</th>
          <td>1.680834</td>
          <td>NaN</td>
        </tr>
        <tr>
          <th>C</th>
          <td>NaN</td>
          <td>-1.301363</td>
        </tr>
      </tbody>
    </table>
    </div>
    </div>
    <br />
    <br />

.. GENERATED FROM PYTHON SOURCE LINES 52-53

**Time series**

.. GENERATED FROM PYTHON SOURCE LINES 53-57

.. code-block:: Python

    indexData = pd.date_range("1/5/2022", periods=100, freq="S")
    timestamps = pd.Series(np.random.randint(0, 500, len(indexData)), index=indexData)
    timestamps.resample("5Min").sum()





.. 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_reshaping.py:53: FutureWarning:

    'S' is deprecated and will be removed in a future version, please use 's' instead.


    2022-01-05    24493
    Freq: 5min, dtype: int32



.. GENERATED FROM PYTHON SOURCE LINES 58-60

.. code-block:: Python

    timeStempsUTC = timestamps.tz_localize("UTC")








.. GENERATED FROM PYTHON SOURCE LINES 61-63

.. code-block:: Python

    timeStempsUTC.tz_convert("US/Eastern")





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

 .. code-block:: none


    2022-01-04 19:00:00-05:00    351
    2022-01-04 19:00:01-05:00     77
    2022-01-04 19:00:02-05:00    269
    2022-01-04 19:00:03-05:00    415
    2022-01-04 19:00:04-05:00     47
                                ...
    2022-01-04 19:01:35-05:00    357
    2022-01-04 19:01:36-05:00    484
    2022-01-04 19:01:37-05:00    162
    2022-01-04 19:01:38-05:00    128
    2022-01-04 19:01:39-05:00    340
    Freq: s, Length: 100, dtype: int32



.. GENERATED FROM PYTHON SOURCE LINES 64-66

.. code-block:: Python

    ps = timestamps.to_period()








.. GENERATED FROM PYTHON SOURCE LINES 67-69

.. code-block:: Python

    ps.to_timestamp()





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

 .. code-block:: none


    2022-01-05 00:00:00    351
    2022-01-05 00:00:01     77
    2022-01-05 00:00:02    269
    2022-01-05 00:00:03    415
    2022-01-05 00:00:04     47
                          ...
    2022-01-05 00:01:35    357
    2022-01-05 00:01:36    484
    2022-01-05 00:01:37    162
    2022-01-05 00:01:38    128
    2022-01-05 00:01:39    340
    Freq: s, Length: 100, dtype: int32



.. GENERATED FROM PYTHON SOURCE LINES 70-73

.. code-block:: Python

    prng = pd.period_range("1990Q1", "2000Q4", freq="Q-NOV")
    ts = pd.Series(np.random.randn(len(prng)), prng)
    ts.index = (prng.asfreq("M", "e") + 1).asfreq("H", "s") + 9




.. 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_reshaping.py:72: FutureWarning:

    'H' is deprecated and will be removed in a future version, please use 'h' instead.






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

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


.. _sphx_glr_download_11_demos_python_packages_pandas_demo_reshaping.py:

.. only:: html

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

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

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

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

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

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

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