← retour aux snippets

pandas: merge suffixes

Résoudre conflits de colonnes jointes via suffixes.

python pandas #pandas#merge#suffixes

objectif

Résoudre conflits de colonnes jointes via suffixes.

code minimal

import pandas as pd
a = pd.DataFrame({"id":[1,2], "x":[10,20]})
b = pd.DataFrame({"id":[1,2], "x":[100,200]})
m = a.merge(b, on="id", suffixes=("_left","_right"))
print("x_left" in m.columns and "x_right" in m.columns)

utilisation

import pandas as pd
a = pd.DataFrame({"id":[1], "v":[1]})
b = pd.DataFrame({"id":[1], "v":[2]})
print(a.merge(b, on="id", suffixes=("","_b")).columns.tolist())

variante(s) utile(s)

import pandas as pd
print(pd.concat([a.add_suffix("_a"), b.add_suffix("_b")], axis=1) is not None)

notes

  • Toujours spécifier des suffixes lisibles.