Making Sure DataFrames Have Same Columns in Pandas
Friday 26 January 2018Python 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
No comments