Printing panda dataframe mislabels columns

[wyy1997]

Issue Type: Bug

Create a two-dimensional array using Python: Pandas: DataFrame, and output a table column index top that does not correspond to the data
import pandas as pd from pandas import Series, dict2 = {'a':[1, 2, 3], 'b':[4, 5, 6]} df6 = pd.DataFrame.from_dict(dict2) print(df6)

Extension version: 2020.3.63821-dev
VS Code version: Code 1.42.1 (c47d83b293181d9be64f27ff093689e8e7aed054, 2020-02-11T14:45:59.656Z)
OS version: Windows_NT x64 10.0.18362

System Info

Item	Value
CPUs	Intel(R) Core(TM) i5-6300HQ CPU @ 2.30GHz (4 x 2304)
GPU Status	2d_canvas: enabled flash_3d: enabled flash_stage3d: enabled flash_stage3d_baseline: enabled gpu_compositing: enabled metal: disabled_off multiple_raster_threads: enabled_on oop_rasterization: disabled_off protected_video_decode: unavailable_off rasterization: enabled skia_renderer: disabled_off surface_control: disabled_off surface_synchronization: enabled_on video_decode: enabled viz_display_compositor: enabled_on viz_hit_test_surface_layer: disabled_off webgl: enabled webgl2: enabled
Load (avg)	undefined
Memory (System)	7.88GB (1.88GB free)
Process Argv
Screen Reader	no
VM	40%

[rchiodo]

This has to do with the styles in the output of print(df6). You can work around this by using df.head() instead or by using the data viewer in the Variables:

[RMeli]

I have the same problem.

---

df = pd.DataFrame(np.arange(9).reshape(3,3), index=list("abc"), columns=list("def"))

Output with Jupyter Notebook or IPython console (expected, correct):

   d  e
a  0  1
b  3  4
c  6  7

Output with VSCode:

d  e
a  0  1
b  3  4
c  6  7

---

VSCode: 1.43.2
Python for VSCode: 2020.3.69010

pandas: 1.0.3

jupyter core : 4.6.3
jupyter-notebook : 6.0.3
qtconsole : 4.7.2
ipython : 7.13.0
ipykernel : 5.2.0
jupyter client : 6.1.2
jupyter lab : not installed
nbconvert : 5.6.1
ipywidgets : 7.5.1
nbformat : 5.0.4
traitlets : 4.3.3

[RMeli]

Printing the DataFrame a second time does not show the same issue:

df = pd.DataFrame(np.arange(9).reshape(3,3), index=list("abc"), columns=list("def"))

print(df, "\n")
print(df)

d  e  f
a  0  1  2
b  3  4  5
c  6  7  8 

   d  e  f
a  0  1  2
b  3  4  5
c  6  7  8

Is the output of the cell stripped of beginning/end withe spaces?

[whlinaa]

This is actually a bug of VS Code, which automatically remove the leading whitespaces of a print() statement.

Example: write print(" hello world"), and the output will remove the leading whitespaces of this statement.

VS Code, please help resolve this problem. This is really driving Python users nuts.

More info: microsoft/vscode#103766

[rchiodo]

Moving back to triage. We've been getting a bunch of dupes of this.

Note: One of the dupes was marked as Nice To Have for July.

[rchiodo]

Validated. Should be in September release.