Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"Write date to csv"
Hello
I am exporting a data set that have dates in some attributes. My datasample is long enought (more than 70.000 examples) to write a excel file, so I considered to write a csv. However, Now I have the problem that I dont can't retrive all the values as a dates(Some values are writing as a text). Please, can anybody give me a tip.
Thanks.
I am exporting a data set that have dates in some attributes. My datasample is long enought (more than 70.000 examples) to write a excel file, so I considered to write a csv. However, Now I have the problem that I dont can't retrive all the values as a dates(Some values are writing as a text). Please, can anybody give me a tip.
Thanks.
Tagged:
0
Answers
with which tool are you trying to retrive the values from the CSV file? If you are using RapidMiner with Read CSV, please be sure to define the date column as type "date", and set the date format correctly if necessary.
Best, Marius
Well, I retrieved all the information with the "read database" operator. I set up a break point on this operator and the metadataview show me the types of the attributes in the right way, I mean, all the dates as a date data type. However, writing to csv give me problems. I saw that the problems sometimes happens when I have a date with a month menor to ten. For example, if I have the next date (10/25/2008) the csv file show me a date, but if I have a 1/28/2008 I get a text. I suppose the problem is related with the initial zero, but I haven't been able to solve this problem.
Thanks Marius
Best,
Marius
The first time, I opened the csv with excel 2010 and the got the error that I told you. Today i tried with the read csv operator of rapid miner and I got missing values from the attributes with dates.
Thanks for your replies Marius
However we're happy that you managed to get it right!
Best,
~Marius