Related to Issue 3922: Panda still crashes with pivot() Function

[rmschne]

Followup to 3922 where it was recognised a bug maybe to be fixed in Ver 12, I left it a few months and waiting for version 0.12.0 which is now installed on Mac with fully patched mavericks.

Old issue: #3922

Doing the example on http://pandas.pydata.org/pandas-docs/stable/reshaping.html, all works down to In [3] where I issue the command:

df.pivot(index='date', columns='variable', values='value')

Nothing happens. Press ctrl-d:

File "<stdin>", line 1, in <module>
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/frame.py", line 4182, in pivot
    return pivot(self, index=index, columns=columns, values=values)
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/reshape.py", line 345, in pivot
    return indexed.unstack(columns)
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/series.py", line 2439, in unstack
    return unstack(self, level)
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/reshape.py", line 419, in unstack
    unstacker = _Unstacker(obj.values, obj.index, level=level)
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/reshape.py", line 87, in __init__
    self._make_sorted_values_labels()
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/reshape.py", line 98, in _make_sorted_values_labels
    comp_index, obs_ids = get_compressed_ids(to_sort, sizes)
  File "/Users/rmschne/.virtualenv/rmspython/lib/python2.7/site-packages/pandas/core/reshape.py", line 470, in get_compressed_ids
    while com._long_prod(sizes[:i]) >= 2 ** 63:

System requirements (from 'pip') are:
Cython==0.19.1
Django==1.5.1
MySQL-python==1.2.4b4
distribute==0.6.28
django-ical==1.1
django-mailchimp==0.1.30
icalendar==3.1
ipython==0.13.2
mailsnake==1.6.1
matplotlib==1.2.1
nose==1.3.0
numpy==1.7.1
pandas==0.12.0
python-dateutil==2.1
pytz==2013.8
requests==0.14.2
scipy==0.11.0
simplejson==2.6.2
six==1.3.0
twitter==1.10.2
wsgiref==0.1.2
yolk==0.4.3

[rmschne]

On the same Mac, using Parallels to run Ubuntu ... installed pandas and all dependancies ... the above pivot at step [3] worked just fine.

Thus I'm guessing something with with Apple's Python 2.7 or something.

[ghost]

Can you provide a gdb stack trace? if the segfault occurs in pandas code we'll look into it.

[rmschne]

Could you please advise how to do a gdb stack trace. Thanks.

On 27 Jan 2014, at 05:12, y-p [email protected] wrote:

Can you provide a gdb stack trace? if the segfault occurs in pandas code we'll look into it.

—
Reply to this email directly or view it on GitHub.

--rms

Rob Schneider
[email protected]

[ghost]

http://stackoverflow.com/a/2664232

[ghost]

Closing, we'll reoepn if new info is available.