Spyder: Spyder ipython could not show H2O dataframe

[ellsaking]

Description of your problem

Spyder ipython console doesn't show h2o dataframe correctly.
What steps will reproduce the problem?

1. import h2o #import h2o module
2. import pandas as pd # import pandas module
3. h2o.init() #initialize h2o on cluster
4. df = pd.read_csv('dataXy_2.csv') # read any file into pandas dataframe
5. hf = h2o.H2OFrame(df) # convert pandas dataframe into H2O dataframe
6. run the above code in ipython console of Spyder, try to print hf, or hf.summary(), hf.show(), hf.describe()

What is the expected output? What do you see instead?
The hf dataframe structure, but out put nothing.

Please provide any additional information below
I tried to use Jupyter notebook or ipython notebook, they were showing the dataframe fine.

Versions and main components

• Spyder Version: 3.1.4.dev0
• Python Version: 3.5.3
• Qt Version: 5.8.0
• PyQt Version: 5.8.1
• Operating system: Windows

Dependencies

h2o, pandas
Please go to the menu entry Help > Optional Dependencies (or
Help > Dependencies), press the button Copy to clipboard
and paste the contents below:

[ccordoba12]

Please post screenshots of the results you get in Spyder and the notebook because I don't understand what you mean.

[ellsaking]

import pandas as pd
import h2o
h2o.init()
import numpy as np
foo = np.arange(10)
df = pd.DataFrame(foo, columns=['test'])
h2odf = h2o.H2OFrame(df)
h2odf
Output nothing, and the h2odf variable does not show in "Variable Explorer Panel"

[ellsaking]

Here comes the Jupyter notebook results

[javiqm12]

Same here with Spyder 3.2.6

Spyder dependencies:
IPython >=4.0 : 6.2.1 (OK)
cython >=0.21 : 0.25.2 (OK)
jedi >=0.9.0 : 0.11.1 (OK)
nbconvert >=4.0 : 5.3.1 (OK)
numpy >=1.7 : 1.12.1 (OK)
pandas >=0.13.1 : 0.20.1 (OK)
psutil >=0.3 : 5.4.3 (OK)
pycodestyle >=2.3: 2.3.1 (OK)
pyflakes >=0.6.0 : 1.6.0 (OK)
pygments >=2.0 : 2.2.0 (OK)
pylint >=0.25 : 1.8.1 (OK)
qtconsole >=4.2.0: 4.3.1 (OK)
rope >=0.9.4 : 0.10.7 (OK)
sphinx >=0.6.6 : 1.6.6 (OK)
sympy >=0.7.3 : 1.0 (OK)

H2O
h2o (3.16.0.4)

[TheXu]

Any updates to this problem? Having the same issue on Spyder

[ccordoba12]

No, we haven't worked on this, sorry.

[siafu2001]

This ain't working, what is the work around
import numpy as np
import pandas as pd
from pandas import Series,DataFrame
import webbrowser
website='http://en.wikipedia.org/wiki/NFL_win-loss_records'
webbrowser.open(website)
nfl_frame=pd.read_clipboard()
nfl_frame

[frozenfire10642]

Facing the same issue. Has anyone figured out the why this is happening?

[iutboy]

this is the workaround for now, convert it to dataframe
h2odf.as_data_frame()

[salmanea]

It's incredible that this error was reported here in 2017 and it's now almost 2020 and no fix for it. I really don't want to invest my time on a platform that is so badly maintained.

[marvely]

I recently start using spyder and doing something with H2O, this issue bothers me a lot!
Can you find someone to fix this old bug? I really prefer using spyder than jupyter notebook but this one bug may be able to force me ditch spyder... ;(

[goanpeca]

@marvely we are working to solve this issue.

[mnaidoo01]

Thank you. Will you release this in soon? Odd problem as we can see the h2o dataframe in the Anaconda command line interface (Python 3.7.5) but not in Spyder 3 or in Spyder 4 (beta). I've even run this after 'conda update -all', and still have the same problem.
The only way to view the data is by appending "as_data_frame()" the the h2o dataframe, as mentioned by iutboy earlier on this thread.

[redleafnew]

Has this issue been solved?

[goanpeca]

Not yet, we will work on it for the next release

[hailin-du]

It is been like two years, is the issue resolve yet? Thanks!