How can I find the missing index using python pandas?

Question

Example

Order_ID Name
1        Man
2        Boss
5        Don
7        Lil
9        Dom
10       Bob

Want to get an output as:

3 4 6 8 are the missing Order_ID 

Answer 1

Try using a list comprehension with range:

print([i for i in range(1, 10) if i not in df['Order_ID']])

Output:

[3, 4, 6, 8]