Jupyter Notebook Hangs When Using DataFrame.Hist?

Question

I'm using Jupyter notebook and get a DataFrame back with two columns: 'pageviews' and 'type'.

First, I run this in its own cell:

%matplotlib notebook

Then I run code to get my DataFrame object (code omitted here but it runs fine and returns the correct result).

However, when I run this cell:

import numpy as np
df.hist(by='pageviews')

it hangs (I see "[ * ]").

Any idea what's going on here / what I'm doing incorrectly?

Thanks!

P.S. For reference, my DataFrame has 140k-ish entries and doing df.hist(by='type') seems to work...

    
RangeIndex: 104215 entries, 0 to 104214
Data columns (total 2 columns):
pageviews    104215 non-null float64
type         104215 non-null object
dtypes: float64(1), object(1)
memory usage: 1.6+ MB

Response from doing:

df = df[:50]
df.hist(by='pageviews', bins=10)

array([[,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ],
       [,
        ,
        ,
        ,
        ,
        ,
        ]], dtype=object)

Diego Aguado · Accepted Answer

Your pageviews column has dtype = float, try converting it to string

df.pageviews = df.pageviews.astype(int)

maybe this will help pandas to group and count the different bins.

Also, you could specify the number of bins with df.hist(by='pageviews', bins=10) for example

Jupyter Notebook Hangs When Using DataFrame.Hist?

Answers (1)

Related Questions