Note Python Quarto Demo

Code

import pandas as pd
import numpy as np

Code

df = pd.DataFrame()
size = 10000
df["age"] = np.random.randint(18, 90, size)
df["canal"] = np.random.choice(["EPS", "MESA", "AUTO CREDENCIAMENTO"], size)

Code

df.head()

	age	canal
0	74	AUTO CREDENCIAMENTO
1	38	MESA
2	64	EPS
3	67	EPS
4	63	AUTO CREDENCIAMENTO

Code

%%timeit
df["risco"] = "Aprovado"
df.loc[(df["age"] <= 23) | ((df["canal"] == "AUTO CREDENCIAMENTO") & (df["age"] <= 30)), "risco"] = "Reprovado"

1.23 ms ± 10.9 µs per loop (mean ± std. dev. of 7 runs, 1,000 loops each)

Code

df.query("risco == 'Reprovado'")

	age	canal	risco
7	28	AUTO CREDENCIAMENTO	Reprovado
19	30	AUTO CREDENCIAMENTO	Reprovado
21	18	AUTO CREDENCIAMENTO	Reprovado
22	30	AUTO CREDENCIAMENTO	Reprovado
41	20	MESA	Reprovado
...	...	...	...
9988	19	EPS	Reprovado
9991	20	AUTO CREDENCIAMENTO	Reprovado
9997	19	MESA	Reprovado
9998	26	AUTO CREDENCIAMENTO	Reprovado
9999	23	MESA	Reprovado

1155 rows × 3 columns