I created one Excel file which has data in three columns the first and second column has numerical data and the third column has characters, these columns have the header too. i want the following tasks to perform on it:

1 Ansicht (letzte 30 Tage)
I want to read this excel sheet. I want to save data of the rows of second column in folders which I have created, the names of folders are 0,2,3. the first column has numerical values, the second column has pixel values of a gray image, the third column has characters. the header names of columns are Emotion, Pixels, usage. Emotion, pixel and usage have values in its cells are:
emotions pixels Usage
0 70 80 82 72 58 58 60 63 54 58 60 48 89 115 Training
0 151 150 147 155 148 133 111 140 170 174 182 154 153 Training
2 231 212 156 164 174 138 161 173 182 200 106 38 39 74 138 161 164 Testing
0 70 80 82 72 58 58 60 63 54 58 60 48 89 115 Training
3 151 150 147 155 148 133 111 140 170 174 182 154 153 Training
2 231 212 156 164 174 138 161 173 182 200 106 38 39 74 138 161 164 Training
0 70 80 82 72 58 58 60 63 54 58 60 48 89 115 Training
0 151 150 147 155 148 133 111 140 170 174 182 154 153 Testing
2 231 212 156 164 174 138 161 173 182 200 106 38 39 74 138 161 164 Testing
now i want to save data from the file to text folders in text form. If usage is training and Emotion is 0 then pixel value of that raw should save in the 0 folder which is sub folder of training if the value if from testing then it should be saved in sub folder 0 of testing. same process with 2 and 3. kindly help me to perform this.

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by