'Stack()' output with all Individual index's filled in Pandas DataFrame
<p>I have the following DataFrame:</p>

<pre><code>import pandas as pd
import numpy as np
dates = pd.date_range('20130101',periods=6)
df = pd.DataFrame(np.random.randn(6,4),index=dates,columns=list('ABCD'))
</code></pre>

<p>which is:</p>

<pre><code>out[]:df
                A          B            C           D
2013-01-01  0.849638    0.163683    -0.422279   -0.981363
2013-01-02  -0.828562   -0.726762   -0.154431   1.695164
2013-01-03  1.668989    1.057559    -0.958682   -1.443136
2013-01-04  -3.386432   0.115499    -2.095343   -1.887334
2013-01-05  1.595712    0.270327    -0.532860   -0.690501
2013-01-06  -1.734169   0.574431    -0.982097   1.092113
</code></pre>

<p>I stacked the dataframe with purpose and it appears as below:</p>

<pre><code>2013-01-01  A    0.849638
            B    0.163683
            C   -0.422279
            D   -0.981363
2013-01-02  A   -0.828562
            B   -0.726762
            C   -0.154431
            D    1.695164
2013-01-03  A    1.668989
            B    1.057559
            C   -0.958682
            D   -1.443136
2013-01-04  A   -3.386432
            B    0.115499
            C   -2.095343
            D   -1.887334
2013-01-05  A    1.595712
            B    0.270327
            C   -0.532860
            D   -0.690501
2013-01-06  A   -1.734169
            B    0.574431
            C   -0.982097
            D    1.092113
dtype: float64
</code></pre>

<p>I wish to have the dates printed in all the rows instead of having merged together. I want to have something like this:</p>

<pre><code>2013-01-01  A    0.849638
2013-01-01  B    0.163683
2013-01-01  C   -0.422279
2013-01-01  D   -0.981363
.......
.......

2013-01-06  A   -1.734169
2013-01-06  B    0.574431
2013-01-06  C   -0.982097
2013-01-06  D    1.092113

dtype: float64
</code></pre>

<p>Can anyone please help me to achieve this goal. Thank you.</p>

<p>the relevant pandas option is <code>'display.multi_sparse'</code><br>
you can set it yourself with</p>

<pre><code>pd.set_option('display.multi_sparse', False)
</code></pre>

<p>or use <code>pd.option_context</code> to temporarily set it in a <code>with</code> block</p>

<pre><code>with pd.option_context('display.multi_sparse', False):
    dates = pd.date_range('20130101',periods=6)
    print(pd.DataFrame(np.random.randn(6,4),index=dates,columns=list('ABCD')).stack())

2013-01-01  A    0.074056
2013-01-01  B    0.565971
2013-01-01  C    0.312375
2013-01-01  D    0.000926
2013-01-02  A    0.669702
2013-01-02  B    0.458241
2013-01-02  C    0.854965
2013-01-02  D    1.608542
2013-01-03  A    0.358990
2013-01-03  B    0.194446
2013-01-03  C   -0.988489
2013-01-03  D   -0.967467
2013-01-04  A   -0.768605
2013-01-04  B    0.791746
2013-01-04  C    0.073552
2013-01-04  D   -0.604505
2013-01-05  A    0.254031
2013-01-05  B    0.143891
2013-01-05  C   -0.351159
2013-01-05  D    0.642623
2013-01-06  A    0.499416
2013-01-06  B   -0.588694
2013-01-06  C    1.418078
2013-01-06  D   -0.071737
dtype: float64
</code></pre>

python pandas dataframe data-munging