read csv file with a lot of columns.

30 Mär. 2022
2 Antworten
Aktualisiert 31 Mär. 2022
10 Ansichten (30 Tage)

0 Stimmen

Hello guys, i have the uploaded .csv file and i would like to only read the numbers that start with 0. how do i that? i tried 'readtable' and it reads but it puts everything in one cell and for textscan it has way too many columns.
I would appreciate some help thanks!

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (2)

Stephen23
Stephen23 am 31 Mär. 2022
Bearbeitet: Stephen23 am 31 Mär. 2022
Ran in:

1 Stimme

Ran in:
A much better approach would use READTABLE to correctly import that numeric data (with decimal-commas in what is actually a semicolon-separated values file, not a CSV file). Do not import numeric data as text, as you are doing now. Fiddling around with text like that is fragile and inefficient.
T = readtable('rawdata.csv','FileType','text', 'Delimiter',';', 'DecimalSeparator',',',...
'ReadVariableNames',true, 'VariableNamingRule','preserve')
T = 92×130 table
Var1 908,1 914,294 920,489 926,683 932,877 939,072 945,266 951,46 957,655 963,849 970,044 976,238 982,432 988,627 994,821 1001,015 1007,21 1013,404 1019,598 1025,793 1031,987 1038,181 1044,376 1050,57 1056,764 1062,959 1069,153 1075,348 1081,542 1087,736 1093,931 1100,125 1106,319 1112,514 1118,708 1124,902 1131,097 1137,291 1143,485 1149,68 1155,874 1162,069 1168,263 1174,457 1180,652 1186,846 1193,04 1199,235 1205,429 1211,623 1217,818 1224,012 1230,206 1236,401 1242,595 1248,789 1254,984 1261,178 1267,373 1273,567 1279,761 1285,956 1292,15 1298,344 1304,539 1310,733 1316,927 1323,122 1329,316 1335,51 1341,705 1347,899 1354,094 1360,288 1366,482 1372,677 1378,871 1385,065 1391,26 1397,454 1403,648 1409,843 1416,037 1422,231 1428,426 1434,62 1440,814 1447,009 1453,203 1459,398 1465,592 1471,786 1477,981 1484,175 1490,369 1496,564 1502,758 1508,952 1515,147 1521,341 1527,535 1533,73 1539,924 1546,119 1552,313 1558,507 1564,702 1570,896 1577,09 1583,285 1589,479 1595,673 1601,868 1608,062 1614,256 1620,451 1626,645 1632,839 1639,034 1645,228 1651,423 1657,617 1663,811 1670,006 1676,2 Instrument Serial Number Temperature Notes Timestamp ____________________________ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ _______ ________ _______ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ _______ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ ________ _______ ________________________ ___________ _____ ___________________ {'Test-1.sam' } 0.83221 0.84018 0.84497 0.85111 0.85665 0.86114 0.86451 0.8665 0.86738 0.86788 0.86838 0.86873 0.86887 0.86825 0.8671 0.86564 0.86432 0.86318 0.86272 0.86209 0.86029 0.85956 0.85867 0.85694 0.85604 0.85543 0.85439 0.85327 0.85263 0.85151 0.85052 0.84977 0.84874 0.84828 0.84749 0.84644 0.84566 0.84442 0.84383 0.84308 0.84211 0.84122 0.84035 0.83933 0.83824 0.83746 0.83671 0.83557 0.83477 0.83396 0.833 0.83175 0.831 0.82983 0.829 0.82813 0.82721 0.82628 0.82546 0.82438 0.82337 0.82269 0.82179 0.82078 0.82033 0.81935 0.81845 0.81798 0.8172 0.81616 0.81544 0.81456 0.81345 0.81294 0.81228 0.81149 0.81095 0.81022 0.80915 0.80847 0.80774 0.80697 0.80662 0.80609 0.80521 0.80471 0.80402 0.80337 0.80306 0.8026 0.80205 0.80164 0.80102 0.80025 0.7997 0.79926 0.79857 0.79812 0.79782 0.79712 0.79666 0.79629 0.79555 0.79518 0.79492 0.79409 0.79356 0.79323 0.79244 0.79191 0.79167 0.79095 0.79026 0.79007 0.78926 0.7887 0.78843 0.7877 0.78713 0.78683 0.78594 0.78513 0.78472 0.78402 0.78326 {'S1-PAT50023'} 37.562 NaN 15.03.2022 11:44:55 {'Probe-86Prozent-rF-1.sam'} 0.85061 0.85773 0.8645 0.87072 0.87581 0.88141 0.88596 0.8884 0.88963 0.89001 0.89014 0.89051 0.89047 0.8901 0.88947 0.8876 0.88674 0.88603 0.885 0.88445 0.88337 0.88197 0.88066 0.87961 0.87892 0.87783 0.87635 0.8756 0.87496 0.87376 0.87303 0.87231 0.87112 0.87046 0.86983 0.86919 0.86806 0.86701 0.86649 0.86542 0.8644 0.86346 0.86269 0.86165 0.86078 0.85973 0.85897 0.85791 0.85689 0.8563 0.85512 0.85419 0.85293 0.85192 0.85071 0.85002 0.84907 0.84798 0.84741 0.84638 0.8454 0.84448 0.84343 0.84247 0.84194 0.84085 0.83999 0.83946 0.83859 0.83775 0.83692 0.83606 0.83493 0.83432 0.83357 0.83276 0.83203 0.83131 0.83018 0.82963 0.82894 0.8281 0.8275 0.82682 0.82595 0.8254 0.82461 0.82382 0.82346 0.82309 0.82242 0.82207 0.82152 0.8205 0.81997 0.81953 0.81872 0.81819 0.81776 0.81704 0.81661 0.81613 0.81541 0.81496 0.81459 0.81385 0.81321 0.81286 0.81203 0.81145 0.81121 0.81034 0.80965 0.80943 0.80869 0.80799 0.8076 0.80682 0.80614 0.80586 0.80495 0.80409 0.80355 0.80274 0.80172 {'S1-PAT50023'} 37.812 NaN 15.03.2022 11:48:52 {'Probe-86Prozent-rF-2.sam'} 0.84862 0.85574 0.86245 0.86952 0.87501 0.88011 0.88381 0.88687 0.88773 0.88847 0.88893 0.88894 0.88876 0.88808 0.88784 0.8865 0.88534 0.88469 0.88373 0.88286 0.88152 0.88049 0.87924 0.87808 0.87707 0.87611 0.87487 0.87391 0.8736 0.87214 0.87121 0.87079 0.8696 0.869 0.86832 0.86725 0.86617 0.86548 0.86477 0.86363 0.86286 0.86188 0.86084 0.86002 0.85901 0.85802 0.85729 0.85614 0.85544 0.85458 0.85344 0.85228 0.85164 0.85022 0.84891 0.84827 0.84749 0.84644 0.84566 0.84467 0.84362 0.84272 0.84173 0.8407 0.84011 0.83895 0.83811 0.83771 0.83708 0.83604 0.83512 0.83428 0.83312 0.83244 0.8317 0.83093 0.83022 0.82951 0.82849 0.82781 0.82708 0.82629 0.82566 0.82499 0.82419 0.82357 0.82274 0.82207 0.82172 0.82131 0.82065 0.82024 0.81963 0.8187 0.81822 0.81776 0.81697 0.81646 0.81601 0.81526 0.81477 0.81432 0.81359 0.81315 0.81282 0.81206 0.81145 0.81107 0.81027 0.80967 0.80941 0.80864 0.80795 0.80762 0.80681 0.80616 0.80586 0.80507 0.80454 0.8041 0.80319 0.80235 0.80178 0.80084 0.79998 {'S1-PAT50023'} 37.75 NaN 15.03.2022 11:49:10 {'Probe-86Prozent-rF-3.sam'} 0.84783 0.85473 0.86147 0.86849 0.87483 0.87965 0.88252 0.8852 0.88749 0.88762 0.88795 0.88876 0.88848 0.88763 0.88652 0.88531 0.88439 0.88346 0.88289 0.88182 0.88053 0.87978 0.87852 0.87741 0.87612 0.87492 0.87416 0.87307 0.87241 0.87146 0.87049 0.86974 0.86879 0.86794 0.86716 0.86637 0.86523 0.8644 0.86381 0.86299 0.86185 0.86096 0.86011 0.8593 0.85831 0.85732 0.85645 0.85529 0.85417 0.85352 0.85269 0.85152 0.85047 0.84938 0.84809 0.84746 0.84631 0.84555 0.84478 0.84381 0.84278 0.8418 0.84071 0.8397 0.83923 0.83831 0.83742 0.83674 0.836 0.83495 0.83432 0.83346 0.8323 0.83156 0.83081 0.83006 0.82928 0.82864 0.8275 0.82686 0.82622 0.82547 0.82485 0.82416 0.82328 0.82271 0.82189 0.82119 0.82091 0.82051 0.81978 0.81936 0.81884 0.81795 0.81741 0.81692 0.81611 0.81558 0.81513 0.81442 0.81398 0.81351 0.81275 0.81232 0.81198 0.81119 0.81057 0.81014 0.80942 0.80893 0.8086 0.80778 0.80708 0.80681 0.80597 0.8053 0.80505 0.80419 0.80363 0.80327 0.80232 0.80156 0.80093 0.80004 0.7991 {'S1-PAT50023'} 37.812 NaN 15.03.2022 11:49:30 {'Probe-86Prozent-rF-4.sam'} 0.84765 0.85469 0.86228 0.86877 0.87488 0.87894 0.88285 0.88546 0.88746 0.88677 0.88719 0.88737 0.88734 0.88711 0.88655 0.88566 0.88406 0.88328 0.8825 0.88154 0.8806 0.87952 0.87826 0.87665 0.87588 0.87504 0.8739 0.8731 0.87224 0.87082 0.87013 0.86976 0.86851 0.86776 0.86713 0.86617 0.86519 0.86423 0.86373 0.86242 0.86166 0.86057 0.85974 0.85894 0.85798 0.85713 0.85594 0.85498 0.85403 0.85351 0.85238 0.85122 0.85018 0.8491 0.84795 0.84706 0.84618 0.84517 0.84428 0.84344 0.84254 0.84168 0.8406 0.83949 0.83892 0.83799 0.8371 0.83653 0.83563 0.83465 0.83396 0.833 0.832 0.83129 0.83055 0.82973 0.82902 0.82825 0.82728 0.82663 0.82596 0.82522 0.82461 0.82386 0.82302 0.82249 0.82168 0.82095 0.82055 0.82008 0.8194 0.81906 0.81854 0.81765 0.81719 0.81668 0.8158 0.81523 0.81475 0.81409 0.81366 0.81317 0.81246 0.81203 0.81167 0.81083 0.81027 0.80993 0.80911 0.80851 0.80829 0.80743 0.80673 0.80655 0.80569 0.80497 0.80473 0.80392 0.80334 0.80294 0.80201 0.80115 0.80064 0.79973 0.79878 {'S1-PAT50023'} 37.812 NaN 15.03.2022 11:49:50 {'Probe-86Prozent-rF-5.sam'} 0.84676 0.85449 0.8615 0.86856 0.87419 0.87867 0.88299 0.88497 0.88675 0.88697 0.88697 0.88791 0.8882 0.88737 0.88625 0.88536 0.88415 0.88303 0.88226 0.88138 0.88017 0.87914 0.87801 0.87683 0.87612 0.87503 0.87359 0.87272 0.87237 0.87072 0.86986 0.86949 0.86835 0.86765 0.86674 0.86618 0.86496 0.86397 0.86332 0.86222 0.86149 0.86058 0.85975 0.85892 0.85776 0.85663 0.85579 0.85483 0.85402 0.85335 0.85224 0.85123 0.85018 0.84895 0.84781 0.84706 0.84605 0.84516 0.84428 0.84332 0.84231 0.84133 0.84037 0.83937 0.83881 0.83779 0.83678 0.8364 0.83563 0.83457 0.83386 0.83291 0.83182 0.83119 0.83039 0.82962 0.82901 0.82812 0.82709 0.82652 0.82589 0.825 0.82448 0.8238 0.8229 0.82229 0.8215 0.8208 0.82045 0.82002 0.81932 0.81902 0.81853 0.81756 0.81699 0.81646 0.8157 0.8152 0.81477 0.814 0.81349 0.81305 0.81234 0.81188 0.8115 0.81077 0.81025 0.80984 0.80894 0.80842 0.80823 0.80733 0.80666 0.80643 0.80559 0.80492 0.80468 0.80386 0.80323 0.80282 0.8019 0.80108 0.80045 0.79961 0.79859 {'S1-PAT50023'} 37.875 NaN 15.03.2022 11:50:10 {'Probe-86Prozent-rF-6.sam'} 0.84862 0.85568 0.86336 0.86909 0.87401 0.87988 0.88399 0.88564 0.8879 0.88827 0.88828 0.88834 0.88819 0.88765 0.88681 0.88551 0.88463 0.88364 0.88309 0.8824 0.88047 0.87968 0.87884 0.87722 0.87605 0.87514 0.87412 0.87308 0.87233 0.87111 0.8704 0.86989 0.86833 0.86778 0.86713 0.86617 0.8652 0.86418 0.86356 0.8626 0.86163 0.86064 0.86012 0.85911 0.85816 0.8573 0.85608 0.85484 0.85418 0.85351 0.85254 0.85137 0.85018 0.8491 0.84795 0.84706 0.84605 0.84529 0.84465 0.84345 0.84242 0.84156 0.84049 0.83948 0.83892 0.83789 0.837 0.83633 0.83569 0.83466 0.83404 0.83311 0.83183 0.83126 0.83048 0.82971 0.82902 0.82825 0.82721 0.82654 0.82587 0.82519 0.82467 0.82389 0.82303 0.82239 0.82162 0.82094 0.82059 0.82012 0.8194 0.81906 0.81855 0.81758 0.81705 0.81661 0.81576 0.8152 0.81476 0.81406 0.81359 0.81313 0.81243 0.81197 0.81163 0.81084 0.81027 0.8099 0.80902 0.80851 0.80827 0.80741 0.80673 0.80643 0.80572 0.805 0.80466 0.80387 0.80328 0.80283 0.802 0.80105 0.80064 0.7996 0.79859 {'S1-PAT50023'} 37.875 NaN 15.03.2022 11:50:30 {'Probe-86Prozent-rF-7.sam'} 0.84761 0.85475 0.86141 0.86927 0.87503 0.88011 0.88397 0.88572 0.8868 0.88791 0.88788 0.8881 0.8882 0.88761 0.88707 0.88586 0.88438 0.88328 0.88224 0.88136 0.88035 0.87953 0.8784 0.87703 0.87609 0.87502 0.87375 0.8729 0.87217 0.87078 0.87026 0.86949 0.86844 0.86758 0.86717 0.86612 0.86502 0.86414 0.86337 0.86262 0.86164 0.8606 0.8599 0.85876 0.85796 0.8568 0.85595 0.85483 0.85401 0.85319 0.85224 0.85123 0.85018 0.84895 0.84768 0.84706 0.84605 0.84503 0.84453 0.84345 0.84231 0.84133 0.84048 0.83937 0.83891 0.83779 0.83699 0.83643 0.83562 0.83456 0.83395 0.83284 0.83189 0.8312 0.83048 0.82948 0.82889 0.82824 0.82704 0.82656 0.82593 0.82498 0.82453 0.82383 0.82296 0.82227 0.82147 0.82074 0.82042 0.82002 0.81935 0.81891 0.81844 0.81756 0.81695 0.81644 0.81563 0.81514 0.81467 0.81397 0.81351 0.813 0.81238 0.81192 0.81149 0.81077 0.81025 0.80983 0.80897 0.80846 0.80822 0.8073 0.80664 0.80651 0.80557 0.80487 0.80462 0.80381 0.80323 0.80282 0.8019 0.80102 0.80039 0.79949 0.79853 {'S1-PAT50023'} 37.875 NaN 15.03.2022 11:50:50 {'Probe-67Prozent-rF-1.sam'} 0.82836 0.83681 0.84431 0.85049 0.85639 0.86117 0.86444 0.86701 0.868 0.869 0.8692 0.86964 0.86968 0.86925 0.86864 0.86716 0.86657 0.86572 0.86456 0.86349 0.86219 0.86173 0.86087 0.85928 0.85828 0.85748 0.85622 0.85539 0.85479 0.8535 0.85303 0.85262 0.8514 0.85078 0.8499 0.84927 0.84825 0.8473 0.84657 0.84563 0.84494 0.84394 0.84304 0.84234 0.84161 0.84054 0.83959 0.83853 0.83766 0.83694 0.83608 0.83529 0.83418 0.83293 0.8319 0.83097 0.82998 0.82923 0.8287 0.82777 0.8268 0.82583 0.82504 0.82409 0.82336 0.82238 0.82161 0.82118 0.82032 0.81948 0.81872 0.81792 0.81704 0.81635 0.81559 0.81483 0.81412 0.8135 0.81247 0.81198 0.81142 0.81071 0.81011 0.80946 0.80861 0.80799 0.80724 0.80653 0.80631 0.80595 0.80524 0.80489 0.80448 0.80371 0.80324 0.80277 0.80195 0.80148 0.80107 0.80044 0.80002 0.79956 0.79898 0.79862 0.79828 0.79759 0.79708 0.79679 0.79601 0.79552 0.7953 0.79452 0.79387 0.79365 0.79293 0.79223 0.79199 0.79117 0.7907 0.79038 0.78945 0.78864 0.78801 0.787 0.78576 {'S1-PAT50023'} 38.125 NaN 15.03.2022 11:53:25 {'Probe-67Prozent-rF-2.sam'} 0.82827 0.83546 0.84155 0.84913 0.85493 0.86007 0.86434 0.86665 0.86695 0.8672 0.86774 0.86854 0.86887 0.86825 0.86709 0.86584 0.865 0.86415 0.86334 0.86257 0.8611 0.86012 0.85904 0.85793 0.85725 0.85622 0.85487 0.85407 0.85385 0.85257 0.85155 0.85086 0.84979 0.849 0.84852 0.84773 0.84672 0.8457 0.84521 0.84422 0.84323 0.84233 0.84166 0.8411 0.8399 0.83889 0.83784 0.83697 0.83598 0.83531 0.83462 0.83373 0.83265 0.83144 0.83031 0.82942 0.82847 0.82763 0.8269 0.82601 0.8252 0.82426 0.82341 0.82227 0.82178 0.82077 0.81984 0.81933 0.81877 0.81782 0.81715 0.81633 0.81532 0.81445 0.81386 0.81301 0.81243 0.81181 0.81077 0.81021 0.80964 0.80889 0.80837 0.80774 0.8069 0.80633 0.80545 0.80484 0.80456 0.8041 0.80359 0.8033 0.8028 0.80205 0.80151 0.80102 0.80028 0.79978 0.79937 0.79872 0.7983 0.79781 0.79723 0.79684 0.79652 0.79587 0.79539 0.79503 0.79421 0.79377 0.79355 0.79274 0.7921 0.79189 0.79118 0.79051 0.7903 0.78939 0.7889 0.78855 0.78769 0.78684 0.7862 0.78517 0.78402 {'S1-PAT50023'} 38.125 NaN 15.03.2022 11:53:44 {'Probe-67Prozent-rF-3.sam'} 0.82651 0.83412 0.84217 0.84876 0.85404 0.85938 0.8631 0.86514 0.86605 0.86714 0.86741 0.86758 0.86752 0.86686 0.86637 0.86484 0.86412 0.86385 0.86272 0.86191 0.86078 0.85959 0.85849 0.85745 0.85671 0.85583 0.85446 0.85345 0.85258 0.85168 0.85106 0.85027 0.84922 0.84869 0.84781 0.84707 0.84614 0.84525 0.84459 0.84364 0.8427 0.84198 0.84121 0.84011 0.83961 0.83854 0.83735 0.83652 0.83582 0.8347 0.83405 0.83316 0.8321 0.83077 0.82992 0.82903 0.82797 0.82701 0.82665 0.82555 0.82474 0.82382 0.82287 0.82196 0.82128 0.82035 0.81954 0.81896 0.81831 0.81736 0.81662 0.81579 0.81478 0.81409 0.81337 0.81265 0.81198 0.81118 0.81023 0.80978 0.80924 0.8085 0.80799 0.80731 0.80646 0.80585 0.805 0.80443 0.80411 0.80364 0.80303 0.80278 0.80237 0.80155 0.80111 0.80064 0.7998 0.79939 0.79897 0.79824 0.79785 0.79741 0.79679 0.79641 0.79614 0.79544 0.79491 0.79462 0.79381 0.79334 0.79312 0.79233 0.79172 0.79145 0.7907 0.79003 0.78984 0.78902 0.78853 0.78816 0.78724 0.78643 0.78579 0.78481 0.7836 {'S1-PAT50023'} 38.125 NaN 15.03.2022 11:54:05 {'Probe-67Prozent-rF-4.sam'} 0.82632 0.8343 0.84069 0.84755 0.85328 0.85799 0.86216 0.8644 0.86582 0.86717 0.86704 0.8677 0.86739 0.86662 0.8664 0.86524 0.86385 0.86305 0.86253 0.86179 0.86035 0.8594 0.85838 0.85713 0.85624 0.85541 0.85441 0.85316 0.85232 0.85131 0.85061 0.85008 0.84889 0.84832 0.8478 0.84683 0.84593 0.84505 0.84439 0.84349 0.84261 0.84148 0.8411 0.84007 0.83923 0.8381 0.83738 0.83648 0.83523 0.83472 0.83389 0.83287 0.83183 0.83077 0.82979 0.8289 0.82784 0.82689 0.82653 0.82531 0.82462 0.82371 0.82266 0.82174 0.82117 0.82016 0.81925 0.81866 0.8181 0.81717 0.81652 0.81563 0.8146 0.81392 0.81328 0.8125 0.81181 0.81114 0.8102 0.80951 0.80897 0.80819 0.80773 0.80709 0.80628 0.80575 0.80489 0.80429 0.80401 0.80358 0.80292 0.80265 0.80224 0.80148 0.80096 0.8004 0.79962 0.7992 0.79881 0.79812 0.79773 0.79728 0.79662 0.79624 0.79597 0.7953 0.79476 0.79439 0.79368 0.79321 0.79295 0.79217 0.79157 0.79135 0.79062 0.78994 0.78962 0.78891 0.78832 0.78796 0.78714 0.78631 0.78561 0.78464 0.78347 {'S1-PAT50023'} 38.188 NaN 15.03.2022 11:54:24 {'Probe-67Prozent-rF-5.sam'} 0.82713 0.83447 0.84136 0.84849 0.85406 0.85938 0.86319 0.86457 0.86631 0.86735 0.86741 0.86758 0.86752 0.86686 0.86637 0.86509 0.86434 0.86338 0.8621 0.86171 0.86082 0.85961 0.85831 0.85728 0.8565 0.85525 0.85428 0.85358 0.85272 0.85135 0.85096 0.8505 0.84896 0.84856 0.84798 0.84682 0.84593 0.84505 0.84439 0.84352 0.84283 0.84163 0.84108 0.84006 0.83925 0.83823 0.8372 0.83634 0.83537 0.83456 0.8339 0.83302 0.83196 0.83063 0.82965 0.82878 0.82784 0.82689 0.82641 0.82531 0.82462 0.8236 0.82265 0.82174 0.82107 0.82015 0.81934 0.81885 0.81813 0.81717 0.81644 0.81561 0.81459 0.814 0.81315 0.81247 0.81175 0.81106 0.81016 0.80964 0.80908 0.80828 0.80775 0.80714 0.80625 0.80567 0.80494 0.80421 0.80391 0.80356 0.80287 0.80262 0.80223 0.80137 0.80089 0.80044 0.79966 0.79917 0.7988 0.79816 0.79771 0.79724 0.79659 0.7962 0.79598 0.7953 0.79478 0.79444 0.79365 0.79317 0.79295 0.79211 0.79152 0.7913 0.79057 0.78995 0.78966 0.78881 0.78832 0.78795 0.78708 0.78631 0.78561 0.78457 0.78341 {'S1-PAT50023'} 38.188 NaN 15.03.2022 11:54:45 {'Probe-67Prozent-rF-6.sam'} 0.82632 0.83415 0.84236 0.84738 0.85294 0.85802 0.86216 0.86447 0.8654 0.86652 0.86682 0.86666 0.86668 0.86668 0.86594 0.86432 0.86389 0.86326 0.86165 0.86088 0.86021 0.85942 0.85838 0.85713 0.85627 0.85518 0.85382 0.8531 0.85257 0.8514 0.8508 0.84999 0.84854 0.84791 0.84765 0.84685 0.84589 0.84483 0.8442 0.84326 0.84226 0.84127 0.84075 0.8399 0.83908 0.83807 0.83701 0.83588 0.83508 0.83442 0.83374 0.8326 0.83183 0.83076 0.82926 0.82865 0.82771 0.82677 0.82652 0.82532 0.8244 0.82348 0.82265 0.82164 0.82107 0.82005 0.81924 0.81867 0.81793 0.81707 0.81634 0.8156 0.81453 0.81383 0.8132 0.81235 0.81164 0.81098 0.81008 0.80956 0.80899 0.80828 0.80758 0.807 0.80618 0.80565 0.80485 0.80411 0.80384 0.80349 0.80283 0.80248 0.80207 0.80135 0.80086 0.80035 0.79957 0.79908 0.7987 0.79807 0.79761 0.79718 0.79656 0.79618 0.79589 0.79517 0.79471 0.79444 0.79353 0.79308 0.7929 0.79206 0.79145 0.7912 0.79055 0.78981 0.78957 0.78876 0.78826 0.78784 0.78702 0.7862 0.78549 0.78446 0.7833 {'S1-PAT50023'} 38.188 NaN 15.03.2022 11:55:04 {'Probe-67Prozent-rF-7.sam'} 0.82829 0.83539 0.84237 0.84861 0.85531 0.86042 0.86379 0.86582 0.86674 0.86725 0.86779 0.86818 0.86803 0.86767 0.86738 0.86622 0.86444 0.86372 0.8632 0.86212 0.86073 0.85977 0.85855 0.85725 0.85673 0.85585 0.85425 0.8535 0.85312 0.85165 0.85113 0.8505 0.84921 0.84879 0.84825 0.84728 0.84626 0.84508 0.84461 0.84367 0.84283 0.84185 0.84146 0.84039 0.83939 0.83824 0.83737 0.8365 0.83551 0.83457 0.83405 0.83302 0.8321 0.8309 0.82979 0.82903 0.82797 0.82701 0.82653 0.82543 0.82451 0.82359 0.82286 0.82185 0.82128 0.82006 0.81933 0.81885 0.81812 0.81725 0.81653 0.81578 0.81471 0.81393 0.81328 0.8125 0.8118 0.81121 0.81012 0.80962 0.80908 0.80835 0.80777 0.80719 0.80632 0.80579 0.80493 0.80424 0.80394 0.80359 0.80294 0.80268 0.8023 0.80139 0.80092 0.80049 0.79965 0.7992 0.7989 0.79823 0.79767 0.79719 0.79662 0.79626 0.79602 0.79529 0.79478 0.79446 0.7937 0.79315 0.7929 0.79215 0.79154 0.79136 0.79055 0.78992 0.78968 0.78887 0.78837 0.788 0.78713 0.78631 0.78561 0.78463 0.7834 {'S1-PAT50023'} 38.188 NaN 15.03.2022 11:55:24 {'Probe-33Prozent-rF-1.sam'} 0.82916 0.83714 0.84351 0.85021 0.85635 0.86165 0.8657 0.8684 0.86931 0.87024 0.87002 0.87056 0.87078 0.87022 0.87008 0.86932 0.86791 0.86659 0.86598 0.86548 0.86449 0.86363 0.86214 0.86073 0.86002 0.85948 0.85823 0.85711 0.85653 0.85537 0.85493 0.85454 0.85293 0.85245 0.85155 0.8511 0.85018 0.84914 0.8484 0.84757 0.84682 0.84576 0.84488 0.84444 0.84345 0.84234 0.84136 0.84042 0.83951 0.8389 0.83826 0.83714 0.83613 0.83497 0.83389 0.83305 0.83213 0.8312 0.83051 0.82954 0.82863 0.82795 0.82701 0.82611 0.82545 0.82433 0.82341 0.82292 0.82238 0.82145 0.82081 0.82 0.819 0.81832 0.81763 0.81686 0.81604 0.81546 0.81445 0.81394 0.8133 0.81258 0.81215 0.81154 0.81055 0.80998 0.80915 0.80841 0.80803 0.80769 0.80709 0.80679 0.8064 0.80558 0.80515 0.80474 0.80388 0.80339 0.80298 0.80232 0.80187 0.80133 0.80071 0.80034 0.80013 0.7994 0.79894 0.79868 0.79782 0.79734 0.79715 0.79629 0.79568 0.79554 0.79476 0.79411 0.79376 0.79291 0.79244 0.79211 0.79116 0.79032 0.78958 0.7884 0.78695 {'S1-PAT50023'} 38.438 NaN 15.03.2022 11:58:51
T.Timestamp % it even identifies the timestamp correctly.
ans = 92×1 datetime array
15.03.2022 11:44:55 15.03.2022 11:48:52 15.03.2022 11:49:10 15.03.2022 11:49:30 15.03.2022 11:49:50 15.03.2022 11:50:10 15.03.2022 11:50:30 15.03.2022 11:50:50 15.03.2022 11:53:25 15.03.2022 11:53:44 15.03.2022 11:54:05 15.03.2022 11:54:24 15.03.2022 11:54:45 15.03.2022 11:55:04 15.03.2022 11:55:24 15.03.2022 11:58:51 15.03.2022 11:59:12 15.03.2022 11:59:30 15.03.2022 11:59:50 15.03.2022 12:00:10 15.03.2022 12:00:30 15.03.2022 12:00:50 15.03.2022 12:02:06 15.03.2022 12:02:25 15.03.2022 12:02:45 15.03.2022 12:03:05 15.03.2022 12:03:25 15.03.2022 12:03:45 15.03.2022 12:04:05 15.03.2022 13:19:11
Arif Hoq
Arif Hoq am 30 Mär. 2022
Bearbeitet: Arif Hoq am 30 Mär. 2022

