Python data viewer does not support grouped columns (custom indices), Multi-index , PeriodIndex

[p5ydn0]

Bug: Notebook Editor, Interactive Window, Editor cells

Steps to cause the bug to occur

When run below code:

import numpy as np
import pandas as pd

# data is from kaggle Titanic Competition
data_train = pd.read_csv('data/train.csv')

g = data_train.groupby(['SibSp','Survived'])
df1 = pd.DataFrame(g.count()['PassengerId'])
df2 = pd.DataFrame(g.count()['Pclass'])
print(df)

the python interactive variables function can't achieve(display) the expected groupby effect.

the expected effect is like this(below is in Spyder):

but the VSCode variables effect is this:

Your Jupyter and/or Python environment

Please provide as much info as you readily know

• Jupyter server running: Local
• Extension version: 2020.3.71659
• VS Code version: 1.43.2
• Setting python.jediEnabled: true
• Python and/or Anaconda version: 3.7.3
• OS: Mac
• Virtual environment: conda

Developer Tools Console Output

Microsoft Data Science for VS Code Engineering Team: @rchiodo, @IanMatthewHuff, @DavidKutu, @DonJayamanne, @greazer

[rchiodo]

Sorry but not sure what you're asking for here? Did you want column reordering?

We do support sorting by different columns, you just can't move them around.

[p5ydn0]

Sorry but not sure what you're asking for here? Did you want column reordering?

We do support sorting by different columns, you just can't move them around.

Thank you for your reply.

I am not going to sort, but to group by the two columns of SibSp and Survived; you can notice the first two columns in the picture expected to be displayed correctly, that is the result I expect; and the display of these two columns in VSCode is the "garbled" content in the index below (or not displayed).

[aeryen]

bump this, the current data viewer seems have poor support for multi-index.