[ARROW-1291] [Python] pa.RecordBatch.from_pandas doesn't accept DataFrame with numeric column names

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.5.0
• Fix Version/s: 0.6.0
• Component/s: Python
• External issue URL: https://github.com/apache/arrow/issues/17262
• Assignee: Wes McKinney
• Reporter: Li Jin
• Created: 28/Jul/17 15:35
• Updated: 11/Jan/23 07:13
• Resolved: 29/Jul/17 17:55

Description

import pyarrow as pa
import pandas as pd

df = pd.DataFrame([1])
pa.RecordBatch.from_pandas(df)

Exception:

TypeError                                 Traceback (most recent call last)
<ipython-input-5-670ba4a2ddb2> in <module>()
      3 
      4 df = pd.DataFrame([1])
----> 5 pa.RecordBatch.from_pandas(df)

table.pxi in pyarrow.lib.RecordBatch.from_pandas()

table.pxi in pyarrow.lib._dataframe_to_arrays()

/home/icexelloss/miniconda3/envs/spark-dev/lib/python3.5/site-packages/pyarrow/pandas_compat.py in construct_metadata(df, index_levels, preserve_index, types)
    187                         arrow_type=arrow_type
    188                     )
--> 189                     for name, arrow_type in zip(df.columns, df_types)
    190                 ] + (
    191                     [

/home/icexelloss/miniconda3/envs/spark-dev/lib/python3.5/site-packages/pyarrow/pandas_compat.py in <listcomp>(.0)
    187                         arrow_type=arrow_type
    188                     )
--> 189                     for name, arrow_type in zip(df.columns, df_types)
    190                 ] + (
    191                     [

/home/icexelloss/miniconda3/envs/spark-dev/lib/python3.5/site-packages/pyarrow/pandas_compat.py in get_column_metadata(column, name, arrow_type)
    125         raise TypeError(
    126             'Column name must be a string. Got column {} of type {}'.format(
--> 127                 name, type(name).__name__
    128             )
    129         )

TypeError: Column name must be a string. Got column 0 of type int64