Resolved: Return 2 values in 2 columns

Question:

Do you know if it was possible to return 2 values in 2 columns with one def?
I have this two def:

def codeAcro (row):
    NOVA, Concordance = row['Code'], row['Concordance']
    if pd.isna(Concordance) == True:
        return None
    else:
        return Concordance

ListeCodeNova['Acronyme'] = ListeCodeNova[['Concordance','Code']].apply(codeAcro, axis=1)

def codeNOVA (row):
    NOVA, Concordance = row['Code'], row['Concordance']
    if pd.isna(Concordance) == True:
        return None
    else:
        return NOVA

ListeCodeNova['Concordance'] = ListeCodeNova[['Concordance','Code']].apply(codeNOVA, axis=1)

And i want to know if it was possible to simplify in just one def.

Answer:

For performance more better to avoid the apply method (which is called for every row), and use boolean indexing instead:

import pandas as pd
import numpy as np

df = pd.DataFrame({'Concordance':[1, np.nan, 2], 'Code':[10, 11,12]})
mask = df.Concordance.notna()
df['Acronyme'] = np.where(mask, df.Concordance, None)
df['Concordance'] = np.where(mask, df.Code, None)

If you have better answer, please add a comment about this, thank you!

Resolved: Return 2 values in 2 columns

Resolved: How can I write CSS selector(s) that apply to table rows for all td elements on that row after a td with a certain class?

Resolved: How do I use SetWindowText with Unicode in Win32 using PowerShell?

Resolved: Shopware 400 Status Error “This value is too long. It should have 255 character or less.” When I Try Updating Database Table

Leave A Reply