Column headers out of alignment in 10 MInutes tutorial

[vlbrown]

Beginning at line In [93]: in getting_started/10min.html, the column headers of the output data frames go out of alignment.

Is this meant to have a semantic meaning that is not addressed by the tutorial commentary?

Code Sample, a copy-pastable example if possible

df = pd.DataFrame({'A': ['foo', 'bar', 'foo', 'bar',
                                         'foo', 'bar', 'foo', 'foo'],
                                   'B': ['one', 'one', 'two', 'three',
                                          'two', 'two', 'one', 'three'],
                                   'C': np.random.randn(8),
                                   'D': np.random.randn(8)})
df.groupby('A').sum()

Problem description

Output column headers do not line up as expected

            C        D
A                     
bar -2.802588  2.42611
foo  3.146492 -0.63958

Expected Output

A         C         D   
bar -2.802588  2.42611
foo  3.146492 -0.63958

Output of pd.show_versions()

INSTALLED VERSIONS ------------------ commit: None python: 3.7.3.final.0 python-bits: 64 OS: Darwin OS-release: 15.6.0 machine: x86_64 processor: i386 byteorder: little LC_ALL: None LANG: en_US.UTF-8 LOCALE: en_US.UTF-8

pandas: 0.24.2
pytest: 4.3.1
pip: 19.0.3
setuptools: 40.8.0
Cython: 0.29.6
numpy: 1.16.2
scipy: 1.2.1
pyarrow: None
xarray: None
IPython: 7.4.0
sphinx: 1.8.5
patsy: 0.5.1
dateutil: 2.8.0
pytz: 2018.9
blosc: None
bottleneck: 1.2.1
tables: 3.5.1
numexpr: 2.6.9
feather: None
matplotlib: 3.0.3
openpyxl: 2.6.1
xlrd: 1.2.0
xlwt: 1.3.0
xlsxwriter: 1.1.5
lxml.etree: 4.3.2
bs4: 4.7.1
html5lib: 1.0.1
sqlalchemy: 1.3.1
pymysql: None
psycopg2: None
jinja2: 2.10
s3fs: None
fastparquet: None
pandas_gbq: None
pandas_datareader: 0.7.0
gcsfs: None

[TomAugspurger]

I think that's deliberate. When you groupie 'A', it's moved to the index. Check df.groupby("A").sum().columns and df.groupby("A").sum().index.name.

I wonder if we should note that after doing the .sum(). Something like

"The unique values in the A column now form the index."

[vlbrown]

I would appreciate some sot of notation. It looks... odd and thus detracts from the learning experience. Especially given that this is part of a"10-minute introduction" - V

…

On Jun 19, 2019, at 20:09 , Tom Augspurger ***@***.***> wrote: I think that's deliberate. When you groupie 'A', it's moved to the index. Check df.groupby("A").sum().columns and df.groupby("A").sum().index.name. I wonder if we should note that after doing the .sum(). Something like "The unique values in the A column now form the index."

[TomAugspurger]

Are you interested in making a pull request to clarify it? The contributing docs are at http://pandas-docs.github.io/pandas-docs-travis/development/contributing.html . On Thu, Jun 20, 2019 at 1:38 PM Vicki Brown <notifications@github.com> wrote:

…

I would appreciate some sot of notation. It looks... odd and thus detracts from the learning experience. Especially given that this is part of a"10-minute introduction" - V > On Jun 19, 2019, at 20:09 , Tom Augspurger ***@***.***> wrote: > > I think that's deliberate. When you groupie 'A', it's moved to the index. Check df.groupby("A").sum().columns and df.groupby("A").sum(). index.name. > > I wonder if we should note that after doing the .sum(). Something like > > "The unique values in the A column now form the index." > — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#26955?email_source=notifications&email_token=AAKAOIQRJKDZPSM2UPHTHJLP3PFAXA5CNFSM4HZO3XB2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODYGIGTQ#issuecomment-504136526>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAKAOITDKAHC2KPJERJYSTTP3PFAXANCNFSM4HZO3XBQ> .