TypeError while trying to print a dataframe in jupyter notebook

Question

I have an example dataframe defined like this in python:

df = pd.DataFrame({
  'col1': ['Item0', 'Item0', 'Item1', 'Item1'],
  'col2': ['Gold', 'Bronze', 'Gold', 'Silver'],
  'col3': [1, 2, np.nan, 4]
   })

when I try to print the dataframe df in jupyter notebook by simply typing df in jupyter and executing it I am getting an error:

TypeError: The numpy boolean negative, the - operator, is not supported, use the ~ operator or the logical_not function instead.

I have tried print(df), converting to html table and printing it, display(df) all are showing the same error.

PS: print(df) or just df were working perfectly fine in jupyter a few weeks back.

You've probably assigned something incorrect to df what does type(df) show? Also try restarting your kernel as it looks like you have some incorrect state — EdChum
– EdChum, Commented Jun 22, 2017 at 11:21
100% agree with @EdChum. First step is to restart your kernel (or, to be extra safe, jupyter). Second step is to check the type of your df. — erip
– erip, Commented Jun 22, 2017 at 11:29
ya even I guess @EdChum is right. I am getting this error only when I run the following program on jupyter running on docker on server. When I executed the same program in the jupyter running on my local machine it works just fine. — Abhijit Balaji
– Abhijit Balaji, Commented Jun 23, 2017 at 4:25

dfrankow · Accepted Answer · 2017-09-06 18:45:19Z

2

It helped me to upgrade from pandas 0.13 to 0.20.3.

answered Sep 6, 2017 at 18:45

dfrankow

21.7k44 gold badges167 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

telegraphic · Accepted Answer · 2017-07-19 04:27:52Z

1

I just ran into this error in a different setting, and I think the underlying issue is incompatibility with Numpy 1.13, with the (interim) fix being to reinstall with Numpy 1.12.

The change in behavior that's causing the error is that Numpy now throws an error if you try and negate a boolean: https://docs.scipy.org/doc/numpy/release.html#deprecationwarning-to-error

DeprecationWarning to error: negative(bool_), TypeError when negative applied to booleans.

answered Jul 19, 2017 at 4:27

telegraphic

3435 silver badges7 bronze badges

1 Comment

ehfaafzv Over a year ago

I cannot print(df) or df in Jupyter, or in python. The error msg was: TypeError: reduce() takes at most 5 arguments (6 given). Moving numpy from 1.15 to 1.14 solved it.

user3483203 · Accepted Answer · 2018-02-16 18:25:44Z

1

Try editing the file it gives error. I had a similar issue pointing to file series.py in my python packages at line ~1800 had to manually edit good = -bad to good = ~bad

Surprisingly even when I commented the first line to add the second it game me an error saying - is not supported ...

After editing it manually everything looks fixed.

edited Feb 16, 2018 at 18:25

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

answered Feb 16, 2018 at 16:09

user9305954

Comments

Yusra Shahid · Accepted Answer · 2017-06-22 11:27:34Z

-1

Try using iloc,

    df.iloc[0:5] #this will show first 5 rows of the dataframe

for more details visit http://www.shanelynn.ie/select-pandas-dataframe-rows-and-columns-using-iloc-loc-and-ix/

answered Jun 22, 2017 at 11:27

Yusra Shahid

1029 bronze badges

Collectives™ on Stack Overflow

TypeError while trying to print a dataframe in jupyter notebook

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related