Excel Data preprocessing from a scattered one into an organised table

17 views (last 30 days)
Gurtej
Gurtej on 20 Mar 2025 at 8:19
Edited: Star Strider on 21 Mar 2025 at 11:16
I have excel data that is pretty big (10000x63) and unorganised. I have attached the sample data file here (sample.xlsx).
This data is converted from a pdf to excel so there are a lot of issues. I will highlight some of them here.
Some key things to note about data
  1. There are strings and numbers and I would like to keep them both organised.
  2. After every 200-250 rows, the table header labels keep repeating which I would like to remove
  3. Whenever the table header repeats, the columns shift left or right (sometimes upto 5 or 6 columns)
  4. There is one column "Code" which has both strings(1,2) and numbers(2).
  5. There are some cells where there is no data or "------".
  6. There are some texts on the top and bottom of the table (legends etc) which I would like to remove.
I would like the data to look like this one big simple list (it took me 4 hours to make this). I would like to automate it as I have many excel files of similar dimensions(10000x63).
Additionally I would like to know if there's a better way to organise this data other than matlab?
Thank you well in advance for your help. I am still learning matlab so any help would mean a lot!

Sign in to answer this question.

Answers (2)

Cris LaPierre
Cris LaPierre on 20 Mar 2025 at 18:48
Edited: Cris LaPierre on 20 Mar 2025 at 18:48
Ran in:
I found it easier to work with the file if I first exported the data to a csv file in Excel.
While this works well for this file, I'm not sure how well it will work across all your files.
% Had to manually determine the number of headerlines.
% Ideally, this is constant across all your files.
opts = detectImportOptions('Sample.csv','NumHeaderLines',6,'VariableNamingRule','preserve','TextType','string','TreatAsMissing',"---");
opts.ConsecutiveDelimitersRule = 'join';
myT = readtable('Sample.csv',opts)
myT = 53x62 table
ID FORMULA NAME CAS No A B C n TMIN TMAX code T, K density @ T Var14 Var15 Var16 Var17 Var18 Var19 Var20 Var21 Var22 Var23 Var24 Var25 Var26 Var27 Var28 Var29 Var30 Var31 Var32 Var33 Var34 Var35 Var36 Var37 Var38 Var39 Var40 Var41 Var42 Var43 Var44 Var45 Var46 Var47 Var48 Var49 Var50 Var51 Var52 Var53 Var54 Var55 Var56 Var57 Var58 Var59 Var60 Var61 Var62 ___ _____________________________ ____________________________________ __________ _________ _________ _________ _________ _________ _________ _________ _________ _____________ _________ _________ _________ _________ _________ _________ _________ _____ _____ _____ _____ _________ _____ _____ _____ _____ _________ _________ _____ _____ _____ _________ _________ _________ _____ _____ _________ _________ _________ _________ _________ _____ _________ _________ _________ _________ _________ _____ _________ _________ _________ _____ _________ _________ _________ _____ _________ _________ _____ 1 "CBrClF2" "bromochlorodifluoromethane" "353-59-3" "0.6722" "0.24741" "426.15" "0.28571" "113.65" "426.15" "1,2" "298.15" "1.8100" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 2 "CBrCl2F" "bromodichlorofluoromethane" "353-58-2" "0.6835" "0.31179" "512.90" "0.28571" "113.65" "512.90" "2" "298.15" "1.6960" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 3 "CBrCl3" "bromotrichloromethane" "75-62-7" "0.6981" "0.27984" "606.00" "0.28571" "252.15" "606.00" "1,2" "298.15" "1.9940" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 4 "CBrF3" "bromotrifluoromethane" "75-63-8" "0.7446" "0.26811" "340.15" "0.28571" "105.15" "340.15" "1,2" "298.15" "1.5360" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 5 "CBr2F2" "dibromodifluoromethane" "75-61-6" "0.8426" "0.26912" "478.00" "0.28571" "131.60" "478.00" "1,2" "298.15" "2.2740" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 6 "CBr4" "carbon tetrabromide" "558-13-4" "1.0156" "0.24172" "706.76" "0.28571" "364.15" "706.76" "1,2" "462.70" "2.8962" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 7 "CClF3" "chlorotrifluoromethane" "75-72-9" "0.5797" "0.26892" "301.80" "0.28571" "92.00" "301.80" "1,2" "298.15" "0.8410" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN NaN "density = A B - (1 - T/C)^n" "(density - g/ml, T - K)" <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN NaN "FORMULA" "NAME" "CAS No" "A" "B" "C" "n" "TMIN" "TMAX" "code" "T, K" "density @ T" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 81 "C2HCl2F3" "1,1-dichloro-1,2,2-trifluoroethane" "812-04-4" "0.5697" "0.27827" "462.04" "0.28571" "229.44" "462.04" "2" "298.15" "1.4750" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 82 "C2HCl2F3" "1,2-dichloro-1,1,2-trifluoroethane" "354-23-4" "0.5813" "0.29392" "461.60" "0.28571" "195.15" "461.60" "1,2" "298.15" "1.4444" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 83 "C2HCl2F3" "2,2-dichloro-1,1,1-trifluoroethane" "306-83-2" "0.5501" "0.26342" "456.94" "0.28571" "166.00" "456.94" "1,2" "298.15" "1.4750" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 84 "C2HCl3" "trichloroethylene" "79-01-6" "0.4920" "0.26196" "571.00" "0.28571" "188.40" "571.00" "1,2" "298.15" "1.4556" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN 85 "C2HCl3F2" "1,1,1-trichloro-2,2-difluoroethane" "354-12-1" "0.5964" "0.29415" "513.20" "0.28571" "267.59" "513.20" "2" "298.15" "1.5489" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN NaN "density = A B - (1 - T/C)^n" "(density - g/ml, T - K)" <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN NaN "FORMULA" "NAME" "CAS No" "A" "B" "C" "n" "TMIN" "TMAX" "code" "T, K" "density @ T" <missing> <missing> <missing> <missing> <missing> <missing> <missing> NaN NaN NaN NaN <missing> NaN NaN NaN NaN <missing> <missing> NaN NaN NaN <missing> <missing> <missing> NaN NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> <missing> NaN <missing> <missing> NaN
% Remove any rows where the ID is nan
ind = isnan(myT.ID);
myT(ind,:)=[];
% Remove any columns where the first value is missing
ind = table2array(varfun(@ismissing,myT(1,:)));
myT = removevars(myT,ind);
% convert numeric values to numeric data type
myT.code = cellfun(@str2num,myT.code,'UniformOutput',false);
myT = convertvars(myT,["A","B","C","n","TMIN","TMAX","T, K","density @ T"],'double')
myT = 39x13 table
ID FORMULA NAME CAS No A B C n TMIN TMAX code T, K density @ T ___ __________ ___________________________________________ __________ ______ _______ ______ _______ ______ ______ _______ ______ ___________ 1 "CBrClF2" "bromochlorodifluoromethane" "353-59-3" 0.6722 0.24741 426.15 0.28571 113.65 426.15 {[1 2]} 298.15 1.81 2 "CBrCl2F" "bromodichlorofluoromethane" "353-58-2" 0.6835 0.31179 512.9 0.28571 113.65 512.9 {[ 2]} 298.15 1.696 3 "CBrCl3" "bromotrichloromethane" "75-62-7" 0.6981 0.27984 606 0.28571 252.15 606 {[1 2]} 298.15 1.994 4 "CBrF3" "bromotrifluoromethane" "75-63-8" 0.7446 0.26811 340.15 0.28571 105.15 340.15 {[1 2]} 298.15 1.536 5 "CBr2F2" "dibromodifluoromethane" "75-61-6" 0.8426 0.26912 478 0.28571 131.6 478 {[1 2]} 298.15 2.274 6 "CBr4" "carbon tetrabromide" "558-13-4" 1.0156 0.24172 706.76 0.28571 364.15 706.76 {[1 2]} 462.7 2.8962 7 "CClF3" "chlorotrifluoromethane" "75-72-9" 0.5797 0.26892 301.8 0.28571 92 301.8 {[1 2]} 298.15 0.841 81 "C2HCl2F3" "1,1-dichloro-1,2,2-trifluoroethane" "812-04-4" 0.5697 0.27827 462.04 0.28571 229.44 462.04 {[ 2]} 298.15 1.475 82 "C2HCl2F3" "1,2-dichloro-1,1,2-trifluoroethane" "354-23-4" 0.5813 0.29392 461.6 0.28571 195.15 461.6 {[1 2]} 298.15 1.4444 83 "C2HCl2F3" "2,2-dichloro-1,1,1-trifluoroethane" "306-83-2" 0.5501 0.26342 456.94 0.28571 166 456.94 {[1 2]} 298.15 1.475 84 "C2HCl3" "trichloroethylene" "79-01-6" 0.492 0.26196 571 0.28571 188.4 571 {[1 2]} 298.15 1.4556 85 "C2HCl3F2" "1,1,1-trichloro-2,2-difluoroethane" "354-12-1" 0.5964 0.29415 513.2 0.28571 267.59 513.2 {[ 2]} 298.15 1.5489 229 "C2I2" "diiodoacetylene" "624-74-8" 1.02 0.25494 606.27 0.28571 354.65 606.27 {[ 2]} NaN 4.0008 230 "C2I4" "tetraiodoethene" "513-92-8" 1.2309 0.25339 806.58 0.28571 460.15 806.58 {[ 2]} 561.45 3.2694 231 "C2N2" "cyanogen" "460-19-5" 0.2669 0.20997 400.15 0.20635 245.25 400.15 {[1 2]} 298.15 0.866 232 "C3ClF7" "1-chloro-1,1,2,2,3,3,3-heptafluoropropane" "422-86-6" 0.4969 0.22106 400.69 0.28571 191.78 400.69 {[ 2]} 298.15 1.3814
Star Strider
Star Strider on 20 Mar 2025 at 12:17
Edited: Star Strider on 21 Mar 2025 at 11:16
Ran in:
I am not certain what result you want.
This approach first eliminated columns that are completely empty, then eliminates the empty rows from that result, finds the values in column 1 that are 'ID', and then segments the remaining rows by those results into separate cell arrays.
Try this —
C1 = readcell('Sample.xlsx', HeaderLines=6)
C1 = 54x62 cell array
Columns 1 through 10 {'ID' } {[<missing>]} {'FORMULA' } {[<missing>]} {[<missing>]} {'NAME' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 1]} {[<missing>]} {'CBrClF2' } {[<missing>]} {[<missing>]} {'bromochlorodif...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 2]} {[<missing>]} {'CBrCl2F' } {[<missing>]} {[<missing>]} {'bromodichlorof...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 3]} {[<missing>]} {'CBrCl3' } {[<missing>]} {[<missing>]} {'bromotrichloro...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 4]} {[<missing>]} {'CBrF3' } {[<missing>]} {[<missing>]} {'bromotrifluoro...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 5]} {[<missing>]} {'CBr2F2' } {[<missing>]} {[<missing>]} {'dibromodifluor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 6]} {[<missing>]} {'CBr4' } {[<missing>]} {[<missing>]} {'carbon tetrabr...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 7]} {[<missing>]} {'CClF3' } {[<missing>]} {[<missing>]} {'chlorotrifluor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'ID' } {[<missing>]} {'FORMULA' } {[<missing>]} {[<missing>]} {'NAME' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 81]} {[<missing>]} {'C2HCl2F3' } {[<missing>]} {[<missing>]} {'1,1-dichloro-1...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 82]} {[<missing>]} {'C2HCl2F3' } {[<missing>]} {[<missing>]} {'1,2-dichloro-1...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 83]} {[<missing>]} {'C2HCl2F3' } {[<missing>]} {[<missing>]} {'2,2-dichloro-1...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 84]} {[<missing>]} {'C2HCl3' } {[<missing>]} {[<missing>]} {'trichloroethylene'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 85]} {[<missing>]} {'C2HCl3F2' } {[<missing>]} {[<missing>]} {'1,1,1-trichlor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 11 through 20 {[<missing>]} {[<missing>]} {'CAS No' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'353-59-3' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'353-58-2' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'75-62-7' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'75-63-8' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'75-61-6' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'558-13-4' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'75-72-9' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'CAS No' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'812-04-4' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'354-23-4' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'306-83-2' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[06-Jan-2079]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'354-12-1' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 21 through 29 {'A' } {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {'B' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.6722]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2474]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.6835]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.3118]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.6981]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2798]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.7446]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2681]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.8426]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2691]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 1.0156]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2417]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.5797]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2689]} {[<missing>]} {[<missing>]} {[<missing>]} {'density = A B ...'} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'A' } {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {'B' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.5697]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2783]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.5813]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2939]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.5501]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2634]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.4920]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2620]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.5964]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[ 0.2942]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {'density = A B ...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 30 through 39 {[<missing>]} {[<missing>]} {'C' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'n' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 426.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 512.9000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 606]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 340.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 478]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 706.7600]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 301.8000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'C' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'n' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 462.0400]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 461.6000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 456.9400]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 571]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 513.2000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 40 through 49 {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMIN' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 113.6500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 113.6500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 252.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 105.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 131.6000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 364.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 92]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMIN' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 229.4400]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 195.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 166]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 188.4000]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 267.5900]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 50 through 59 {[<missing>]} {'TMAX' } {[<missing>]} {[<missing>]} {[<missing>]} {'code' } {[<missing>]} {[<missing>]} {[<missing>]} {'T, K' } {[<missing>]} {[ 426.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 512.9000]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 2]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 606]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 340.1500]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 478]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 706.7600]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 462.7000]} {[<missing>]} {[ 301.8000]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {'(density - g/m...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMAX' } {[<missing>]} {[<missing>]} {[<missing>]} {'code' } {[<missing>]} {[<missing>]} {[<missing>]} {'T, K' } {[<missing>]} {[ 462.0400]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 2]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 461.6000]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 456.9400]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 571]} {[<missing>]} {[<missing>]} {[<missing>]} {'1,2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {[ 513.2000]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 2]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 298.1500]} {[<missing>]} {'(density - g/m...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} Columns 60 through 62 {[<missing>]} {[<missing>]} {'density @ T'} {[<missing>]} {[<missing>]} {[ 1.8100]} {[<missing>]} {[<missing>]} {[ 1.6960]} {[<missing>]} {[<missing>]} {[ 1.9940]} {[<missing>]} {[<missing>]} {[ 1.5360]} {[<missing>]} {[<missing>]} {[ 2.2740]} {[<missing>]} {[<missing>]} {[ 2.8962]} {[<missing>]} {[<missing>]} {[ 0.8410]} {[<missing>]} {[<missing>]} {[<missing> ]} {[<missing>]} {[<missing>]} {'density @ T'} {[<missing>]} {[<missing>]} {[ 1.4750]} {[<missing>]} {[<missing>]} {[ 1.4444]} {[<missing>]} {[<missing>]} {[ 1.4750]} {[<missing>]} {[<missing>]} {[ 1.4556]} {[<missing>]} {[<missing>]} {[ 1.5489]} {[<missing>]} {[<missing>]} {[<missing> ]}
Lv1 = cellfun(@(x)~all(ismissing(x),2),C1(1,:), Unif=0); % Logical Vector Of ‘missing’ Columns
Lv1 = [Lv1{:}];
C2 = C1(:,Lv1);
SzC2 = size(C2)
SzC2 = 1×2
54 13
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
% disp(C2)
Col1_mt = cellfun(@(x)~all(ismissing(x),2), C2(:,1), Unif=0); % Missing Rows In ‘C2’
Col1_mt_Lv = [Col1_mt{:}];
C2 = C2(Col1_mt_Lv,:) % Resulting Fiiltered ‘C2’
C2 = 44x13 cell array
Columns 1 through 10 {'ID' } {'FORMULA' } {'NAME' } {'CAS No' } {'A' } {'B' } {'C' } {'n' } {'TMIN' } {'TMAX' } {[ 1]} {'CBrClF2' } {'bromochlorodif...'} {'353-59-3' } {[ 0.6722]} {[ 0.2474]} {[ 426.1500]} {[ 0.2857]} {[113.6500]} {[426.1500]} {[ 2]} {'CBrCl2F' } {'bromodichlorof...'} {'353-58-2' } {[ 0.6835]} {[ 0.3118]} {[ 512.9000]} {[ 0.2857]} {[113.6500]} {[512.9000]} {[ 3]} {'CBrCl3' } {'bromotrichloro...'} {'75-62-7' } {[ 0.6981]} {[ 0.2798]} {[ 606]} {[ 0.2857]} {[252.1500]} {[ 606]} {[ 4]} {'CBrF3' } {'bromotrifluoro...'} {'75-63-8' } {[ 0.7446]} {[ 0.2681]} {[ 340.1500]} {[ 0.2857]} {[105.1500]} {[340.1500]} {[ 5]} {'CBr2F2' } {'dibromodifluor...'} {'75-61-6' } {[ 0.8426]} {[ 0.2691]} {[ 478]} {[ 0.2857]} {[131.6000]} {[ 478]} {[ 6]} {'CBr4' } {'carbon tetrabr...'} {'558-13-4' } {[ 1.0156]} {[ 0.2417]} {[ 706.7600]} {[ 0.2857]} {[364.1500]} {[706.7600]} {[ 7]} {'CClF3' } {'chlorotrifluor...'} {'75-72-9' } {[ 0.5797]} {[ 0.2689]} {[ 301.8000]} {[ 0.2857]} {[ 92]} {[301.8000]} {'ID' } {'FORMULA' } {'NAME' } {'CAS No' } {'A' } {'B' } {'C' } {'n' } {'TMIN' } {'TMAX' } {[ 81]} {'C2HCl2F3'} {'1,1-dichloro-1...'} {'812-04-4' } {[ 0.5697]} {[ 0.2783]} {[ 462.0400]} {[ 0.2857]} {[229.4400]} {[462.0400]} {[ 82]} {'C2HCl2F3'} {'1,2-dichloro-1...'} {'354-23-4' } {[ 0.5813]} {[ 0.2939]} {[ 461.6000]} {[ 0.2857]} {[195.1500]} {[461.6000]} {[ 83]} {'C2HCl2F3'} {'2,2-dichloro-1...'} {'306-83-2' } {[ 0.5501]} {[ 0.2634]} {[ 456.9400]} {[ 0.2857]} {[ 166]} {[456.9400]} {[ 84]} {'C2HCl3' } {'trichloroethylene'} {[06-Jan-2079]} {[ 0.4920]} {[ 0.2620]} {[ 571]} {[ 0.2857]} {[188.4000]} {[ 571]} {[ 85]} {'C2HCl3F2'} {'1,1,1-trichlor...'} {'354-12-1' } {[ 0.5964]} {[ 0.2942]} {[ 513.2000]} {[ 0.2857]} {[267.5900]} {[513.2000]} {'ID' } {'FORMULA' } {'NAME' } {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMIN' } {'TMAX' } {[229]} {'C2I2' } {'diiodoacetylene' } {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[354.6500]} {[606.2700]} Columns 11 through 13 {'code'} {'T, K' } {'density @ T'} {'1,2' } {[298.1500]} {[ 1.8100]} {[ 2]} {[298.1500]} {[ 1.6960]} {'1,2' } {[298.1500]} {[ 1.9940]} {'1,2' } {[298.1500]} {[ 1.5360]} {'1,2' } {[298.1500]} {[ 2.2740]} {'1,2' } {[462.7000]} {[ 2.8962]} {'1,2' } {[298.1500]} {[ 0.8410]} {'code'} {'T, K' } {'density @ T'} {[ 2]} {[298.1500]} {[ 1.4750]} {'1,2' } {[298.1500]} {[ 1.4444]} {'1,2' } {[298.1500]} {[ 1.4750]} {'1,2' } {[298.1500]} {[ 1.4556]} {[ 2]} {[298.1500]} {[ 1.5489]} {'code'} {'T, K' } {'density @ T'} {[ 2]} {'---' } {[ 4.0008]}
% Col1_mt_nv = find([Col1_mt{:}])
Col1_ID = cellfun(@(x)strcmp(x,'ID'), C2(:,1), Unif=0); % Rows Of Column 1 That Have 'ID'
Col1_ID_nv = [find([Col1_ID{:}]) size(Col1_ID,1)]; % Numeric Index Values
for k = 1:numel(Col1_ID_nv)-1 % Segment ‘C2’
idxrng = Col1_ID_nv(k) : Col1_ID_nv(k+1)-1;
Segment{k,:} = C2(idxrng,:);
end
for k = 1:numel(Segment) % Display Segments (Optional — Not Necessarry Forr The Rest Of The Code)
disp("----- Segment "+k+" -----")
Segment{k}
end
----- Segment 1 -----
ans = 8x13 cell array
Columns 1 through 11 {'ID'} {'FORMULA'} {'NAME' } {'CAS No' } {'A' } {'B' } {'C' } {'n' } {'TMIN' } {'TMAX' } {'code'} {[ 1]} {'CBrClF2'} {'bromochlorodif...'} {'353-59-3'} {[0.6722]} {[0.2474]} {[426.1500]} {[0.2857]} {[113.6500]} {[426.1500]} {'1,2' } {[ 2]} {'CBrCl2F'} {'bromodichlorof...'} {'353-58-2'} {[0.6835]} {[0.3118]} {[512.9000]} {[0.2857]} {[113.6500]} {[512.9000]} {[ 2]} {[ 3]} {'CBrCl3' } {'bromotrichloro...'} {'75-62-7' } {[0.6981]} {[0.2798]} {[ 606]} {[0.2857]} {[252.1500]} {[ 606]} {'1,2' } {[ 4]} {'CBrF3' } {'bromotrifluoro...'} {'75-63-8' } {[0.7446]} {[0.2681]} {[340.1500]} {[0.2857]} {[105.1500]} {[340.1500]} {'1,2' } {[ 5]} {'CBr2F2' } {'dibromodifluor...'} {'75-61-6' } {[0.8426]} {[0.2691]} {[ 478]} {[0.2857]} {[131.6000]} {[ 478]} {'1,2' } {[ 6]} {'CBr4' } {'carbon tetrabr...'} {'558-13-4'} {[1.0156]} {[0.2417]} {[706.7600]} {[0.2857]} {[364.1500]} {[706.7600]} {'1,2' } {[ 7]} {'CClF3' } {'chlorotrifluor...'} {'75-72-9' } {[0.5797]} {[0.2689]} {[301.8000]} {[0.2857]} {[ 92]} {[301.8000]} {'1,2' } Columns 12 through 13 {'T, K' } {'density @ T'} {[298.1500]} {[ 1.8100]} {[298.1500]} {[ 1.6960]} {[298.1500]} {[ 1.9940]} {[298.1500]} {[ 1.5360]} {[298.1500]} {[ 2.2740]} {[462.7000]} {[ 2.8962]} {[298.1500]} {[ 0.8410]}
----- Segment 2 -----
ans = 6x13 cell array
Columns 1 through 11 {'ID'} {'FORMULA' } {'NAME' } {'CAS No' } {'A' } {'B' } {'C' } {'n' } {'TMIN' } {'TMAX' } {'code'} {[81]} {'C2HCl2F3'} {'1,1-dichloro-1...'} {'812-04-4' } {[0.5697]} {[0.2783]} {[462.0400]} {[0.2857]} {[229.4400]} {[462.0400]} {[ 2]} {[82]} {'C2HCl2F3'} {'1,2-dichloro-1...'} {'354-23-4' } {[0.5813]} {[0.2939]} {[461.6000]} {[0.2857]} {[195.1500]} {[461.6000]} {'1,2' } {[83]} {'C2HCl2F3'} {'2,2-dichloro-1...'} {'306-83-2' } {[0.5501]} {[0.2634]} {[456.9400]} {[0.2857]} {[ 166]} {[456.9400]} {'1,2' } {[84]} {'C2HCl3' } {'trichloroethylene'} {[06-Jan-2079]} {[0.4920]} {[0.2620]} {[ 571]} {[0.2857]} {[188.4000]} {[ 571]} {'1,2' } {[85]} {'C2HCl3F2'} {'1,1,1-trichlor...'} {'354-12-1' } {[0.5964]} {[0.2942]} {[513.2000]} {[0.2857]} {[267.5900]} {[513.2000]} {[ 2]} Columns 12 through 13 {'T, K' } {'density @ T'} {[298.1500]} {[ 1.4750]} {[298.1500]} {[ 1.4444]} {[298.1500]} {[ 1.4750]} {[298.1500]} {[ 1.4556]} {[298.1500]} {[ 1.5489]}
----- Segment 3 -----
ans = 13x13 cell array
Columns 1 through 11 {'ID' } {'FORMULA'} {'NAME' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMIN' } {'TMAX' } {'code'} {[229]} {'C2I2' } {'diiodoacetylene' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[354.6500]} {[606.2700]} {[ 2]} {[230]} {'C2I4' } {'tetraiodoethene' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[460.1500]} {[806.5800]} {[ 2]} {[231]} {'C2N2' } {'cyanogen' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[245.2500]} {[400.1500]} {'1,2' } {[232]} {'C3ClF7' } {'1-chloro-1,1,2...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[191.7800]} {[400.6900]} {[ 2]} {[233]} {'C3ClF7' } {'2-chloro-1,1,1...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 191]} {[399.5900]} {[ 2]} {[234]} {'C3Cl2F6'} {'1,2-dichlorohe...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[148.2500]} {[450.8900]} {[ 2]} {[235]} {'C3Cl2F6'} {'1,3-dichloro-1...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[229.9600]} {[451.9000]} {[ 2]} {[236]} {'C3Cl3F5'} {'1,1,1-trichlor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[193.1500]} {[501.4400]} {'1,2' } {[237]} {'C3Cl3F5'} {'1,2,2-trichlor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[270.9500]} {[501.4400]} {'1,2' } {[238]} {'C3Cl3F5'} {'1,2,3-trichlor...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[201.1500]} {[501.2100]} {'1,2' } {[239]} {'C3Cl4F4'} {'1,2,2,3-tetrac...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[230.2500]} {[556.5600]} {'1,2' } {[240]} {'C3Cl4F4'} {'1,1,1,3-tetrac...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 307]} {[555.2600]} {[ 2]} Columns 12 through 13 {'T, K' } {'density @ T'} {'---' } {[ 4.0008]} {[561.4500]} {[ 3.2694]} {[298.1500]} {[ 0.8660]} {[298.1500]} {[ 1.3814]} {[298.1500]} {[ 1.3814]} {[298.1500]} {[ 1.6538]} {[298.1500]} {[ 1.6538]} {[298.1500]} {[ 1.6430]} {[298.1500]} {[ 1.6531]} {[298.1500]} {[ 1.6514]} {[298.1500]} {[ 1.7103]} {[ 387]} {[ 1.5251]}
----- Segment 4 -----
ans = 9x13 cell array
Columns 1 through 11 {'ID' } {'FORMULA'} {'NAME' } {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {'TMIN' } {'TMAX' } {'code'} {[241]} {'C3Cl5F3'} {'1,1,1,3,3-pent...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[349.4000]} {[612.4100]} {[ 2]} {[242]} {'C3Cl6F2'} {'hexachloro-2,2...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[260.4500]} {[666.8800]} {[ 2]} {[243]} {'C3Cl6F2'} {'hexachlorodifl...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 324]} {[670.0400]} {[ 2]} {[244]} {'C3Cl7F' } {'1,1,1,2,2,3,3-...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[420.5700]} {[707.4900]} {[ 2]} {[245]} {'C3F6' } {'hexafluoroprop...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[116.6500]} {[399.3200]} {[ 2]} {[246]} {'C3F6O' } {'hexafluoroacetone'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[151.1500]} {[357.1400]} {'1,2' } {[247]} {'C3F6O' } {'trifluoromethy...'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[167.1500]} {[ 363]} {[ 2]} {[248]} {'C3F8' } {'octafluoropropane'} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[124.8500]} {[345.0500]} {'1,2' } Columns 12 through 13 {'T, K' } {'density @ T'} {[429.4000]} {[ 1.5084]} {[298.1500]} {[ 1.7752]} {[472.1400]} {[ 1.5543]} {[500.5700]} {[ 1.4844]} {[298.1500]} {[ 1.2738]} {[298.1500]} {[ 1.3210]} {[298.1500]} {[ 1.3210]} {[298.1500]} {[ 1.2732]}
----- Segment 5 -----
ans = 7x13 cell array
Columns 1 through 11 {'ID' } {'FORMULA' } {'NAME' } {'CAS No' } {[<missing>]} {[<missing>]} {[<missing>]} {'n' } {'TMIN' } {'TMAX' } {'code'} {[321]} {'C3H3ClF4'} {'2-chloro-1,1,1...'} {'421-73-8' } {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} {[322]} {'C3H3ClF4'} {'3-chloro-1,1,2...'} {'679-85-6' } {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} {[323]} {'C3H3ClF4'} {'1-chloro-1,1,2...'} {'421-75-0' } {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} {[324]} {'C3H3ClF4'} {'1-chloro-1,2,2...'} {'67406-66-0' } {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} {[325]} {'C3H3ClF4'} {'2-chloro-1,1,3...'} {'19041-02-2' } {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} {[326]} {'C3H3ClF4'} {'2-chloro-1,1,1...'} {'117970-90-8'} {[<missing>]} {[<missing>]} {[<missing>]} {[0.2857]} {[205.1000]} {[428.1100]} {[ 2]} Columns 12 through 13 {'T, K' } {'density @ T'} {[298.1500]} {[ 1.2432]} {[298.1500]} {[ 1.2432]} {[298.1500]} {[ 1.2432]} {[298.1500]} {[ 1.2432]} {[298.1500]} {[ 1.2432]} {[298.1500]} {[ 1.2432]}
VN = Segment{1}(1,:);
for k = 1:numel(Segment)
Segments{k,:} = Segment{k}(2:end,:);
end
OneCellArray = vertcat(VN,Segments{:});
disp(OneCellArray)
Columns 1 through 10 {'ID' } {'FORMULA' } {'NAME' } {'CAS No' } {'A' } {'B' } {'C' } {'n' } {'TMIN' } {'TMAX' } {[ 1]} {'CBrClF2' } {'bromochlorodif...'} {'353-59-3' } {[ 0.6722]} {[ 0.2474]} {[ 426.1500]} {[ 0.2857]} {[113.6500]} {[426.1500]} {[ 2]} {'CBrCl2F' } {'bromodichlorof...'} {'353-58-2' } {[ 0.6835]} {[ 0.3118]} {[ 512.9000]} {[ 0.2857]} {[113.6500]} {[512.9000]} {[ 3]} {'CBrCl3' } {'bromotrichloro...'} {'75-62-7' } {[ 0.6981]} {[ 0.2798]} {[ 606]} {[ 0.2857]} {[252.1500]} {[ 606]} {[ 4]} {'CBrF3' } {'bromotrifluoro...'} {'75-63-8' } {[ 0.7446]} {[ 0.2681]} {[ 340.1500]} {[ 0.2857]} {[105.1500]} {[340.1500]} {[ 5]} {'CBr2F2' } {'dibromodifluor...'} {'75-61-6' } {[ 0.8426]} {[ 0.2691]} {[ 478]} {[ 0.2857]} {[131.6000]} {[ 478]} {[ 6]} {'CBr4' } {'carbon tetrabr...'} {'558-13-4' } {[ 1.0156]} {[ 0.2417]} {[ 706.7600]} {[ 0.2857]} {[364.1500]} {[706.7600]} {[ 7]} {'CClF3' } {'chlorotrifluor...'} {'75-72-9' } {[ 0.5797]} {[ 0.2689]} {[ 301.8000]} {[ 0.2857]} {[ 92]} {[301.8000]} {[ 81]} {'C2HCl2F3'} {'1,1-dichloro-1...'} {'812-04-4' } {[ 0.5697]} {[ 0.2783]} {[ 462.0400]} {[ 0.2857]} {[229.4400]} {[462.0400]} {[ 82]} {'C2HCl2F3'} {'1,2-dichloro-1...'} {'354-23-4' } {[ 0.5813]} {[ 0.2939]} {[ 461.6000]} {[ 0.2857]} {[195.1500]} {[461.6000]} {[ 83]} {'C2HCl2F3'} {'2,2-dichloro-1...'} {'306-83-2' } {[ 0.5501]} {[ 0.2634]} {[ 456.9400]} {[ 0.2857]} {[ 166]} {[456.9400]} {[ 84]} {'C2HCl3' } {'trichloroethylene'} {[06-Jan-2079]} {[ 0.4920]} {[ 0.2620]} {[ 571]} {[ 0.2857]} {[188.4000]} {[ 571]} {[ 85]} {'C2HCl3F2'} {'1,1,1-trichlor...'} {'354-12-1' } {[ 0.5964]} {[ 0.2942]} {[ 513.2000]} {[ 0.2857]} {[267.5900]} {[513.2000]} {[229]} {'C2I2' } {'diiodoacetylene' } {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[354.6500]} {[606.2700]} {[230]} {'C2I4' } {'tetraiodoethene' } {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[460.1500]} {[806.5800]} {[231]} {'C2N2' } {'cyanogen' } {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[245.2500]} {[400.1500]} {[232]} {'C3ClF7' } {'1-chloro-1,1,2...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[191.7800]} {[400.6900]} {[233]} {'C3ClF7' } {'2-chloro-1,1,1...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 191]} {[399.5900]} {[234]} {'C3Cl2F6' } {'1,2-dichlorohe...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[148.2500]} {[450.8900]} {[235]} {'C3Cl2F6' } {'1,3-dichloro-1...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[229.9600]} {[451.9000]} {[236]} {'C3Cl3F5' } {'1,1,1-trichlor...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[193.1500]} {[501.4400]} {[237]} {'C3Cl3F5' } {'1,2,2-trichlor...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[270.9500]} {[501.4400]} {[238]} {'C3Cl3F5' } {'1,2,3-trichlor...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[201.1500]} {[501.2100]} {[239]} {'C3Cl4F4' } {'1,2,2,3-tetrac...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[230.2500]} {[556.5600]} {[240]} {'C3Cl4F4' } {'1,1,1,3-tetrac...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 307]} {[555.2600]} {[241]} {'C3Cl5F3' } {'1,1,1,3,3-pent...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[349.4000]} {[612.4100]} {[242]} {'C3Cl6F2' } {'hexachloro-2,2...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[260.4500]} {[666.8800]} {[243]} {'C3Cl6F2' } {'hexachlorodifl...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[ 324]} {[670.0400]} {[244]} {'C3Cl7F' } {'1,1,1,2,2,3,3-...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[420.5700]} {[707.4900]} {[245]} {'C3F6' } {'hexafluoroprop...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[116.6500]} {[399.3200]} {[246]} {'C3F6O' } {'hexafluoroacetone'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[151.1500]} {[357.1400]} {[247]} {'C3F6O' } {'trifluoromethy...'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[167.1500]} {[ 363]} {[248]} {'C3F8' } {'octafluoropropane'} {[<missing> ]} {[<missing>]} {[<missing>]} {[<missing>]} {[<missing>]} {[124.8500]} {[345.0500]} {[321]} {'C3H3ClF4'} {'2-chloro-1,1,1...'} {'421-73-8' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} {[322]} {'C3H3ClF4'} {'3-chloro-1,1,2...'} {'679-85-6' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} {[323]} {'C3H3ClF4'} {'1-chloro-1,1,2...'} {'421-75-0' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} {[324]} {'C3H3ClF4'} {'1-chloro-1,2,2...'} {'67406-66-0' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} {[325]} {'C3H3ClF4'} {'2-chloro-1,1,3...'} {'19041-02-2' } {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} {[326]} {'C3H3ClF4'} {'2-chloro-1,1,1...'} {'117970-90-8'} {[<missing>]} {[<missing>]} {[<missing>]} {[ 0.2857]} {[205.1000]} {[428.1100]} Columns 11 through 13 {'code'} {'T, K' } {'density @ T'} {'1,2' } {[298.1500]} {[ 1.8100]} {[ 2]} {[298.1500]} {[ 1.6960]} {'1,2' } {[298.1500]} {[ 1.9940]} {'1,2' } {[298.1500]} {[ 1.5360]} {'1,2' } {[298.1500]} {[ 2.2740]} {'1,2' } {[462.7000]} {[ 2.8962]} {'1,2' } {[298.1500]} {[ 0.8410]} {[ 2]} {[298.1500]} {[ 1.4750]} {'1,2' } {[298.1500]} {[ 1.4444]} {'1,2' } {[298.1500]} {[ 1.4750]} {'1,2' } {[298.1500]} {[ 1.4556]} {[ 2]} {[298.1500]} {[ 1.5489]} {[ 2]} {'---' } {[ 4.0008]} {[ 2]} {[561.4500]} {[ 3.2694]} {'1,2' } {[298.1500]} {[ 0.8660]} {[ 2]} {[298.1500]} {[ 1.3814]} {[ 2]} {[298.1500]} {[ 1.3814]} {[ 2]} {[298.1500]} {[ 1.6538]} {[ 2]} {[298.1500]} {[ 1.6538]} {'1,2' } {[298.1500]} {[ 1.6430]} {'1,2' } {[298.1500]} {[ 1.6531]} {'1,2' } {[298.1500]} {[ 1.6514]} {'1,2' } {[298.1500]} {[ 1.7103]} {[ 2]} {[ 387]} {[ 1.5251]} {[ 2]} {[429.4000]} {[ 1.5084]} {[ 2]} {[298.1500]} {[ 1.7752]} {[ 2]} {[472.1400]} {[ 1.5543]} {[ 2]} {[500.5700]} {[ 1.4844]} {[ 2]} {[298.1500]} {[ 1.2738]} {'1,2' } {[298.1500]} {[ 1.3210]} {[ 2]} {[298.1500]} {[ 1.3210]} {'1,2' } {[298.1500]} {[ 1.2732]} {[ 2]} {[298.1500]} {[ 1.2432]} {[ 2]} {[298.1500]} {[ 1.2432]} {[ 2]} {[298.1500]} {[ 1.2432]} {[ 2]} {[298.1500]} {[ 1.2432]} {[ 2]} {[298.1500]} {[ 1.2432]} {[ 2]} {[298.1500]} {[ 1.2432]}
OneTable = cell2table(OneCellArray(2:end,:), VariableNames=VN)
OneTable = 38x13 table
ID FORMULA NAME CAS No A B C n TMIN TMAX code T, K density @ T ___ ____________ _____________________________________________ _______________ ______ _______ ______ _______ ______ ______ _______ ____________ ___________ 1 {'CBrClF2' } {'bromochlorodifluoromethane' } {'353-59-3' } 0.6722 0.24741 426.15 0.28571 113.65 426.15 {'1,2'} {[298.1500]} 1.81 2 {'CBrCl2F' } {'bromodichlorofluoromethane' } {'353-58-2' } 0.6835 0.31179 512.9 0.28571 113.65 512.9 {[ 2]} {[298.1500]} 1.696 3 {'CBrCl3' } {'bromotrichloromethane' } {'75-62-7' } 0.6981 0.27984 606 0.28571 252.15 606 {'1,2'} {[298.1500]} 1.994 4 {'CBrF3' } {'bromotrifluoromethane' } {'75-63-8' } 0.7446 0.26811 340.15 0.28571 105.15 340.15 {'1,2'} {[298.1500]} 1.536 5 {'CBr2F2' } {'dibromodifluoromethane' } {'75-61-6' } 0.8426 0.26912 478 0.28571 131.6 478 {'1,2'} {[298.1500]} 2.274 6 {'CBr4' } {'carbon tetrabromide' } {'558-13-4' } 1.0156 0.24172 706.76 0.28571 364.15 706.76 {'1,2'} {[462.7000]} 2.8962 7 {'CClF3' } {'chlorotrifluoromethane' } {'75-72-9' } 0.5797 0.26892 301.8 0.28571 92 301.8 {'1,2'} {[298.1500]} 0.841 81 {'C2HCl2F3'} {'1,1-dichloro-1,2,2-trifluoroethane' } {'812-04-4' } 0.5697 0.27827 462.04 0.28571 229.44 462.04 {[ 2]} {[298.1500]} 1.475 82 {'C2HCl2F3'} {'1,2-dichloro-1,1,2-trifluoroethane' } {'354-23-4' } 0.5813 0.29392 461.6 0.28571 195.15 461.6 {'1,2'} {[298.1500]} 1.4444 83 {'C2HCl2F3'} {'2,2-dichloro-1,1,1-trifluoroethane' } {'306-83-2' } 0.5501 0.26342 456.94 0.28571 166 456.94 {'1,2'} {[298.1500]} 1.475 84 {'C2HCl3' } {'trichloroethylene' } {[06-Jan-2079]} 0.492 0.26196 571 0.28571 188.4 571 {'1,2'} {[298.1500]} 1.4556 85 {'C2HCl3F2'} {'1,1,1-trichloro-2,2-difluoroethane' } {'354-12-1' } 0.5964 0.29415 513.2 0.28571 267.59 513.2 {[ 2]} {[298.1500]} 1.5489 229 {'C2I2' } {'diiodoacetylene' } {[<missing> ]} NaN NaN NaN NaN 354.65 606.27 {[ 2]} {'---' } 4.0008 230 {'C2I4' } {'tetraiodoethene' } {[<missing> ]} NaN NaN NaN NaN 460.15 806.58 {[ 2]} {[561.4500]} 3.2694 231 {'C2N2' } {'cyanogen' } {[<missing> ]} NaN NaN NaN NaN 245.25 400.15 {'1,2'} {[298.1500]} 0.866 232 {'C3ClF7' } {'1-chloro-1,1,2,2,3,3,3-heptafluoropropane'} {[<missing> ]} NaN NaN NaN NaN 191.78 400.69 {[ 2]} {[298.1500]} 1.3814
I kept the segmented results as cell arrays, since they are probably easier to work with that way.
Make appropriate changes to get the desired result.
.
EDIT — Corrected typographical errors, re-ran code.
EDIT — (20 Mar 2025 at 19:16)
Corrected typographical error in display loop so that it now displays all the segments.
EDIT — (21 Mar 2025 at 11:16)
Added ‘OneCellArray’ and ‘OneTable’.
.

Categories

Find more on Pattern Recognition and Classification in Help Center and File Exchange

Tags

Products


Release

R2024b

Community Treasure Hunt

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

Start Hunting!