How to show all elements of a series using pandas

Question

I have a list containing strings that I want to separate with a '|'. The problem I am facing is that creating a pandas series only shows the first few observations followed by ... Is there something I can do to avoid that? Thanks

import pandas as pd

names = pd.Series([['james', 'han', 'sam', 'john', 'dan',
                    'greg', 'adam', 'ben', 'johan', 'asesh', 'kofi']])
name_list = names.str.join('|').to_string(index=False)

Does this answer your question? [Pretty-print an entire Pandas Series / DataFrame](https://stackoverflow.com/questions/19124601/pretty-print-an-entire-pandas-series-dataframe) — Emmanuel Murairi, Jun 15 '23 at 04:21

score 1 · Answer 1 · answered Jun 15 '23 at 03:05

This answer discusses how Pandas automatically truncates long strings, so your names_list isn't printing because it's been truncated. Set the Pandas parameter below to fix this particular issue:

import pandas as pd
pd.options.display.max_colwidth = None

names = pd.Series([['james', 'han', 'sam', 'john', 'dan',
                    'greg', 'adam', 'ben', 'johan', 'asesh', 'kofi']])
name_list = names.str.join('|').to_string(index=False)
print(name_list)

james|han|sam|john|dan|greg|adam|ben|johan|asesh|kofi

score 0 · Answer 2 · answered Jun 15 '23 at 03:26

You can use to_dict() or to_list().

Output:

{0: ['james',
  'han',
  'sam',
  'john',
  'dan',
  'greg',
  'adam',
  'ben',
  'johan',
  'asesh',
  'kofi']}

Or

[['james',
  'han',
  'sam',
  'john',
  'dan',
  'greg',
  'adam',
  'ben',
  'johan',
  'asesh',
  'kofi']]

How to show all elements of a series using pandas

2 Answers2