Pandas read_sql() returns not the whole values, reduces the size

Asked Oct 08 '19 at 08:59

Active Oct 08 '19 at 08:59

Viewed 199 times

I am fetching a table from a database with read_sql()

table = pd.read_sql('SELECT * FROM {}'.format(table), con=engine)

But in the result, some characters in rows are substituted by 3 dots (...).

Example:

A  B     C
1  name  example_name...
2  city  example_city...

If I explicitly populate a df with the reduced values, it is ok.

Example:

A  B     C
1  name  example_name_Name1
2  city  example_city_Name2

I googled but haven't found an answer why it happens like this.

asked Oct 08 '19 at 08:59

Anna

1

it's just a shortened presentation of "long" values – RomanPerekhrest Oct 08 '19 at 09:00
Can you not try print(table.to_string()) to see the un-shortened version? – cloud88111 Oct 08 '19 at 14:30
I need to pass it as a parameter, not to see it – Anna Oct 09 '19 at 06:26

0 Answers0