Pycharm is truncating dataframe output in Console Debug window

Answered

Created April 21, 2022 18:15

I have been using Pycharm Community edition for a while and am currently evaluating the Professional edition.

I am noticing though that when debugging in the console, the professional edition does not display the entire dataframe and simply truncates the display with ...

OUTPUT FROM PYCHARM COMMUNITY 2020.2.5

In[11]: x.sort_values('flow_id')[['flow_id', 'BillingCity', 'BillingPostalCode']]

Out[12]:
flow_id BillingCity BillingPostalCode
1096 00026bab2f2b4c4a9df1d401d95bc8fd ambridge 15003
1897 00093a4569764aac99795538f7b325c9 Quartzsite 85346
1221 00244ab57d3b4576b7b9e46d8c72413c Kissimmee 34759
1160 005f6e1df69a46278aa942a52cb72a68 Stamford 06902
1388 005faa442e1742a99d5065407a777a92 Lauderdale lakes 33319
379 01402913788443f5a25bccbd0ebe703f SHELBY 48316
943 014058ea533c4ca7b5e426cc3c1cc017 Denton 76201
1042 014de842b81b4dfabaaae934d8b3e742 Lawrenceville 30045
113 016006f91d4747f29f1a9ee42a33eb45 Las Vegas 89123
952 0177057d97874b52b5a04950a0b14750 Tulsa 74115
81 018d7743daa2476d91021749132c3cca Horn Lake 38637
1494 019520a3616b46c388d4d1fc1cb86f36 Orland Park 60462
765 01d6898364b34455996e3506ab431726 Miami 33015
612 0227cc4d84c84ce58b29d2cd5b2f4dc9 HATTIESBURG 39401
1407 02523af2bea64081afbad9effd04858a Palmdale 93551
1453 028f3eaea3f448a6a025e971e45fc47d Goodyear 85395
462 02935a15ba1e4536b49a2e317270ce49 Eagan 55123
1284 036deaf8825543c8a467a1034caa85e9 Colleyville 76034
48 036e67e81e104854b0f8078613c6759c Las Vegas 89123
591 038aa24c47524886b95891b545633325 Winthrop 02152
896 03c6654751fd4a84a4ce180dec0b2a97 Harvey 70058
1156 03c904cb1642431bb7c6e9bddfc5133a Lakewood 80232
763 03eaddff2d3a4fd9a55136ef6dda2463 Brookhaven 30319
213 03edd8dd8811471b8cc6144a5af3ce6c ELKRIDGE 21075
1143 044596ad28b6432e8765fca0d851c3b9 Knoxville 37912
295 0454cd4e5dc944c392d00b986d2ff808 Palm Bay 32908
764 0527d316e7c24bf08ca3508ca7cd72a8 Aurora 80016
675 053a0451bb8d4ee894d341bea34ace66 Decatur 30030
1280 0547b4de63b7409e9d9fcccf0e114c15 CANTON 44708
474 0551aad477be42a991f2d634b87c095b Hillsboro 45133
... ... ... ...
312 fd17222853d54688bc991605befea5ec Fort Worth 76116
1371 fd4cc4f0c56343499cc90a96855b32ab San antonio 78230
1201 fd51d23c6bbe4646aa2102824991aee4 Miramar 33025
330 fd8a0b29ec964308a2637457aff8ad9d Jersey Shore 17740
1230 fd8a28b812e3427d9589ba9332566af9 Riverside 92509
947 fdb9ecd7b0ee4fc4b6ffac0523a4667f HOUSTON 77056
718 fdd9aa99d45b45d48afedbb5e9288d04 HOUSTON 77036
1200 fe045837d4ec47b1be0517b98fc6e0e2 St Petersburg 33712
458 fe0f2d926767418da20f6b751b90bc58 Chicago 60624
97 fe5a5296cf274027b7aae61cc70528ae Detroit 48226
481 fe850a1aeb424ae8a02693c5085fc995 laveen 85339
318 fee7781e4da94eb9a7f8ac5109b6150b Raleigh 27612
1395 ff73283e305c485ea38813bd334e9c57 Camp Hill 17011
929 ffb70a6d6d1f413ba59180b768a0560e West new york 07093
251 ffb7568b6cf544f7948f4e27477c18fc Myrtle Beach Games 29588
1219 ffc54e6d52294e6f824521519ad28518 Auburn 48611
1260 ffdda644ec8f4e758346722340eade29 Hempstead 11550
1886 testing Miami 33169
1887 testing10 raleigh 27616
1885 testing10 Knoxville 37918
1896 testing10 Fort Lauderdale 33304
1895 testing10 Brooklyn 11212
1894 testing10 Alhambra 91803
1893 testing10 Indianapolis 46250
1889 testing4 Decatur 30036
1888 testing4 Union City 30291
1891 testing8 iselin 08830
1890 testing8 Plano 75025
1892 testing9 Brooklyn 11219
1864 testing9 Sturtevant 53177
[1923 rows x 3 columns]

OUTPUT FROM 2022.1 PROFESSIONAL EDITION

In[16]: x.sort_values('flow_id')[['flow_id', 'BillingCity', 'BillingPostalCode']]

Out[17]:
flow_id BillingCity BillingPostalCode
1096 00026bab2f2b4c4a9df1d401d95bc8fd ambridge 15003
1897 00093a4569764aac99795538f7b325c9 Quartzsite 85346
1221 00244ab57d3b4576b7b9e46d8c72413c Kissimmee 34759
1160 005f6e1df69a46278aa942a52cb72a68 Stamford 06902
1388 005faa442e1742a99d5065407a777a92 Lauderdale lakes 33319
379 01402913788443f5a25bccbd0ebe703f SHELBY 48316
943 014058ea533c4ca7b5e426cc3c1cc017 Denton 76201
1042 014de842b81b4dfabaaae934d8b3e742 Lawrenceville 30045
113 016006f91d4747f29f1a9ee42a33eb45 Las Vegas 89123
952 0177057d97874b52b5a04950a0b14750 Tulsa 74115
81 018d7743daa2476d91021749132c3cca Horn Lake 38637
1494 019520a3616b46c388d4d1fc1cb86f36 Orland Park 6046...

3 comments

Geoff

Created April 21, 2022 18:19

I forgot to mention - pandas display settings are identical on both versions, further I have tried the 'Override console cycle buffer size' to no avail.

Aaron

Created May 04, 2022 17:58

I've noticed this as well, however, I think it was introduced in a recent upgrade to PyCharm.

The following becomes truncated for me as well:

print('truncates' * 1000)
truncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatestruncatest...