Editing csv data and convert it into a table

13 visualizaciones (últimos 30 días)
Hicham
Hicham el 14 de Feb. de 2024
Movida: Voss el 21 de Feb. de 2024
How can I edit the following csv file so that the data is separated into individual columns. I tried it with import tool. Unfortunately, it is not. I am thankful for any help
%% Import data from text file
% Script for importing data from the following text file:
%
% filename: O:\E054\E054_b-tws\40_TSEVM\99 User\Belhassan\Priv\Experimentation\EnergyLIS.csv
%
% Auto-generated by MATLAB on 14-Feb-2024 17:39:23
%% Set up the Import Options and import the data
opts = delimitedTextImportOptions("NumVariables", 1, "Encoding", "UTF-8");
% Specify range and delimiter
opts.DataLines = [2, Inf];
opts.Delimiter = ["\t", "Enter Custom Delimiter"];
% Specify column names and types
opts.VariableNames = "Datum0000001500300045010001150130014502000215023002450300031503";
opts.VariableTypes = "string";
% Specify file level properties
opts.ImportErrorRule = "error";
opts.ExtraColumnsRule = "ignore";
opts.EmptyLineRule = "read";
opts.ConsecutiveDelimitersRule = "join";
% Specify variable properties
opts = setvaropts(opts, "Datum0000001500300045010001150130014502000215023002450300031503", "WhitespaceRule", "preserve");
opts = setvaropts(opts, "Datum0000001500300045010001150130014502000215023002450300031503", "EmptyFieldRule", "auto");
% Import the data
EnergyLIS = readtable("O:\E054\E054_b-tws\40_TSEVM\99 User\Belhassan\Priv\Experimentation\EnergyLIS.csv", opts);
%% Clear temporary variables
clear opts
  4 comentarios
Mostrar 2 comentarios más antiguos
Matthew Josh
Matthew Josh el 21 de Feb. de 2024
Movida: Voss el 21 de Feb. de 2024
Heres a real shame with Matlab!!!!!
If you double click on a csv file it opens a really a nice easy to view table format with options for importing.. HOWEVER,, whilst viewing it in this lovely table, IT WOULD BE AWESOME, if it were possible to acutally edit the table.. ie make changes to the numbers in the table and have them save into the original file... hint hint MATLAB. :)

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Voss
Voss el 14 de Feb. de 2024
Ran in:
filename = 'EnergyLIS.csv';
out = importdata(filename);
out(2:end) = strrep(out(2:end),',"','/');
out(2:end) = strrep(out(2:end),',','.');
out(1) = strrep(out(1),',','/');
out = strrep(out,'"','');
C = split(out,'/');
tbl = cell2table(C(2:end,:),'VariableNames',C(1,:));
tbl = convertvars(tbl,1,@(x)datetime(x,'InputFormat','MM-dd-yyyy'));
tbl = convertvars(tbl,2:size(tbl,2),@str2double)
tbl = 30x97 table
Datum 00:00 00:15 00:30 00:45 01:00 01:15 01:30 01:45 02:00 02:15 02:30 02:45 03:00 03:15 03:30 03:45 04:00 04:15 04:30 04:45 05:00 05:15 05:30 05:45 06:00 06:15 06:30 06:45 07:00 07:15 07:30 07:45 08:00 08:15 08:30 08:45 09:00 09:15 09:30 09:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 13:00 13:15 13:30 13:45 14:00 14:15 14:30 14:45 15:00 15:15 15:30 15:45 16:00 16:15 16:30 16:45 17:00 17:15 17:30 17:45 18:00 18:15 18:30 18:45 19:00 19:15 19:30 19:45 20:00 20:15 20:30 20:45 21:00 21:15 21:30 21:45 22:00 22:15 22:30 22:45 23:00 23:15 23:30 23:45 ___________ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ _____ _____ _____ ______ ______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ 16-Jan-2024 0 0.58 2.808 2.805 2.813 2.813 2.797 2.817 2.819 2.476 0 0 0 0 0 0 0 0 0.555 2.819 9.577 23.35 42.269 62.843 72.287 74.869 81.823 84.279 78.114 75.484 69.806 63.326 54.432 53.215 52.569 53.354 53.185 50.893 43.319 46.548 43.336 40.657 43.293 26.16 19.99 20.694 16.778 15.963 11.468 10.472 10.487 11.731 22.936 26.528 40.116 51.822 63.06 58.533 55.868 46.854 34.659 24.963 19.748 16.207 13.968 13.089 10.679 7.264 7.379 7.399 6.478 6.019 5.507 5.512 5.501 5.508 5.51 3.968 1.399 2.144 2.771 5.371 7.702 8.779 6.725 9.251 16.857 24.982 34.633 28.194 28.543 27.612 20.685 14.526 13.892 12.16 17-Jan-2024 8.793 8.354 6.327 5.819 5.798 5.567 5.772 3.615 2.803 2.784 3.019 2.792 2.786 0.922 0.215 0 0 0 0.646 1.693 16.073 18.703 50.842 58.587 59.758 62.291 68.434 66.023 61.297 61.539 71.804 74.832 69.938 54.997 43.461 39.526 40.237 38.053 34.837 31.702 23.352 20.434 22.155 19.333 16.47 15.567 16.358 16.722 18.291 10.48 8.639 8.458 12.959 24.771 34.972 64.197 99.029 94.645 80.046 49.654 37.904 29.502 24.083 22.591 20.429 20.193 15.029 13.136 11.187 14.956 14.079 13.983 13.251 7.54 3.945 2.808 2.356 0 0.002 0.187 2.7 2.824 2.752 2.975 3.57 3.153 9.229 12.349 28.236 39.275 18.769 14.353 9.688 6.514 3.456 0.441 18-Jan-2024 0.507 0.202 0.137 0.082 0.411 0 0 0 0.214 0 0 0 0 0.213 0 0 0 0.297 0 2.222 10.393 20.163 38.942 49.895 66.931 69.099 64.881 58.019 51.546 46.416 43.138 36.898 39.323 38.839 34.772 33.194 32.704 28.594 25.258 28.522 28.351 24.611 20.707 16.979 15.141 15.132 13.597 12.701 13.259 14.74 13.161 15.592 21.183 24.87 29.387 42.109 54.716 54.567 46.48 38.179 25.299 13.621 10.669 9.169 3.464 4.882 4.548 5.037 3.493 4.039 5.042 2.794 2.792 2.791 2.785 2.783 2.397 2.637 2.636 2.65 6.909 7.741 8.752 10.572 10.675 11.024 13.943 20.745 21.204 24.66 22.882 20.613 14.697 9.432 7.302 7.152 19-Jan-2024 7.297 6.994 6.876 6.693 4.241 3.966 3.97 3.963 4.289 3.942 3.936 3.927 4.202 1.178 1.151 0.985 1.157 1.464 1.147 2.197 10.504 25.687 37.01 57.468 61.466 64.225 67.325 60.447 49.667 48.288 52.404 45.56 50.17 41.204 36.873 34.685 35.776 37.228 36.833 37.569 36.595 33.658 29.26 24.963 22.052 19.983 14.799 13.245 12.766 10.899 10.72 8.194 12.635 23.693 33.338 51.208 60.487 62.773 66.283 45.056 32.955 26.158 21.082 20.223 15.824 14.853 10.294 9.84 9.446 8.335 8.09 7.256 6.771 4.28 5.536 5.517 4.98 2.797 0.519 0 0.078 0 0 0.162 3.719 9.06 11.965 19.447 17.164 21.808 22.454 21.937 16.817 7.784 9.069 5.858 20-Jan-2024 5.786 5.785 5.722 5.597 2.252 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.248 1.289 2.568 3.114 2.988 2.8 2.801 2.799 2.779 2.794 2.796 2.783 3.272 3.433 2.804 2.815 2.796 2.802 2.815 2.795 2.801 2.804 2.808 4.589 2.81 2.726 0.583 2.417 3.636 3.72 3.925 3.695 4.843 5.62 8.001 8.374 8.356 8.356 8.339 8.339 8.349 7.702 5.958 5.563 5.567 5.026 3.123 2.804 1.365 0 0 0 0 0 0 0 0 0 0 2.193 4.87 3.551 1.96 1.589 0.17 0 0 0.671 0.663 0 0 0 0 0 0 0 21-Jan-2024 0 0 0 0 0 0.19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.535 2.367 0 0 0 0 0 1.09 2.834 2.84 2.845 2.845 2.846 2.831 2.859 2.843 2.864 2.855 2.851 2.86 1.421 0 0 0 0 0 0 0 0 0 1.036 2.785 2.798 2.799 0.696 0 0 0 1.518 1.824 4.394 4.603 3.236 2.779 2.78 2.781 2.764 2.778 2.795 22-Jan-2024 2.768 2.822 2.808 2.82 2.823 2.822 2.818 2.82 2.819 2.82 2.818 2.814 2.804 1.533 0 0 0 0.002 0 2.097 10.276 37.099 64.181 81.681 87.109 98.691 101.22 86.954 80.581 65.926 58.538 63.237 73.318 73.779 74.354 70.375 58.568 57.945 45.352 42.325 38.27 34.281 29.629 25.214 27.698 22.215 17.372 13.047 12.949 12.085 13.523 14.161 18.736 25.478 38.336 49.217 53.57 52.728 52.151 46.37 42.111 34.139 29.566 23.916 23.209 21.153 19.386 17.12 13.594 13.989 13.535 13.583 12.417 11.587 10.952 10.599 6.157 4.429 2.719 0.302 1.608 2.852 5.419 5.645 6.254 5.521 5.166 7.398 8.678 9.681 9.011 9.603 7.691 5.636 5.596 5.603 23-Jan-2024 5.608 5.613 5.616 5.61 5.596 5.612 5.606 5.588 5.622 5.591 4.517 2.821 2.828 2.819 2.806 1.429 0.642 0.95 0.934 1.67 4.956 27.87 49.803 67.664 84.104 81.197 75.925 60.944 56.956 65.769 71.611 77.047 80.211 80.282 70.152 69.38 69.696 66.56 63.596 63.242 60.829 53.027 42.486 37.499 28.868 22.03 18.447 18.872 18.767 15.185 13.064 14.126 18.435 23.19 33.604 43.689 51.55 45.205 44.116 37.991 34.55 29.07 23.254 17.135 14.216 10.518 8.089 7.569 9.011 8.504 7.198 6.613 6.993 6.462 6.455 6.442 6.01 4.745 4.857 7.12 9.176 9.711 6.751 4.428 4.687 9.344 12.24 9.207 8.856 8.541 11.816 10.794 9.446 8.207 8.237 8.211 24-Jan-2024 8.207 8.19 8.201 8.074 6.592 5.821 5.554 5.581 5.842 6.528 6.346 5.266 3.436 3.484 3.473 3.09 2.802 3.389 1.023 3.512 10.802 34.45 49.679 70.04 68.276 60.575 49.677 47.835 76.674 76.174 90.454 80.571 60.839 53.114 46.012 42.094 39.411 39.372 37.508 21.78 17.108 17.499 17.159 16.81 11.941 11.277 9.12 10.054 12.148 12.271 14.639 15.744 15.034 23.343 39.309 54.535 62.153 62.073 52.188 42.177 32.45 21.213 18.164 13.591 12.594 7.969 9.359 9.139 6.197 4.062 3.543 5.022 7.932 6.503 5.124 2.638 0 0 0 0 0.001 1.773 2.786 2.784 1.093 2.025 8.271 7.759 7.941 6.034 5.768 5.496 4.224 2.884 2.806 2.805 25-Jan-2024 2.805 2.809 2.812 2.816 2.818 2.815 2.817 2.816 2.823 2.812 2.828 2.812 2.635 0 0 0 0.038 0.981 0.86 0.71 7.744 28.409 38.188 42.679 49.859 54.294 56.38 53.666 50.211 52.226 53.525 51.689 58.488 59.244 65.383 59.97 51.191 49.924 42.612 37.87 36.152 34.031 30.354 20.121 14.41 9.927 11.105 11.117 11.812 11.175 10.362 8.395 14.675 17.505 24.116 38.168 50.972 44.266 39.299 34.682 27.407 22.279 18.34 18.987 12.616 6.914 5.173 7.113 4.223 7.531 5.383 3.588 1.874 0.916 1.113 3.732 3.737 3.745 3.227 2.799 2.794 2.795 2.795 2.79 3.012 6.534 7.224 8.465 7.67 8.427 9.735 10.624 9.007 8.375 6.233 5.607 26-Jan-2024 5.615 5.617 5.611 5.613 5.595 4.616 2.806 2.823 2.84 2.812 2.823 2.795 2.986 3.766 3.691 1.946 0.118 0 1.565 2.84 9.659 35.57 48.296 61.407 71.209 64.424 57.193 53.108 52.462 45.768 37.082 33.311 30.936 27.205 24.178 32.422 31.257 23.255 15.685 12.433 11.588 11.596 5.122 5.329 3.46 1.679 1.459 1.686 4.212 6.762 8.422 8.469 13.504 25.613 26.587 38.844 54.594 54.44 44.473 38.846 30.033 24.952 20.631 18.265 17.346 17.806 17.37 16.467 15.1 7.664 5.137 4.69 4.267 4.485 4.263 4.25 4.463 4.252 4.259 2.94 1.652 1.448 1.448 1.448 2.258 2.393 2.102 3.192 4.258 3.815 3.958 6.453 3.757 1.595 1.248 1.139 27-Jan-2024 0.603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.551 3.148 2.786 2.787 2.804 2.788 2.807 2.81 2.798 2.819 5.108 5.576 7.425 7.568 7.055 5.867 5.559 5.58 5.56 7.018 9.772 11.182 11.311 11.275 10.398 8.517 8.549 8.545 7.613 5.781 5.773 5.096 3.591 7.462 7.362 5.703 3.952 1.014 0.843 0.852 0.523 0.805 0.495 0.31 0.207 0.148 0.055 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.337 1.932 2.818 2.801 2.818 2.802 0.12 0 0 0 0 0 28-Jan-2024 0 0 0 0 0 0 0 0 0 0 0.002 0 0 0 0 0 0 0 0 0 0 0.254 4.105 6.742 8.263 5.873 5.466 5.46 5.469 3.732 2.643 2.617 1.407 0.485 0.132 0 0 0 0 0 0 0 0 0 0 0 0.305 2.826 2.836 2.84 1.359 2.845 0.449 0 0 0 0.002 1.736 1.761 1.751 2.761 6.379 4.555 3.448 3.127 1.762 1.591 0.458 0 0.001 0 0 0.101 1.121 0.004 0 0 0 0 0.028 2.759 2.826 2.812 2.814 2.811 3.797 6.259 9.062 10.097 10.12 10.093 5.751 4.535 4.533 4.362 4.216 29-Jan-2024 4.091 3.995 2.18 0.978 0.435 0 0 0 0 0 0 0 0 0 0 0 0 0 0.167 1.043 5.644 16.421 42.128 64.618 69.713 78.306 83.247 80.756 82.278 75.248 72.082 66.701 62.376 58.109 58.443 53.462 49.95 46.24 43.267 36.525 32.439 25.297 24.952 19.309 17.962 14.439 10.333 6.235 4.644 2.489 3.436 3.177 5.028 18.608 32.518 43.318 51.023 58.901 51.323 43.267 40.966 35.597 30.435 27.723 23.407 21.955 20.735 19.96 17.296 13.87 14.435 10.861 6.628 5.66 5.616 3.486 2.816 2.812 2.829 4.576 3.044 2.808 5.064 5.657 5.664 7.89 9.156 10.758 11.588 12.175 11.124 10.841 8.069 5.759 5.535 5.284 30-Jan-2024 3.914 3.253 2.909 2.902 2.898 2.896 2.898 0.426 0 0 0 0 0 0 0 0 0 0 0 0 3.988 14.357 30.821 52.712 71.941 80.226 83.017 79.31 78.091 77.039 81.877 82.246 72.94 69.314 60.952 56.935 58.666 78.971 79.591 67.511 50.869 39.749 35.752 32.777 24.141 21.825 20.329 17.26 15.895 16.381 13.58 15.237 20.233 22.815 23.904 34.591 75.653 78.277 42.244 33.556 22.638 15.633 12.8 7.703 4.466 6.232 9.326 8.903 5.952 3.114 0.751 0.795 0.052 0 0 0 0 0 1.241 2.831 15.824 12.387 9.012 5.601 5.613 8.66 9.899 13.684 13.966 9.178 9.705 7.465 7.414 3.69 2.126 2.879 31-Jan-2024 2.743 0.318 0 0 0.255 0.023 0 0 0 0 0 0 0 0 0.397 0 0 0 0.893 4.265 7.063 16.334 28.253 40.819 52.107 61.469 61.784 57.635 49.4 47.119 47.516 51.66 54.834 52.8 60.026 55.749 39.395 32.394 31.623 30.28 27.163 26.781 23.372 21.885 16.668 10.528 8.28 8.134 9.245 11.116 12.454 15.366 22.496 29.827 30.417 32.253 64.18 59.308 45.191 32.813 27.145 20.934 16.069 14.091 12.192 11.962 9.891 9.28 9.282 6.614 5.896 1.888 0 0.001 0.001 0 0 0 0.669 1.403 2.815 2.807 2.802 3.087 2.043 1.628 4.12 10.338 13.341 13.462 11.593 8.874 7.488 5.472 3.263 2.812
  6 comentarios
