That error suggests you have a row in your csv/excel file where one of the columns is empty.
You can fix that in the source file before loading it or do some processing afterwards to identify any missing values and either reject them or convert them as you need.