Friday 26 January 2018 at 10:36

Making Sure DataFrames Have Same Columns in Pandas

By Eric Antoine Scuccimarra

Python code to make sure two data frames have the same columns in the same order. I used this to make sure that two dataframes had the same dummy columns after using pd.get_dummies:

missing_cols = set( X1.columns ) - set( X2.columns )
for c in missing_cols:
    X2[c] = 0
X2 = X2[X1.columns]

Labels: coding, python, machine_learning


Login or Register to leave a comment..