how to extract subset from dataset?

Welcome

I have a dataset of type "CSV" named "NF" in which there is a column of type Categorecal named "Attack" and it has five categories: 'Benign', 'Theft', 'DDoS', 'DoS', and 'Reconnaissance' .

I want to extract a new dataset from this dataset "NF" based on the value of the column "Attack" if it is only equal to 'DDoS'

Answer 1

[Arif Hoq]

a=readtable("NF.xlsx");
aa=find(strcmp(a.Attack,'DDoS'));
aaa=a(aa,:)

aaa = 3×5 table
    value    del    dys     label     Attack 
    _____    ___    ____    _____    ________

      1      43      232      1      {'DDoS'}
      3       4     2323      1      {'DDoS'}
     34       6     2323      1      {'DDoS'}

[mahmood aljamal]

I got this error

Attempt to execute SCRIPT readtable as a function:

D:\Polyspace\R2019b\toolbox\matlab\iofun\readtable.m

[Arif Hoq]

possibly your file is in CSV format. try this. It would be better if you attach your file here.

a=readtable("NF.CSV");

[mahmood aljamal]

My dataset file size is 47MB and I can't upload it here but I can give you a link to download it https://cloudstor.aarnet.edu.au/plus/s/N0JTc8JFNtZtUE4

If you can implement your code on it, please send me the dataset that you extracted

thank you very much

[Arif Hoq]

I was able to run your CSV file. I have attached here the dataset.

a=readtable("NF-BoT-IoT.csv");
aa=find(strcmp(a.Attack,'DDoS'));
output=a(aa,:)

[mahmood aljamal]

Thank you very much brother, you have been very helpful

[mahmood aljamal]

Can you send a csv file?

[Arif Hoq]

which CSV file? I have attached the dataset according to the CSV file that you uploaded to the cloud storage.

[mahmood aljamal]

I mean the file you sent me with the mat extension. Can you send it in csv format?

[Arif Hoq]

use this syntax to export in a CSV file.

loadmatfile=load("output.mat");
your_output=loadmatfile.aaa;
writetable(your_output,'mycsvfile.csv')

[mahmood aljamal]

I got this error

Error using load

Unable to read file 'output.mat'. No such file or directory.

[Arif Hoq]

check the 'output.mat' file in your matlab directory.