[ARROW-13972] [python] read csv with different number of columns per row

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.0.0
• Component/s: Python
• Labels: csv table
• External issue URL: https://github.com/apache/arrow/issues/18839

Language

Python

• Assignee: Unassigned
• Reporter: Sai Krishna Chaitanya Chaganti
• Created: 10/Sep/21 11:55
• Updated: 11/Jan/23 08:36

Description

When tried to read CSV data with multiple columns per row, arrows fails with an error message like below. When tried to read the CSV using other libs such as spark and pandas, they are filling up the remaining columns with null values. Is it possible to introduce such feature in pyarrow, CSV may or may not contain headers.

Expected 952 columns, got 620: