Sasol Customer Retention Recruitment Competition
'%3e%3cpath fill='%23001489' d='M0 0v6h9V0z'/%3e%3cpath fill='%23e03c31' d='M0 0v3h9V0z'/%3e%3cg stroke='%23fff' stroke-width='2'%3e%3cpath id='d' d='m0 0 4.5 3L0 6m4.5-3H9'/%3e%3cuse xlink:href='%23b' stroke='%23ffb81c' clip-path='url(%23c)'/%3e%3c/g%3e%3cuse xlink:href='%23d' fill='none' stroke='%23007749' stroke-width='1.2'/%3e%3c/g%3e%3c/svg%3e)
Helping South Africa
R10 000 ZAR
Challenge completed ~2 years ago
Prediction
Job Opportunity
253 joined
56 active
Start
Oct 05, 23
Close
Nov 26, 23
Reveal
Nov 26, 23
'/%3e%3c/defs%3e%3cpath fill='%23012169' d='M0 0h10080v5040H0z'/%3e%3cpath stroke='%23fff' stroke-width='.6' d='m0 0 6 3m0-3L0 3' clip-path='url(%23b)' transform='scale(840)'/%3e%3cpath stroke='%23e4002b' stroke-width='.4' d='m0 0 6 3m0-3L0 3' clip-path='url(%23c)' transform='scale(840)'/%3e%3cpath stroke='%23fff' stroke-width='840' d='M2520 0v2520M0 1260h5040'/%3e%3cpath stroke='%23e4002b' stroke-width='504' d='M2520 0v2520M0 1260h5040'/%3e%3cg fill='%23fff'%3e%3cuse xlink:href='%23d' x='2520' y='3780'/%3e%3cuse xlink:href='%23a' x='7560' y='4200'/%3e%3cuse xlink:href='%23a' x='6300' y='2205'/%3e%3cuse xlink:href='%23a' x='7560' y='840'/%3e%3cuse xlink:href='%23a' x='8680' y='1869'/%3e%3cuse xlink:href='%23e' x='8064' y='2730'/%3e%3c/g%3e%3c/svg%3e){kind=small}
Missing ID entries
Help · 17 Oct 2023, 06:46 · 4
Hi everyone, I am having trouble with submitting my results. I have used index = False but that has not worked. The following below is my code with how I evaluated and saved my predictions to the submission file. Your help will be grealty appreciated:
test_df = test[X.columns]
preds = model.predict(test_df)
sub = pd.DataFrame({'ID': test.ID, 'Target': preds})
sub.to_csv('LightgbmBayesianOptimizedSubmission.csv', index = False)
I had the same problem when using lightgbm which you are using as I see, make sure that the predictions are integers not floats, i.e [1, 0] not [1.0, 0.0], this was my problem as least.
preds = [int(i) for i in preds]
I tried using the preds = [int(i) for i in preds]. it still came up with missing ID entries. The following below is my code with the float to integer function:
XTest = test.drop('ID', axis=1)
y_preds = model.predict(XTest)
y_preds = [int(i) for i in y_preds]
sub = pd.DataFrame({'ID': test.ID, 'Target': y_preds})
sub.to_csv('LGBMClassifierSubmission.csv', index = False)
this is wierd, did you look up for the csv file in your local machine? sometimes due to an error in the preprocessing you have done somethings doesn't go as expected.
try using
test['Target']=preds
sub = .........