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:

Question

saeeda saher 2017-11-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/364952-i-created-one-excel-file-which-has-data-in-three-columns-the-first-and-second-column-has-numerical-d

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
70 80 82 72 58 58 60 63 54 58 60 48 89 115                          Training
151 150 147 155 148 133 111 140 170 174 182 154 153                   Training
231 212 156 164 174 138 161 173 182 200 106 38 39 74 138 161 164   Testing
70 80 82 72 58 58 60 63 54 58 60 48 89 115                          Training
151 150 147 155 148 133 111 140 170 174 182 154 153                   Training
231 212 156 164 174 138 161 173 182 200 106 38 39 74 138 161 164   Training
70 80 82 72 58 58 60 63 54 58 60 48 89 115                          Training
151 150 147 155 148 133 111 140 170 174 182 154 153                   Testing
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.