I am trying to print a pandas DataFrame.
One of the columns is too wide (it is a very long string).
To print I am using tabulate
library. But when it is printed it shows the whole content of all columns in one very long line. Here is what I see:
row name review rating
0 Planetwise Flannel Wipes These flannel wipes are OK, but in my opinion not worth keeping. I also ordered someImse Vimse Cloth Wipes-Ocean Blue-12 countwhich are larger, had a nicer, softer texture and just seemed higher quality. I use cloth wipes for hands and faces and have been usingThirsties 6 Pack Fab Wipes, Boyfor about 8 months now and need to replace them because they are starting to get rough and have had stink issues for a while that stripping no longer handles. 3
1 Planetwise Wipe Pouch it came early and was not disappointed. i love planet wise bags and now my wipe holder. it keps my osocozy wipes moist and does not leak. highly recommend it. 5
2 Annas Dream Full Quilt with 2 Shams Very soft and comfortable and warmer than it looks...fit the full size bed perfectly...would recommend to anyone looking for this type of quilt 5
3 Stop Pacifier Sucking without tears with Thumbuddy To Love\'s Binky Fairy Puppet and Adorable Book This is a product well worth the purchase. I have not found anything else like this, and it is a positive, ingenious approach to losing the binky. What I love most about this product is how much ownership my daughter has in getting rid of the binky. She is so proud of herself, and loves her little fairy. I love the artwork, the chart in the back, and the clever approach of this tool. 5
4 Stop Pacifier Sucking without tears with Thumbuddy To Love\'s Binky Fairy Puppet and Adorable Book All of my kids have cried non-stop when I tried to ween them off their paci
as you can see the line is too long. How can I limit the number of characters in the printed string? For example I would like that line 3 to be printed as something like this:
3 Stop Pacifier Sucking without tears ... This is a product well worth ... 5
I want this limitation to be applied to all lines in the table.
The default number of the max number of columns is 20. If we don't change it and having a data frame with more than 20 columns, we won't be able to view the columns in the middle again.
The long answer is the size limit for pandas DataFrames is 100 gigabytes (GB) of memory instead of a set number of cells.
Using set_option(), we can change the default number of rows to be displayed. import pandas as pd pd.
A function set_option() is provided by pandas to display all rows of the data frame. display. max_rows represents the maximum number of rows that pandas will display while displaying a data frame. The default value of max_rows is 10.
There's max_colwidth
and (terminal) width
:
In [11]: pd.options.display.width = 50
In [12]: pd.options.display.max_colwidth = 50
In [13]: df
Out[13]:
0 \
0 0 Planetwise Flannel Wipes
1 1 Planetwise Wipe Pouch
2 2 Annas Dream Full Quilt with 2 Shams
3 3 Stop Pacifier Sucking without tears with Th...
4 4 Stop Pacifier Sucking without tears with Th...
...
See the options docs.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With