tabulate showing "\n" while printing

Question

I would like to print a table on the terminal and for that I use the tabulate package but I have extra return chariot '\n'. How can I remove them?

import pandas as pd
from tabulate import tabulate
df = pd.DataFrame({'schools' : ['Harvard', 'MIT', 'UCal', 'Cornell'],
                   'Faculty' : ['CS', 'Psychology', 'Biology', 'BioInformatics']})
print(tabulate(df,headers='keys',tablefmt='psql'))

Result

('+----+-----------+----------------+\n'
 '|    | schools   | Faculty        |\n'
 '|----+-----------+----------------|\n'
 '|  0 | Harvard   | CS             |\n'
 '|  1 | MIT       | Psychology     |\n'
 '|  2 | UCal      | Biology        |\n'
 '|  3 | Cornell   | BioInformatics |\n'
 '+----+-----------+----------------+')

When I try your example in my terminal it's fine. How are you using your script? Is it in a file script.py and then ran with a command like: python3 script.py ? — JimZer, Jun 12 '19 at 19:46

score 1 · Answer 1 · answered Jun 12 '19 at 21:10

It looks like you are not actually printing the string, but something else containing the string. In my terminal, if I use your code it works:

jvaubien@ml18-pc03 ~/Downloads> python3 test.py
+----+----------------+-----------+
|    | Faculty        | schools   |
|----+----------------+-----------|
|  0 | CS             | Harvard   |
|  1 | Psychology     | MIT       |
|  2 | Biology        | UCal      |
|  3 | BioInformatics | Cornell   |
+----+----------------+-----------+

With test.py containing your code sample.

But if I do:

import pandas as pd
from tabulate import tabulate
df = pd.DataFrame({'schools' : ['Harvard', 'MIT', 'UCal', 'Cornell'],
                   'Faculty' : ['CS', 'Psychology', 'Biology', 'BioInformatics']})
x = tabulate(df, headers='keys', tablefmt='psql')
print((x,))

I get the same result as you with the parenthesis and the \n.

Are you sure that you print the string and not something else? You have parenthesis around the string which shouldn't be here if you only printed the string.

tabulate showing "\n" while printing

1 Answers1