novaBBS - comp.lang.python - Error pd.set_option('display.width', 10000)

Error pd.set_option('display.width', 10000)

<mailman.45.1707012945.3227.python-list@python.org>

https://www.novabbs.com/devel/article-flat.php?id=25012&group=comp.lang.python#25012

copy link Newsgroups: comp.lang.python

Path: i2pn2.org!i2pn.org!news.hispagatos.org!eternal-september.org!feeder3.eternal-september.org!fu-berlin.de!uni-berlin.de!not-for-mail
From: gel...@hotmail.com (gelukt gelukt)
Newsgroups: comp.lang.python
Subject: Error pd.set_option('display.width', 10000)
Date: Sat, 3 Feb 2024 23:02:05 +0000
Lines: 55
Message-ID: <mailman.45.1707012945.3227.python-list@python.org>
References: <AS4P189MB1968DE4D45E67E9C0078006FCB412@AS4P189MB1968.EURP189.PROD.OUTLOOK.COM>
<AS4P189MB1968CCB9C98B5E4184B8E1AECB412@AS4P189MB1968.EURP189.PROD.OUTLOOK.COM>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: news.uni-berlin.de Hmf8/so4bE9yxe5/XLxrhQEflC8/mNg4Io+kO74f5mSQ==
Cancel-Lock: sha1:Mc/fk+20LYYo1Ukj+e2eTdS8TlM= sha256:4pvZtZLMu+TAWOHS62Unuj3wmDNf3F2CL4aOTOQSRQM=
Return-Path: <gelukt@hotmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=pass
reason="2048-bit key; unprotected key"
header.d=hotmail.com header.i=@hotmail.com header.b=uMOlBdCb;
dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.010
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'traceback': 0.04; '(most':
0.05; 'last):': 0.05; 'exit': 0.07; 'skip:^ 10': 0.09; '102,':
0.16; '458,': 0.16; '__call__': 0.16; 'error?': 0.16; 'key,':
0.16; 'none)': 0.16; 'skip:" 70': 0.16; 'skip:& 90': 0.16;
"subject:('": 0.16; 'to:addr:python-list': 0.20; 'skip:& 40':
0.22; 'code': 0.23; 'to:name:python-list@python.org': 0.24;
'skip:- 10': 0.25; 'error': 0.29; 'code,': 0.31; 'header:In-Reply-
To:1': 0.34; 'running': 0.34; 'subject:skip:d 10': 0.35; 'fix':
0.36; 'file': 0.38; 'skip:o 10': 0.61; 'below:': 0.63; 'finished':
0.64; 'subject:skip:p 10': 0.64; 'skip:w 20': 0.69;
'charset:iso-8859-1': 0.73; 'dear,': 0.76; '1973,': 0.84;
'received:eurp189.prod.outlook.com': 0.84; 'skip:" 40': 0.84
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
b=G0oHYjhQaTRQDwl753IVuUrdMEArkXilOR7CWwEgneMNb+PBKpqIQr3fEeaFI8h+13bBiMcLg4m69BpX38ESFvKSgG2puJqke8CF56bgvnv2SFyFT0G1SRwO6LDxI1Xq6t7uCFmhsUnEOkdsYt7po35/uQMl1YHiCjolqQbgN7HXMDnhtha7a3CV1qgQhfoOPxSH09M17++K2qHVUUap5LxkrSwvs9sYf+mP8Wke1zG0pJUEBei/a03lxZdbEf3BYeHMuXgquaaNyYYRuxEm63fyJV/nziS3b3woJrrFRqo/jDNkY5gSq6VDrMC6qvHfk//OfJdF9ht39kSshjVpBQ==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
s=arcselector9901;
h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
bh=eWfZcrJp5PB0dYmyhEZU59D+frbH5D8LBcyrO0yhuNs=;
b=JPJBD3kzcgO+fzuoOa4CwoMUXlIcw5c5YuWM2Giz+T0Xd+bYCbMJ0StNMXpVcy2nUBeCT2gusAOGJlZlgPDLvS0/0AaVIeakh/TvHVmyShcInzxoQC7pktIHiUEOjOnJ9zqDJzW81m64DYsuWLX7oU4wAvLQ0gLWXGFeD+Id3r4RorBIvbaOgrIJ4YvJPT5kuKV18yy5hdNol8OAEhgjAqnF3OQZYFLdNdQgBnY2o3M8uVImO63sgLHFSaIx+7Dr4v/zrmPZe0m6IM9TROh/nl61+okwYGzIFKFfP60BB2iWdD5yAVsKQ26durcTgQXM3REnwejnqi07fkmOPTKIUg==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none;
dkim=none; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com;
s=selector1;
h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
bh=eWfZcrJp5PB0dYmyhEZU59D+frbH5D8LBcyrO0yhuNs=;
b=uMOlBdCbgHoCUMr3ftRIVmMimUA+7X1/WzLnTVtstmTRgtNwXty9DLW0tIOaCPsh/hALAwN8ZSrTDjwcwRUcU9SqajrSo7o76VGLue4PSTcHEJCvBROMoYbxby5cv95MsLAFyfUq4yGN6mwWuYYFtd6HnhOVGGVdlOvEqvd9OzR1AB/vqZ4Uy3O2VocUNjPP6aVtYqTnfuMb76ONHnHspFtEM1Ro1kOOyvSW6JOWqlGoCGFpPK3GVrt5owkeB0FILGFj8KhtOXzVmoE0DL00tx34hD+MZix+jFBnCcWU2FJHp8S5ClwMAFS7eRYtjM78B21jDLq6MVYUZtQZoa/MdQ==
Thread-Topic: Error pd.set_option('display.width', 10000)
Thread-Index: AQHaVvRk2wV8vmMdvUCtv1FXO2Abx7D5O+pB
In-Reply-To: <AS4P189MB1968DE4D45E67E9C0078006FCB412@AS4P189MB1968.EURP189.PROD.OUTLOOK.COM>
Accept-Language: nl-BE, en-US
Content-Language: nl-BE
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
msip_labels:
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [yGubjYCv2BBcm6ROUgc9FfSatu9GFwxRpvXwXiH4qWETLfJiSwuQBsFPGrIjyOxu]
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: AS4P189MB1968:EE_|PA4P189MB1263:EE_
x-ms-office365-filtering-correlation-id: 2f10d9a9-a022-4421-4fe9-08dc250c23eb
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: SHf0EYbKlXKEhT83y3Fxd2xJb2FautfrzB3RK5NqYDm9iQAbUv2gdz6ZLojhkH0Tlyq6e8qkRo8+RB0PZFqevfTp3eL2eZtFhkFrJZysJdITHOvZM/RjPGvlfJf13pdP89x8yeBmTm6aZITjzelSjeQ0jMBhAcXv5Wbifx6fPEYOYY2hs6V6tuIHuXfrPccbslGsm6Us80/dStscFVE6RjFMGs+BWJpvEmit55+gGk1LMqLHbDNa2Yz6iHPKf9VvCDC1qM412vLIuuZu3w//hqLMJ9fE0Oz2ar+aUElT2L7Vrwij2RS58lExXhHTWyq0SAKh0oLqTgII0GkmaEil9Wf2B9HkwBU1ZmJ6fzjZ5xuZKyxvND3N4sFphvZPB7t0gSFvGxMh9HYcC7AEIrPgc1K1VHBcWu5Wgeqk8jOdNvhHo/ABQvnWC6cmNT0vN8t6F+dlutjOl7ZTS77N/iPSU/woqqSIs9SElrDVz6+/AwiTRqlLQMPUXGbo5hrPKfkqZ/dCa6n5bWvAEDu7Seg8/d/l2IC167i0MNenSt2nHxy17WDDUwWvzmbhfKmdEssz
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: t87bNDG1EX1RgEWGLWiThSW92nFjBr6PoWRAs4DrxyKuutmGVInVsmCkez
kB/wC41vio3n5jy3L4HLmGrdvQb/dW3+skVacUH6+WgR1dJ0rKj1F+Sv9+
tNMKvJlUCpnI2bsMbRVFATIqXx8vnQpbzfIWfA2SGPFVIfvY3gpbYGe739
SPafoUOJUX67mHne83BLcQRhG8+ePaIj9bdIUxsu0Wi+DLBZPMJ/4SzbP6
agGJI3QF76xT/IIMFDLo6KYeRTlvPnh8FsoJCQjKgF8IK+vHuRaKgDM+es
gb3FlbZy+tWXKclTt2K4KD4lnt+DM/YuvMdVm4Nu3k2v2eqgcIcIWChK7g
ijC51oOcTGDvebQ0RGX9hWcoUc7WwJSCcNLFQ7gv4PQQDXpw1DLf0nh7Tz
ggDfR3mU78Mo9kwgE90e3O+/ePfJHUSdfC0cGS10vO3CySYfHwHnCiRHIv
eylSeQ6mTx8TbF4vXtMq0gdQghg/o/T3aKF33eTUQq5j92Z9EbnE5GgGHC
5b/NEQZeCoF7tMlhfi9jVfpNREr0vzp+ZqlWT35WotbK7f6s4GgHoi5Yj9
Zhyhn9X4amTMTnjpdS/imqk6tchXcTxN7LgquPk06gl4DkgBX6C7VlxYUD
bbRW8YguzrdnsMDm0+26Zf5A1FXIILS9PgseAKQN5sxhs7COolUhio1+WL
6DP7VQTzvHijuVFUx9GIkX6U6Sb9sYCFetA4Dj4NH17fe7pWB1V+fBnUXB
VCsspQzOWubvC0gC57hzHCAc2YTtt++krKvYrlt8TqTVOuBrO8SHBJhEBk
xasG/PWyjaSvr1iQxgCe66Y4Vgg/+2HKom5/sGCzakGnRRq8qQmJlNGPFd
qFeZcJS44COEML1fZjru0dwgMaMOGL8czyyknyOoDG4vqeuQZCp/YZQY8Z
uxS3KCOmNueJR3829H1j5imYV+2E32OtxjDln10dqmociQ31OpJs5mYBok
o0T4SfmMY+SFL0Iyot5cCewGn5ep9fapTiNR2Uvdff7LkCDdhej3uTIjZc
7ogMeVkJFJ+mjl95bDk2MaY4iPXjS2nE+9SuSBePjIRhXNC+MBykGzudiF
4ollWwhPdWMs2VXppwuGeJHGesB3hp6JGDDhOfDxFuhFJ16I5697y8D4oc
HVCDWY6GPVICIS1t4CTyRFx//19AS+WRfs+Dt4cHa3NiyhsLLmGj0oQ27p
3fgjX0XOp4LGzeqWygpVe71+mdCkJ6iWnz5sb4cdeHYN7LnXybjJrm6ckV
m7An
X-OriginatorOrg: sct-15-20-4734-24-msonline-outlook-c54b5.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AS4P189MB1968.EURP189.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 2f10d9a9-a022-4421-4fe9-08dc250c23eb
X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Feb 2024 23:02:05.1923 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PA4P189MB1263
X-Mailman-Approved-At: Sat, 03 Feb 2024 21:15:41 -0500
X-Content-Filtered-By: Mailman/MimeDel 2.1.39
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.39
Precedence: list
List-Id: General discussion list for the Python programming language
<python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>,
<mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <https://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>,
<mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <AS4P189MB1968CCB9C98B5E4184B8E1AECB412@AS4P189MB1968.EURP189.PROD.OUTLOOK.COM>
X-Mailman-Original-References: <AS4P189MB1968DE4D45E67E9C0078006FCB412@AS4P189MB1968.EURP189.PROD.OUTLOOK.COM>

