Primary competition visual

Absa Corporate Client Activity Forecasting Challenge

Helping South Africa
$5 000 USD
Completed (almost 4 years ago)
Forecast
156 joined
46 active
Starti
01 Nov 22
Closei
27 Nov 22
Reveali
27 Nov 22
Struggling to submit
Help Ā· 13 Nov 2022, 16:10 Ā· 6

@Zindi

I am struggling to submit, every time when I try to submit it gives me an error and I do not know what it means.Apolologies if this is trivial, its my first time competing on this platform.

The error: Missing entries for IDs User2504_Wed_3_0, User6554_Wed_3_6, User4267_Wed_3_0, User1758_Wed_3_18, User3074_Wed_3_0 and more

I tried checking for the suggested missing entries in my submission to see if they are realy missing but they appear when I check them.

Example:

Code;

filtered_df1 = test[test['UserID_Day_Month_Hour'] == "User2504_Wed_3_0"]

filtered_df1

Output:

UserID_Day_Month_Hour eventdatetime userid

15311User2504_Wed_3_0 2021-03-24 00:00:00 2504

Discussion 6 answers
User avatar
skaak

Perhaps show a little bit more code - how do you write your sub? I suspect you have to drop a few columns, you only retain the UserID_Day_Month_Hour and Target columns.

Upvotes 0
User avatar
skaak

... or better yet, don't use test when you create your sub, rather use the provided sample submission and just populate its target column.

Upvotes 0
User avatar

Thank you for your reply sir, it is much appreciated.

I did drop the extra columns

Submission.drop(["eventdatetime","userid"],axis=1,inplace=True)

Submission

Upvotes 0
User avatar
Upvotes 0
User avatar
skaak

Ok great, also, of course, remember to set index = False, e.g.

sub.to_csv ( fname, index = False )

but seems you've got everything covered. Just eyeball the file itself to be sure it looks the same as the sample sub.

Upvotes 1