0 Stimmen

try this:
A=readtable('rawdata.csv','ReadVariableName',false);
B=table2array(A(:,1));
C=split(B,';');
output=C(:,2:125);

6 Kommentare
4 ältere Kommentare anzeigen 4 ältere Kommentare ausblenden

Alex Perrakis
Alex Perrakis am 30 Mär. 2022
Can you explain the solution?
Arif Hoq
Arif Hoq am 30 Mär. 2022
Bearbeitet: Arif Hoq am 30 Mär. 2022
B=table2array(A(:,1)); % converts the table, T, to a homogeneous array, B
C=split(B,';'); % split the string with delimiter semicolon.
output=C(:,2:125); % use linear indexing to find out the value starts with 0
Alex Perrakis
Alex Perrakis am 30 Mär. 2022
Cool thanks! one more question, i have other .csv files with more rows but the same number of columns and for some reason it always returns 125 do you have any idea why? i mean you are using all the rows.
Arif Hoq
Arif Hoq am 30 Mär. 2022
please attach your csv file
Alex Perrakis
Alex Perrakis am 30 Mär. 2022
For example this one , they have a varied amount of rows. They are named the same because the system names them like that.
Arif Hoq
Arif Hoq am 30 Mär. 2022
try this:
A=readtable('rawdata2.csv','ReadVariableName',false);
B=table2array(A(:,1));
C=split(B,';');
output=C(:,2:126);

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Text Files finden Sie in Hilfe-Center und File Exchange

Produkte

Version

R2019a

Tags

Gefragt:

Alex Perrakis
Alex Perrakis
am 30 Mär. 2022

Kommentiert:

Alex Perrakis
Alex Perrakis
am 31 Mär. 2022

Community Treasure Hunt

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

Start Hunting!

Translated by