Mostrar 4 comentarios más antiguos
Hicham
Hicham el 16 de Feb. de 2024
awesome....thats it.
again thank you for the quick and great help.
Voss
Voss el 16 de Feb. de 2024
Editada: Voss el 16 de Feb. de 2024
You're welcome! Any other questions, let me know.

Iniciar sesión para comentar.

Más respuestas (3)

Mathieu NOE
Mathieu NOE el 14 de Feb. de 2024
Ran in:
i know it's not the cleanest approach , but it works (at least)
out = importdata('EnergyLIS.csv'); % cell array
% now a bit of strrep gymn
out2 = strrep(out(2:end),',"','/"');
out2 = strrep(out2,',','.');
out2 = strrep(out2,'/"',',');
out2 = strrep(out2,'"','');
out3 = [out(1);out2];
% conversion to table
tbl = cell2table(split(out3,','))
tbl = 31×97 table
Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12 Var13 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 Var63 Var64 Var65 Var66 Var67 Var68 Var69 Var70 Var71 Var72 Var73 Var74 Var75 Var76 Var77 Var78 Var79 Var80 Var81 Var82 Var83 Var84 Var85 Var86 Var87 Var88 Var89 Var90 Var91 Var92 Var93 Var94 Var95 Var96 Var97 ______________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ _________ __________ __________ __________ __________ __________ __________ ___________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ _________ _________ _________ _________ __________ __________ _________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ __________ _________ {'Datum' } {'00:00'} {'00:15'} {'00:30'} {'00:45'} {'01:00'} {'01:15'} {'01:30'} {'01:45'} {'02:00'} {'02:15'} {'02:30'} {'02:45'} {'03:00'} {'03:15'} {'03:30'} {'03:45'} {'04:00'} {'04:15'} {'04:30'} {'04:45'} {'05:00' } {'05:15' } {'05:30' } {'05:45' } {'06:00' } {'06:15' } {'06:30' } {'06:45' } {'07:00' } {'07:15' } {'07:30' } {'07:45' } {'08:00' } {'08:15' } {'08:30' } {'08:45' } {'09:00' } {'09:15' } {'09:30' } {'09:45' } {'10:00' } {'10:15' } {'10:30' } {'10:45' } {'11:00' } {'11:15' } {'11:30' } {'11:45' } {'12:00' } {'12:15' } {'12:30' } {'12:45' } {'13:00' } {'13:15' } {'13:30' } {'13:45' } {'14:00' } {'14:15' } {'14:30' } {'14:45' } {'15:00' } {'15:15' } {'15:30' } {'15:45' } {'16:00' } {'16:15' } {'16:30' } {'16:45' } {'17:00' } {'17:15' } {'17:30' } {'17:45' } {'18:00' } {'18:15' } {'18:30' } {'18:45' } {'19:00'} {'19:15'} {'19:30'} {'19:45'} {'20:00' } {'20:15' } {'20:30'} {'20:45' } {'21:00' } {'21:15' } {'21:30' } {'21:45' } {'22:00' } {'22:15' } {'22:30' } {'22:45' } {'23:00' } {'23:15' } {'23:30' } {'23:45'} {'01-16-2024'} {'0' } {'0.58' } {'2.808'} {'2.805'} {'2.813'} {'2.813'} {'2.797'} {'2.817'} {'2.819'} {'2.476'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.555'} {'2.819'} {'9.577' } {'23.35' } {'42.269'} {'62.843'} {'72.287'} {'74.869'} {'81.823' } {'84.279'} {'78.114'} {'75.484'} {'69.806'} {'63.326'} {'54.432'} {'53.215'} {'52.569'} {'53.354'} {'53.185'} {'50.893'} {'43.319'} {'46.548'} {'43.336'} {'40.657'} {'43.293'} {'26.16' } {'19.99' } {'20.694'} {'16.778'} {'15.963'} {'11.468'} {'10.472'} {'10.487'} {'11.731'} {'22.936'} {'26.528'} {'40.116'} {'51.822'} {'63.06' } {'58.533'} {'55.868'} {'46.854'} {'34.659'} {'24.963'} {'19.748'} {'16.207'} {'13.968'} {'13.089'} {'10.679'} {'7.264' } {'7.379' } {'7.399' } {'6.478' } {'6.019' } {'5.507' } {'5.512' } {'5.501' } {'5.508' } {'5.51' } {'3.968'} {'1.399'} {'2.144'} {'2.771' } {'5.371' } {'7.702'} {'8.779' } {'6.725' } {'9.251' } {'16.857'} {'24.982'} {'34.633'} {'28.194'} {'28.543'} {'27.612'} {'20.685'} {'14.526'} {'13.892'} {'12.16'} {'01-17-2024'} {'8.793'} {'8.354'} {'6.327'} {'5.819'} {'5.798'} {'5.567'} {'5.772'} {'3.615'} {'2.803'} {'2.784'} {'3.019'} {'2.792'} {'2.786'} {'0.922'} {'0.215'} {'0' } {'0' } {'0' } {'0.646'} {'1.693'} {'16.073'} {'18.703'} {'50.842'} {'58.587'} {'59.758'} {'62.291'} {'68.434' } {'66.023'} {'61.297'} {'61.539'} {'71.804'} {'74.832'} {'69.938'} {'54.997'} {'43.461'} {'39.526'} {'40.237'} {'38.053'} {'34.837'} {'31.702'} {'23.352'} {'20.434'} {'22.155'} {'19.333'} {'16.47' } {'15.567'} {'16.358'} {'16.722'} {'18.291'} {'10.48' } {'8.639' } {'8.458' } {'12.959'} {'24.771'} {'34.972'} {'64.197'} {'99.029'} {'94.645'} {'80.046'} {'49.654'} {'37.904'} {'29.502'} {'24.083'} {'22.591'} {'20.429'} {'20.193'} {'15.029'} {'13.136'} {'11.187'} {'14.956'} {'14.079'} {'13.983'} {'13.251'} {'7.54' } {'3.945' } {'2.808' } {'2.356'} {'0' } {'0.002'} {'0.187'} {'2.7' } {'2.824' } {'2.752'} {'2.975' } {'3.57' } {'3.153' } {'9.229' } {'12.349'} {'28.236'} {'39.275'} {'18.769'} {'14.353'} {'9.688' } {'6.514' } {'3.456' } {'0.441'} {'01-18-2024'} {'0.507'} {'0.202'} {'0.137'} {'0.082'} {'0.411'} {'0' } {'0' } {'0' } {'0.214'} {'0' } {'0' } {'0' } {'0' } {'0.213'} {'0' } {'0' } {'0' } {'0.297'} {'0' } {'2.222'} {'10.393'} {'20.163'} {'38.942'} {'49.895'} {'66.931'} {'69.099'} {'64.881' } {'58.019'} {'51.546'} {'46.416'} {'43.138'} {'36.898'} {'39.323'} {'38.839'} {'34.772'} {'33.194'} {'32.704'} {'28.594'} {'25.258'} {'28.522'} {'28.351'} {'24.611'} {'20.707'} {'16.979'} {'15.141'} {'15.132'} {'13.597'} {'12.701'} {'13.259'} {'14.74' } {'13.161'} {'15.592'} {'21.183'} {'24.87' } {'29.387'} {'42.109'} {'54.716'} {'54.567'} {'46.48' } {'38.179'} {'25.299'} {'13.621'} {'10.669'} {'9.169' } {'3.464' } {'4.882' } {'4.548' } {'5.037' } {'3.493' } {'4.039' } {'5.042' } {'2.794' } {'2.792' } {'2.791' } {'2.785' } {'2.783' } {'2.397'} {'2.637'} {'2.636'} {'2.65' } {'6.909' } {'7.741' } {'8.752'} {'10.572'} {'10.675'} {'11.024'} {'13.943'} {'20.745'} {'21.204'} {'24.66' } {'22.882'} {'20.613'} {'14.697'} {'9.432' } {'7.302' } {'7.152'} {'01-19-2024'} {'7.297'} {'6.994'} {'6.876'} {'6.693'} {'4.241'} {'3.966'} {'3.97' } {'3.963'} {'4.289'} {'3.942'} {'3.936'} {'3.927'} {'4.202'} {'1.178'} {'1.151'} {'0.985'} {'1.157'} {'1.464'} {'1.147'} {'2.197'} {'10.504'} {'25.687'} {'37.01' } {'57.468'} {'61.466'} {'64.225'} {'67.325' } {'60.447'} {'49.667'} {'48.288'} {'52.404'} {'45.56' } {'50.17' } {'41.204'} {'36.873'} {'34.685'} {'35.776'} {'37.228'} {'36.833'} {'37.569'} {'36.595'} {'33.658'} {'29.26' } {'24.963'} {'22.052'} {'19.983'} {'14.799'} {'13.245'} {'12.766'} {'10.899'} {'10.72' } {'8.194' } {'12.635'} {'23.693'} {'33.338'} {'51.208'} {'60.487'} {'62.773'} {'66.283'} {'45.056'} {'32.955'} {'26.158'} {'21.082'} {'20.223'} {'15.824'} {'14.853'} {'10.294'} {'9.84' } {'9.446' } {'8.335' } {'8.09' } {'7.256' } {'6.771' } {'4.28' } {'5.536' } {'5.517' } {'4.98' } {'2.797'} {'0.519'} {'0' } {'0.078' } {'0' } {'0' } {'0.162' } {'3.719' } {'9.06' } {'11.965'} {'19.447'} {'17.164'} {'21.808'} {'22.454'} {'21.937'} {'16.817'} {'7.784' } {'9.069' } {'5.858'} {'01-20-2024'} {'5.786'} {'5.785'} {'5.722'} {'5.597'} {'2.252'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'1.248' } {'1.289' } {'2.568' } {'3.114' } {'2.988' } {'2.8' } {'2.801' } {'2.799' } {'2.779' } {'2.794' } {'2.796' } {'2.783' } {'3.272' } {'3.433' } {'2.804' } {'2.815' } {'2.796' } {'2.802' } {'2.815' } {'2.795' } {'2.801' } {'2.804' } {'2.808' } {'4.589' } {'2.81' } {'2.726' } {'0.583' } {'2.417' } {'3.636' } {'3.72' } {'3.925' } {'3.695' } {'4.843' } {'5.62' } {'8.001' } {'8.374' } {'8.356' } {'8.356' } {'8.339' } {'8.339' } {'8.349' } {'7.702' } {'5.958' } {'5.563' } {'5.567' } {'5.026' } {'3.123' } {'2.804' } {'1.365' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'2.193'} {'4.87' } {'3.551' } {'1.96' } {'1.589' } {'0.17' } {'0' } {'0' } {'0.671' } {'0.663' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'01-21-2024'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0.19' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'2.535' } {'2.367' } {'0' } {'0' } {'0' } {'0' } {'0' } {'1.09' } {'2.834' } {'2.84' } {'2.845' } {'2.845' } {'2.846' } {'2.831' } {'2.859' } {'2.843' } {'2.864' } {'2.855' } {'2.851' } {'2.86' } {'1.421' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'1.036'} {'2.785'} {'2.798'} {'2.799' } {'0.696' } {'0' } {'0' } {'0' } {'1.518' } {'1.824' } {'4.394' } {'4.603' } {'3.236' } {'2.779' } {'2.78' } {'2.781' } {'2.764' } {'2.778' } {'2.795'} {'01-22-2024'} {'2.768'} {'2.822'} {'2.808'} {'2.82' } {'2.823'} {'2.822'} {'2.818'} {'2.82' } {'2.819'} {'2.82' } {'2.818'} {'2.814'} {'2.804'} {'1.533'} {'0' } {'0' } {'0' } {'0.002'} {'0' } {'2.097'} {'10.276'} {'37.099'} {'64.181'} {'81.681'} {'87.109'} {'98.691'} {'101.225'} {'86.954'} {'80.581'} {'65.926'} {'58.538'} {'63.237'} {'73.318'} {'73.779'} {'74.354'} {'70.375'} {'58.568'} {'57.945'} {'45.352'} {'42.325'} {'38.27' } {'34.281'} {'29.629'} {'25.214'} {'27.698'} {'22.215'} {'17.372'} {'13.047'} {'12.949'} {'12.085'} {'13.523'} {'14.161'} {'18.736'} {'25.478'} {'38.336'} {'49.217'} {'53.57' } {'52.728'} {'52.151'} {'46.37' } {'42.111'} {'34.139'} {'29.566'} {'23.916'} {'23.209'} {'21.153'} {'19.386'} {'17.12' } {'13.594'} {'13.989'} {'13.535'} {'13.583'} {'12.417'} {'11.587'} {'10.952'} {'10.599'} {'6.157'} {'4.429'} {'2.719'} {'0.302'} {'1.608' } {'2.852' } {'5.419'} {'5.645' } {'6.254' } {'5.521' } {'5.166' } {'7.398' } {'8.678' } {'9.681' } {'9.011' } {'9.603' } {'7.691' } {'5.636' } {'5.596' } {'5.603'} {'01-23-2024'} {'5.608'} {'5.613'} {'5.616'} {'5.61' } {'5.596'} {'5.612'} {'5.606'} {'5.588'} {'5.622'} {'5.591'} {'4.517'} {'2.821'} {'2.828'} {'2.819'} {'2.806'} {'1.429'} {'0.642'} {'0.95' } {'0.934'} {'1.67' } {'4.956' } {'27.87' } {'49.803'} {'67.664'} {'84.104'} {'81.197'} {'75.925' } {'60.944'} {'56.956'} {'65.769'} {'71.611'} {'77.047'} {'80.211'} {'80.282'} {'70.152'} {'69.38' } {'69.696'} {'66.56' } {'63.596'} {'63.242'} {'60.829'} {'53.027'} {'42.486'} {'37.499'} {'28.868'} {'22.03' } {'18.447'} {'18.872'} {'18.767'} {'15.185'} {'13.064'} {'14.126'} {'18.435'} {'23.19' } {'33.604'} {'43.689'} {'51.55' } {'45.205'} {'44.116'} {'37.991'} {'34.55' } {'29.07' } {'23.254'} {'17.135'} {'14.216'} {'10.518'} {'8.089' } {'7.569' } {'9.011' } {'8.504' } {'7.198' } {'6.613' } {'6.993' } {'6.462' } {'6.455' } {'6.442' } {'6.01' } {'4.745'} {'4.857'} {'7.12' } {'9.176' } {'9.711' } {'6.751'} {'4.428' } {'4.687' } {'9.344' } {'12.24' } {'9.207' } {'8.856' } {'8.541' } {'11.816'} {'10.794'} {'9.446' } {'8.207' } {'8.237' } {'8.211'} {'01-24-2024'} {'8.207'} {'8.19' } {'8.201'} {'8.074'} {'6.592'} {'5.821'} {'5.554'} {'5.581'} {'5.842'} {'6.528'} {'6.346'} {'5.266'} {'3.436'} {'3.484'} {'3.473'} {'3.09' } {'2.802'} {'3.389'} {'1.023'} {'3.512'} {'10.802'} {'34.45' } {'49.679'} {'70.04' } {'68.276'} {'60.575'} {'49.677' } {'47.835'} {'76.674'} {'76.174'} {'90.454'} {'80.571'} {'60.839'} {'53.114'} {'46.012'} {'42.094'} {'39.411'} {'39.372'} {'37.508'} {'21.78' } {'17.108'} {'17.499'} {'17.159'} {'16.81' } {'11.941'} {'11.277'} {'9.12' } {'10.054'} {'12.148'} {'12.271'} {'14.639'} {'15.744'} {'15.034'} {'23.343'} {'39.309'} {'54.535'} {'62.153'} {'62.073'} {'52.188'} {'42.177'} {'32.45' } {'21.213'} {'18.164'} {'13.591'} {'12.594'} {'7.969' } {'9.359' } {'9.139' } {'6.197' } {'4.062' } {'3.543' } {'5.022' } {'7.932' } {'6.503' } {'5.124' } {'2.638' } {'0' } {'0' } {'0' } {'0' } {'0.001' } {'1.773' } {'2.786'} {'2.784' } {'1.093' } {'2.025' } {'8.271' } {'7.759' } {'7.941' } {'6.034' } {'5.768' } {'5.496' } {'4.224' } {'2.884' } {'2.806' } {'2.805'} {'01-25-2024'} {'2.805'} {'2.809'} {'2.812'} {'2.816'} {'2.818'} {'2.815'} {'2.817'} {'2.816'} {'2.823'} {'2.812'} {'2.828'} {'2.812'} {'2.635'} {'0' } {'0' } {'0' } {'0.038'} {'0.981'} {'0.86' } {'0.71' } {'7.744' } {'28.409'} {'38.188'} {'42.679'} {'49.859'} {'54.294'} {'56.38' } {'53.666'} {'50.211'} {'52.226'} {'53.525'} {'51.689'} {'58.488'} {'59.244'} {'65.383'} {'59.97' } {'51.191'} {'49.924'} {'42.612'} {'37.87' } {'36.152'} {'34.031'} {'30.354'} {'20.121'} {'14.41' } {'9.927' } {'11.105'} {'11.117'} {'11.812'} {'11.175'} {'10.362'} {'8.395' } {'14.675'} {'17.505'} {'24.116'} {'38.168'} {'50.972'} {'44.266'} {'39.299'} {'34.682'} {'27.407'} {'22.279'} {'18.34' } {'18.987'} {'12.616'} {'6.914' } {'5.173' } {'7.113' } {'4.223' } {'7.531' } {'5.383' } {'3.588' } {'1.874' } {'0.916' } {'1.113' } {'3.732' } {'3.737'} {'3.745'} {'3.227'} {'2.799'} {'2.794' } {'2.795' } {'2.795'} {'2.79' } {'3.012' } {'6.534' } {'7.224' } {'8.465' } {'7.67' } {'8.427' } {'9.735' } {'10.624'} {'9.007' } {'8.375' } {'6.233' } {'5.607'} {'01-26-2024'} {'5.615'} {'5.617'} {'5.611'} {'5.613'} {'5.595'} {'4.616'} {'2.806'} {'2.823'} {'2.84' } {'2.812'} {'2.823'} {'2.795'} {'2.986'} {'3.766'} {'3.691'} {'1.946'} {'0.118'} {'0' } {'1.565'} {'2.84' } {'9.659' } {'35.57' } {'48.296'} {'61.407'} {'71.209'} {'64.424'} {'57.193' } {'53.108'} {'52.462'} {'45.768'} {'37.082'} {'33.311'} {'30.936'} {'27.205'} {'24.178'} {'32.422'} {'31.257'} {'23.255'} {'15.685'} {'12.433'} {'11.588'} {'11.596'} {'5.122' } {'5.329' } {'3.46' } {'1.679' } {'1.459' } {'1.686' } {'4.212' } {'6.762' } {'8.422' } {'8.469' } {'13.504'} {'25.613'} {'26.587'} {'38.844'} {'54.594'} {'54.44' } {'44.473'} {'38.846'} {'30.033'} {'24.952'} {'20.631'} {'18.265'} {'17.346'} {'17.806'} {'17.37' } {'16.467'} {'15.1' } {'7.664' } {'5.137' } {'4.69' } {'4.267' } {'4.485' } {'4.263' } {'4.25' } {'4.463'} {'4.252'} {'4.259'} {'2.94' } {'1.652' } {'1.448' } {'1.448'} {'1.448' } {'2.258' } {'2.393' } {'2.102' } {'3.192' } {'4.258' } {'3.815' } {'3.958' } {'6.453' } {'3.757' } {'1.595' } {'1.248' } {'1.139'} {'01-27-2024'} {'0.603'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.551' } {'3.148' } {'2.786' } {'2.787' } {'2.804' } {'2.788' } {'2.807' } {'2.81' } {'2.798' } {'2.819' } {'5.108' } {'5.576' } {'7.425' } {'7.568' } {'7.055' } {'5.867' } {'5.559' } {'5.58' } {'5.56' } {'7.018' } {'9.772' } {'11.182'} {'11.311'} {'11.275'} {'10.398'} {'8.517' } {'8.549' } {'8.545' } {'7.613' } {'5.781' } {'5.773' } {'5.096' } {'3.591' } {'7.462' } {'7.362' } {'5.703' } {'3.952' } {'1.014' } {'0.843' } {'0.852' } {'0.523' } {'0.805' } {'0.495' } {'0.31' } {'0.207' } {'0.148' } {'0.055' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.337' } {'1.932' } {'2.818' } {'2.801' } {'2.818' } {'2.802' } {'0.12' } {'0' } {'0' } {'0' } {'0' } {'0' } {'01-28-2024'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.002'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.254' } {'4.105' } {'6.742' } {'8.263' } {'5.873' } {'5.466' } {'5.46' } {'5.469' } {'3.732' } {'2.643' } {'2.617' } {'1.407' } {'0.485' } {'0.132' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.305' } {'2.826' } {'2.836' } {'2.84' } {'1.359' } {'2.845' } {'0.449' } {'0' } {'0' } {'0' } {'0.002' } {'1.736' } {'1.761' } {'1.751' } {'2.761' } {'6.379' } {'4.555' } {'3.448' } {'3.127' } {'1.762' } {'1.591' } {'0.458' } {'0' } {'0.001' } {'0' } {'0' } {'0.101' } {'1.121' } {'0.004' } {'0' } {'0' } {'0' } {'0' } {'0.028'} {'2.759' } {'2.826' } {'2.812'} {'2.814' } {'2.811' } {'3.797' } {'6.259' } {'9.062' } {'10.097'} {'10.12' } {'10.093'} {'5.751' } {'4.535' } {'4.533' } {'4.362' } {'4.216'} {'01-29-2024'} {'4.091'} {'3.995'} {'2.18' } {'0.978'} {'0.435'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0.167'} {'1.043'} {'5.644' } {'16.421'} {'42.128'} {'64.618'} {'69.713'} {'78.306'} {'83.247' } {'80.756'} {'82.278'} {'75.248'} {'72.082'} {'66.701'} {'62.376'} {'58.109'} {'58.443'} {'53.462'} {'49.95' } {'46.24' } {'43.267'} {'36.525'} {'32.439'} {'25.297'} {'24.952'} {'19.309'} {'17.962'} {'14.439'} {'10.333'} {'6.235' } {'4.644' } {'2.489' } {'3.436' } {'3.177' } {'5.028' } {'18.608'} {'32.518'} {'43.318'} {'51.023'} {'58.901'} {'51.323'} {'43.267'} {'40.966'} {'35.597'} {'30.435'} {'27.723'} {'23.407'} {'21.955'} {'20.735'} {'19.96' } {'17.296'} {'13.87' } {'14.435'} {'10.861'} {'6.628' } {'5.66' } {'5.616' } {'3.486' } {'2.816'} {'2.812'} {'2.829'} {'4.576'} {'3.044' } {'2.808' } {'5.064'} {'5.657' } {'5.664' } {'7.89' } {'9.156' } {'10.758'} {'11.588'} {'12.175'} {'11.124'} {'10.841'} {'8.069' } {'5.759' } {'5.535' } {'5.284'} {'01-30-2024'} {'3.914'} {'3.253'} {'2.909'} {'2.902'} {'2.898'} {'2.896'} {'2.898'} {'0.426'} {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'0' } {'3.988' } {'14.357'} {'30.821'} {'52.712'} {'71.941'} {'80.226'} {'83.017' } {'79.31' } {'78.091'} {'77.039'} {'81.877'} {'82.246'} {'72.94' } {'69.314'} {'60.952'} {'56.935'} {'58.666'} {'78.971'} {'79.591'} {'67.511'} {'50.869'} {'39.749'} {'35.752'} {'32.777'} {'24.141'} {'21.825'} {'20.329'} {'17.26' } {'15.895'} {'16.381'} {'13.58' } {'15.237'} {'20.233'} {'22.815'} {'23.904'} {'34.591'} {'75.653'} {'78.277'} {'42.244'} {'33.556'} {'22.638'} {'15.633'} {'12.8' } {'7.703' } {'4.466' } {'6.232' } {'9.326' } {'8.903' } {'5.952' } {'3.114' } {'0.751' } {'0.795' } {'0.052' } {'0' } {'0' } {'0' } {'0' } {'0' } {'1.241'} {'2.831'} {'15.824'} {'12.387'} {'9.012'} {'5.601' } {'5.613' } {'8.66' } {'9.899' } {'13.684'} {'13.966'} {'9.178' } {'9.705' } {'7.465' } {'7.414' } {'3.69' } {'2.126' } {'2.879'}
Stephen23
Stephen23 el 16 de Feb. de 2024
Editada: Stephen23 el 16 de Feb. de 2024
Ran in:
Lets fix the file so that it is formatted as a proper CSV file. Then importing it is trivial.
S = readlines('EnergyLIS.csv') % uurrggh, what a mess!
S = 32×1 string array
"Datum,00:00,00:15,00:30,00:45,01:00,01:15,01:30,01:45,02:00,02:15,02:30,02:45,03:00,03:15,03:30,03:45,04:00,04:15,04:30,04:45,05:00,05:15,05:30,05:45,06:00,06:15,06:30,06:45,07:00,07:15,07:30,07:45,08:00,08:15,08:30,08:45,09:00,09:15,09:30,09:45,10:00,10:15,10:30,10:45,11:00,11:15,11:30,11:45,12:00,12:15,12:30,12:45,13:00,13:15,13:30,13:45,14:00,14:15,14:30,14:45,15:00,15:15,15:30,15:45,16:00,16:15,16:30,16:45,17:00,17:15,17:30,17:45,18:00,18:15,18:30,18:45,19:00,19:15,19:30,19:45,20:00,20:15,20:30,20:45,21:00,21:15,21:30,21:45,22:00,22:15,22:30,22:45,23:00,23:15,23:30,23:45" ""01-16-2024,""0"",""0,58"",""2,808"",""2,805"",""2,813"",""2,813"",""2,797"",""2,817"",""2,819"",""2,476"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,555"",""2,819"",""9,577"",""23,35"",""42,269"",""62,843"",""72,287"",""74,869"",""81,823"",""84,279"",""78,114"",""75,484"",""69,806"",""63,326"",""54,432"",""53,215"",""52,569"",""53,354"",""53,185"",""50,893"",""43,319"",""46,548"",""43,336"",""40,657"",""43,293"",""26,16"",""19,99"",""20,694"",""16,778"",""15,963"",""11,468"",""10,472"",""10,487"",""11,731"",""22,936"",""26,528"",""40,116"",""51,822"",""63,06"",""58,533"",""55,868"",""46,854"",""34,659"",""24,963"",""19,748"",""16,207"",""13,968"",""13,089"",""10,679"",""7,264"",""7,379"",""7,399"",""6,478"",""6,019"",""5,507"",""5,512"",""5,501"",""5,508"",""5,51"",""3,968"",""1,399"",""2,144"",""2,771"",""5,371"",""7,702"",""8,779"",""6,725"",""9,251"",""16,857"",""24,982"",""34,633"",""28,194"",""28,543"",""27,612"",""20,685"",""14,526"",""13,892"",""12,16"""" ""01-17-2024,""8,793"",""8,354"",""6,327"",""5,819"",""5,798"",""5,567"",""5,772"",""3,615"",""2,803"",""2,784"",""3,019"",""2,792"",""2,786"",""0,922"",""0,215"",""0"",""0"",""0"",""0,646"",""1,693"",""16,073"",""18,703"",""50,842"",""58,587"",""59,758"",""62,291"",""68,434"",""66,023"",""61,297"",""61,539"",""71,804"",""74,832"",""69,938"",""54,997"",""43,461"",""39,526"",""40,237"",""38,053"",""34,837"",""31,702"",""23,352"",""20,434"",""22,155"",""19,333"",""16,47"",""15,567"",""16,358"",""16,722"",""18,291"",""10,48"",""8,639"",""8,458"",""12,959"",""24,771"",""34,972"",""64,197"",""99,029"",""94,645"",""80,046"",""49,654"",""37,904"",""29,502"",""24,083"",""22,591"",""20,429"",""20,193"",""15,029"",""13,136"",""11,187"",""14,956"",""14,079"",""13,983"",""13,251"",""7,54"",""3,945"",""2,808"",""2,356"",""0"",""0,002"",""0,187"",""2,7"",""2,824"",""2,752"",""2,975"",""3,57"",""3,153"",""9,229"",""12,349"",""28,236"",""39,275"",""18,769"",""14,353"",""9,688"",""6,514"",""3,456"",""0,441"""" ""01-18-2024,""0,507"",""0,202"",""0,137"",""0,082"",""0,411"",""0"",""0"",""0"",""0,214"",""0"",""0"",""0"",""0"",""0,213"",""0"",""0"",""0"",""0,297"",""0"",""2,222"",""10,393"",""20,163"",""38,942"",""49,895"",""66,931"",""69,099"",""64,881"",""58,019"",""51,546"",""46,416"",""43,138"",""36,898"",""39,323"",""38,839"",""34,772"",""33,194"",""32,704"",""28,594"",""25,258"",""28,522"",""28,351"",""24,611"",""20,707"",""16,979"",""15,141"",""15,132"",""13,597"",""12,701"",""13,259"",""14,74"",""13,161"",""15,592"",""21,183"",""24,87"",""29,387"",""42,109"",""54,716"",""54,567"",""46,48"",""38,179"",""25,299"",""13,621"",""10,669"",""9,169"",""3,464"",""4,882"",""4,548"",""5,037"",""3,493"",""4,039"",""5,042"",""2,794"",""2,792"",""2,791"",""2,785"",""2,783"",""2,397"",""2,637"",""2,636"",""2,65"",""6,909"",""7,741"",""8,752"",""10,572"",""10,675"",""11,024"",""13,943"",""20,745"",""21,204"",""24,66"",""22,882"",""20,613"",""14,697"",""9,432"",""7,302"",""7,152"""" ""01-19-2024,""7,297"",""6,994"",""6,876"",""6,693"",""4,241"",""3,966"",""3,97"",""3,963"",""4,289"",""3,942"",""3,936"",""3,927"",""4,202"",""1,178"",""1,151"",""0,985"",""1,157"",""1,464"",""1,147"",""2,197"",""10,504"",""25,687"",""37,01"",""57,468"",""61,466"",""64,225"",""67,325"",""60,447"",""49,667"",""48,288"",""52,404"",""45,56"",""50,17"",""41,204"",""36,873"",""34,685"",""35,776"",""37,228"",""36,833"",""37,569"",""36,595"",""33,658"",""29,26"",""24,963"",""22,052"",""19,983"",""14,799"",""13,245"",""12,766"",""10,899"",""10,72"",""8,194"",""12,635"",""23,693"",""33,338"",""51,208"",""60,487"",""62,773"",""66,283"",""45,056"",""32,955"",""26,158"",""21,082"",""20,223"",""15,824"",""14,853"",""10,294"",""9,84"",""9,446"",""8,335"",""8,09"",""7,256"",""6,771"",""4,28"",""5,536"",""5,517"",""4,98"",""2,797"",""0,519"",""0"",""0,078"",""0"",""0"",""0,162"",""3,719"",""9,06"",""11,965"",""19,447"",""17,164"",""21,808"",""22,454"",""21,937"",""16,817"",""7,784"",""9,069"",""5,858"""" ""01-20-2024,""5,786"",""5,785"",""5,722"",""5,597"",""2,252"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""1,248"",""1,289"",""2,568"",""3,114"",""2,988"",""2,8"",""2,801"",""2,799"",""2,779"",""2,794"",""2,796"",""2,783"",""3,272"",""3,433"",""2,804"",""2,815"",""2,796"",""2,802"",""2,815"",""2,795"",""2,801"",""2,804"",""2,808"",""4,589"",""2,81"",""2,726"",""0,583"",""2,417"",""3,636"",""3,72"",""3,925"",""3,695"",""4,843"",""5,62"",""8,001"",""8,374"",""8,356"",""8,356"",""8,339"",""8,339"",""8,349"",""7,702"",""5,958"",""5,563"",""5,567"",""5,026"",""3,123"",""2,804"",""1,365"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""2,193"",""4,87"",""3,551"",""1,96"",""1,589"",""0,17"",""0"",""0"",""0,671"",""0,663"",""0"",""0"",""0"",""0"",""0"",""0"",""0"""" ""01-21-2024,""0"",""0"",""0"",""0"",""0"",""0,19"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""2,535"",""2,367"",""0"",""0"",""0"",""0"",""0"",""1,09"",""2,834"",""2,84"",""2,845"",""2,845"",""2,846"",""2,831"",""2,859"",""2,843"",""2,864"",""2,855"",""2,851"",""2,86"",""1,421"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""1,036"",""2,785"",""2,798"",""2,799"",""0,696"",""0"",""0"",""0"",""1,518"",""1,824"",""4,394"",""4,603"",""3,236"",""2,779"",""2,78"",""2,781"",""2,764"",""2,778"",""2,795"""" ""01-22-2024,""2,768"",""2,822"",""2,808"",""2,82"",""2,823"",""2,822"",""2,818"",""2,82"",""2,819"",""2,82"",""2,818"",""2,814"",""2,804"",""1,533"",""0"",""0"",""0"",""0,002"",""0"",""2,097"",""10,276"",""37,099"",""64,181"",""81,681"",""87,109"",""98,691"",""101,225"",""86,954"",""80,581"",""65,926"",""58,538"",""63,237"",""73,318"",""73,779"",""74,354"",""70,375"",""58,568"",""57,945"",""45,352"",""42,325"",""38,27"",""34,281"",""29,629"",""25,214"",""27,698"",""22,215"",""17,372"",""13,047"",""12,949"",""12,085"",""13,523"",""14,161"",""18,736"",""25,478"",""38,336"",""49,217"",""53,57"",""52,728"",""52,151"",""46,37"",""42,111"",""34,139"",""29,566"",""23,916"",""23,209"",""21,153"",""19,386"",""17,12"",""13,594"",""13,989"",""13,535"",""13,583"",""12,417"",""11,587"",""10,952"",""10,599"",""6,157"",""4,429"",""2,719"",""0,302"",""1,608"",""2,852"",""5,419"",""5,645"",""6,254"",""5,521"",""5,166"",""7,398"",""8,678"",""9,681"",""9,011"",""9,603"",""7,691"",""5,636"",""5,596"",""5,603"""" ""01-23-2024,""5,608"",""5,613"",""5,616"",""5,61"",""5,596"",""5,612"",""5,606"",""5,588"",""5,622"",""5,591"",""4,517"",""2,821"",""2,828"",""2,819"",""2,806"",""1,429"",""0,642"",""0,95"",""0,934"",""1,67"",""4,956"",""27,87"",""49,803"",""67,664"",""84,104"",""81,197"",""75,925"",""60,944"",""56,956"",""65,769"",""71,611"",""77,047"",""80,211"",""80,282"",""70,152"",""69,38"",""69,696"",""66,56"",""63,596"",""63,242"",""60,829"",""53,027"",""42,486"",""37,499"",""28,868"",""22,03"",""18,447"",""18,872"",""18,767"",""15,185"",""13,064"",""14,126"",""18,435"",""23,19"",""33,604"",""43,689"",""51,55"",""45,205"",""44,116"",""37,991"",""34,55"",""29,07"",""23,254"",""17,135"",""14,216"",""10,518"",""8,089"",""7,569"",""9,011"",""8,504"",""7,198"",""6,613"",""6,993"",""6,462"",""6,455"",""6,442"",""6,01"",""4,745"",""4,857"",""7,12"",""9,176"",""9,711"",""6,751"",""4,428"",""4,687"",""9,344"",""12,24"",""9,207"",""8,856"",""8,541"",""11,816"",""10,794"",""9,446"",""8,207"",""8,237"",""8,211"""" ""01-24-2024,""8,207"",""8,19"",""8,201"",""8,074"",""6,592"",""5,821"",""5,554"",""5,581"",""5,842"",""6,528"",""6,346"",""5,266"",""3,436"",""3,484"",""3,473"",""3,09"",""2,802"",""3,389"",""1,023"",""3,512"",""10,802"",""34,45"",""49,679"",""70,04"",""68,276"",""60,575"",""49,677"",""47,835"",""76,674"",""76,174"",""90,454"",""80,571"",""60,839"",""53,114"",""46,012"",""42,094"",""39,411"",""39,372"",""37,508"",""21,78"",""17,108"",""17,499"",""17,159"",""16,81"",""11,941"",""11,277"",""9,12"",""10,054"",""12,148"",""12,271"",""14,639"",""15,744"",""15,034"",""23,343"",""39,309"",""54,535"",""62,153"",""62,073"",""52,188"",""42,177"",""32,45"",""21,213"",""18,164"",""13,591"",""12,594"",""7,969"",""9,359"",""9,139"",""6,197"",""4,062"",""3,543"",""5,022"",""7,932"",""6,503"",""5,124"",""2,638"",""0"",""0"",""0"",""0"",""0,001"",""1,773"",""2,786"",""2,784"",""1,093"",""2,025"",""8,271"",""7,759"",""7,941"",""6,034"",""5,768"",""5,496"",""4,224"",""2,884"",""2,806"",""2,805"""" ""01-25-2024,""2,805"",""2,809"",""2,812"",""2,816"",""2,818"",""2,815"",""2,817"",""2,816"",""2,823"",""2,812"",""2,828"",""2,812"",""2,635"",""0"",""0"",""0"",""0,038"",""0,981"",""0,86"",""0,71"",""7,744"",""28,409"",""38,188"",""42,679"",""49,859"",""54,294"",""56,38"",""53,666"",""50,211"",""52,226"",""53,525"",""51,689"",""58,488"",""59,244"",""65,383"",""59,97"",""51,191"",""49,924"",""42,612"",""37,87"",""36,152"",""34,031"",""30,354"",""20,121"",""14,41"",""9,927"",""11,105"",""11,117"",""11,812"",""11,175"",""10,362"",""8,395"",""14,675"",""17,505"",""24,116"",""38,168"",""50,972"",""44,266"",""39,299"",""34,682"",""27,407"",""22,279"",""18,34"",""18,987"",""12,616"",""6,914"",""5,173"",""7,113"",""4,223"",""7,531"",""5,383"",""3,588"",""1,874"",""0,916"",""1,113"",""3,732"",""3,737"",""3,745"",""3,227"",""2,799"",""2,794"",""2,795"",""2,795"",""2,79"",""3,012"",""6,534"",""7,224"",""8,465"",""7,67"",""8,427"",""9,735"",""10,624"",""9,007"",""8,375"",""6,233"",""5,607"""" ""01-26-2024,""5,615"",""5,617"",""5,611"",""5,613"",""5,595"",""4,616"",""2,806"",""2,823"",""2,84"",""2,812"",""2,823"",""2,795"",""2,986"",""3,766"",""3,691"",""1,946"",""0,118"",""0"",""1,565"",""2,84"",""9,659"",""35,57"",""48,296"",""61,407"",""71,209"",""64,424"",""57,193"",""53,108"",""52,462"",""45,768"",""37,082"",""33,311"",""30,936"",""27,205"",""24,178"",""32,422"",""31,257"",""23,255"",""15,685"",""12,433"",""11,588"",""11,596"",""5,122"",""5,329"",""3,46"",""1,679"",""1,459"",""1,686"",""4,212"",""6,762"",""8,422"",""8,469"",""13,504"",""25,613"",""26,587"",""38,844"",""54,594"",""54,44"",""44,473"",""38,846"",""30,033"",""24,952"",""20,631"",""18,265"",""17,346"",""17,806"",""17,37"",""16,467"",""15,1"",""7,664"",""5,137"",""4,69"",""4,267"",""4,485"",""4,263"",""4,25"",""4,463"",""4,252"",""4,259"",""2,94"",""1,652"",""1,448"",""1,448"",""1,448"",""2,258"",""2,393"",""2,102"",""3,192"",""4,258"",""3,815"",""3,958"",""6,453"",""3,757"",""1,595"",""1,248"",""1,139"""" ""01-27-2024,""0,603"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,551"",""3,148"",""2,786"",""2,787"",""2,804"",""2,788"",""2,807"",""2,81"",""2,798"",""2,819"",""5,108"",""5,576"",""7,425"",""7,568"",""7,055"",""5,867"",""5,559"",""5,58"",""5,56"",""7,018"",""9,772"",""11,182"",""11,311"",""11,275"",""10,398"",""8,517"",""8,549"",""8,545"",""7,613"",""5,781"",""5,773"",""5,096"",""3,591"",""7,462"",""7,362"",""5,703"",""3,952"",""1,014"",""0,843"",""0,852"",""0,523"",""0,805"",""0,495"",""0,31"",""0,207"",""0,148"",""0,055"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,337"",""1,932"",""2,818"",""2,801"",""2,818"",""2,802"",""0,12"",""0"",""0"",""0"",""0"",""0"""" ""01-28-2024,""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,002"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,254"",""4,105"",""6,742"",""8,263"",""5,873"",""5,466"",""5,46"",""5,469"",""3,732"",""2,643"",""2,617"",""1,407"",""0,485"",""0,132"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,305"",""2,826"",""2,836"",""2,84"",""1,359"",""2,845"",""0,449"",""0"",""0"",""0"",""0,002"",""1,736"",""1,761"",""1,751"",""2,761"",""6,379"",""4,555"",""3,448"",""3,127"",""1,762"",""1,591"",""0,458"",""0"",""0,001"",""0"",""0"",""0,101"",""1,121"",""0,004"",""0"",""0"",""0"",""0"",""0,028"",""2,759"",""2,826"",""2,812"",""2,814"",""2,811"",""3,797"",""6,259"",""9,062"",""10,097"",""10,12"",""10,093"",""5,751"",""4,535"",""4,533"",""4,362"",""4,216"""" ""01-29-2024,""4,091"",""3,995"",""2,18"",""0,978"",""0,435"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,167"",""1,043"",""5,644"",""16,421"",""42,128"",""64,618"",""69,713"",""78,306"",""83,247"",""80,756"",""82,278"",""75,248"",""72,082"",""66,701"",""62,376"",""58,109"",""58,443"",""53,462"",""49,95"",""46,24"",""43,267"",""36,525"",""32,439"",""25,297"",""24,952"",""19,309"",""17,962"",""14,439"",""10,333"",""6,235"",""4,644"",""2,489"",""3,436"",""3,177"",""5,028"",""18,608"",""32,518"",""43,318"",""51,023"",""58,901"",""51,323"",""43,267"",""40,966"",""35,597"",""30,435"",""27,723"",""23,407"",""21,955"",""20,735"",""19,96"",""17,296"",""13,87"",""14,435"",""10,861"",""6,628"",""5,66"",""5,616"",""3,486"",""2,816"",""2,812"",""2,829"",""4,576"",""3,044"",""2,808"",""5,064"",""5,657"",""5,664"",""7,89"",""9,156"",""10,758"",""11,588"",""12,175"",""11,124"",""10,841"",""8,069"",""5,759"",""5,535"",""5,284"""" ""01-30-2024,""3,914"",""3,253"",""2,909"",""2,902"",""2,898"",""2,896"",""2,898"",""0,426"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""3,988"",""14,357"",""30,821"",""52,712"",""71,941"",""80,226"",""83,017"",""79,31"",""78,091"",""77,039"",""81,877"",""82,246"",""72,94"",""69,314"",""60,952"",""56,935"",""58,666"",""78,971"",""79,591"",""67,511"",""50,869"",""39,749"",""35,752"",""32,777"",""24,141"",""21,825"",""20,329"",""17,26"",""15,895"",""16,381"",""13,58"",""15,237"",""20,233"",""22,815"",""23,904"",""34,591"",""75,653"",""78,277"",""42,244"",""33,556"",""22,638"",""15,633"",""12,8"",""7,703"",""4,466"",""6,232"",""9,326"",""8,903"",""5,952"",""3,114"",""0,751"",""0,795"",""0,052"",""0"",""0"",""0"",""0"",""0"",""1,241"",""2,831"",""15,824"",""12,387"",""9,012"",""5,601"",""5,613"",""8,66"",""9,899"",""13,684"",""13,966"",""9,178"",""9,705"",""7,465"",""7,414"",""3,69"",""2,126"",""2,879"""" ""01-31-2024,""2,743"",""0,318"",""0"",""0"",""0,255"",""0,023"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,397"",""0"",""0"",""0"",""0,893"",""4,265"",""7,063"",""16,334"",""28,253"",""40,819"",""52,107"",""61,469"",""61,784"",""57,635"",""49,4"",""47,119"",""47,516"",""51,66"",""54,834"",""52,8"",""60,026"",""55,749"",""39,395"",""32,394"",""31,623"",""30,28"",""27,163"",""26,781"",""23,372"",""21,885"",""16,668"",""10,528"",""8,28"",""8,134"",""9,245"",""11,116"",""12,454"",""15,366"",""22,496"",""29,827"",""30,417"",""32,253"",""64,18"",""59,308"",""45,191"",""32,813"",""27,145"",""20,934"",""16,069"",""14,091"",""12,192"",""11,962"",""9,891"",""9,28"",""9,282"",""6,614"",""5,896"",""1,888"",""0"",""0,001"",""0,001"",""0"",""0"",""0"",""0,669"",""1,403"",""2,815"",""2,807"",""2,802"",""3,087"",""2,043"",""1,628"",""4,12"",""10,338"",""13,341"",""13,462"",""11,593"",""8,874"",""7,488"",""5,472"",""3,263"",""2,812"""" ""02-01-2024,""2,795"",""2,796"",""2,809"",""2,812"",""2,808"",""3,015"",""2,809"",""2,814"",""2,816"",""2,822"",""2,812"",""2,827"",""2,804"",""2,822"",""2,819"",""2,822"",""2,812"",""2,821"",""1,59"",""0,998"",""8,908"",""17,589"",""39,534"",""53,405"",""48,594"",""56,204"",""52,091"",""49,084"",""48,15"",""38,538"",""37,239"",""41,327"",""34,36"",""30,326"",""28,141"",""28,481"",""30,251"",""27,637"",""25,342"",""22,694"",""17,882"",""15,68"",""17,488"",""19,971"",""20,055"",""19,777"",""18,924"",""19,403"",""15,866"",""10,022"",""8,741"",""9,088"",""6,45"",""7"",""14,592"",""24,763"",""31,461"",""34,881"",""25,197"",""19,099"",""13,558"",""9,315"",""6,96"",""6,776"",""6,657"",""7,692"",""5,353"",""1,335"",""1,754"",""4,573"",""2,469"",""3,285"",""3,043"",""2,805"",""2,797"",""2,797"",""2,793"",""1,069"",""3,538"",""5,191"",""4,18"",""3,135"",""2,766"",""3,991"",""6,161"",""6,498"",""8,426"",""7,9"",""10,303"",""10,874"",""9,829"",""11,002"",""9,346"",""6,637"",""4,585"",""4,594"""" ""02-02-2024,""4,587"",""4,591"",""4,461"",""3,462"",""0,829"",""0,186"",""0"",""0"",""0"",""0"",""0,254"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,363"",""7,262"",""21,946"",""55,835"",""81,659"",""94,222"",""93,952"",""94,16"",""94,05"",""93,099"",""85,259"",""77,845"",""69,724"",""67,898"",""66,467"",""63,292"",""62,879"",""56,347"",""39,505"",""34,417"",""34,516"",""32,856"",""30,469"",""26,644"",""24,522"",""24,058"",""22,949"",""22,389"",""16,688"",""14,759"",""15,534"",""15,888"",""15,559"",""15,405"",""24,143"",""32,443"",""49,111"",""61,601"",""70,449"",""57,319"",""46,573"",""32,791"",""26,113"",""21,01"",""18,45"",""18,726"",""14,809"",""10,136"",""9,856"",""9,897"",""9,86"",""9,872"",""9,901"",""8,697"",""7,043"",""5,339"",""4,269"",""4,263"",""3,872"",""1,448"",""1,445"",""1,439"",""1,427"",""1,424"",""1,423"",""1,429"",""1,428"",""1,251"",""6,486"",""5,918"",""8,429"",""8,029"",""8,521"",""6,911"",""5,537"",""4,573"",""4,167"""" ""02-03-2024,""2,827"",""2,811"",""2,832"",""2,806"",""2,818"",""3,064"",""2,812"",""2,821"",""2,824"",""2,82"",""2,817"",""0,465"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,74"",""4,425"",""10,249"",""8,531"",""7,362"",""6,771"",""5,451"",""5,463"",""5,451"",""5,458"",""5,455"",""5,474"",""5,453"",""4,373"",""2,797"",""2,8"",""2,805"",""2,79"",""2,796"",""2,796"",""2,78"",""1,275"",""1,758"",""2,796"",""2,807"",""2,031"",""0"",""0"",""0,001"",""0"",""0"",""0"",""1,21"",""1,033"",""2,027"",""3,594"",""3,597"",""3,607"",""3,589"",""3,603"",""3,603"",""3,603"",""3,609"",""3,589"",""3,623"",""3,62"",""3,624"",""3,612"",""3,606"",""3,6"",""1,294"",""0,731"",""0,735"",""0,732"",""0,736"",""0,73"",""0,733"",""0,733"",""0,735"",""0,733"",""0,732"",""0,733"",""0,733"",""0,736"",""0,735"",""0,736"",""0,737"",""0,736"",""0,736"",""0,739"",""0,736"",""0,657"",""0,739"",""0,737"",""0,737"",""0,737"""" ""02-04-2024,""0,738"",""0,737"",""0,74"",""0,738"",""0,582"",""0,322"",""0,194"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""1,699"",""2,767"",""2,764"",""2,766"",""2,764"",""2,764"",""2,767"",""2,764"",""2,764"",""2,764"",""2,763"",""2,753"",""2,774"",""2,753"",""2,763"",""2,772"",""2,757"",""2,772"",""2,755"",""2,763"",""2,764"",""2,764"",""2,765"",""5,058"",""7,709"",""6,194"",""4,929"",""3,298"",""2,766"",""0,789"",""0"",""2,918"",""4,97"",""3,541"",""2,278"",""0,193"",""0"",""0"",""0"",""0"",""0"",""0,87"",""2,324"",""4,603"",""4,598"",""3,788"",""1,833"",""1,231"",""0,104"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,289"",""0,837"",""0,836"",""0,831"",""0,835"",""0,836"",""0,832"",""3,722"",""5,229"",""7,853"",""6,029"",""3,936"",""3,781"",""3,7"",""3,638"",""3,541"",""3,536"",""3,54"""" ""02-05-2024,""3,535"",""3,581"",""3,572"",""3,584"",""3,572"",""2,902"",""0,781"",""0,002"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""5,449"",""20,348"",""47,298"",""70,331"",""75,058"",""71,43"",""74,759"",""70,654"",""59,44"",""56,813"",""71,54"",""83,547"",""74,483"",""64,354"",""55,502"",""51,827"",""52,332"",""60,631"",""65,698"",""63,586"",""61,889"",""59,125"",""54,159"",""40,017"",""26,814"",""19,505"",""15,136"",""13,707"",""11,302"",""9,259"",""11,501"",""20,151"",""19,217"",""22,347"",""35,255"",""54,694"",""61,515"",""54,676"",""54,729"",""43,909"",""40,661"",""35,245"",""26,526"",""21,304"",""17,393"",""15,592"",""12,051"",""12,047"",""10,641"",""9,039"",""8,408"",""7,351"",""5,112"",""2,795"",""2,778"",""2,785"",""2,798"",""2,788"",""2,019"",""1,972"",""3,315"",""3,474"",""1,83"",""2,038"",""7,728"",""13,882"",""18,684"",""23,657"",""28,841"",""32,104"",""25,458"",""19,379"",""13,754"",""12,217"",""10,407"",""6,146"""" ""02-06-2024,""5,953"",""5,864"",""5,994"",""5,944"",""5,619"",""2,798"",""2,812"",""3,029"",""2,525"",""0"",""0"",""0,221"",""0"",""0"",""0"",""0"",""0,303"",""0"",""0,002"",""0,836"",""8,738"",""33,018"",""49,006"",""69,364"",""86,198"",""93,289"",""89,971"",""96,861"",""89,965"",""80,709"",""86,274"",""83,196"",""83,084"",""77,776"",""74,072"",""63,517"",""59,854"",""54,831"",""52,622"",""50,417"",""45,375"",""45,314"",""42,54"",""36,293"",""30,831"",""26,926"",""23,404"",""19,244"",""16,364"",""13,614"",""9,137"",""10,961"",""11,31"",""15,94"",""22,038"",""34,081"",""46,715"",""47,353"",""48,425"",""51,643"",""47,785"",""41,436"",""34,303"",""24,079"",""19,015"",""16,044"",""15,931"",""21,465"",""16,114"",""11,117"",""2,121"",""0,792"",""0,102"",""0,244"",""0,162"",""0,159"",""0,398"",""2,413"",""2,972"",""2,982"",""3,204"",""3,201"",""9,879"",""11,368"",""11,853"",""15,518"",""15,883"",""21,442"",""22,568"",""19,364"",""18,332"",""19,002"",""17,777"",""12,132"",""12,044"",""10,571"""" ""02-07-2024,""7,832"",""6,301"",""4,042"",""3,916"",""3,921"",""4,101"",""3,892"",""3,06"",""2,995"",""2,997"",""3,539"",""2,819"",""2,972"",""0,466"",""0,452"",""0,159"",""0,156"",""0,455"",""0,723"",""0,462"",""9,01"",""28,418"",""47,149"",""64,181"",""62,601"",""70,719"",""61,329"",""52,947"",""60,907"",""70,796"",""63,673"",""52,927"",""48,25"",""44,922"",""43,315"",""42,369"",""38,134"",""33,995"",""25,449"",""23,692"",""23,004"",""19,186"",""14,918"",""14,119"",""13,166"",""11,354"",""10,356"",""5,426"",""4,809"",""4,785"",""4,787"",""8,395"",""7,946"",""5,634"",""9,424"",""27,717"",""49,101"",""52,83"",""43,679"",""33,571"",""24,471"",""14,775"",""8,875"",""6,843"",""6,137"",""5,337"",""5,251"",""5,203"",""7,823"",""6,322"",""2,03"",""1,482"",""0,402"",""0,396"",""0,346"",""0"",""0"",""0"",""0"",""0,002"",""0"",""0"",""0"",""0,479"",""4,986"",""3,282"",""5,893"",""13,203"",""35,335"",""33,3"",""22,865"",""15,26"",""10,645"",""9,363"",""8,526"",""6,363"""" ""02-08-2024,""6,095"",""6,187"",""5,837"",""5,841"",""5,737"",""6,008"",""5,755"",""5,739"",""5,764"",""5,973"",""5,769"",""5,707"",""3,217"",""2,961"",""3,151"",""0,811"",""0,054"",""0,073"",""0,291"",""0,43"",""8,447"",""24,654"",""45,168"",""66,296"",""69,745"",""65,555"",""61,919"",""61,065"",""68,257"",""67,806"",""62,249"",""62,657"",""49,96"",""48,156"",""50,327"",""49,112"",""47,16"",""42,522"",""40,523"",""39,441"",""38,214"",""37,833"",""30,03"",""24,54"",""19,596"",""15,266"",""15,345"",""13,92"",""12,549"",""9,453"",""4,555"",""5,18"",""2,283"",""5,531"",""13,191"",""25,574"",""31,586"",""36,08"",""36,691"",""36,719"",""27,653"",""20,522"",""13,639"",""9,747"",""11,635"",""9,905"",""6,972"",""3,925"",""2,791"",""1,21"",""0,584"",""1,375"",""2,819"",""2,816"",""2,813"",""2,809"",""1,479"",""0"",""0"",""1,274"",""1,823"",""1,812"",""1,805"",""1,817"",""2,593"",""3,691"",""6,113"",""9,745"",""28,909"",""30,527"",""21,818"",""15,163"",""8,43"",""6,719"",""4,602"",""4,813"""" ""02-09-2024,""4,609"",""4,622"",""4,611"",""4,474"",""2,822"",""2,819"",""2,809"",""3,032"",""2,808"",""2,778"",""2,78"",""2,778"",""0,841"",""0"",""0"",""0"",""0,207"",""0"",""0,578"",""2,826"",""7,606"",""26,731"",""41,826"",""56,491"",""61,063"",""56,618"",""51,822"",""48,861"",""46,256"",""46,735"",""41,783"",""46,04"",""46,992"",""39,836"",""34,684"",""35,084"",""33,528"",""27,442"",""23,155"",""21,422"",""19,426"",""16,992"",""14,027"",""9,873"",""9,903"",""9,18"",""6,729"",""6,97"",""4,591"",""4,1"",""3,194"",""3,655"",""3,541"",""11,939"",""23,122"",""41,182"",""50,35"",""50,308"",""41,935"",""31,784"",""29,142"",""26,709"",""19,907"",""14,352"",""13,444"",""10,269"",""5,74"",""5,751"",""5,018"",""3,499"",""3,043"",""2,774"",""2,772"",""2,772"",""2,77"",""2,772"",""2,761"",""2,781"",""2,763"",""2,778"",""4,238"",""2,839"",""2,838"",""3,203"",""5,443"",""5,486"",""5,467"",""9,476"",""7,951"",""7,909"",""9,118"",""8,41"",""3,855"",""3,677"",""2,103"",""1,146"""" ""02-10-2024,""1,149"",""1,035"",""0,55"",""0,321"",""0,037"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""2,074"",""3,704"",""4,076"",""6,247"",""6,526"",""8,582"",""9,36"",""9,336"",""9,096"",""9,607"",""9,423"",""9,232"",""8,667"",""8,497"",""8,488"",""8,485"",""8,496"",""8,47"",""8,013"",""5,653"",""5,647"",""4,419"",""1,179"",""0,001"",""0"",""0,001"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,002"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"""" ""02-11-2024,""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""1,659"",""2,79"",""2,795"",""2,794"",""2,797"",""2,796"",""2,805"",""2,803"",""2,801"",""2,8"",""2,806"",""2,225"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0,001"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""0"",""1,574"",""2,795"",""2,815"",""2,814"",""2,812"",""2,801"",""2,818"",""2,807"",""2,809"""" ""02-12-2024,""2,815"",""2,81"",""2,796"",""2,817"",""2,804"",""2,808"",""2,801"",""2,797"",""2,794"",""2,795"",""2,791"",""2,807"",""2,792"",""2,814"",""2,802"",""2,801"",""2,802"",""2,785"",""2,796"",""5,414"",""15,743"",""33,123"",""57,507"",""75,358"",""78,759"",""87,755"",""77,4"",""68,524"",""59,096"",""54,804"",""58,221"",""59,302"",""58,054"",""59,357"",""60,25"",""57,115"",""53,945"",""54,036"",""49,555"",""43,056"",""33,101"",""29,278"",""28,304"",""19,553"",""16,117"",""16,731"",""12,112"",""13,552"",""11,229"",""8,957"",""8,703"",""9,253"",""15,791"",""19,723"",""24,106"",""42,124"",""55,766"",""53,775"",""50,052"",""43,132"",""36,937"",""32,448"",""31,222"",""27,022"",""23,959"",""21,087"",""19,995"",""16,086"",""14,028"",""13,864"",""16,179"",""15,124"",""10,997"",""8,85"",""9,906"",""12,163"",""14,712"",""17,144"",""13,956"",""13,777"",""9,413"",""9,776"",""11,496"",""9,391"",""5,604"",""8,806"",""16,89"",""23,97"",""24,747"",""23,72"",""22,036"",""21,007"",""19,372"",""12,826"",""9,584"",""7,452"""" ""02-13-2024,""6,918"",""6,883"",""6,876"",""6,851"",""6,845"",""6,338"",""3,409"",""3,131"",""2,763"",""0,262"",""0"",""0"",""0,896"",""0,935"",""0,934"",""0,933"",""0,934"",""0,932"",""0,932"",""4,401"",""6,555"",""16,315"",""32,448"",""50,622"",""55,744"",""58,793"",""54,931"",""53,802"",""63,192"",""60,412"",""55,46"",""47,961"",""48,739"",""47,439"",""46,345"",""42,575"",""36,882"",""32,572"",""27,548"",""24,745"",""23,199"",""16,716"",""13,752"",""11,033"",""15,363"",""10,361"",""2,894"",""2,827"",""3,247"",""2,943"",""2,162"",""5,994"",""10,212"",""9,81"",""18,424"",""32,829"",""41,714"",""43,287"",""39,528"",""29,027"",""15,492"",""10,6"",""10,569"",""9,128"",""8,02"",""7,469"",""5,044"",""5,324"",""5,056"",""5,002"",""3,229"",""4,2"",""6,361"",""6,635"",""6,287"",""5,992"",""5,818"",""5,429"",""5,426"",""7,217"",""7,17"",""2,759"",""2,677"",""2,398"",""3,678"",""4,47"",""6,445"",""6,563"",""6,457"",""6,472"",""5,986"",""7,756"",""5,125"",""3,676"",""3,498"",""3,18""""
S(2:end) = regexprep(S(2:end),{'("+,|,"+)','"',',',';'},{';','','.',','});
writelines(S,'proper.csv')
Lets see how it looks now:
type proper.csv
Datum,00:00,00:15,00:30,00:45,01:00,01:15,01:30,01:45,02:00,02:15,02:30,02:45,03:00,03:15,03:30,03:45,04:00,04:15,04:30,04:45,05:00,05:15,05:30,05:45,06:00,06:15,06:30,06:45,07:00,07:15,07:30,07:45,08:00,08:15,08:30,08:45,09:00,09:15,09:30,09:45,10:00,10:15,10:30,10:45,11:00,11:15,11:30,11:45,12:00,12:15,12:30,12:45,13:00,13:15,13:30,13:45,14:00,14:15,14:30,14:45,15:00,15:15,15:30,15:45,16:00,16:15,16:30,16:45,17:00,17:15,17:30,17:45,18:00,18:15,18:30,18:45,19:00,19:15,19:30,19:45,20:00,20:15,20:30,20:45,21:00,21:15,21:30,21:45,22:00,22:15,22:30,22:45,23:00,23:15,23:30,23:45 01-16-2024,0,0.58,2.808,2.805,2.813,2.813,2.797,2.817,2.819,2.476,0,0,0,0,0,0,0,0,0.555,2.819,9.577,23.35,42.269,62.843,72.287,74.869,81.823,84.279,78.114,75.484,69.806,63.326,54.432,53.215,52.569,53.354,53.185,50.893,43.319,46.548,43.336,40.657,43.293,26.16,19.99,20.694,16.778,15.963,11.468,10.472,10.487,11.731,22.936,26.528,40.116,51.822,63.06,58.533,55.868,46.854,34.659,24.963,19.748,16.207,13.968,13.089,10.679,7.264,7.379,7.399,6.478,6.019,5.507,5.512,5.501,5.508,5.51,3.968,1.399,2.144,2.771,5.371,7.702,8.779,6.725,9.251,16.857,24.982,34.633,28.194,28.543,27.612,20.685,14.526,13.892,12.16 01-17-2024,8.793,8.354,6.327,5.819,5.798,5.567,5.772,3.615,2.803,2.784,3.019,2.792,2.786,0.922,0.215,0,0,0,0.646,1.693,16.073,18.703,50.842,58.587,59.758,62.291,68.434,66.023,61.297,61.539,71.804,74.832,69.938,54.997,43.461,39.526,40.237,38.053,34.837,31.702,23.352,20.434,22.155,19.333,16.47,15.567,16.358,16.722,18.291,10.48,8.639,8.458,12.959,24.771,34.972,64.197,99.029,94.645,80.046,49.654,37.904,29.502,24.083,22.591,20.429,20.193,15.029,13.136,11.187,14.956,14.079,13.983,13.251,7.54,3.945,2.808,2.356,0,0.002,0.187,2.7,2.824,2.752,2.975,3.57,3.153,9.229,12.349,28.236,39.275,18.769,14.353,9.688,6.514,3.456,0.441 01-18-2024,0.507,0.202,0.137,0.082,0.411,0,0,0,0.214,0,0,0,0,0.213,0,0,0,0.297,0,2.222,10.393,20.163,38.942,49.895,66.931,69.099,64.881,58.019,51.546,46.416,43.138,36.898,39.323,38.839,34.772,33.194,32.704,28.594,25.258,28.522,28.351,24.611,20.707,16.979,15.141,15.132,13.597,12.701,13.259,14.74,13.161,15.592,21.183,24.87,29.387,42.109,54.716,54.567,46.48,38.179,25.299,13.621,10.669,9.169,3.464,4.882,4.548,5.037,3.493,4.039,5.042,2.794,2.792,2.791,2.785,2.783,2.397,2.637,2.636,2.65,6.909,7.741,8.752,10.572,10.675,11.024,13.943,20.745,21.204,24.66,22.882,20.613,14.697,9.432,7.302,7.152 01-19-2024,7.297,6.994,6.876,6.693,4.241,3.966,3.97,3.963,4.289,3.942,3.936,3.927,4.202,1.178,1.151,0.985,1.157,1.464,1.147,2.197,10.504,25.687,37.01,57.468,61.466,64.225,67.325,60.447,49.667,48.288,52.404,45.56,50.17,41.204,36.873,34.685,35.776,37.228,36.833,37.569,36.595,33.658,29.26,24.963,22.052,19.983,14.799,13.245,12.766,10.899,10.72,8.194,12.635,23.693,33.338,51.208,60.487,62.773,66.283,45.056,32.955,26.158,21.082,20.223,15.824,14.853,10.294,9.84,9.446,8.335,8.09,7.256,6.771,4.28,5.536,5.517,4.98,2.797,0.519,0,0.078,0,0,0.162,3.719,9.06,11.965,19.447,17.164,21.808,22.454,21.937,16.817,7.784,9.069,5.858 01-20-2024,5.786,5.785,5.722,5.597,2.252,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.248,1.289,2.568,3.114,2.988,2.8,2.801,2.799,2.779,2.794,2.796,2.783,3.272,3.433,2.804,2.815,2.796,2.802,2.815,2.795,2.801,2.804,2.808,4.589,2.81,2.726,0.583,2.417,3.636,3.72,3.925,3.695,4.843,5.62,8.001,8.374,8.356,8.356,8.339,8.339,8.349,7.702,5.958,5.563,5.567,5.026,3.123,2.804,1.365,0,0,0,0,0,0,0,0,0,0,2.193,4.87,3.551,1.96,1.589,0.17,0,0,0.671,0.663,0,0,0,0,0,0,0 01-21-2024,0,0,0,0,0,0.19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.535,2.367,0,0,0,0,0,1.09,2.834,2.84,2.845,2.845,2.846,2.831,2.859,2.843,2.864,2.855,2.851,2.86,1.421,0,0,0,0,0,0,0,0,0,1.036,2.785,2.798,2.799,0.696,0,0,0,1.518,1.824,4.394,4.603,3.236,2.779,2.78,2.781,2.764,2.778,2.795 01-22-2024,2.768,2.822,2.808,2.82,2.823,2.822,2.818,2.82,2.819,2.82,2.818,2.814,2.804,1.533,0,0,0,0.002,0,2.097,10.276,37.099,64.181,81.681,87.109,98.691,101.225,86.954,80.581,65.926,58.538,63.237,73.318,73.779,74.354,70.375,58.568,57.945,45.352,42.325,38.27,34.281,29.629,25.214,27.698,22.215,17.372,13.047,12.949,12.085,13.523,14.161,18.736,25.478,38.336,49.217,53.57,52.728,52.151,46.37,42.111,34.139,29.566,23.916,23.209,21.153,19.386,17.12,13.594,13.989,13.535,13.583,12.417,11.587,10.952,10.599,6.157,4.429,2.719,0.302,1.608,2.852,5.419,5.645,6.254,5.521,5.166,7.398,8.678,9.681,9.011,9.603,7.691,5.636,5.596,5.603 01-23-2024,5.608,5.613,5.616,5.61,5.596,5.612,5.606,5.588,5.622,5.591,4.517,2.821,2.828,2.819,2.806,1.429,0.642,0.95,0.934,1.67,4.956,27.87,49.803,67.664,84.104,81.197,75.925,60.944,56.956,65.769,71.611,77.047,80.211,80.282,70.152,69.38,69.696,66.56,63.596,63.242,60.829,53.027,42.486,37.499,28.868,22.03,18.447,18.872,18.767,15.185,13.064,14.126,18.435,23.19,33.604,43.689,51.55,45.205,44.116,37.991,34.55,29.07,23.254,17.135,14.216,10.518,8.089,7.569,9.011,8.504,7.198,6.613,6.993,6.462,6.455,6.442,6.01,4.745,4.857,7.12,9.176,9.711,6.751,4.428,4.687,9.344,12.24,9.207,8.856,8.541,11.816,10.794,9.446,8.207,8.237,8.211 01-24-2024,8.207,8.19,8.201,8.074,6.592,5.821,5.554,5.581,5.842,6.528,6.346,5.266,3.436,3.484,3.473,3.09,2.802,3.389,1.023,3.512,10.802,34.45,49.679,70.04,68.276,60.575,49.677,47.835,76.674,76.174,90.454,80.571,60.839,53.114,46.012,42.094,39.411,39.372,37.508,21.78,17.108,17.499,17.159,16.81,11.941,11.277,9.12,10.054,12.148,12.271,14.639,15.744,15.034,23.343,39.309,54.535,62.153,62.073,52.188,42.177,32.45,21.213,18.164,13.591,12.594,7.969,9.359,9.139,6.197,4.062,3.543,5.022,7.932,6.503,5.124,2.638,0,0,0,0,0.001,1.773,2.786,2.784,1.093,2.025,8.271,7.759,7.941,6.034,5.768,5.496,4.224,2.884,2.806,2.805 01-25-2024,2.805,2.809,2.812,2.816,2.818,2.815,2.817,2.816,2.823,2.812,2.828,2.812,2.635,0,0,0,0.038,0.981,0.86,0.71,7.744,28.409,38.188,42.679,49.859,54.294,56.38,53.666,50.211,52.226,53.525,51.689,58.488,59.244,65.383,59.97,51.191,49.924,42.612,37.87,36.152,34.031,30.354,20.121,14.41,9.927,11.105,11.117,11.812,11.175,10.362,8.395,14.675,17.505,24.116,38.168,50.972,44.266,39.299,34.682,27.407,22.279,18.34,18.987,12.616,6.914,5.173,7.113,4.223,7.531,5.383,3.588,1.874,0.916,1.113,3.732,3.737,3.745,3.227,2.799,2.794,2.795,2.795,2.79,3.012,6.534,7.224,8.465,7.67,8.427,9.735,10.624,9.007,8.375,6.233,5.607 01-26-2024,5.615,5.617,5.611,5.613,5.595,4.616,2.806,2.823,2.84,2.812,2.823,2.795,2.986,3.766,3.691,1.946,0.118,0,1.565,2.84,9.659,35.57,48.296,61.407,71.209,64.424,57.193,53.108,52.462,45.768,37.082,33.311,30.936,27.205,24.178,32.422,31.257,23.255,15.685,12.433,11.588,11.596,5.122,5.329,3.46,1.679,1.459,1.686,4.212,6.762,8.422,8.469,13.504,25.613,26.587,38.844,54.594,54.44,44.473,38.846,30.033,24.952,20.631,18.265,17.346,17.806,17.37,16.467,15.1,7.664,5.137,4.69,4.267,4.485,4.263,4.25,4.463,4.252,4.259,2.94,1.652,1.448,1.448,1.448,2.258,2.393,2.102,3.192,4.258,3.815,3.958,6.453,3.757,1.595,1.248,1.139 01-27-2024,0.603,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.551,3.148,2.786,2.787,2.804,2.788,2.807,2.81,2.798,2.819,5.108,5.576,7.425,7.568,7.055,5.867,5.559,5.58,5.56,7.018,9.772,11.182,11.311,11.275,10.398,8.517,8.549,8.545,7.613,5.781,5.773,5.096,3.591,7.462,7.362,5.703,3.952,1.014,0.843,0.852,0.523,0.805,0.495,0.31,0.207,0.148,0.055,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.337,1.932,2.818,2.801,2.818,2.802,0.12,0,0,0,0,0 01-28-2024,0,0,0,0,0,0,0,0,0,0,0.002,0,0,0,0,0,0,0,0,0,0,0.254,4.105,6.742,8.263,5.873,5.466,5.46,5.469,3.732,2.643,2.617,1.407,0.485,0.132,0,0,0,0,0,0,0,0,0,0,0,0.305,2.826,2.836,2.84,1.359,2.845,0.449,0,0,0,0.002,1.736,1.761,1.751,2.761,6.379,4.555,3.448,3.127,1.762,1.591,0.458,0,0.001,0,0,0.101,1.121,0.004,0,0,0,0,0.028,2.759,2.826,2.812,2.814,2.811,3.797,6.259,9.062,10.097,10.12,10.093,5.751,4.535,4.533,4.362,4.216 01-29-2024,4.091,3.995,2.18,0.978,0.435,0,0,0,0,0,0,0,0,0,0,0,0,0,0.167,1.043,5.644,16.421,42.128,64.618,69.713,78.306,83.247,80.756,82.278,75.248,72.082,66.701,62.376,58.109,58.443,53.462,49.95,46.24,43.267,36.525,32.439,25.297,24.952,19.309,17.962,14.439,10.333,6.235,4.644,2.489,3.436,3.177,5.028,18.608,32.518,43.318,51.023,58.901,51.323,43.267,40.966,35.597,30.435,27.723,23.407,21.955,20.735,19.96,17.296,13.87,14.435,10.861,6.628,5.66,5.616,3.486,2.816,2.812,2.829,4.576,3.044,2.808,5.064,5.657,5.664,7.89,9.156,10.758,11.588,12.175,11.124,10.841,8.069,5.759,5.535,5.284 01-30-2024,3.914,3.253,2.909,2.902,2.898,2.896,2.898,0.426,0,0,0,0,0,0,0,0,0,0,0,0,3.988,14.357,30.821,52.712,71.941,80.226,83.017,79.31,78.091,77.039,81.877,82.246,72.94,69.314,60.952,56.935,58.666,78.971,79.591,67.511,50.869,39.749,35.752,32.777,24.141,21.825,20.329,17.26,15.895,16.381,13.58,15.237,20.233,22.815,23.904,34.591,75.653,78.277,42.244,33.556,22.638,15.633,12.8,7.703,4.466,6.232,9.326,8.903,5.952,3.114,0.751,0.795,0.052,0,0,0,0,0,1.241,2.831,15.824,12.387,9.012,5.601,5.613,8.66,9.899,13.684,13.966,9.178,9.705,7.465,7.414,3.69,2.126,2.879 01-31-2024,2.743,0.318,0,0,0.255,0.023,0,0,0,0,0,0,0,0,0.397,0,0,0,0.893,4.265,7.063,16.334,28.253,40.819,52.107,61.469,61.784,57.635,49.4,47.119,47.516,51.66,54.834,52.8,60.026,55.749,39.395,32.394,31.623,30.28,27.163,26.781,23.372,21.885,16.668,10.528,8.28,8.134,9.245,11.116,12.454,15.366,22.496,29.827,30.417,32.253,64.18,59.308,45.191,32.813,27.145,20.934,16.069,14.091,12.192,11.962,9.891,9.28,9.282,6.614,5.896,1.888,0,0.001,0.001,0,0,0,0.669,1.403,2.815,2.807,2.802,3.087,2.043,1.628,4.12,10.338,13.341,13.462,11.593,8.874,7.488,5.472,3.263,2.812 02-01-2024,2.795,2.796,2.809,2.812,2.808,3.015,2.809,2.814,2.816,2.822,2.812,2.827,2.804,2.822,2.819,2.822,2.812,2.821,1.59,0.998,8.908,17.589,39.534,53.405,48.594,56.204,52.091,49.084,48.15,38.538,37.239,41.327,34.36,30.326,28.141,28.481,30.251,27.637,25.342,22.694,17.882,15.68,17.488,19.971,20.055,19.777,18.924,19.403,15.866,10.022,8.741,9.088,6.45,7,14.592,24.763,31.461,34.881,25.197,19.099,13.558,9.315,6.96,6.776,6.657,7.692,5.353,1.335,1.754,4.573,2.469,3.285,3.043,2.805,2.797,2.797,2.793,1.069,3.538,5.191,4.18,3.135,2.766,3.991,6.161,6.498,8.426,7.9,10.303,10.874,9.829,11.002,9.346,6.637,4.585,4.594 02-02-2024,4.587,4.591,4.461,3.462,0.829,0.186,0,0,0,0,0.254,0,0,0,0,0,0,0,0,0.363,7.262,21.946,55.835,81.659,94.222,93.952,94.16,94.05,93.099,85.259,77.845,69.724,67.898,66.467,63.292,62.879,56.347,39.505,34.417,34.516,32.856,30.469,26.644,24.522,24.058,22.949,22.389,16.688,14.759,15.534,15.888,15.559,15.405,24.143,32.443,49.111,61.601,70.449,57.319,46.573,32.791,26.113,21.01,18.45,18.726,14.809,10.136,9.856,9.897,9.86,9.872,9.901,8.697,7.043,5.339,4.269,4.263,3.872,1.448,1.445,1.439,1.427,1.424,1.423,1.429,1.428,1.251,6.486,5.918,8.429,8.029,8.521,6.911,5.537,4.573,4.167 02-03-2024,2.827,2.811,2.832,2.806,2.818,3.064,2.812,2.821,2.824,2.82,2.817,0.465,0,0,0,0,0,0,0,0,0.74,4.425,10.249,8.531,7.362,6.771,5.451,5.463,5.451,5.458,5.455,5.474,5.453,4.373,2.797,2.8,2.805,2.79,2.796,2.796,2.78,1.275,1.758,2.796,2.807,2.031,0,0,0.001,0,0,0,1.21,1.033,2.027,3.594,3.597,3.607,3.589,3.603,3.603,3.603,3.609,3.589,3.623,3.62,3.624,3.612,3.606,3.6,1.294,0.731,0.735,0.732,0.736,0.73,0.733,0.733,0.735,0.733,0.732,0.733,0.733,0.736,0.735,0.736,0.737,0.736,0.736,0.739,0.736,0.657,0.739,0.737,0.737,0.737 02-04-2024,0.738,0.737,0.74,0.738,0.582,0.322,0.194,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.699,2.767,2.764,2.766,2.764,2.764,2.767,2.764,2.764,2.764,2.763,2.753,2.774,2.753,2.763,2.772,2.757,2.772,2.755,2.763,2.764,2.764,2.765,5.058,7.709,6.194,4.929,3.298,2.766,0.789,0,2.918,4.97,3.541,2.278,0.193,0,0,0,0,0,0.87,2.324,4.603,4.598,3.788,1.833,1.231,0.104,0,0,0,0,0,0,0,0.289,0.837,0.836,0.831,0.835,0.836,0.832,3.722,5.229,7.853,6.029,3.936,3.781,3.7,3.638,3.541,3.536,3.54 02-05-2024,3.535,3.581,3.572,3.584,3.572,2.902,0.781,0.002,0,0,0,0,0,0,0,0,0,0,0,0,5.449,20.348,47.298,70.331,75.058,71.43,74.759,70.654,59.44,56.813,71.54,83.547,74.483,64.354,55.502,51.827,52.332,60.631,65.698,63.586,61.889,59.125,54.159,40.017,26.814,19.505,15.136,13.707,11.302,9.259,11.501,20.151,19.217,22.347,35.255,54.694,61.515,54.676,54.729,43.909,40.661,35.245,26.526,21.304,17.393,15.592,12.051,12.047,10.641,9.039,8.408,7.351,5.112,2.795,2.778,2.785,2.798,2.788,2.019,1.972,3.315,3.474,1.83,2.038,7.728,13.882,18.684,23.657,28.841,32.104,25.458,19.379,13.754,12.217,10.407,6.146 02-06-2024,5.953,5.864,5.994,5.944,5.619,2.798,2.812,3.029,2.525,0,0,0.221,0,0,0,0,0.303,0,0.002,0.836,8.738,33.018,49.006,69.364,86.198,93.289,89.971,96.861,89.965,80.709,86.274,83.196,83.084,77.776,74.072,63.517,59.854,54.831,52.622,50.417,45.375,45.314,42.54,36.293,30.831,26.926,23.404,19.244,16.364,13.614,9.137,10.961,11.31,15.94,22.038,34.081,46.715,47.353,48.425,51.643,47.785,41.436,34.303,24.079,19.015,16.044,15.931,21.465,16.114,11.117,2.121,0.792,0.102,0.244,0.162,0.159,0.398,2.413,2.972,2.982,3.204,3.201,9.879,11.368,11.853,15.518,15.883,21.442,22.568,19.364,18.332,19.002,17.777,12.132,12.044,10.571 02-07-2024,7.832,6.301,4.042,3.916,3.921,4.101,3.892,3.06,2.995,2.997,3.539,2.819,2.972,0.466,0.452,0.159,0.156,0.455,0.723,0.462,9.01,28.418,47.149,64.181,62.601,70.719,61.329,52.947,60.907,70.796,63.673,52.927,48.25,44.922,43.315,42.369,38.134,33.995,25.449,23.692,23.004,19.186,14.918,14.119,13.166,11.354,10.356,5.426,4.809,4.785,4.787,8.395,7.946,5.634,9.424,27.717,49.101,52.83,43.679,33.571,24.471,14.775,8.875,6.843,6.137,5.337,5.251,5.203,7.823,6.322,2.03,1.482,0.402,0.396,0.346,0,0,0,0,0.002,0,0,0,0.479,4.986,3.282,5.893,13.203,35.335,33.3,22.865,15.26,10.645,9.363,8.526,6.363 02-08-2024,6.095,6.187,5.837,5.841,5.737,6.008,5.755,5.739,5.764,5.973,5.769,5.707,3.217,2.961,3.151,0.811,0.054,0.073,0.291,0.43,8.447,24.654,45.168,66.296,69.745,65.555,61.919,61.065,68.257,67.806,62.249,62.657,49.96,48.156,50.327,49.112,47.16,42.522,40.523,39.441,38.214,37.833,30.03,24.54,19.596,15.266,15.345,13.92,12.549,9.453,4.555,5.18,2.283,5.531,13.191,25.574,31.586,36.08,36.691,36.719,27.653,20.522,13.639,9.747,11.635,9.905,6.972,3.925,2.791,1.21,0.584,1.375,2.819,2.816,2.813,2.809,1.479,0,0,1.274,1.823,1.812,1.805,1.817,2.593,3.691,6.113,9.745,28.909,30.527,21.818,15.163,8.43,6.719,4.602,4.813 02-09-2024,4.609,4.622,4.611,4.474,2.822,2.819,2.809,3.032,2.808,2.778,2.78,2.778,0.841,0,0,0,0.207,0,0.578,2.826,7.606,26.731,41.826,56.491,61.063,56.618,51.822,48.861,46.256,46.735,41.783,46.04,46.992,39.836,34.684,35.084,33.528,27.442,23.155,21.422,19.426,16.992,14.027,9.873,9.903,9.18,6.729,6.97,4.591,4.1,3.194,3.655,3.541,11.939,23.122,41.182,50.35,50.308,41.935,31.784,29.142,26.709,19.907,14.352,13.444,10.269,5.74,5.751,5.018,3.499,3.043,2.774,2.772,2.772,2.77,2.772,2.761,2.781,2.763,2.778,4.238,2.839,2.838,3.203,5.443,5.486,5.467,9.476,7.951,7.909,9.118,8.41,3.855,3.677,2.103,1.146 02-10-2024,1.149,1.035,0.55,0.321,0.037,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.074,3.704,4.076,6.247,6.526,8.582,9.36,9.336,9.096,9.607,9.423,9.232,8.667,8.497,8.488,8.485,8.496,8.47,8.013,5.653,5.647,4.419,1.179,0.001,0,0.001,0,0,0,0,0,0,0,0,0,0,0,0,0.002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 02-11-2024,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.659,2.79,2.795,2.794,2.797,2.796,2.805,2.803,2.801,2.8,2.806,2.225,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.574,2.795,2.815,2.814,2.812,2.801,2.818,2.807,2.809 02-12-2024,2.815,2.81,2.796,2.817,2.804,2.808,2.801,2.797,2.794,2.795,2.791,2.807,2.792,2.814,2.802,2.801,2.802,2.785,2.796,5.414,15.743,33.123,57.507,75.358,78.759,87.755,77.4,68.524,59.096,54.804,58.221,59.302,58.054,59.357,60.25,57.115,53.945,54.036,49.555,43.056,33.101,29.278,28.304,19.553,16.117,16.731,12.112,13.552,11.229,8.957,8.703,9.253,15.791,19.723,24.106,42.124,55.766,53.775,50.052,43.132,36.937,32.448,31.222,27.022,23.959,21.087,19.995,16.086,14.028,13.864,16.179,15.124,10.997,8.85,9.906,12.163,14.712,17.144,13.956,13.777,9.413,9.776,11.496,9.391,5.604,8.806,16.89,23.97,24.747,23.72,22.036,21.007,19.372,12.826,9.584,7.452 02-13-2024,6.918,6.883,6.876,6.851,6.845,6.338,3.409,3.131,2.763,0.262,0,0,0.896,0.935,0.934,0.933,0.934,0.932,0.932,4.401,6.555,16.315,32.448,50.622,55.744,58.793,54.931,53.802,63.192,60.412,55.46,47.961,48.739,47.439,46.345,42.575,36.882,32.572,27.548,24.745,23.199,16.716,13.752,11.033,15.363,10.361,2.894,2.827,3.247,2.943,2.162,5.994,10.212,9.81,18.424,32.829,41.714,43.287,39.528,29.027,15.492,10.6,10.569,9.128,8.02,7.469,5.044,5.324,5.056,5.002,3.229,4.2,6.361,6.635,6.287,5.992,5.818,5.429,5.426,7.217,7.17,2.759,2.677,2.398,3.678,4.47,6.445,6.563,6.457,6.472,5.986,7.756,5.125,3.676,3.498,3.18 02-14-2024,2.953,2.797,2.788,2.79,2.791,2.793,2.794,1.77,0,0,0,0,0,0,0,0,0,0,0,4.746,10.863,14.296,23.639,34.076,44.702,39.123,33.017,31.141,23.354,16.367,12.945,10.676,8.138,7.234,9.324,11.758,9.605,8.73,8.858,11.522,9.01,7.462,6.237,4.471,2.583,2.465,3.613,5.339,5.319,5.368,5.355,3.684,0.831,0,0,0.001,2.951,3.217,2.786,1.389,0.458,3.31,0.001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
Aaah, that looks much better! Now importing is very easy:
T = readtable('proper.csv', 'VariableNamingRule','preserve');
T.Datum = datetime(T.Datum,'InputFormat','M-d-y', 'Format','yyyy-MM-dd')
T = 30×97 table
Datum 00:00 00:15 00:30 00:45 01:00 01:15 01:30 01:45 02:00 02:15 02:30 02:45 03:00 03:15 03:30 03:45 04:00 04:15 04:30 04:45 05:00 05:15 05:30 05:45 06:00 06:15 06:30 06:45 07:00 07:15 07:30 07:45 08:00 08:15 08:30 08:45 09:00 09:15 09:30 09:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 13:00 13:15 13:30 13:45 14:00 14:15 14:30 14:45 15:00 15:15 15:30 15:45 16:00 16:15 16:30 16:45 17:00 17:15 17:30 17:45 18:00 18:15 18:30 18:45 19:00 19:15 19:30 19:45 20:00 20:15 20:30 20:45 21:00 21:15 21:30 21:45 22:00 22:15 22:30 22:45 23:00 23:15 23:30 23:45 __________ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ _____ _____ _____ ______ ______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ 2024-01-16 0 0.58 2.808 2.805 2.813 2.813 2.797 2.817 2.819 2.476 0 0 0 0 0 0 0 0 0.555 2.819 9.577 23.35 42.269 62.843 72.287 74.869 81.823 84.279 78.114 75.484 69.806 63.326 54.432 53.215 52.569 53.354 53.185 50.893 43.319 46.548 43.336 40.657 43.293 26.16 19.99 20.694 16.778 15.963 11.468 10.472 10.487 11.731 22.936 26.528 40.116 51.822 63.06 58.533 55.868 46.854 34.659 24.963 19.748 16.207 13.968 13.089 10.679 7.264 7.379 7.399 6.478 6.019 5.507 5.512 5.501 5.508 5.51 3.968 1.399 2.144 2.771 5.371 7.702 8.779 6.725 9.251 16.857 24.982 34.633 28.194 28.543 27.612 20.685 14.526 13.892 12.16 2024-01-17 8.793 8.354 6.327 5.819 5.798 5.567 5.772 3.615 2.803 2.784 3.019 2.792 2.786 0.922 0.215 0 0 0 0.646 1.693 16.073 18.703 50.842 58.587 59.758 62.291 68.434 66.023 61.297 61.539 71.804 74.832 69.938 54.997 43.461 39.526 40.237 38.053 34.837 31.702 23.352 20.434 22.155 19.333 16.47 15.567 16.358 16.722 18.291 10.48 8.639 8.458 12.959 24.771 34.972 64.197 99.029 94.645 80.046 49.654 37.904 29.502 24.083 22.591 20.429 20.193 15.029 13.136 11.187 14.956 14.079 13.983 13.251 7.54 3.945 2.808 2.356 0 0.002 0.187 2.7 2.824 2.752 2.975 3.57 3.153 9.229 12.349 28.236 39.275 18.769 14.353 9.688 6.514 3.456 0.441 2024-01-18 0.507 0.202 0.137 0.082 0.411 0 0 0 0.214 0 0 0 0 0.213 0 0 0 0.297 0 2.222 10.393 20.163 38.942 49.895 66.931 69.099 64.881 58.019 51.546 46.416 43.138 36.898 39.323 38.839 34.772 33.194 32.704 28.594 25.258 28.522 28.351 24.611 20.707 16.979 15.141 15.132 13.597 12.701 13.259 14.74 13.161 15.592 21.183 24.87 29.387 42.109 54.716 54.567 46.48 38.179 25.299 13.621 10.669 9.169 3.464 4.882 4.548 5.037 3.493 4.039 5.042 2.794 2.792 2.791 2.785 2.783 2.397 2.637 2.636 2.65 6.909 7.741 8.752 10.572 10.675 11.024 13.943 20.745 21.204 24.66 22.882 20.613 14.697 9.432 7.302 7.152 2024-01-19 7.297 6.994 6.876 6.693 4.241 3.966 3.97 3.963 4.289 3.942 3.936 3.927 4.202 1.178 1.151 0.985 1.157 1.464 1.147 2.197 10.504 25.687 37.01 57.468 61.466 64.225 67.325 60.447 49.667 48.288 52.404 45.56 50.17 41.204 36.873 34.685 35.776 37.228 36.833 37.569 36.595 33.658 29.26 24.963 22.052 19.983 14.799 13.245 12.766 10.899 10.72 8.194 12.635 23.693 33.338 51.208 60.487 62.773 66.283 45.056 32.955 26.158 21.082 20.223 15.824 14.853 10.294 9.84 9.446 8.335 8.09 7.256 6.771 4.28 5.536 5.517 4.98 2.797 0.519 0 0.078 0 0 0.162 3.719 9.06 11.965 19.447 17.164 21.808 22.454 21.937 16.817 7.784 9.069 5.858 2024-01-20 5.786 5.785 5.722 5.597 2.252 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.248 1.289 2.568 3.114 2.988 2.8 2.801 2.799 2.779 2.794 2.796 2.783 3.272 3.433 2.804 2.815 2.796 2.802 2.815 2.795 2.801 2.804 2.808 4.589 2.81 2.726 0.583 2.417 3.636 3.72 3.925 3.695 4.843 5.62 8.001 8.374 8.356 8.356 8.339 8.339 8.349 7.702 5.958 5.563 5.567 5.026 3.123 2.804 1.365 0 0 0 0 0 0 0 0 0 0 2.193 4.87 3.551 1.96 1.589 0.17 0 0 0.671 0.663 0 0 0 0 0 0 0 2024-01-21 0 0 0 0 0 0.19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.535 2.367 0 0 0 0 0 1.09 2.834 2.84 2.845 2.845 2.846 2.831 2.859 2.843 2.864 2.855 2.851 2.86 1.421 0 0 0 0 0 0 0 0 0 1.036 2.785 2.798 2.799 0.696 0 0 0 1.518 1.824 4.394 4.603 3.236 2.779 2.78 2.781 2.764 2.778 2.795 2024-01-22 2.768 2.822 2.808 2.82 2.823 2.822 2.818 2.82 2.819 2.82 2.818 2.814 2.804 1.533 0 0 0 0.002 0 2.097 10.276 37.099 64.181 81.681 87.109 98.691 101.22 86.954 80.581 65.926 58.538 63.237 73.318 73.779 74.354 70.375 58.568 57.945 45.352 42.325 38.27 34.281 29.629 25.214 27.698 22.215 17.372 13.047 12.949 12.085 13.523 14.161 18.736 25.478 38.336 49.217 53.57 52.728 52.151 46.37 42.111 34.139 29.566 23.916 23.209 21.153 19.386 17.12 13.594 13.989 13.535 13.583 12.417 11.587 10.952 10.599 6.157 4.429 2.719 0.302 1.608 2.852 5.419 5.645 6.254 5.521 5.166 7.398 8.678 9.681 9.011 9.603 7.691 5.636 5.596 5.603 2024-01-23 5.608 5.613 5.616 5.61 5.596 5.612 5.606 5.588 5.622 5.591 4.517 2.821 2.828 2.819 2.806 1.429 0.642 0.95 0.934 1.67 4.956 27.87 49.803 67.664 84.104 81.197 75.925 60.944 56.956 65.769 71.611 77.047 80.211 80.282 70.152 69.38 69.696 66.56 63.596 63.242 60.829 53.027 42.486 37.499 28.868 22.03 18.447 18.872 18.767 15.185 13.064 14.126 18.435 23.19 33.604 43.689 51.55 45.205 44.116 37.991 34.55 29.07 23.254 17.135 14.216 10.518 8.089 7.569 9.011 8.504 7.198 6.613 6.993 6.462 6.455 6.442 6.01 4.745 4.857 7.12 9.176 9.711 6.751 4.428 4.687 9.344 12.24 9.207 8.856 8.541 11.816 10.794 9.446 8.207 8.237 8.211 2024-01-24 8.207 8.19 8.201 8.074 6.592 5.821 5.554 5.581 5.842 6.528 6.346 5.266 3.436 3.484 3.473 3.09 2.802 3.389 1.023 3.512 10.802 34.45 49.679 70.04 68.276 60.575 49.677 47.835 76.674 76.174 90.454 80.571 60.839 53.114 46.012 42.094 39.411 39.372 37.508 21.78 17.108 17.499 17.159 16.81 11.941 11.277 9.12 10.054 12.148 12.271 14.639 15.744 15.034 23.343 39.309 54.535 62.153 62.073 52.188 42.177 32.45 21.213 18.164 13.591 12.594 7.969 9.359 9.139 6.197 4.062 3.543 5.022 7.932 6.503 5.124 2.638 0 0 0 0 0.001 1.773 2.786 2.784 1.093 2.025 8.271 7.759 7.941 6.034 5.768 5.496 4.224 2.884 2.806 2.805 2024-01-25 2.805 2.809 2.812 2.816 2.818 2.815 2.817 2.816 2.823 2.812 2.828 2.812 2.635 0 0 0 0.038 0.981 0.86 0.71 7.744 28.409 38.188 42.679 49.859 54.294 56.38 53.666 50.211 52.226 53.525 51.689 58.488 59.244 65.383 59.97 51.191 49.924 42.612 37.87 36.152 34.031 30.354 20.121 14.41 9.927 11.105 11.117 11.812 11.175 10.362 8.395 14.675 17.505 24.116 38.168 50.972 44.266 39.299 34.682 27.407 22.279 18.34 18.987 12.616 6.914 5.173 7.113 4.223 7.531 5.383 3.588 1.874 0.916 1.113 3.732 3.737 3.745 3.227 2.799 2.794 2.795 2.795 2.79 3.012 6.534 7.224 8.465 7.67 8.427 9.735 10.624 9.007 8.375 6.233 5.607 2024-01-26 5.615 5.617 5.611 5.613 5.595 4.616 2.806 2.823 2.84 2.812 2.823 2.795 2.986 3.766 3.691 1.946 0.118 0 1.565 2.84 9.659 35.57 48.296 61.407 71.209 64.424 57.193 53.108 52.462 45.768 37.082 33.311 30.936 27.205 24.178 32.422 31.257 23.255 15.685 12.433 11.588 11.596 5.122 5.329 3.46 1.679 1.459 1.686 4.212 6.762 8.422 8.469 13.504 25.613 26.587 38.844 54.594 54.44 44.473 38.846 30.033 24.952 20.631 18.265 17.346 17.806 17.37 16.467 15.1 7.664 5.137 4.69 4.267 4.485 4.263 4.25 4.463 4.252 4.259 2.94 1.652 1.448 1.448 1.448 2.258 2.393 2.102 3.192 4.258 3.815 3.958 6.453 3.757 1.595 1.248 1.139 2024-01-27 0.603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.551 3.148 2.786 2.787 2.804 2.788 2.807 2.81 2.798 2.819 5.108 5.576 7.425 7.568 7.055 5.867 5.559 5.58 5.56 7.018 9.772 11.182 11.311 11.275 10.398 8.517 8.549 8.545 7.613 5.781 5.773 5.096 3.591 7.462 7.362 5.703 3.952 1.014 0.843 0.852 0.523 0.805 0.495 0.31 0.207 0.148 0.055 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.337 1.932 2.818 2.801 2.818 2.802 0.12 0 0 0 0 0 2024-01-28 0 0 0 0 0 0 0 0 0 0 0.002 0 0 0 0 0 0 0 0 0 0 0.254 4.105 6.742 8.263 5.873 5.466 5.46 5.469 3.732 2.643 2.617 1.407 0.485 0.132 0 0 0 0 0 0 0 0 0 0 0 0.305 2.826 2.836 2.84 1.359 2.845 0.449 0 0 0 0.002 1.736 1.761 1.751 2.761 6.379 4.555 3.448 3.127 1.762 1.591 0.458 0 0.001 0 0 0.101 1.121 0.004 0 0 0 0 0.028 2.759 2.826 2.812 2.814 2.811 3.797 6.259 9.062 10.097 10.12 10.093 5.751 4.535 4.533 4.362 4.216 2024-01-29 4.091 3.995 2.18 0.978 0.435 0 0 0 0 0 0 0 0 0 0 0 0 0 0.167 1.043 5.644 16.421 42.128 64.618 69.713 78.306 83.247 80.756 82.278 75.248 72.082 66.701 62.376 58.109 58.443 53.462 49.95 46.24 43.267 36.525 32.439 25.297 24.952 19.309 17.962 14.439 10.333 6.235 4.644 2.489 3.436 3.177 5.028 18.608 32.518 43.318 51.023 58.901 51.323 43.267 40.966 35.597 30.435 27.723 23.407 21.955 20.735 19.96 17.296 13.87 14.435 10.861 6.628 5.66 5.616 3.486 2.816 2.812 2.829 4.576 3.044 2.808 5.064 5.657 5.664 7.89 9.156 10.758 11.588 12.175 11.124 10.841 8.069 5.759 5.535 5.284 2024-01-30 3.914 3.253 2.909 2.902 2.898 2.896 2.898 0.426 0 0 0 0 0 0 0 0 0 0 0 0 3.988 14.357 30.821 52.712 71.941 80.226 83.017 79.31 78.091 77.039 81.877 82.246 72.94 69.314 60.952 56.935 58.666 78.971 79.591 67.511 50.869 39.749 35.752 32.777 24.141 21.825 20.329 17.26 15.895 16.381 13.58 15.237 20.233 22.815 23.904 34.591 75.653 78.277 42.244 33.556 22.638 15.633 12.8 7.703 4.466 6.232 9.326 8.903 5.952 3.114 0.751 0.795 0.052 0 0 0 0 0 1.241 2.831 15.824 12.387 9.012 5.601 5.613 8.66 9.899 13.684 13.966 9.178 9.705 7.465 7.414 3.69 2.126 2.879 2024-01-31 2.743 0.318 0 0 0.255 0.023 0 0 0 0 0 0 0 0 0.397 0 0 0 0.893 4.265 7.063 16.334 28.253 40.819 52.107 61.469 61.784 57.635 49.4 47.119 47.516 51.66 54.834 52.8 60.026 55.749 39.395 32.394 31.623 30.28 27.163 26.781 23.372 21.885 16.668 10.528 8.28 8.134 9.245 11.116 12.454 15.366 22.496 29.827 30.417 32.253 64.18 59.308 45.191 32.813 27.145 20.934 16.069 14.091 12.192 11.962 9.891 9.28 9.282 6.614 5.896 1.888 0 0.001 0.001 0 0 0 0.669 1.403 2.815 2.807 2.802 3.087 2.043 1.628 4.12 10.338 13.341 13.462 11.593 8.874 7.488 5.472 3.263 2.812
So fixing the file format and importing it requires very few llines of code... and you get a proper CSV file as well :)
  1 comentario
Hicham
Hicham el 16 de Feb. de 2024
thank you for the step by step explanations. its also works very well

Iniciar sesión para comentar.

Austin M. Weber
Austin M. Weber el 14 de Feb. de 2024
Ran in:
@Hicham,
Here is another way that you could import your data, but keeping the variable names from the original file.
filename = 'EnergyLIS.csv';
T_initial = readtable(filename,...
'Delimiter',',',...
'VariableNamingRule','preserve');
variable_names = T_initial.Properties.VariableNames;
col1 = T_initial.Datum;
col1 = string(col1);
col1 = strrep(col1,'",','";');
col1 = strrep(col1,',"',';"');
col1 = strrep(col1,',','.');
col1 = strrep(col1,'"','');
col1 = arrayfun(@(x) strsplit(x,';'), col1, 'UniformOutput', false);
cols_split = [];
for i = 1:length(col1)
cols_split = [cols_split ;col1{i}];
end
cols_split;
cols_datum = datetime(cols_split(:,1),'Format','MM-dd-uuuu');
cols_numeric = double(cols_split(:,2:end));
T_final = array2table(cols_numeric,'VariableNames',variable_names(2:end));
T_final.Datum = cols_datum;
T_final = movevars(T_final,'Datum','Before','00:00')
T_final = 30×97 table
Datum 00:00 00:15 00:30 00:45 01:00 01:15 01:30 01:45 02:00 02:15 02:30 02:45 03:00 03:15 03:30 03:45 04:00 04:15 04:30 04:45 05:00 05:15 05:30 05:45 06:00 06:15 06:30 06:45 07:00 07:15 07:30 07:45 08:00 08:15 08:30 08:45 09:00 09:15 09:30 09:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 13:00 13:15 13:30 13:45 14:00 14:15 14:30 14:45 15:00 15:15 15:30 15:45 16:00 16:15 16:30 16:45 17:00 17:15 17:30 17:45 18:00 18:15 18:30 18:45 19:00 19:15 19:30 19:45 20:00 20:15 20:30 20:45 21:00 21:15 21:30 21:45 22:00 22:15 22:30 22:45 23:00 23:15 23:30 23:45 __________ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ _____ _____ _____ ______ ______ _____ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ ______ _____ 01-16-2024 0 0.58 2.808 2.805 2.813 2.813 2.797 2.817 2.819 2.476 0 0 0 0 0 0 0 0 0.555 2.819 9.577 23.35 42.269 62.843 72.287 74.869 81.823 84.279 78.114 75.484 69.806 63.326 54.432 53.215 52.569 53.354 53.185 50.893 43.319 46.548 43.336 40.657 43.293 26.16 19.99 20.694 16.778 15.963 11.468 10.472 10.487 11.731 22.936 26.528 40.116 51.822 63.06 58.533 55.868 46.854 34.659 24.963 19.748 16.207 13.968 13.089 10.679 7.264 7.379 7.399 6.478 6.019 5.507 5.512 5.501 5.508 5.51 3.968 1.399 2.144 2.771 5.371 7.702 8.779 6.725 9.251 16.857 24.982 34.633 28.194 28.543 27.612 20.685 14.526 13.892 12.16 01-17-2024 8.793 8.354 6.327 5.819 5.798 5.567 5.772 3.615 2.803 2.784 3.019 2.792 2.786 0.922 0.215 0 0 0 0.646 1.693 16.073 18.703 50.842 58.587 59.758 62.291 68.434 66.023 61.297 61.539 71.804 74.832 69.938 54.997 43.461 39.526 40.237 38.053 34.837 31.702 23.352 20.434 22.155 19.333 16.47 15.567 16.358 16.722 18.291 10.48 8.639 8.458 12.959 24.771 34.972 64.197 99.029 94.645 80.046 49.654 37.904 29.502 24.083 22.591 20.429 20.193 15.029 13.136 11.187 14.956 14.079 13.983 13.251 7.54 3.945 2.808 2.356 0 0.002 0.187 2.7 2.824 2.752 2.975 3.57 3.153 9.229 12.349 28.236 39.275 18.769 14.353 9.688 6.514 3.456 0.441 01-18-2024 0.507 0.202 0.137 0.082 0.411 0 0 0 0.214 0 0 0 0 0.213 0 0 0 0.297 0 2.222 10.393 20.163 38.942 49.895 66.931 69.099 64.881 58.019 51.546 46.416 43.138 36.898 39.323 38.839 34.772 33.194 32.704 28.594 25.258 28.522 28.351 24.611 20.707 16.979 15.141 15.132 13.597 12.701 13.259 14.74 13.161 15.592 21.183 24.87 29.387 42.109 54.716 54.567 46.48 38.179 25.299 13.621 10.669 9.169 3.464 4.882 4.548 5.037 3.493 4.039 5.042 2.794 2.792 2.791 2.785 2.783 2.397 2.637 2.636 2.65 6.909 7.741 8.752 10.572 10.675 11.024 13.943 20.745 21.204 24.66 22.882 20.613 14.697 9.432 7.302 7.152 01-19-2024 7.297 6.994 6.876 6.693 4.241 3.966 3.97 3.963 4.289 3.942 3.936 3.927 4.202 1.178 1.151 0.985 1.157 1.464 1.147 2.197 10.504 25.687 37.01 57.468 61.466 64.225 67.325 60.447 49.667 48.288 52.404 45.56 50.17 41.204 36.873 34.685 35.776 37.228 36.833 37.569 36.595 33.658 29.26 24.963 22.052 19.983 14.799 13.245 12.766 10.899 10.72 8.194 12.635 23.693 33.338 51.208 60.487 62.773 66.283 45.056 32.955 26.158 21.082 20.223 15.824 14.853 10.294 9.84 9.446 8.335 8.09 7.256 6.771 4.28 5.536 5.517 4.98 2.797 0.519 0 0.078 0 0 0.162 3.719 9.06 11.965 19.447 17.164 21.808 22.454 21.937 16.817 7.784 9.069 5.858 01-20-2024 5.786 5.785 5.722 5.597 2.252 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.248 1.289 2.568 3.114 2.988 2.8 2.801 2.799 2.779 2.794 2.796 2.783 3.272 3.433 2.804 2.815 2.796 2.802 2.815 2.795 2.801 2.804 2.808 4.589 2.81 2.726 0.583 2.417 3.636 3.72 3.925 3.695 4.843 5.62 8.001 8.374 8.356 8.356 8.339 8.339 8.349 7.702 5.958 5.563 5.567 5.026 3.123 2.804 1.365 0 0 0 0 0 0 0 0 0 0 2.193 4.87 3.551 1.96 1.589 0.17 0 0 0.671 0.663 0 0 0 0 0 0 0 01-21-2024 0 0 0 0 0 0.19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.535 2.367 0 0 0 0 0 1.09 2.834 2.84 2.845 2.845 2.846 2.831 2.859 2.843 2.864 2.855 2.851 2.86 1.421 0 0 0 0 0 0 0 0 0 1.036 2.785 2.798 2.799 0.696 0 0 0 1.518 1.824 4.394 4.603 3.236 2.779 2.78 2.781 2.764 2.778 2.795 01-22-2024 2.768 2.822 2.808 2.82 2.823 2.822 2.818 2.82 2.819 2.82 2.818 2.814 2.804 1.533 0 0 0 0.002 0 2.097 10.276 37.099 64.181 81.681 87.109 98.691 101.22 86.954 80.581 65.926 58.538 63.237 73.318 73.779 74.354 70.375 58.568 57.945 45.352 42.325 38.27 34.281 29.629 25.214 27.698 22.215 17.372 13.047 12.949 12.085 13.523 14.161 18.736 25.478 38.336 49.217 53.57 52.728 52.151 46.37 42.111 34.139 29.566 23.916 23.209 21.153 19.386 17.12 13.594 13.989 13.535 13.583 12.417 11.587 10.952 10.599 6.157 4.429 2.719 0.302 1.608 2.852 5.419 5.645 6.254 5.521 5.166 7.398 8.678 9.681 9.011 9.603 7.691 5.636 5.596 5.603 01-23-2024 5.608 5.613 5.616 5.61 5.596 5.612 5.606 5.588 5.622 5.591 4.517 2.821 2.828 2.819 2.806 1.429 0.642 0.95 0.934 1.67 4.956 27.87 49.803 67.664 84.104 81.197 75.925 60.944 56.956 65.769 71.611 77.047 80.211 80.282 70.152 69.38 69.696 66.56 63.596 63.242 60.829 53.027 42.486 37.499 28.868 22.03 18.447 18.872 18.767 15.185 13.064 14.126 18.435 23.19 33.604 43.689 51.55 45.205 44.116 37.991 34.55 29.07 23.254 17.135 14.216 10.518 8.089 7.569 9.011 8.504 7.198 6.613 6.993 6.462 6.455 6.442 6.01 4.745 4.857 7.12 9.176 9.711 6.751 4.428 4.687 9.344 12.24 9.207 8.856 8.541 11.816 10.794 9.446 8.207 8.237 8.211 01-24-2024 8.207 8.19 8.201 8.074 6.592 5.821 5.554 5.581 5.842 6.528 6.346 5.266 3.436 3.484 3.473 3.09 2.802 3.389 1.023 3.512 10.802 34.45 49.679 70.04 68.276 60.575 49.677 47.835 76.674 76.174 90.454 80.571 60.839 53.114 46.012 42.094 39.411 39.372 37.508 21.78 17.108 17.499 17.159 16.81 11.941 11.277 9.12 10.054 12.148 12.271 14.639 15.744 15.034 23.343 39.309 54.535 62.153 62.073 52.188 42.177 32.45 21.213 18.164 13.591 12.594 7.969 9.359 9.139 6.197 4.062 3.543 5.022 7.932 6.503 5.124 2.638 0 0 0 0 0.001 1.773 2.786 2.784 1.093 2.025 8.271 7.759 7.941 6.034 5.768 5.496 4.224 2.884 2.806 2.805 01-25-2024 2.805 2.809 2.812 2.816 2.818 2.815 2.817 2.816 2.823 2.812 2.828 2.812 2.635 0 0 0 0.038 0.981 0.86 0.71 7.744 28.409 38.188 42.679 49.859 54.294 56.38 53.666 50.211 52.226 53.525 51.689 58.488 59.244 65.383 59.97 51.191 49.924 42.612 37.87 36.152 34.031 30.354 20.121 14.41 9.927 11.105 11.117 11.812 11.175 10.362 8.395 14.675 17.505 24.116 38.168 50.972 44.266 39.299 34.682 27.407 22.279 18.34 18.987 12.616 6.914 5.173 7.113 4.223 7.531 5.383 3.588 1.874 0.916 1.113 3.732 3.737 3.745 3.227 2.799 2.794 2.795 2.795 2.79 3.012 6.534 7.224 8.465 7.67 8.427 9.735 10.624 9.007 8.375 6.233 5.607 01-26-2024 5.615 5.617 5.611 5.613 5.595 4.616 2.806 2.823 2.84 2.812 2.823 2.795 2.986 3.766 3.691 1.946 0.118 0 1.565 2.84 9.659 35.57 48.296 61.407 71.209 64.424 57.193 53.108 52.462 45.768 37.082 33.311 30.936 27.205 24.178 32.422 31.257 23.255 15.685 12.433 11.588 11.596 5.122 5.329 3.46 1.679 1.459 1.686 4.212 6.762 8.422 8.469 13.504 25.613 26.587 38.844 54.594 54.44 44.473 38.846 30.033 24.952 20.631 18.265 17.346 17.806 17.37 16.467 15.1 7.664 5.137 4.69 4.267 4.485 4.263 4.25 4.463 4.252 4.259 2.94 1.652 1.448 1.448 1.448 2.258 2.393 2.102 3.192 4.258 3.815 3.958 6.453 3.757 1.595 1.248 1.139 01-27-2024 0.603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.551 3.148 2.786 2.787 2.804 2.788 2.807 2.81 2.798 2.819 5.108 5.576 7.425 7.568 7.055 5.867 5.559 5.58 5.56 7.018 9.772 11.182 11.311 11.275 10.398 8.517 8.549 8.545 7.613 5.781 5.773 5.096 3.591 7.462 7.362 5.703 3.952 1.014 0.843 0.852 0.523 0.805 0.495 0.31 0.207 0.148 0.055 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.337 1.932 2.818 2.801 2.818 2.802 0.12 0 0 0 0 0 01-28-2024 0 0 0 0 0 0 0 0 0 0 0.002 0 0 0 0 0 0 0 0 0 0 0.254 4.105 6.742 8.263 5.873 5.466 5.46 5.469 3.732 2.643 2.617 1.407 0.485 0.132 0 0 0 0 0 0 0 0 0 0 0 0.305 2.826 2.836 2.84 1.359 2.845 0.449 0 0 0 0.002 1.736 1.761 1.751 2.761 6.379 4.555 3.448 3.127 1.762 1.591 0.458 0 0.001 0 0 0.101 1.121 0.004 0 0 0 0 0.028 2.759 2.826 2.812 2.814 2.811 3.797 6.259 9.062 10.097 10.12 10.093 5.751 4.535 4.533 4.362 4.216 01-29-2024 4.091 3.995 2.18 0.978 0.435 0 0 0 0 0 0 0 0 0 0 0 0 0 0.167 1.043 5.644 16.421 42.128 64.618 69.713 78.306 83.247 80.756 82.278 75.248 72.082 66.701 62.376 58.109 58.443 53.462 49.95 46.24 43.267 36.525 32.439 25.297 24.952 19.309 17.962 14.439 10.333 6.235 4.644 2.489 3.436 3.177 5.028 18.608 32.518 43.318 51.023 58.901 51.323 43.267 40.966 35.597 30.435 27.723 23.407 21.955 20.735 19.96 17.296 13.87 14.435 10.861 6.628 5.66 5.616 3.486 2.816 2.812 2.829 4.576 3.044 2.808 5.064 5.657 5.664 7.89 9.156 10.758 11.588 12.175 11.124 10.841 8.069 5.759 5.535 5.284 01-30-2024 3.914 3.253 2.909 2.902 2.898 2.896 2.898 0.426 0 0 0 0 0 0 0 0 0 0 0 0 3.988 14.357 30.821 52.712 71.941 80.226 83.017 79.31 78.091 77.039 81.877 82.246 72.94 69.314 60.952 56.935 58.666 78.971 79.591 67.511 50.869 39.749 35.752 32.777 24.141 21.825 20.329 17.26 15.895 16.381 13.58 15.237 20.233 22.815 23.904 34.591 75.653 78.277 42.244 33.556 22.638 15.633 12.8 7.703 4.466 6.232 9.326 8.903 5.952 3.114 0.751 0.795 0.052 0 0 0 0 0 1.241 2.831 15.824 12.387 9.012 5.601 5.613 8.66 9.899 13.684 13.966 9.178 9.705 7.465 7.414 3.69 2.126 2.879 01-31-2024 2.743 0.318 0 0 0.255 0.023 0 0 0 0 0 0 0 0 0.397 0 0 0 0.893 4.265 7.063 16.334 28.253 40.819 52.107 61.469 61.784 57.635 49.4 47.119 47.516 51.66 54.834 52.8 60.026 55.749 39.395 32.394 31.623 30.28 27.163 26.781 23.372 21.885 16.668 10.528 8.28 8.134 9.245 11.116 12.454 15.366 22.496 29.827 30.417 32.253 64.18 59.308 45.191 32.813 27.145 20.934 16.069 14.091 12.192 11.962 9.891 9.28 9.282 6.614 5.896 1.888 0 0.001 0.001 0 0 0 0.669 1.403 2.815 2.807 2.802 3.087 2.043 1.628 4.12 10.338 13.341 13.462 11.593 8.874 7.488 5.472 3.263 2.812

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by