Options

Read CSV puzzle

User51984User51984 Member Posts: 7 Contributor II
in Help
Hello,

I have a simple .csv file with 2 columns and 1,000 examples of Mackey-Glass, the top of which looks like this:
Date,y
2018-01-01,103.88
2018-01-02,103.72
2018-01-03,103.58
It reads in properly, but the meta tells me it has 0 examples and the operator that follows Filter Examples Range drops an error. Any ideas?

Thanks,
Ivan

Answers

  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    Hi @User51984,
    can you share your csv file?

    best, 

    Cesar
  • Options
    User51984User51984 Member Posts: 7 Contributor II
    Absolutely, Cesar. Here it is. It is saved from a simple python script, df.to_csv. Notepad++ do not show any special symbols. So weird... and time wasteful. :(

    Thanks for looking into this! 
    Ivan
  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    Hi again @User51984,
    I have opened the file without any problem and the filter operator detects the attributes correctly. 
    Please check that you have enabled the Synchronise metadata with real data option in the Process top menu.

    best, 
    Cesar
  • Options
    User51984User51984 Member Posts: 7 Contributor II
    Hi Cesar,
    It very kind of you trying to help, but it is not it, and I have no idea what's wrong.Here is the latest screenshot:
Sign In or Register to comment.