queryverse / queryverse/ExcelFiles.jl
Cannot convert from DataValues.DataValue{Any} to DateTime
Open
Nobody has claimed this yet.
- Dominant language
- Julia
- Stars
- 43
- Forks
- 11
- Avg merge
- 1d 1h
- Merged PRs (30d)
- 3
Description
I'm trying to convert a row in an imported excel file into an array of DateTime allowing missing values.
using ExcelFiles, DataFrames
f_labs = "file.xlsx"
df = DataFrame(load(filename, "4!C1:X6"),header=false))
datetimearray = convert(Array{Union{Missings.Missing,DateTime}},df[2,:])
MethodError: Cannot `convert` an object of type DataValues.DataValue{Any} to an object of type DateTime
What's the correct way to do this?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the example with ExcelFiles and DataFrames, focusing on the value returned by load(filename, "4!C1:X6") and the contents of df[2,:]. Inspect how the imported DataValue{Any} values are expected to convert to DateTime or missing. Done means the issue has a verified conversion path or clearly documents the correct way to obtain an array of Union{Missing,DateTime}.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- julia
- Domain
- data
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100