Python:限制pandas DataFrame的打印列的宽度 [英] Python: limit the width of printed columns of pandas DataFrame

查看:772
本文介绍了Python:限制pandas DataFrame的打印列的宽度的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试打印熊猫DataFrame. 列之一太宽(这是一个很长的字符串). 要打印,我正在使用tabulate库.但是,在打印时,它会在很长的一行中显示所有列的全部内容.这是我看到的:

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

如您所见,这行太长了. 如何限制打印字符串中的字符数?例如,我希望将第3行打印为如下内容:

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.

推荐答案

max_colwidth和(终端)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...

...

请参见选项文档.

这篇关于Python:限制pandas DataFrame的打印列的宽度的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