Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Are you perchance running on a 64-bit machine? -- Larry Wall in <199711102149.NAA16878@wall.org>


devel / comp.lang.python / RE: Problem with concatenating two dataframes

SubjectAuthor
o RE: Problem with concatenating two dataframesSchachner, Joseph

1
RE: Problem with concatenating two dataframes

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

  copy mid

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

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.szaf.org!fu-berlin.de!uni-berlin.de!not-for-mail
From: Joseph.S...@Teledyne.com (Schachner, Joseph)
Newsgroups: comp.lang.python
Subject: RE: Problem with concatenating two dataframes
Date: Mon, 8 Nov 2021 19:29:42 +0000
Lines: 21
Message-ID: <mailman.191.1636399857.23718.python-list@python.org>
References: <1670105892.779098.1636215375137.ref@mail.yahoo.com>
<1670105892.779098.1636215375137@mail.yahoo.com>
<737b7bd8-b718-2c4a-ee02-da077172bf4d@mrabarnett.plus.com>
<1170888568.656209.1636229533285@mail.yahoo.com>
<d1bf9117-9867-0606-d082-11e8fe3abf0a@mrabarnett.plus.com>
<1371877181.810127.1636236061880@mail.yahoo.com>
<BN8PR14MB28513EBD0792E10D54F19DBDF5919@BN8PR14MB2851.namprd14.prod.outlook.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
X-Trace: news.uni-berlin.de 5ovRVAZdbauD+26INYHhYw3eDLRalCIuRZFzhe9nQZpA==
Return-Path: <prvs=9390aeb7e=Joseph.Schachner@teledyne.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=none reason="no signature";
dkim-adsp=none (unprotected policy); dkim-atps=neutral
X-Spam-Status: OK 0.008
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'argument': 0.04; 'joseph':
0.05; 'python.': 0.08; 'pandas': 0.09;
'received:namprd14.prod.outlook.com': 0.09; 'skip:6 20': 0.09;
'skip:[ 20': 0.09; 'subject:two': 0.09; '8bit%:47': 0.16;
'dataframes': 0.16; 'defaults': 0.16; 'dictionary.': 0.16;
'mahmood': 0.16; 'opinion,': 0.16; 'pandas.': 0.16; 'skip:8 20':
0.16; 'problem': 0.16; 'python': 0.16; 'instead': 0.17; 'to:addr
:python-list': 0.20; 'code': 0.23; "i'd": 0.24; 'to:name:python-
list@python.org': 0.24; 'skip:- 10': 0.25; 'python,': 0.25;
'sensitive': 0.26; 'fact': 0.28; "doesn't": 0.32; 'but': 0.32;
"i'll": 0.33; 'header:In-Reply-To:1': 0.34; 'people': 0.36;
'missing': 0.37; "skip:' 10": 0.37; 'could': 0.38; 'two': 0.39;
'use': 0.39; 'received:unknown': 0.39; "couldn't": 0.40; 'try':
0.40; 'from:': 0.62; 'to:': 0.62; 'load': 0.62; 'here': 0.62;
're:': 0.64; 'skip:1 20': 0.67; 'losing': 0.69; '2021': 0.71;
'business': 0.77; 'sent:': 0.78; '8bit%:67': 0.81; 'saturday,':
0.84; 'shocked': 0.93
IronPort-Data: A9a23:eKSj8qAqr9o/iBVW/7vhw5YqxClBgxIJ4kV8jS/XYbTApGkk3zdUz
2pMDzqBOfrfYGP8KN1/YY7g8kpTvcLczYNrTANkpHpgcS52pJueD7x1DG+pZ3nOdpWbFCqLz
O1HMoOcdJhsFhcwgj/3b9ANeFEljfngqoLUUbKCYmYoLeNdYH9JZShLwobVv6Yz6TSHK1LU0
T/Ni52HULOV82Yc3rU8sv/rRLtH5ZweiRtA1rAMTakjUGz2zhH5OKkiyZSZcxMUdGX28tmSH
I4vxJnhlo/QEoxE5tmNyt4XeWVTKlLe0JTnZtO7lMFOjzAbzhHe3JrXO9JHaBpoyCXZsOp99
8dKrsGbFykzOpzlzbF1vxlwS0mSPIV7w+WCH0CaiuPW6mf2KyKq3/l/Sl07OYAU6+B6R2pJ8
JT0KhhUNUjF2rrwmu7mDLI07iggBJCD0Ic3mHZ7wCnZS80tQZnIQ6PH//dE0TM9itFIELDVY
M9xhT9HMEmbPUQSYQZ/5JQWscfzn0f5TB1htHHE+7dnxmnW6QlLz+24WDbSUpnQLSlPpW6At
37G+GK8BhABKPSH2CaF9XTqgfXA9R4XQ6pLT+X+q6Ys2gHOgDdLYPELaWaGTTCCohbWc7pix
4Y8o0LCcYBaGJSXc+TA
IronPort-HdrOrdr: A9a23:GtM2u6uq72pP8NhEsE907zt17skCxoMji2hC6mlwRA09TyXGra
+TdaUguSMc1gx9ZJh5o6H6BEDyewKnyXcT2/hcAV7CZniqhILGFvAE0WKP+V3d8mjFh5ZgPM
RbAudD4b/LfD5HZK/BiWHSebhA/DDEytHQuQ639QY1cegAUdAD0+4NMHf+LqQAfngiOXNWLu
v+2uN34x6bPVgHZMWyAXcIG8LZocfQqZ7gaRkaQzY69Qinl1qTmfDHOind+i1bfyJEwL8k/2
SAuRf+/L+fv/ayzQKZ/3PP7q5RhMDqxrJ4dY2xY4kuW3XRYzSTFcZcso65zXUISSaUmRIXee
z30lQd1gJImjTsly+O0F3QMkLboUsTAjfZuCOlaD3Y0JTErXsBerR8bY41SGqn12Mw+N57y6
5FxGSfqt5eCg7Bhj3045zSWwhtjVfcmwtrrQc/tQ0obWIlUs4ZkWXfxjImLL4QWCbhrIw3Gu
hnC8/RoP5QbFOBdnjc+m1i2salUHg/FgqPBhFqgL3e7xFG2HRii0cIzs0WmXkNsJo7Vplf/u
zBdqBljqtHQMMaZb90QO0BXcy0AGrQRg+kChPYHX33UKUcf37doZ/+57s4oOmsZZwT1ZM33I
/MVVtJ3FRCDH4Gyff+qKGj3iq9MFlVbA6dv/22vaIJy4EUbICbQhG+dA==
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
b=ZFc5oHzR0jFl2e60tQTo82kSqdu1uA8h5BlUPAq5FGxVFQledYW27sFDDxq96+tm+I7GP5hBN6zORipQk5Zpfcjy8rFfi/LvjwnlycqRnbZUlEMnCGIvyXoiMsKrGJgRNpQp2GPDUdQvA+/R33nRBrHKBusjCh0RUvMMNliaDzE9u4ZGiBJFQHakC8oc+FYOlcHZfgAolkxg85aH9Xas9Zcnp5uJPM4VXY7YCby9m1OahMChwfp6t8WTvh9rWLnFkFpoHuAVr1bq1jAGjsEtsyoC7R/Mziiw7hsMW2xu3mFtNF1XjdHxuSAVTggwDBsYAa/e7zYjfjJckr4qssMBYQ==
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=GMZm+Dm0F0bgn8H+fKSKOumNs8vWz9whIiPlxp9qx/o=;
b=UmpVNEY8A58+IPCKbfwIbfWJJNuH/w1NcecZK/XlRLb5iRFzqqyqj1OTb2oieH3lZmav5I55b6rhD7z4eWMCRj7wGsxSAg378DVASsEK1x1aacInNj9zwZLs5Fdv4qUMGlQ30bnmAIXxzLdoyecUcdK8KGHchPepHiv65v9hzbnFowU/phuSlvJPjC1FnMSUyGauEPPUDQaRemO9ToVbHjaWeMpGxCk9bLoYjTbFSokAu0Zb8CxE1z2astPGZvp2bnAc51yFxdGurYLd1P3h/FaoR73tiUcpDHUxUqB2TMER97TiQfOtjU6rUNt6muIvBKLt/AnNUn3P8ZUsfkQ9RA==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass
smtp.mailfrom=teledyne.com; dmarc=pass action=none header.from=teledyne.com;
dkim=pass header.d=teledyne.com; arc=none
Thread-Topic: Problem with concatenating two dataframes
Thread-Index: AQHX0/lrB5gz9CD0qkKK2gmbBGimAav6BUew
In-Reply-To: <1371877181.810127.1636236061880@mail.yahoo.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
msip_labels: MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_Enabled=true;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_SetDate=2021-11-08T19:29:41Z;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_Method=Standard;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_Name=Company Sensitive;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_SiteId=e324592a-2653-45c7-9bfc-597c36917127;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_ActionId=51ac9e33-38af-4ddc-b28f-30255598c365;
MSIP_Label_0d178f3f-9d62-4d87-b8af-200399509a39_ContentBits=2
authentication-results: python.org; dkim=none (message not signed)
header.d=none;python.org; dmarc=none action=none header.from=Teledyne.com;
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: 1c097e13-23da-4010-93ff-08d9a2ee1d43
x-ms-traffictypediagnostic: BN7PR14MB2290:
x-microsoft-antispam-prvs: <BN7PR14MB22900126617A85F5530B9D95F5919@BN7PR14MB2290.namprd14.prod.outlook.com>
x-ms-oob-tlc-oobclassifiers: OLM:7691;
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: urpdbPF1s783xKUXcrRVEOKqH+xyKhaa4hcEZG6UO94TymD+i9JvDXMuQ63vLkCgmgp7CcFmXlPBbMbEZkPKrDS7t84uiYIdm3Y3shY4JAIAOjBHiDUyfsY95Q7CXA0yl1sHscC5LG2xll5KzdiU7ydV00xgzPlbZYTvaZ0OKpNPgUoQEngWrFEvTsyqr5qs4ESdkgoOwT0nR1zMrcpmh0sLd72eXJfJ8Wbbryx5Mb+7+v2qnC+KhqFF4sjM4Id2/C1FlnrmOuRAyndQ1fVsjJD5fAZXAiy7SD49Ft/cJVFmZF4cGT2xzvsH20oofkj76L22xWadpq9uDuV2ums0Y5jt1jjklUKv/Kzbv5K7C11Hqz9LM9U5kZboiThRr5ePnkf7FBtQc4kEjsLy3WxQztoX1wQ3wPpX8Pb0Ar9OUy/U3iWeTjNyQ+JCRCnKawFT0T9CFFRAswds/ilk6wrTaqbdmeu+W0CtTSWmZWpff98hYrc8Ib8h5KXC20OjLjbAiWZh4GWNqzw1qIIGd4LHmMwK36PN6jQHuo4XVEzJ/rxe6UlYVLPNP1yv9y4Nh8aQGPZdcDUU3lEtWL1hSluRjqioly4u0UkffQn+KKyPU3w37vScqY2XqublPjfJ4bDL9SNurfvFw6bp+hZfYZVPZPch4AZDfW77a+dI3EyhLM/UcC200VsfforXpCEfIqjxaP5dnAtezNpwtQPsCBhWlQ==
x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:;
IPV:NLI; SFV:NSPM; H:BN8PR14MB2851.namprd14.prod.outlook.com; PTR:; CAT:NONE;
SFS:(366004)(8936002)(76116006)(4744005)(33656002)(52536014)(55016002)(66476007)(186003)(86362001)(508600001)(122000001)(83380400001)(26005)(9686003)(6506007)(6916009)(66446008)(66556008)(53546011)(64756008)(38100700002)(5660300002)(7696005)(8676002)(71200400001)(66946007)(316002)(38070700005)(2906002);
DIR:OUT; SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: jC4KN85gU79b62suobrrND5Y5f5qxgJkI2I18vSk+tYOb
a3mPlSpadB/OCcOR0UXLYV3Sy07X4bQpir/I4863UVkEY
VVf1l1ElcwHMSZC9xrZMZWA9WwdGvs3YVdA2UDHjoSNCn
utOSaVzhS11XBuZ4EJU+9GTmXk/Z8slzEBu3BPNesL2Mj
I0gqVFOOZ/CmL8yh5tKeKP+WwV6gOA3xZ0SnhrC2wYTIg
h1xMK+t1R7cgkxgO2LcvxIN8YPlgxI1fEajGJwup8usHk
cu2vaU+4yu5on0O1X+EagSub92Dd/Dc4+/fyRQDBmRF4u
3rJxPZwpw5SfKV3YI2uIgq5x5sYIy4Da2/XIZhSSy8miD
k5Zx4O9RE7HAxjwgH/kRBShoXXi6h9I8+ONpksSgBDOFR
EweXh+cZsLzBGyclg9NuYAL3h4H9YkB+w6S6q3Qlka8RM
v6y4iv9dV7MHIGAjA/u51lrILt+EtIHwTZtc+Rc2OMTks
bBB8JXvECY0F/IJEaTa36iBzV2zw9W+vlcAKYovVxVsHx
kneH1lN+P3TI5LSFm152znwAvZlrHfMvxK6q1aEhB6Rxy
JhoUk6olgLf/UZOECuk5MYa2Hn0RjLIF70CoFQL9Gx9rA
jNk3/X2WSbde+BG4xMmmM95YzC9rHrWJq8syE+zO/tZJg
QLlZPJ0LAz2sl4E8vWZwAns8n2+MOLer83ny8XJLtMTxE
GyuuGaFu4knQsyb4lUuXtfGNW8SvZUi5KwMl+9ZfklAxq
GbfWbtMRwr12uXZxIYLpp6z7QZebGfHT0tPFTfdr6/zgT
P0NEaVqyUUgSh6CATyxoleBult5jCl3t86M5hvG5NvqOP
onouFkzfxNnm47O+5x6LSUkayA9sJ6r/4igNIo7rKw19O
cWZsJ7nTUiyeL17+hpFOgVrmgdb6Tx8RhTIWM/OId3sKO
aEgXAAOFUtIGDwrIfbtiUf2elrlSm6YzI4YIldOL5aOmt
B3ZmHnG+gq7cOGbG0b0dMdKSszGrxypE7RoHjDwJjhtIk
n2m6853a0zitaAhG2YxEe+MMb0NsHIOXdvUFwZ8XgfRvV
mR9MO2XE98Q4qwA7CeSe8AA9VQbHAhmGTn7mqT4PD7mp8
Oh/+0Z2OGvaTujHH0y5pv7kndN2CRV7wWQYqGdBA47iz1
8UT9vC+goo0GxKaXAdvOwGkkMDT3W4UHS/paSi8zgRfaa
1ZDTxx0DfNS0h7B0JufhLtUtuTG2DT9QayxtWMEtnnu4I
xOW0Mu8B5AhF7x1XNOGqSNpS8cgbTopaKfRREBXoaRiJ2
aSn203vVX8WxgoZ0OxT6TjvRZ7Kmhk7/JXMLCZ89AGOO8
yyA7T0H2uRacW4gyJKq0BkEAMuB8y5HZ9e3fIvy+ywS+S
bzl7r9v/FfiN1zGWfPMT+0We4UqEYMY9NNrcty7R8P7Vh
l3pyVW2DM+daqpWAe4+lilB6slKsT93PwmLHxgFGc/y3u
zsfJHaq0opWah2MlF3b+LO+D6WotvwUvSWYKMnmB9N2+l
joZy2fjYfY3dfH6JR7Trb3zgvGTXy6ypkpo/ayfV83ETf
otiVjP6rRAsuw/YP2r6aOR2ten+zhaP6TL0mRs/BNkDLr
HSaph3ukV9W24FDTWfBvDh1zn2zNiYibyriVC+sBJT4Xz
XM9AxlMtk/euNiPZWZ55A==
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BN8PR14MB2851.namprd14.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 1c097e13-23da-4010-93ff-08d9a2ee1d43
X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Nov 2021 19:29:42.4930 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: e324592a-2653-45c7-9bfc-597c36917127
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: CBS9n9uDD3NHga57m9ImOt9PvmDI83A/AsBD8MNSOBsoJDjFSnsL5Mxt29A+LSYWnRJnAsw/3ayO344mw50QRoIsbbB+8bn2s/R0EygVW1c=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN7PR14MB2290
X-OriginatorOrg: Teledyne.com
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.35
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: <BN8PR14MB28513EBD0792E10D54F19DBDF5919@BN8PR14MB2851.namprd14.prod.outlook.com>
X-Mailman-Original-References: <1670105892.779098.1636215375137.ref@mail.yahoo.com>
<1670105892.779098.1636215375137@mail.yahoo.com>
<737b7bd8-b718-2c4a-ee02-da077172bf4d@mrabarnett.plus.com>
<1170888568.656209.1636229533285@mail.yahoo.com>
<d1bf9117-9867-0606-d082-11e8fe3abf0a@mrabarnett.plus.com>
<1371877181.810127.1636236061880@mail.yahoo.com>
 by: Schachner, Joseph - Mon, 8 Nov 2021 19:29 UTC

The problem I see here is use of Pandas. I know I have he losing opinion, but people who use Python to load Panadas and then only use Pandas are missing out on the functionality of Python.
I'll bet you could code combining this data in pure Python, into one dictionary. In fact I'd be shocked if you couldn't do it.
---- Joseph S.

Teledyne Confidential; Commercially Sensitive Business Data
-----Original Message-----
From: Mahmood Naderan <nt_mahmood@yahoo.com>
Sent: Saturday, November 6, 2021 6:01 PM
To: python-list@python.org; MRAB <python@mrabarnett.plus.com>
Subject: Re: Problem with concatenating two dataframes
>The second argument of pd.concat is 'axis', which defaults to 0. Try
>using 1 instead of 0.

Unfortunately, that doesn't help...

dict[name] = pd.concat( [dict[name],values], axis=1 )

{'dummy':     Value
M1      0
M2      0
M3      0, 'K1':    Value  Value
0   10.0    NaN
1    5.0    NaN
2   10.0    NaN
6    NaN    2.0
7    NaN    2.0
8    NaN    2.0, 'K2':    Value
3     20
4     10
5     15}

Regards,
Mahmood

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor