2
$\begingroup$

I have a column as month in my excel data set, when i load the data in the file, orange changes it to some numerical values.. Help! I want the Month as it is. Tried changing the value type as short or long date in excel too.

The orange loads Dec-16 as 42055.00 something.

|improve this question
$\endgroup$
  • 1
    $\begingroup$ Can you share (a relevant part of) a row of your data, verbatim? $\endgroup$ – K3---rnc Aug 7 '17 at 22:48
  • $\begingroup$ What program are you using? What is orange? Did you google this? $\endgroup$ – Landmaster Aug 8 '17 at 4:07
  • 1
    $\begingroup$ Note : The Orange Data Mining does not change data type if you import dataset in .csv file $\endgroup$ – Suave Bajaj Oct 28 '17 at 16:14
1
$\begingroup$

I have the same problem, I was told to avoid Excel as it did not conform to the ISO 8601 standard of 2016-12-27.

Then I transferred the data to Google Sheets as illustrated in Orange tutorial YouTube videos.

The dates were altered to match the required format however the results remain exactly the same.

enter image description here

enter image description here

enter image description here

|improve this answer
$\endgroup$
0
$\begingroup$

I have run into this issue when attempting to view temporal data on the scatterplot.

Perhaps Excel is outputting a DATEVALUE

I tried some Excel magic to create columns with Text conforming to the ISO 8601 standard -> This looked promising, but data in these columns could not be assigned as a datetime variable in orange.

In the end I got around the issue by adding columns using the "year" and "month" functions in Excel.

|improve this answer
$\endgroup$

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.