# Error: IDs for submission are not correct

**URL:** <https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620>\
**Category:** Hateful Memes\
**Created:** [June 9, 2020, 9:19pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620 "2020-06-09T21:19:58Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_faizan](https://avatars.discourse-cdn.com/v4/letter/_/e274bd/32.png) [@\_faizan](https://community.drivendata.org/u/_faizan)\
**Post date:** [June 9, 2020, 9:19pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/1 "2020-06-09T21:19:58Z")

</div>

![Screen Shot 2020-06-10 at 2.38.55 AM](https://yyz2.discourse-cdn.com/flex028/images/transparent.png)

My sub is in below format.

id,proba,label  
1284,0.6146393418312073,1  
1324,0.3828664720058441,0  
1325,0.3949085474014282,0  
1359,0.6110289692878723,1  
1364,0.42948755621910095,0  
1459,0.3576911985874176,0  
1627,0.5911972522735596,1  
1634,0.7979348301887512,1

All IDs match with the submission\_format.csv downloadable from the data page. and there are 1000 rows only overall. All labels are 0 or 1. All 0\<proba\<1 as well.

> su = pd.read\_csv(“submission\_format.csv”)  
> set(submission\_df.id) == set(su.id)

gives true

---

<div class="post-metadata">

**Author:** ![jetjodh](https://avatars.discourse-cdn.com/v4/letter/j/c37758/32.png) [@jetjodh](https://community.drivendata.org/u/jetjodh)\
**Post date:** [June 10, 2020, 9:53am UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/2 "2020-06-10T09:53:39Z")

</div>

Are you setting df.to\_csv(’…’,index=False)?

---

<div class="post-metadata">

**Author:** ![VictorCallejas](https://avatars.discourse-cdn.com/v4/letter/v/8491ac/32.png) [@VictorCallejas](https://community.drivendata.org/u/VictorCallejas)\
**Post date:** [June 10, 2020, 12:35pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/3 "2020-06-10T12:35:02Z")

</div>

You can also try setting the encoding

```
df.to_csv(file_path,index = False, header=True,sep=',',encoding='utf-8-sig') 

```

The submission file should be 1001 lines, counting the header.

---

<div class="post-metadata">

**Author:** ![isms](https://yyz2.discourse-cdn.com/flex028/user_avatar/community.drivendata.org/isms/32/9_2.png) [@isms](https://community.drivendata.org/u/isms)\
**Post date:** [June 12, 2020, 7:11pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/4 "2020-06-12T19:11:04Z")

</div>

Don’t forget the order of IDs matters.

---

<div class="post-metadata">

**Author:** ![pritish\_mishra](https://avatars.discourse-cdn.com/v4/letter/p/b77776/32.png) [@pritish\_mishra](https://community.drivendata.org/u/pritish_mishra)\
**Post date:** [June 14, 2020, 4:55am UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/5 "2020-06-14T04:55:09Z")

</div>

Yours IDs are not correct !! Your IDs should be from the train.jsonl !! All it will give Error…what you are getting so make prediction for the train.jsonl

---

<div class="post-metadata">

**Author:** ![Furcifer](https://avatars.discourse-cdn.com/v4/letter/f/dec6dc/32.png) [@Furcifer](https://community.drivendata.org/u/Furcifer)\
**Post date:** [June 19, 2020, 11:55pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/6 "2020-06-19T23:55:46Z")

</div>

try to replace the proba and labels inside submission\_format,csv, if the order is not right you’ll get this error

---

<div class="post-metadata">

**Author:** ![kaishengyao](https://avatars.discourse-cdn.com/v4/letter/k/3ec8ea/32.png) [@kaishengyao](https://community.drivendata.org/u/kaishengyao)\
**Post date:** [July 4, 2020, 4:34pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/7 "2020-07-04T16:34:13Z")

</div>

I also got the same error. My output is as follows and the error message is not really useful.  
Can anyone help on this?

id,proba,label  
68394,9.92727705595442e-11,0  
39867,6.556213211217354e-11,0  
15097,4.209503822494298e-05,0  
48916,4.6228714722929e-07,0  
84652,8.170956966591092e-11,0  
27496,1.0306415788363665e-05,0  
19230,6.211123282362507e-11,0  
48539,1.0358038732283248e-10,0  
97423,6.917780837056853e-08,0  
32451,6.979720978961268e-07,0  
38401,1.8754791759867905e-15,0  
92683,0.9999343156814575,1  
89105,0.13309748470783234,0  
47931,0.00013741306611336768,0

---

<div class="post-metadata">

**Author:** ![kaishengyao](https://avatars.discourse-cdn.com/v4/letter/k/3ec8ea/32.png) [@kaishengyao](https://community.drivendata.org/u/kaishengyao)\
**Post date:** [July 4, 2020, 6:17pm UTC](https://community.drivendata.org/t/error-ids-for-submission-are-not-correct/4620/8 "2020-07-04T18:17:34Z")

</div>

fixed the problem. indeed, order matters; have to be consistent to the order in test.jsonl.
