Remove duplicate rows in CSV file
20 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
mohammad Alsajri
am 23 Jul. 2019
Kommentiert: mohammad Alsajri
am 25 Jul. 2019
hello dear mathworkers,
I have a dataset consist of approximatlly 4 millions records, and i want to remove the duplicated rows or records, can any one help me with the way, i am using matlab 2018a . thanks in advance
7 Kommentare
Akzeptierte Antwort
Alex Mcaulley
am 23 Jul. 2019
Since all is numeric data, you can use:
data = xlsread('kdd.xlsx');
datanew = unique(data,'rows');
2 Kommentare
Shameer Parmar
am 23 Jul. 2019
This is not working, because non of data is similar.. I dont find duplicate entries in this sheet provided by Mohammad Alsajri..
using your command, the 'data' and 'datanew' both are getting exact same..
Alex Mcaulley
am 23 Jul. 2019
This code works!
I guess the excel provided by Mohammad is just a small portion of the dataset (4 million of rows).
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Language Fundamentals finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!