1
$\begingroup$

I want to read an excel file using pandas read_excel method.

But it shows an out of range error for the date value . How can I fix this?.

df = pd.read_excel('/home/destiny2/Documents/elejio_data/Raipur/4 Star Hotels.xls')

error

return epoch + datetime.timedelta(days, seconds, 0, milliseconds)

OverflowError: date value out of range
$\endgroup$
  • $\begingroup$ Can You show some of the data int the excel sheet? $\endgroup$ – Joern Boegeholz Jan 25 '18 at 11:55
  • $\begingroup$ demo.xrosters.com/motorcycle_repaire.xlsx $\endgroup$ – Shiva Manhar Jan 25 '18 at 12:22
  • 1
    $\begingroup$ @shivaManhar would you put your entire code? what is epoch? $\endgroup$ – Media Jan 25 '18 at 16:13
  • $\begingroup$ I couldn't reproduce reported issue when parsing "motorcycle_repaire.xlsx"... $\endgroup$ – MaxU Jan 27 '18 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.