To delete the empty fields in the dataset

Dear all, Could you please help me that I faced the difficulty to do the data set to be tidy up? I want to delete the empty fields in the data set. The data set(53x2 cell array) is below;
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] [1x18 struct]
[] []
[1x18 struct] [1x18 struct]
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] [1x18 struct]
[] []
[1x18 struct] []
[] []
[1x18 struct] []
[] []
[] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] [1x18 struct]
[1x18 struct] []
[] []
[1x18 struct] []
[] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] [1x18 struct]
[1x18 struct] []
[1x18 struct] [1x18 struct]
[1x18 struct] []
[] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[1x18 struct] []
[] []
[1x18 struct] [1x18 struct]

2 Comments

Is it a cell array or what? What is its size? do you mean to delete the entire row?
this data set is 53x2 Cell Array,sir. I want to delete only these empty fields showed below:

Sign in to comment.

 Accepted Answer

V={5 [];4 6;[] 8;7 8;[] []}
idx=cellfun(@isempty,V)
V(any(idx,2),:)=[]

3 Comments

Thanks sir,it deletes the entire row that is specified . But I just want to delete the only empty fields ,sir.So , I need to do 53x2 cell array to Nx1 cell array firstly and to delete the empty rows ,sir.Thank for your kind help.
Dear Azzi Abdelmalek , May i also know how to reduce the empty fields of array.I have the array [1 0 0 2 3 5 6 0 2 8 0].I want to delete these empty columns of this array.It is so easy for you,i think.Please help me,sir.
If there are empty element, that means you haven't to delete them, because they don't exist, unless you mean to delete the zero elements, in this case
array=[1 0 0 2 3 5 6 0 2 8 0]
out=nonzeros(array)'

Sign in to comment.

More Answers (1)

Now, try this
V = {1,2,[],[],23,16,'A',struct()}; % your cell array
V = V(~cellfun('isempty'),V);

2 Comments

Plz replace
V = V(~cellfun('isempty'),V);
with
V = V(~cellfun('isempty',V));

Sign in to comment.

Categories

Community Treasure Hunt

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

Start Hunting!