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 view (last 30 days)
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.

Answers (0)

Community Treasure Hunt

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

Start Hunting!