Spyder: Kernel dies when pandas.read_clipboard() is called

[ayhanfuat]

Description of your problem

Whenever I try to load a dataframe from the clipboard with pandas.read_clipboard() I see the message "It seems the kernel died unexpectedly. Use 'Restart kernel' to continue using this console."

What steps will reproduce the problem?

1. Copy some table to clipboard:

   c1  c2  c3  c4
0   1   2   2   1
1   1   3   2   3
2   3   4   4   3
3   4   5   6   5
4   5   6   9   7

1. Import pandas and call read_clipboard

import pandas as pd
df = pd.read_clipboard()

What is the expected output? What do you see instead?

It is expected to have the table loaded in the dataframe df. Instead, it displays the message:

It seems the kernel died unexpectedly. Use 'Restart kernel' to continue using this console.

Please provide any additional information below

I have two environments: one with Python 2.7.11 (named p2) and one with Python 3.5.1 (named p3). Root environment also has Python 3.5.1. The problem does not occur in p2. With Python 3.5.1 it occurs with both pandas v0.18.0 and v0.18.1.

If I run Python (3.5.1 with root env or with p3 env.) from the command line, it loads the dataframe with no errors.

Environment p3 in Spyder:

Root environment:

Environment p3 in command line:

Environment p3 with IPython from the command line:

Versions and main components

• Spyder Version: 2.3.8
• Python Version: 3.5.1
• Operating system: Windows 10 Pro 64-bit
  

  Dependencies

IPython >=1.0 : 4.1.2 (OK)
jedi >=0.8.1;<0.9.0: 0.9.0 (NOK)
matplotlib >=1.0 : 1.5.1 (OK)
pandas >=0.13.1 : 0.18.1 (OK)
pep8 >=0.6 : 1.7.0 (OK)
pyflakes >=0.6.0 : 1.1.0 (OK)
pygments >=1.6 : 2.1.1 (OK)
pylint >=0.25 : None (NOK)
qtconsole >=4.0 : 4.2.0 (OK)
rope >=0.9.2 : 0.9.4-1 (OK)
sphinx >=0.6.6 : 1.3.1 (OK)
sympy >=0.7.3 : 1.0 (OK)
zmq >=2.1.11 : 15.2.0 (OK)

[pbreach]

I have the exact same issue and setup. Hope this gets fixed. The problem only came up after switching from Python 2.7 to 3.5 Anaconda distributions for me.

[ccordoba12]

This is a very strange problem indeed! We'll try to fix it for Spyder 3.0 :-)

[KPilnacek]

To me, this happens as well with the same setup (Python 3.5.1, Anaconda 4.0.0, Spyder 2.3.8). It happens even if I downgrade pandas to 0.17.0

[ccordoba12]

I'm sorry but I'm unable to reproduce this problem in Spyder 2.3.9 nor in master using Windows 7 64 bits.

[pbreach]

Same for me at this time but I'm unsure why...

[yunguan-wang]

Same here.

[ayhanfuat]

I am also still experiencing the same problem and couldn't find a workaround. I suspect it is related to qtconsole as it works fine on ipython shell.

[rishabh-dimri88]

Encountered the same problem in Spyder and Jupyter notebook

[ccordoba12]

Please update to Spyder 3.0 and try again :-)

[Foucl]

fwiw, i tried on my windows 10 x64 machine and have no issues with read_clipboard() in spyder 3.0 (running in a python 2.7 environment) and 2.3.9 (with python 3.4).

[ayhanfuat]

Unfortunately I still have the same issue. In v3.0 it restarts itself though. :)

[jvaldiviezo9]

Hi, I have this problem only in the web browser, in the terminal there is no problem. I'm using Anaconda latest update (21/Oct/2016) and I'm Launching Jupyter Notebook from Spyder 3

The clipboard function make my kernel crash.

[ayhanfuat]

This is being discussed here as well: https://github.com/jupyter/notebook/issues/1667

I guess it is not a Spyder issue after all.

[ccordoba12]

Well, that's a relief :-)

[aravindsd]

See Pandas documentation to use read_clipboard (Anaconda Package)
It seems pandas read_clipboard need optional dependencies which are not yet compatible with python 3.5. I guess that's hindrance for _read_clipboard_

http://pandas.pydata.org/pandas-docs/stable/install.html#optional-dependencies

Doesn't have any issue in Python 3.4 (Anaconda Package)

[ccordoba12]

Closing because there's nothing we can do in Spyder about this.