remove underscores,apostrophes.

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

remove underscores,apostrophes.

polilappa
Hello,I am writing my paper and my i can't open my excel file in weka...I
know that before the file opens in weka I have to remove the underscores,
apostrophes etc. but I have no idea how can I do this. My dataset is:
Tweets.csv <https://weka.8497.n7.nabble.com/file/t6999/Tweets.csv>  
 
Can anyone please help me ?
Thanks a lot.




--
Sent from: https://weka.8497.n7.nabble.com/
_______________________________________________
Wekalist mailing list -- [hidden email]
Send posts to: To unsubscribe send an email to [hidden email]
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
Reply | Threaded
Open this post in threaded view
|

Re: remove underscores,apostrophes.

C. Peter
You could open your file in a text editor and use "search & replace" to
do that. Notepad++ is a good tool for that but any other text processing
tool should do.

Good luck,

Christian

Am 26.11.2019 um 13:23 schrieb polilappa:

> Hello,I am writing my paper and my i can't open my excel file in weka...I
> know that before the file opens in weka I have to remove the underscores,
> apostrophes etc. but I have no idea how can I do this. My dataset is:
> Tweets.csv <https://weka.8497.n7.nabble.com/file/t6999/Tweets.csv>  
>  
> Can anyone please help me ?
> Thanks a lot.
>
>
>
>
> --
> Sent from: https://weka.8497.n7.nabble.com/
> _______________________________________________
> Wekalist mailing list -- [hidden email]
> Send posts to: To unsubscribe send an email to [hidden email]
> 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

--
Dr.-Ing. Christian Peter
BioArtProducts GmbH (B.A.P.)
Kröpeliner Straße 54
18055 Rostock
Germany

http://www.bioartproducts.de/
Tel.: 0381/33738602


Registergericht Amtsgericht Rostock HRB 6178
Geschäftsführer: Thomas Zimmermann

Diese Information ist ausschließlich für die adressierte Person oder
Organisation bestimmt und könnte vertrauliches und/oder privilegiertes
Material enthalten. Personen oder Organisationen, für die diese
Information nicht bestimmt ist, ist es nicht gestattet, diese zu lesen,
erneut zu übertragen, zu verbreiten, anderweitig zu verwenden oder sich
durch sie veranlasst zu sehen, Maßnahmen irgendeiner Art zu ergreifen.
Sollten Sie diese Nachricht irrtümlich erhalten haben, bitten wir Sie,
sich mit dem Absender in Verbindung zu setzen und das Material von Ihrem
Computer zu löschen.
Sie haben uns gebeten, mit Ihnen über das Internet zu korrespondieren.
Unbeschadet dessen ist allein die von uns unterzeichnete schriftliche
Fassung verbindlich. Wir weisen darauf hin, dass derartige Nachrichten
mit und ohne Zutun von Dritten verloren, verändert oder verfälscht werden
können. Herkömmliche E-Mails sind nicht gegen den Zugriff von Dritten
geschützt und deswegen ist auch die Vertraulichkeit unter Umständen nicht
gewahrt. Wir haften deshalb nicht für die Unversehrtheit von E-Mails,
nachdem sie unseren Herrschaftsbereich verlassen haben und können Ihnen
hieraus entstandene Schäden nicht ersetzen. Sollte trotz der von uns
verwendeten Virus-Schutz-Programme durch die Zusendung von E-Mails ein
Virus in Ihre Systeme gelangen, haften wir nicht für eventuell hieraus
entstehende Schäden.
Datenschutzhinweis nach Art. 13, 14 DSGVO:
https://www.bioartproducts.de/home/datenschutz/

This message contains confidential information intended only for the
use of the addressee(s). If you are not the addressee, or the person
responsible for delivering it to the addressee, you are hereby notified
that reading, disseminating, distributing or copying this message or
otherwise making use of the information contained herein is strictly
prohibited. If you have received this message by mistake, please notify
us, by replying to the sender, and delete the original message
immediately thereafter.
_______________________________________________
Wekalist mailing list -- [hidden email]
Send posts to: To unsubscribe send an email to [hidden email]
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
Reply | Threaded
Open this post in threaded view
|

Re: remove underscores,apostrophes.

polilappa
thank you very much Christian for your answer...
and if i want to remove some commas and some other i want to keep?
do you know what can i do?



--
Sent from: https://weka.8497.n7.nabble.com/
_______________________________________________
Wekalist mailing list -- [hidden email]
Send posts to: To unsubscribe send an email to [hidden email]
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
Reply | Threaded
Open this post in threaded view
|

Re: remove underscores,apostrophes.

Peter Reutemann
In reply to this post by polilappa
> Hello,I am writing my paper and my i can't open my excel file in weka...I
> know that before the file opens in weka I have to remove the underscores,
> apostrophes etc. but I have no idea how can I do this. My dataset is:
> Tweets.csv <https://weka.8497.n7.nabble.com/file/t6999/Tweets.csv>

CSV is a very loose standard, unfortunately, and Weka's CSV handling
is straying even further from that.
The Spreadsheet file viewer in ADAMS can load your CSV file and then
also save it as ARFF file (eg using "Simple ARFF file" format).
Just download "adams-ml-app-snapshot" from the ADAMS homepage
(https://adams.cms.waikato.ac.nz/download/snapshot/). If you're not on
Linux, download the zip file, decompress it and start the application
using bin/start_gui.bat on Windows (bin/start_gui.sh on Mac).

Cheers, Peter
--
Peter Reutemann
Dept. of Computer Science
University of Waikato, NZ
+64 (7) 858-5174
http://www.cms.waikato.ac.nz/~fracpete/
http://www.data-mining.co.nz/
_______________________________________________
Wekalist mailing list -- [hidden email]
Send posts to: To unsubscribe send an email to [hidden email]
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