Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"In short, _N is Richardian if, and only if, _N is not Richardian."

devel / comp.lang.python / Extracting dataframe column with multiple conditions on row values

SubjectAuthor
o Extracting dataframe column with multiple conditions on row valuesMahmood Naderan

1
Extracting dataframe column with multiple conditions on row values

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

  copy mid

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

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: nt_mahm...@yahoo.com (Mahmood Naderan)
Newsgroups: comp.lang.python
Subject: Extracting dataframe column with multiple conditions on row values
Date: Sat, 8 Jan 2022 00:07:49 +0100
Lines: 67
Message-ID: <mailman.124.1641596881.3079.python-list@python.org>
References: <92704ABE-B6C4-4F7C-BF40-1883C61A3964.ref@hxcore.ol>
<92704ABE-B6C4-4F7C-BF40-1883C61A3964@hxcore.ol>
Mime-Version: 1.0
Content-Type: text/plain; charset="utf-8"
X-Trace: news.uni-berlin.de NsApDjAr05DPzHFim9N/JgJrTPzy49mMJ6paMk0iQ32A==
Return-Path: <nt_mahmood@yahoo.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=yahoo.com header.i=@yahoo.com header.b=LXkZS8+F;
dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.015
X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'csv': 0.03; '(which':
0.04; '8bit%:26': 0.07; 'arrays': 0.07; 'code?': 0.09; 'then.':
0.09; 'column': 0.16; 'from:addr:nt_mahmood': 0.16;
'from:name:mahmood naderan': 0.16; 'iterate': 0.16; 'received:(vzm
hermes smtp server)': 0.16; 'skip:\xc2 50': 0.16;
'subject:dataframe': 0.16; 'subject:values': 0.16; 'to:addr
:python-list': 0.20; 'to:name:python-list@python.org': 0.24;
'function': 0.27; 'example,': 0.28; 'extract': 0.32; 'specified':
0.32; 'there': 0.33; 'file': 0.38; 'way': 0.38; 'two': 0.39;
'use': 0.39; '(with': 0.39; 'match': 0.40; 'want': 0.40; 'should':
0.40; 'search': 0.61; 'skip:k 10': 0.64; 'skip:r 20': 0.64;
'skip:r 40': 0.64; 'skip:v 30': 0.64; 'manually': 0.69;
'8bit%:33': 0.74; 'match.': 0.84; 'skip:k 30': 0.84; 'skip:d 30':
0.86
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
t=1641596874; bh=9lJjcO+wMVxdsgcVGiGKfJgPljjKPIqP7iwzG2aro7E=;
h=Date:From:Subject:To:References:From:Subject:Reply-To;
b=LXkZS8+FJjsZKglYqPeNU2YhBETzjmt54zq7c2fMzMMeNiZIUh2+FVsX7OrOMTk9JSVkLrZ/OoTJkFxnKWEgbEM7ol/mjJWHaNG6szvVnc8psMZt2ffSm4JAkv6xjCduDXcjM5eBF67DIqdwKrx0eXfwGU+pMmAYyOrJAdXsrNdbtlV6hKOG4wbTdscA76AwY7mVN/uTFW1gsGLg/hZatouc7aJeMONbwjektFzoNfdlvORHS05oVzSMZluw9srQkKrU0XOLHmFrsWVM4lxDsWwldlCjqmXFOKFKYmh8tWTjuZcrVl2CBQEesq8tUdKUVbFb/bEAd0iIENrsT5n2hA==
X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
t=1641596874; bh=tO+SWIshnSKnlb+oCTOmSWsO7hxBNaCYfY7mE1CuCF8=;
h=X-Sonic-MF:Date:From:Subject:To:From:Subject;
b=eEf0AJ1WNY68suZUPPBXUdOTq5sJRHENNSg8qGq3iGCG+2YcXrxijYO/auGlWtAykjrQEZvDYlBqRewD+m64kFVsySTI7JL2pjFLsItcivA21i8sq1bqQEoTrj9xdvpoP83NABOwTXMsvHbamvp7bE0eKu3MIouynp+s2z201MXVyzfEF+EjHEa666nFhvogTw9khtrJq0RXAur49NbN2rBzunVp1hQ0VI2LzuaUl1XzLhzo8dlMQ2ysGKsohPK89cYRqfaJQt7wyb3fCkTga4LJgqvR0LJGTxOqsSxzT4XwTymoahhh0Phb2burgId42tzsRGNDguOqnTmALByvwQ==
X-YMail-OSG: zVEorWkVM1nUrelkXGOH5OUORvdKDv_BlxGnFrch5spMPcMBILb3DivL3Al_17S
ZhdmbkNPKMFLbkU7AUGgllW1yJu9J1lCSZU8za3sBOrTJ8KfbaWT70YX3c5RhyGjGWSg1a4p4KFo
E.1NtPQdG.g.SA8NbQ4l3idCdOss21_g5SJtYtWRAa8.u2ViVZ4Ip9KCzLCSqZ5.R5Lr3_2Ia.1b
8WPioF51xVjdwJj8tH2vHxc7CFXWMr6IAwxPvPD1oAjzhyOV.34XRmxwpW5suYrTO4VyHTMQ6go9
BeZ_cuXWSmQ8VYecL8.XfAbU0PFKTIRtm0Nv5qxjBOyY_3N8V2aa9MfORGm9y2GZqnF97MsztlJr
pRIhrQVSrD1vaMwe1Dda4WGVYgXDVccHH4uE3wbFS6nGL6a7ts52lv6pr7CYSwvLGJpAaBxN.10O
jQ0wgvfAnm8JnUP42Lr.kEO9OKpRArlNH.U6hM3lhkaGerosuX5Qa7WOlJ3aXKz8700R1C1PumTW
A1OX_JkXTWtFGFwZlRSIOlRuk8yeFXfGMMgnKOCcP.lNHUORPLMKKX4TREJJyAQtLTfm3L.YeLDi
2eCinzopHqQEVffdlysaXiOCKwJqcwFkhO60ja5bHLFiCqAN3bCstQltCo1YFtxpEC4giD5_aSBL
1Ai5V8v8rruJfhaHeQs6P9XcAce4vZm8wf3MkUwgTdR5JwoUE5R3C_r9boU4EUWTyJR580F6Ajo.
yfPZquUvux4GFNM47GaZHbbSWehE0oXpAixBXTyetupsxB3ea03Qq5_OhQyjcY2uoEoFWbEW3idy
h4IjRA.80kw6dgg7AnGTHgy_BOH3BUcKYlWzUjZ4eee1S2XE_yfg5Y_gHSkc4HYY.51r_hAefhCC
eXUV09BiwAQLcepbHjJULUL1c_uoCNxJK2GzNab0Bfrk2uxsZK9tNYE_dFAYuX_5tP7z4iPunwjP
oHrD8vQGPAvhS1n6kNmjZZyoXujF7iXHQnL65E2._NqdOzK6hPa6PO67FgMBusH2MH44Q7fCGuK6
sueIym33WOyVJWvsUZAwHOrJuJpjSI2W26iL80xvT06aCF3ken6YmikkFKvTBplvOPoqw2.YXU6N
rpjDU.6ZhFL1ugmaAqfqgOmq7pHbf5wzq3ulRUh7kPwDr9CHIzJMxsScArX2EyJ4kp9GsW_thr9F
jROB5cW0o5KF5ywE_yIsIXmXzZ8VcGWIZBMwSA.QIii8d6IUc9XLBdhIa.X_PFrtuy6MCaChxnT3
h3L4N0EkD6hYqdm9wN8MxC9jX.jCGa1Acn5UhmZAWdCJVVVehSLjk1Xxht8kNF1oeFrHteRMkgcz
k3JjdzSHBTMoyp2vniudu2BEpWEs9aziIITMmrTDM4bZezM89aW21HVY2OLoNpIiJ9Seo7HqGPha
RhxeW9woyZgUWr6SCyyIg8sQv4RcV1MaMOL_UkMkjTwoiSTnkkW.gYvmxxR28KUBOFKxoTyZPavQ
lY.wo93KwsLPOok09rESdqTRWOU42I.1BwpmWAahqs70r0UA0UuJhdd6N13zENZMg5lZb0..zp3w
H6MFso8JoDM7EOSyDKHvSNklsmzAcAaPX8Qx_0QTd_oAF8v_v0h78gm0JlM9XT.xvLvtvqKzsW.9
q2Qq3haEFJMPbfRNVkJLKcfpKPBhFRCj66pqqlXj2D3jLiolbm5PV4s8GXuesPXIyl8R1PalcU51
p.f9PC.xT6p0i0acq5acUpJspyxnLQV5jCtvSyugyW3iKvaONMcbmvRoNlvjf48R8_SlSRurx9xz
xou_24DNV.IgQBSz2W2RjwfAAr3U.KH5O2qr_wDY32fAEE4Gh0fMQbP6y4oVOa8_SPjxd8uOJBjl
KEk4kWfRmGTiMkpriq.pFkZzoNfB9UjmWO_9qJdGX1WKo.0wqgWdkh8TXLmQz09fLYG_Mp_QV8y_
BthuEEePDgdB.3V.daroDOU.lud84SVZKtE5.rFBq.C42CYQbiLeJ5xaudIskLdjdoEQn5UQYz2i
MJibmT8zL3KE81mT_YYNkJRfE5lg6gIiscTfGF335SdTIdE89Dx.nO17iUPqPRpFJ_0To32Vvd7M
4X2Zsdef483v69OZbm9ll_CNSncSz6ZR.617LKzFSHsuaS_yiVjsIH6RvqblNgI_AbB5a3GgdeQM
y10cnVkp09KgGeef5UVMoHb1jnlxSNd3v2OjYII__qTGDlt5eX8FsH_0FxGQl4MGI2oCgl7F0ig5
OvSbtlqBBPU7q_g2BFqOq9DcmY7d3S5_jna6Mzdy7xtRs
X-Sonic-MF: <nt_mahmood@yahoo.com>
Thread-Topic: Extracting dataframe column with multiple conditions on row
values
X-Mailer: WebService/1.1.19551
mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo
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: <92704ABE-B6C4-4F7C-BF40-1883C61A3964@hxcore.ol>
X-Mailman-Original-References: <92704ABE-B6C4-4F7C-BF40-1883C61A3964.ref@hxcore.ol>
 by: Mahmood Naderan - Fri, 7 Jan 2022 23:07 UTC

Hi

I have a csv file like this

V0,V1,V2,V3

4,1,1,1

6,4,5,2

2,3,6,7

And I want to search two rows for a match and find the column. For
example, I want to search row[0] for 1 and row[1] for 5. The corresponding
column is V2 (which is the third column). Then I want to return the value
at row[2] and the found column. The result should be 6 then.

I can manually extract the specified rows (with index 0 and 1 which are
fixed) and manually iterate over them like arrays to find a match. Then I

key1 = 1

key2 = 5

row1 = df.iloc[0] # row=[4,1,1,1]

row2 = df.iloc[1] # row=[6,4,5,2]

for i in range(len(row1)):

if row1[i] == key1:

for j in range(len(row2)):

if row2[j] == key2:

res = df.iloc[:,j]

print(res) # 6

Is there any way to use built-in function for a more efficient code?

Regards,

Mahmood

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor