Primary competition visual

Absa Corporate Client Activity Forecasting Challenge

Helping South Africa
$5 000 USD
Completed (~3 years ago)
Forecast
150 joined
46 active
Starti
Nov 01, 22
Closei
Nov 27, 22
Reveali
Nov 27, 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
Ferra Solutions

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.

13 Nov 2022, 17:27
Upvotes 0
User avatar
skaak
Ferra Solutions

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

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

Ok let me try to do that.

User avatar
skaak
Ferra Solutions

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.