Jan. 26, 2018, midnight

Making Sure DataFrames Have Same Columns in Pandas

By : Eric A. 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

There are no comments for this article.

Login or register to comment