title: How do I import a CSV file that has columns with different date formats into Weka?
body: <p>Suppose I have a CSV file, where the first column of data is a date with format <code>yyyy-MM-dd HH:mm:ss</code>, while the second column is a date with format <code>yyyy-MM-dd HH:mm</code>. How can I import the CSV file into the Weka Explorer such that both attributes have the &quot;date&quot; type?</p>
  <p>I understand that in the Weka Explorer's &quot;Preprocess&quot; tab's &quot;Open file ...&quot; dialog, I can select &quot;Invoke options dialog&quot; to customize the data types of the imported attributes:</p>
  <p><a href="https://i.stack.imgur.com/hL1oS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hL1oS.png" alt="Weka file selection window" /></a></p>
  <p>However, the resulting configuration window only allows me to specify one <code>dateFormat</code>:</p>
  <p><a href="https://i.stack.imgur.com/jP002.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jP002.png" alt="Weka CSVLoader configuration window" /></a></p>
  <p>How can I solve the problem? Do I have to manually convert the CSV file into an ARFF file by editing the CSV file in a text editor?</p>