5980329d949dd0d9764357a70c36da44645ce503,google_analytics/xgb_predict_spending.py,,,#,14

Before Change

final_by_ind = final_by_ind.add_suffix("_sum").reset_index()

final_by_ind["PredictedLogRevenue"] = np.log1p(final_by_ind["train_yht_sum"])

//submit
final_by_ind.to_csv("cam_pred1.csv")

After Change

final_by_ind = final_by_ind.reset_index()

//merge the predictions with the sample sub
submission = submission.merge(final_by_ind, on = "fullVisitorId", how = "left")
//fill nas and move to right column name
submission["PredictedLogRevenue"] = submission["test_pred"].fillna(0.0)
submission = submission.drop(["test_pred"], axis = 1)

//submit the output
submission.to_csv("cam_lightgbm_pred2.csv", index = False)
/Ǘ.78 first go

Instances