Uploaded image for project: 'Apache Arrow'
  1. Apache Arrow
  2. ARROW-15116

[Python] Expose invalid_row_handler for CSV reader

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 6.0.1
    • 7.0.0
    • Python

    Description

      I deal with 10G+ csv files (tab separated) every day. However, rows are of 21 or 22 fields uncertainly.

      If using pyarrow.csv.read_csv(),  error occurs.  I see ParseOptions(invalid_row_handler=...) in C++ API, but not in python API.

      Is there a due time for this api in python? Thanks in advance!

      Currently, I have to use pandas.read_csv(on_bad_lines=...) , which is extremely slow for 10G+ files...  

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            apitrou Antoine Pitrou
            sun2bin Bin Sun
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 2h 20m
                2h 20m

                Slack

                  Issue deployment