//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)