Error when Inserting CSV file values into a postgreSQL using psycopg2

[klllmmm]

https://www.postgresql.org/docs/9.5/stat...meric.html

Looks like you might want "bigint".

@nilamo Thank you very much for your so valuable comments. 'bigint' is what appropriate data type.
1.but how to handle empty or blank rows in ticket no field? What is the bestway. Do i need to handle at time reading the CSV by assigning some specific character if the field value is blank?
2. I would like make that the PostgreSQL table recognizes the departure date & passportExpDate as the "DATE" format. How to recognize '20180422' or similar values in passportExpDate as date format?