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.