Re: Can we copy residuals of predictions into excel sheet?
Peter Reutemann <[email protected]>
| Newsgroups | gmane.comp.ai.weka |
|---|---|
| Message-ID | <CAHoQ12KwtQjMTbmc_Ovuc8zM4fSkdF2e+w4ZORBSRYDdUALCmg@mail.gmail.com> |
> When we perform the prediction in the classify tab, we get the residuals (difference between predicted and actual values).. I want to perform the statistical tests based on these residuals and for that, I have to export these values into excel (It is difficult to manually type them). > > My question is can we directly export these values into excel ? Because I am unable to copy them and paste into the excel sheet. I presume you are referring to the "error" column in the predictions? In the "More options" dialog in the Explorer, instead of using "PlainText" for "Output predictions", select "CSV". Open the properties for the CSV output and select an appropriate output file. The generated CSV file you should be able to import in Excel (personally, I prefer LibreOffice's import dialog for CSV files). Cheers, Peter -- Peter Reutemann Dept. of Computer Science University of Waikato, NZ +64 (7) 577-5304 http://www.cms.waikato.ac.nz/~fracpete/ http://www.data-mining.co.nz/ _______________________________________________ Wekalist mailing list -- [email protected] Send posts to [email protected] To unsubscribe send an email to [email protected] To subscribe, unsubscribe, etc., visit https://list.waikato.ac.nz/postorius/lists/wekalist.list.waikato.ac.nz List etiquette: http://www.cs.waikato.ac.nz/~ml/weka/mailinglist_etiquette.html