Cannot convert an object of type DataValues.DataValue{Any} to an object of type DateTime #47

Activity

1. IanButterworth commented on Aug 11, 2018

   

   IanButterworth

   on Aug 11, 2018

   Author

   More actions

   Here's a concise example for testing:

   using DataFrames, Dates, ExcelFiles
   filename = "test.xlsx"
   df = DataFrame(load(filename, string("Sheet1!A1:E25"),header=true))
   df[:DateTime] = convert(Vector{Union{DateTime, Missing}},df[:DateTime])
   

   And source excel file: https://www.dropbox.com/s/cwq5m6m9179s57a/test.xlsx?dl=1
2. IanButterworth commented on Aug 11, 2018

   

   IanButterworth

   on Aug 11, 2018

   Author

   More actions

   I've written a temporary function to fix the columns:

   function fixcolumn(col,T)
       arr = Vector{Union{Missing, T}}(0)
       for x in col
           try
               push!(arr,x.value)
           catch
               push!(arr,missing)
           end
       end
       return arr
   end
   

   For instance:

   df[:DateTime] = fixcolumn(df[:DateTime],DateTime)