File fails because data wrangler cannot skip header line

[mladen5000]

Type: Bug

Behaviour

Expected vs. Actual

I know there's a pd.read_csv() argument to skip a header row but its not accessible on data wrangler even if i try to edit it, because once it doesn't read the code grays out

Steps to reproduce:

1. XXX

Diagnostic data

• Jupyter extension version: 2025.1.2024122001
• Python extension version: 2024.23.2024121901
• .NET Install Tool for Extension Authors extension version: Not installed
• Python package dependencies:

{
  "installed": {
    "pandas": "2.2.2",
    "pyarrow": "16.1.0"
  },
  "required": {
    "pandas": "1.2.0"
  },
  "unsatisfied": []
}

• Entrypoint: Command
• Active mode: dataWrangler

Extension version: 1.15.1
VS Code version: Code - Insiders 1.97.0-insider (89f808979a5151bd91324e65d4f7ab1b62896983, 2024-12-20T05:04:19.167Z)
OS version: Darwin arm64 24.3.0
Modes:

System Info

Item	Value
CPUs	Apple M1 (8 x 2400)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	3, 4, 5
Memory (System)	16.00GB (0.12GB free)
Process Argv	--crash-reporter-id 0c3e08e7-ea47-425a-9275-aa898d1457f4
Screen Reader	no
VM	0%

[pwang347]

Hi @mladen5000, thank you for opening this issue!

Could you please share a screenshot or more details of what you mean by this:

even if i try to edit it, because once it doesn't read the code grays out

You should be able to edit the import code by either click the first cleaning step here:

or the link on this toast message

Below, I've added the skiprows=1 parameter and the data in the grid shows a preview, and I can press Update to save the code.

Please let me know if this works for you. Thanks!

[pwang347]

Closing this issue due to inactivity, but please feel free to reopen and provide more details!