[ARROW-4824] [Python] read_csv should accept io.StringIO objects

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.12.1
• Fix Version/s: 0.14.0
• Component/s: Python
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/21341
• Assignee: Antoine Pitrou
• Reporter: Dave Hirschfeld
• Created: 11/Mar/19 12:07
• Updated: 11/Jan/23 07:36
• Resolved: 22/Apr/19 20:17

Description

It would be nice/convenient if `read_csv` also supported `io.StringIO` objects:

 

In [59]: csv = io.StringIO('''issue_date_utc,variable_name,station_name,station_id,value_date_utc,value
    ...: 2019-02-26 22:00:00,TEMPERATURE,ARCHERFIELD,040211,2019-02-27 03:00,29.1
    ...: ''')

In [60]: pd.read_csv(csv)
{{Out[60]: }}
        issue_date_utc variable_name  ...    value_date_utc  value
0  2019-02-26 22:00:00   TEMPERATURE  ...  2019-02-27 03:00   29.1

[1 rows x 6 columns]

In [61]: pa.csv.read_csv(csv)
Traceback (most recent call last):

  File "<ipython-input-61-d86447415aa3>", line 1, in <module>
    pa.csv.read_csv(csv)

SystemError: <built-in function read_csv> returned NULL without setting an error

 

Issue Links

• links to: GitHub Pull Request #4183