Good evening dear researchers,
I have a data set from KEGG database. it is in CSV format. I was trying to convert it into arff format using WEKA for further analysis.
It keeps giving me an error saying that it is not recognized by WEKA as a csv file. I searched for it, then I found that the file needs to be cleansed and put into a suitable data structure for it to be valid and ready to be analyzed.
unfortunately, I do not have the ability or the knowledge now to do that and I need it as soon as possible.
Can anyone help with the problem? thank you so much for your time.
kind regards.
attachments:
-data set csv file.
-error png clip.
A CSV file is nothing else than a plain text file in which information (records of data) is separated by commas. I opened your file, and all I can to say is:
– it is a text file, but it seems corrupted.
For example, the first line in your text file tells that there should be exactly 15 fields in each line...
See this simple example:
Year;Country;Distance;Product;Quantity
2001;UK;1001;A;1
2002;Cro;1002;B;2
2003;Cro;1003;C;3
2004;Ita;1004;D;4
2005;UK;1005;E;5
2006;Nor;1006;F;6
2007;Ita;1007;G;7
2008;Ita;1008;H;8
2009;UK;1009;I;9
2010;Cro;1010;J;10
2011;Hun;1011;K;11
2012;Nor;1012;L;12
2013;UK;1013;M;13
2014;Fra;1014;N;14
Dear Majd Horany ,
ata cleaning is the process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset. When combining multiple data sources, there are many opportunities for data to be duplicated or mislabeled. If data is incorrect, outcomes and algorithms are unreliable, even though they may look correct. There is no one absolute way to prescribe the exact steps in the data cleaning process because the processes will vary from dataset to dataset. But it is crucial to establish a template for your data cleaning process so you know you are doing it the right way every time.
https://www.tableau.com/learn/articles/what-is-data-cleaning
Regards,
Shafagat
looks like your file possesses 2583 lines (see relevant attachment), however, Excel shows 2715 lines ... apparently because lines 605 and 606 are quite (completely) screwed-up.
Furthermore, see the other attachment, there are 70236 brakes in your file - beginning from 2nd entry cell in 2nd line ... clean all these, and then it might be okay
- Badges
- Science topic