Pandas Dataframe automatically shorten strings?

Question

I was trying to convert dictionary to pandas dataframe. I have pretty long string in the original dictionary but when I convert into dataframe, I see these strings get shortened. Do anyone know how to store whole string in the dataframe?

Here is some code:

To convert into Dataframe

test = pd.DataFrame(res['Items'][-1]['Item'])

Whole string code from dictionary

res['Items'][-1]['Item']['catchcopy']

Output:

'クリスタルガイザー / クリスタルガイザー(Crystal Geyser) / ミネラルウォーター 500ml 48本 水 ケース☆送料無料☆'

Shortened string code from dataframe

test.catchcopy

Output:

0    クリスタルガイザー / クリスタルガイザー(Crystal Geyser) / ミネラルウォ...
Name: catchcopy, dtype: object

Consider to [create a Minimal, Complete, and Verifiable example](http://stackoverflow.com/help/mcve) — Anton Protopopov, Feb 05 '16 at 05:32
please provide sample of dict, panda and your code used to convert it — The6thSense, Feb 05 '16 at 05:33

Ami Tavory · Accepted Answer · 2016-02-05T06:36:22.627

12

You seem to be confusing the content of the pandas cell with its display. If you want to change the latter, try using display.max_colwidth, like so:

pd.set_option('max_colwidth',40)

Also, if your DataFrame is df and the column name is 'c', you can access the contents of a cell using:

df['c'].values[1]

(for the second cell, e.g.). If you print this, for example, you should see your Python interpreter's rendition of the string.

edited Feb 05 '16 at 06:36

answered Feb 05 '16 at 05:58

Ami Tavory

74,578
11
141
185

Oh I see, thanks Ami. If you want to temporarily display entire string of a certain cell, how would you do it? Or is it possible? – user3368526 Feb 05 '16 at 06:30
@user3368526 See update. – Ami Tavory Feb 05 '16 at 06:36
Great, worked :D Thank you! – user3368526 Feb 05 '16 at 06:41
You're very welcome. – Ami Tavory Feb 05 '16 at 06:46

Pandas Dataframe automatically shorten strings?

1 Answers1