by: gelukt gelukt - Sat, 3 Feb 2024 23:02 UTC

Dear,

While running a code, I get the error below:
What does this error mean? How can I fix this error?

C:\Users\brech\Desktop\Crypto\venv\Scripts\python.exe "C:/Users/brech/Desktop/Crypto/Project/aaa Arbitrage.py"
Traceback (most recent call last):
File "C:\Users\brech\Desktop\Crypto\Project\aaa Arbitrage.py", line 458, in <module>
methode()
File "C:\Users\brech\Desktop\Crypto\Project\aaa Arbitrage.py", line 49, in methode
wb.sheets[website]['A' + str(1+a)].value = inputString[startIndex:startIndex + 30000]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\main.py", line 2411, in value
conversion.write(data, self, self._options)
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\conversion\__init__.py", line 102, in write
pipeline(ctx)
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\conversion\framework.py", line 79, in __call__
stage(*args, **kwargs)
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\conversion\standard.py", line 75, in __call__
self._write_value(ctx.range, ctx.value, scalar)
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\conversion\standard.py", line 63, in _write_value
rng.raw_value = value
^^^^^^^^^^^^^
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\main.py", line 1973, in raw_value
self.impl.raw_value = data
^^^^^^^^^^^^^^^^^^^
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\_xlwindows.py", line 1209, in raw_value
self.xl.Value = data
^^^^^^^^^^^^^
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\xlwings\_xlwindows.py", line 161, in __setattr__
return setattr(self._inner, key, value)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\brech\Desktop\Crypto\venv\Lib\site-packages\win32com\client\__init__.py", line 597, in __setattr__
self._oleobj_.Invoke(*(args + (value,) + defArgs))
pywintypes.com_error: (-2147352567, 'Er is een uitzondering opgetreden.', (0, None, None, None, 0, -2147024882), None)

Process finished with exit code 1

Kind regards

Gelukt

I've noticed several design suggestions in your code.

devel / comp.lang.python / Error pd.set_option('display.width', 10000)

Subject	Author
Error pd.set_option('display.width', 10000)	gelukt gelukt