Azzera filtri
Azzera filtri

.csv using readtable doesn't make difference between the value 1 and 01

1 visualizzazione (ultimi 30 giorni)
Hi, I try to use readtable to read a .csv file. In the 'NUMBER' colomn, we have one car number 1 and another number 01. That being said, he put both as a number 1. How can I fix it?
data = readtable("23_Time Cards_Practice 1.CSV")
Thank you!
  5 Commenti
Dyuman Joshi
Dyuman Joshi il 21 Set 2023
When you use readtable() directly, it reads the 1st column as numeric data. And in numeric data, more precisely floating point numbers, 01 is stored as 1.
In case you want to store as 01, you will have to use other formats - char, strings etc
Jon
Jon il 21 Set 2023
Modificato: Jon il 21 Set 2023
@the cyclist, Thanks you're right, I had opened up the file in Excel, and it already assumed the Number column was numeric.
I was trying to imagine why anyone would use, for example, 1 and 01 as unique identifiers. Seems very confusing. Looking at the data in the table, I see now that these are IMSA ( International Motor Sports Association) car numbers, and they have quite arcane rules, traditions, and history for choosing such car "numbers". Anyhow never question a ritual in process :)
@Steve GroleauLooks like you got lots of good answers to your question, so I guess you are all set.

Accedi per commentare.

Risposte (3)

Voss
Voss il 21 Set 2023
Modificato: Voss il 21 Set 2023
fn = '23_Time Cards_Practice 1.CSV';
opts = detectImportOptions(fn);
% tell readtable to read NUMBER column as char, not numeric:
opts.VariableTypes(strcmp(opts.VariableNames,'NUMBER')) = {'char'};
t = readtable(fn,opts);
disp(t)
NUMBER DRIVER_NUMBER LAP_NUMBER LAP_TIME LAP_IMPROVEMENT CROSSING_FINISH_LINE_IN_PIT S1 S1_IMPROVEMENT S2 S2_IMPROVEMENT S3 S3_IMPROVEMENT KPH ELAPSED HOUR S1_LARGE S2_LARGE S3_LARGE TOP_SPEED DRIVER_NAME PIT_TIME CLASS GROUP TEAM MANUFACTURER FLAG_AT_FL _______ _____________ __________ _______________ _______________ ___________________________ ______ ______________ ______ ______________ ______ ______________ _____ _______________ ____________ _____________ ____________ _______________ __________ _________________________ ____________ __________ __________ _____________________________________________ ________________ __________ {'01' } 2 1 {'13:38.866' } 0 {'B' } NaN 0 NaN 0 NaN 0 25.2 {'13:38.866' } 11:18:38.866 {'2:06.049' } {'1:00.754'} {'10:32.063' } {0×0 char} {'Renger van der Zande' } 00:01:42.717 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 2 {'6:17.456' } 0 {'B' } 54.603 0 56.445 0 NaN 0 54.6 {'19:56.322' } 11:24:56.322 {'0:54.603' } {'0:56.445'} {'4:26.408' } {0×0 char} {'Renger van der Zande' } 00:10:26.847 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 3 {'2:11.805' } 0 {0×0 char} 51.017 0 50.8 0 29.988 0 156.5 {'22:08.127' } 11:27:08.127 {'0:51.017' } {'0:50.800'} {'0:29.988' } {0×0 char} {'Renger van der Zande' } 00:04:22.040 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 4 {'1:39.473' } 0 {0×0 char} 23.671 0 46.826 0 28.976 0 207.3 {'23:47.600' } 11:28:47.600 {'0:23.671' } {'0:46.826'} {'0:28.976' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 5 {'1:38.641' } 0 {0×0 char} 23.883 0 45.462 0 29.296 0 209.1 {'25:26.241' } 11:30:26.241 {'0:23.883' } {'0:45.462'} {'0:29.296' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 6 {'1:35.740' } 2 {0×0 char} 22.878 2 44.777 2 28.085 2 215.4 {'27:01.981' } 11:32:01.981 {'0:22.878' } {'0:44.777'} {'0:28.085' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 7 {'1:39.715' } 0 {0×0 char} 23.721 0 47.737 0 28.257 0 206.8 {'28:41.696' } 11:33:41.696 {'0:23.721' } {'0:47.737'} {'0:28.257' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 8 {'1:38.395' } 0 {0×0 char} 23.637 0 45.968 0 28.79 0 209.6 {'30:20.091' } 11:35:20.091 {'0:23.637' } {'0:45.968'} {'0:28.790' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 9 {'28:02.190' } 0 {'B' } 23.202 0 46.928 0 NaN 0 12.3 {'58:22.281' } 12:03:22.281 {'0:23.202' } {'0:46.928'} {'26:52.060' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 10 {'2:14.553' } 0 {0×0 char} 55.028 0 50.326 0 29.199 0 153.3 {'1:00:36.834'} 12:05:36.834 {'0:55.028' } {'0:50.326'} {'0:29.199' } {0×0 char} {'Renger van der Zande' } 00:26:58.606 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 11 {'1:38.580' } 0 {0×0 char} 23.203 0 46.67 0 28.707 0 209.2 {'1:02:15.414'} 12:07:15.414 {'0:23.203' } {'0:46.670'} {'0:28.707' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 12 {'1:37.445' } 0 {0×0 char} 23.756 0 44.921 0 28.768 0 211.7 {'1:03:52.859'} 12:08:52.859 {'0:23.756' } {'0:44.921'} {'0:28.768' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 2 13 {'21:46.352' } 0 {'B' } 23.472 0 46.505 0 NaN 0 15.8 {'1:25:39.211'} 12:30:39.211 {'0:23.472' } {'0:46.505'} {'20:36.375' } {0×0 char} {'Renger van der Zande' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 3 14 {'2:20.259' } 0 {0×0 char} NaN 0 49.129 0 29.075 0 147.1 {'1:27:59.470'} 12:32:59.470 {'1:02.055' } {'0:49.129'} {'0:29.075' } {0×0 char} {'Scott Dixon' } 00:20:50.741 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 3 15 {'1:39.299' } 0 {0×0 char} 23.561 1 46.644 0 29.094 0 207.7 {'1:29:38.769'} 12:34:38.769 {'0:23.561' } {'0:46.644'} {'0:29.094' } {0×0 char} {'Scott Dixon' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'01' } 3 16 {'1:38.845' } 0 {0×0 char} 24.274 0 45.506 1 29.065 1 208.7 {'1:31:17.614'} 12:36:17.614 {'0:24.274' } {'0:45.506'} {'0:29.065' } {0×0 char} {'Scott Dixon' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'FF'} {'02' } 1 1 {'11:04.243' } 0 {'B' } NaN 0 NaN 0 NaN 0 31.1 {'11:04.243' } 11:16:04.243 {'1:37.201' } {'1:07.761'} {'8:19.281' } {0×0 char} {'Earl Bamber' } 00:01:12.226 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 2 {'2:41.152' } 0 {0×0 char} NaN 0 NaN 0 32.3 0 128 {'13:45.395' } 11:18:45.395 {'1:06.139' } {'1:02.713'} {'0:32.300' } {0×0 char} {'Earl Bamber' } 00:08:18.154 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 3 {'1:43.087' } 0 {0×0 char} 25.321 0 48.093 0 29.673 0 200.1 {'15:28.482' } 11:20:28.482 {'0:25.321' } {'0:48.093'} {'0:29.673' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 4 {'7:24.962' } 0 {'B' } 23.362 0 59.91 0 NaN 0 46.4 {'22:53.444' } 11:27:53.444 {'0:23.362' } {'0:59.910'} {'6:01.690' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 5 {'2:08.491' } 0 {0×0 char} 50.58 0 48.59 0 29.321 0 160.5 {'25:01.935' } 11:30:01.935 {'0:50.580' } {'0:48.590'} {'0:29.321' } {0×0 char} {'Earl Bamber' } 00:05:53.643 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 6 {'1:36.770' } 0 {0×0 char} 23.602 0 44.838 1 28.33 0 213.1 {'26:38.705' } 11:31:38.705 {'0:23.602' } {'0:44.838'} {'0:28.330' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 7 {'1:36.148' } 0 {0×0 char} 23.158 0 44.839 0 28.151 1 214.5 {'28:14.853' } 11:33:14.853 {'0:23.158' } {'0:44.839'} {'0:28.151' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 8 {'1:37.934' } 0 {0×0 char} 22.786 4 45.352 0 29.796 0 210.6 {'29:52.787' } 11:34:52.787 {'0:22.786' } {'0:45.352'} {'0:29.796' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 1 9 {'11:30.200' } 0 {'B' } 23.243 0 46.892 0 NaN 0 29.9 {'41:22.987' } 11:46:22.987 {'0:23.243' } {'0:46.892'} {'10:20.065' } {0×0 char} {'Earl Bamber' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 10 {'2:10.575' } 0 {0×0 char} 49.684 0 50.848 0 30.043 0 158 {'43:33.562' } 11:48:33.562 {'0:49.684' } {'0:50.848'} {'0:30.043' } {0×0 char} {'Alex Lynn' } 00:10:17.899 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 11 {'1:36.770' } 0 {0×0 char} 22.889 0 45.105 0 28.776 0 213.1 {'45:10.332' } 11:50:10.332 {'0:22.889' } {'0:45.105'} {'0:28.776' } {0×0 char} {'Alex Lynn' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 12 {'1:40.781' } 0 {0×0 char} 23.223 0 47.528 0 30.03 0 204.7 {'46:51.113' } 11:51:51.113 {'0:23.223' } {'0:47.528'} {'0:30.030' } {0×0 char} {'Alex Lynn' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 13 {'1:35.632' } 2 {0×0 char} 22.898 0 44.607 2 28.127 2 215.7 {'48:26.745' } 11:53:26.745 {'0:22.898' } {'0:44.607'} {'0:28.127' } {0×0 char} {'Alex Lynn' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 14 {'1:36.549' } 0 {0×0 char} 22.8 1 44.669 0 29.08 0 213.6 {'50:03.294' } 11:55:03.294 {'0:22.800' } {'0:44.669'} {'0:29.080' } {0×0 char} {'Alex Lynn' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 2 15 {'8:19.515' } 0 {'B' } 23.078 0 45.327 0 NaN 0 41.3 {'58:22.809' } 12:03:22.809 {'0:23.078' } {'0:45.327'} {'7:11.110' } {0×0 char} {'Alex Lynn' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 16 {'2:14.669' } 0 {0×0 char} 56.524 0 49.466 0 28.679 1 153.2 {'1:00:37.478'} 12:05:37.478 {'0:56.524' } {'0:49.466'} {'0:28.679' } {0×0 char} {'Richard Westbrook' } 00:07:22.048 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 17 {'1:38.922' } 0 {0×0 char} 23.556 0 46.21 0 29.156 0 208.5 {'1:02:16.400'} 12:07:16.400 {'0:23.556' } {'0:46.210'} {'0:29.156' } {0×0 char} {'Richard Westbrook' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 18 {'1:37.107' } 0 {0×0 char} 23.411 0 44.938 1 28.758 0 212.4 {'1:03:53.507'} 12:08:53.507 {'0:23.411' } {'0:44.938'} {'0:28.758' } {0×0 char} {'Richard Westbrook' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 19 {'21:44.319' } 0 {'B' } 23.522 0 46.251 0 NaN 0 15.8 {'1:25:37.826'} 12:30:37.826 {'0:23.522' } {'0:46.251'} {'20:34.546' } {0×0 char} {'Richard Westbrook' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 20 {'2:18.068' } 0 {0×0 char} NaN 0 47.684 0 29.18 0 149.4 {'1:27:55.894'} 12:32:55.894 {'1:01.204' } {'0:47.684'} {'0:29.180' } {0×0 char} {'Richard Westbrook' } 00:20:45.144 {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 21 {'1:39.732' } 0 {0×0 char} 23.29 1 46.586 0 29.856 0 206.8 {'1:29:35.626'} 12:34:35.626 {'0:23.290' } {'0:46.586'} {'0:29.856' } {0×0 char} {'Richard Westbrook' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'GF'} {'02' } 3 22 {'1:39.395' } 0 {0×0 char} 23.341 0 46.021 0 30.033 0 207.5 {'1:31:15.021'} 12:36:15.021 {'0:23.341' } {'0:46.021'} {'0:30.033' } {0×0 char} {'Richard Westbrook' } NaN {'GTP' } {0×0 char} {'Cadillac Racing' } {'Cadillac' } {'FF'} {'023'} 4 1 {'4:14.070' } 0 {0×0 char} NaN 0 58.272 0 34.645 0 81.2 {'4:14.070' } 11:09:14.070 {'2:41.153' } {'0:58.272'} {'0:34.645' } {0×0 char} {'Andrea Bertolini' } 00:02:20.660 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 2 {'2:17.881' } 0 {'B' } 27.836 0 54.719 0 55.326 0 149.6 {'6:31.951' } 11:11:31.951 {'0:27.836' } {'0:54.719'} {'0:55.326' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'RF'} {'023'} 4 3 {'6:10.826' } 0 {0×0 char} NaN 0 53.259 0 33.464 0 55.6 {'12:42.777' } 11:17:42.777 {'4:44.103' } {'0:53.259'} {'0:33.464' } {0×0 char} {'Andrea Bertolini' } 00:04:41.050 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 4 {'1:50.236' } 0 {0×0 char} 25.973 0 51.219 0 33.044 0 187.1 {'14:33.013' } 11:19:33.013 {'0:25.973' } {'0:51.219'} {'0:33.044' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 5 {'2:05.795' } 0 {'B' } 25.753 0 51.289 0 48.753 0 164 {'16:38.808' } 11:21:38.808 {'0:25.753' } {'0:51.289'} {'0:48.753' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'RF'} {'023'} 4 6 {'5:24.457' } 0 {0×0 char} NaN 0 56.619 0 34.412 0 63.6 {'22:03.265' } 11:27:03.265 {'3:53.426' } {'0:56.619'} {'0:34.412' } {0×0 char} {'Andrea Bertolini' } 00:03:46.462 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 7 {'1:53.777' } 0 {0×0 char} 26.973 0 53.115 0 33.689 0 181.3 {'23:57.042' } 11:28:57.042 {'0:26.973' } {'0:53.115'} {'0:33.689' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 8 {'1:50.281' } 0 {0×0 char} 25.843 0 51.527 0 32.911 0 187 {'25:47.323' } 11:30:47.323 {'0:25.843' } {'0:51.527'} {'0:32.911' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 9 {'1:50.400' } 0 {0×0 char} 25.541 0 51.12 0 33.739 0 186.8 {'27:37.723' } 11:32:37.723 {'0:25.541' } {'0:51.120'} {'0:33.739' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 10 {'1:48.971' } 0 {0×0 char} 25.479 0 50.678 0 32.814 0 189.3 {'29:26.694' } 11:34:26.694 {'0:25.479' } {'0:50.678'} {'0:32.814' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 11 {'2:05.298' } 0 {'B' } 25.62 0 50.721 0 48.957 0 164.6 {'31:31.992' } 11:36:31.992 {'0:25.620' } {'0:50.721'} {'0:48.957' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'RF'} {'023'} 4 12 {'4:42.304' } 0 {0×0 char} NaN 0 52.364 0 33.054 0 73.1 {'36:14.296' } 11:41:14.296 {'3:16.886' } {'0:52.364'} {'0:33.054' } {0×0 char} {'Andrea Bertolini' } 00:03:14.216 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 13 {'1:49.818' } 0 {0×0 char} 25.568 0 51.166 0 33.084 0 187.8 {'38:04.114' } 11:43:04.114 {'0:25.568' } {'0:51.166'} {'0:33.084' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 14 {'1:48.886' } 2 {0×0 char} 25.45 2 50.669 2 32.767 2 189.4 {'39:53.000' } 11:44:53.000 {'0:25.450' } {'0:50.669'} {'0:32.767' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 4 15 {'2:04.339' } 0 {'B' } 25.468 0 51.094 0 47.777 0 165.9 {'41:57.339' } 11:46:57.339 {'0:25.468' } {'0:51.094'} {'0:47.777' } {0×0 char} {'Andrea Bertolini' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 16 {'4:17.547' } 0 {0×0 char} NaN 0 54.038 0 33.401 0 80.1 {'46:14.886' } 11:51:14.886 {'2:50.108' } {'0:54.038'} {'0:33.401' } {0×0 char} {'Charles Scardina' } 00:02:46.043 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 17 {'1:51.992' } 0 {0×0 char} 26.792 0 51.987 0 33.213 0 184.2 {'48:06.878' } 11:53:06.878 {'0:26.792' } {'0:51.987'} {'0:33.213' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 18 {'1:50.163' } 0 {0×0 char} 26.197 0 51.111 1 32.855 1 187.2 {'49:57.041' } 11:54:57.041 {'0:26.197' } {'0:51.111'} {'0:32.855' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 19 {'1:50.436' } 0 {0×0 char} 26.174 1 51.293 0 32.969 0 186.8 {'51:47.477' } 11:56:47.477 {'0:26.174' } {'0:51.293'} {'0:32.969' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 20 {'2:08.196' } 0 {'B' } 26.681 0 52.361 0 49.154 0 160.9 {'53:55.673' } 11:58:55.673 {'0:26.681' } {'0:52.361'} {'0:49.154' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'RF'} {'023'} 2 21 {'6:25.926' } 0 {0×0 char} NaN 0 53.844 0 33.742 0 53.4 {'1:00:21.599'} 12:05:21.599 {'4:58.340' } {'0:53.844'} {'0:33.742' } {0×0 char} {'Charles Scardina' } 00:04:54.161 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 22 {'1:52.981' } 0 {0×0 char} 27.391 0 52.463 0 33.127 0 182.6 {'1:02:14.580'} 12:07:14.580 {'0:27.391' } {'0:52.463'} {'0:33.127' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 23 {'2:27.822' } 0 {'B' } 27.459 0 NaN 0 55.24 0 139.5 {'1:04:42.402'} 12:09:42.402 {'0:27.459' } {'1:05.123'} {'0:55.240' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 24 {'22:52.066' } 0 {0×0 char} NaN 0 54.775 0 33.925 0 15 {'1:27:34.468'} 12:32:34.468 {'21:23.366'} {'0:54.775'} {'0:33.925' } {0×0 char} {'Charles Scardina' } 00:21:19.046 {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 25 {'1:52.194' } 0 {0×0 char} 26.902 0 52.014 0 33.278 0 183.8 {'1:29:26.662'} 12:34:26.662 {'0:26.902' } {'0:52.014'} {'0:33.278' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'GF'} {'023'} 2 26 {'1:53.214' } 0 {0×0 char} 27.393 0 52.175 0 33.646 0 182.2 {'1:31:19.876'} 12:36:19.876 {'0:27.393' } {'0:52.175'} {'0:33.646' } {0×0 char} {'Charles Scardina' } NaN {'GTD' } {0×0 char} {'Triarsi Competizione' } {'Ferrari' } {'FF'} {'04' } 1 1 {'2:38.902' } 0 {0×0 char} NaN 0 56.622 0 32.106 0 129.8 {'2:38.902' } 11:07:38.902 {'1:10.174' } {'0:56.622'} {'0:32.106' } {0×0 char} {'George Kurtz' } 00:00:48.761 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 2 {'1:45.464' } 0 {0×0 char} 25.912 0 48.562 0 30.99 0 195.6 {'4:24.366' } 11:09:24.366 {'0:25.912' } {'0:48.562'} {'0:30.990' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 3 {'2:14.649' } 0 {'B' } 25.452 0 50.423 0 58.774 0 153.2 {'6:39.015' } 11:11:39.015 {'0:25.452' } {'0:50.423'} {'0:58.774' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'RF'} {'04' } 1 4 {'6:32.378' } 0 {0×0 char} NaN 0 52.816 0 32.69 0 52.6 {'13:11.393' } 11:18:11.393 {'5:06.872' } {'0:52.816'} {'0:32.690' } {0×0 char} {'George Kurtz' } 00:05:03.001 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 5 {'1:46.784' } 0 {0×0 char} 25.468 0 48.199 0 33.117 0 193.2 {'14:58.177' } 11:19:58.177 {'0:25.468' } {'0:48.199'} {'0:33.117' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 6 {'2:17.737' } 0 {'B' } 24.634 0 53.742 0 59.361 0 149.7 {'17:15.914' } 11:22:15.914 {'0:24.634' } {'0:53.742'} {'0:59.361' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'RF'} {'04' } 1 7 {'3:52.331' } 0 {0×0 char} NaN 0 50.554 0 31.361 0 88.8 {'21:08.245' } 11:26:08.245 {'2:30.416' } {'0:50.554'} {'0:31.361' } {0×0 char} {'George Kurtz' } 00:02:27.287 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 8 {'1:42.421' } 0 {0×0 char} 24.141 0 47.942 0 30.338 0 201.4 {'22:50.666' } 11:27:50.666 {'0:24.141' } {'0:47.942'} {'0:30.338' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 9 {'1:41.923' } 0 {0×0 char} 24.323 0 47.62 0 29.98 0 202.4 {'24:32.589' } 11:29:32.589 {'0:24.323' } {'0:47.620'} {'0:29.980' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 10 {'1:41.890' } 0 {0×0 char} 24.293 0 47.327 0 30.27 0 202.4 {'26:14.479' } 11:31:14.479 {'0:24.293' } {'0:47.327'} {'0:30.270' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 11 {'1:43.684' } 0 {0×0 char} 24.546 0 47.926 0 31.212 0 198.9 {'27:58.163' } 11:32:58.163 {'0:24.546' } {'0:47.926'} {'0:31.212' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 12 {'1:41.749' } 0 {0×0 char} 24.18 0 47.424 0 30.145 0 202.7 {'29:39.912' } 11:34:39.912 {'0:24.180' } {'0:47.424'} {'0:30.145' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 13 {'1:57.564' } 0 {'B' } 24.174 0 47.468 0 45.922 0 175.4 {'31:37.476' } 11:36:37.476 {'0:24.174' } {'0:47.468'} {'0:45.922' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'RF'} {'04' } 1 14 {'4:05.228' } 0 {0×0 char} NaN 0 48 0 30.307 0 84.1 {'35:42.704' } 11:40:42.704 {'2:46.921' } {'0:48.000'} {'0:30.307' } {0×0 char} {'George Kurtz' } 00:02:44.502 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 15 {'1:41.651' } 0 {0×0 char} 24.122 0 47.95 0 29.579 2 202.9 {'37:24.355' } 11:42:24.355 {'0:24.122' } {'0:47.950'} {'0:29.579' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 16 {'1:41.475' } 0 {0×0 char} 23.94 0 47.234 0 30.301 0 203.3 {'39:05.830' } 11:44:05.830 {'0:23.940' } {'0:47.234'} {'0:30.301' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 17 {'1:40.584' } 2 {0×0 char} 23.868 2 46.856 2 29.86 0 205.1 {'40:46.414' } 11:45:46.414 {'0:23.868' } {'0:46.856'} {'0:29.860' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 18 {'1:40.585' } 0 {0×0 char} 23.878 0 46.964 0 29.743 0 205.1 {'42:26.999' } 11:47:26.999 {'0:23.878' } {'0:46.964'} {'0:29.743' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 19 {'1:42.703' } 0 {0×0 char} 24.22 0 47.089 0 31.394 0 200.8 {'44:09.702' } 11:49:09.702 {'0:24.220' } {'0:47.089'} {'0:31.394' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 20 {'1:42.247' } 0 {0×0 char} 25.134 0 47.039 0 30.074 0 201.7 {'45:51.949' } 11:50:51.949 {'0:25.134' } {'0:47.039'} {'0:30.074' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 21 {'1:41.637' } 0 {0×0 char} 24.163 0 47.402 0 30.072 0 202.9 {'47:33.586' } 11:52:33.586 {'0:24.163' } {'0:47.402'} {'0:30.072' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 22 {'1:42.656' } 0 {0×0 char} 24.298 0 47.916 0 30.442 0 200.9 {'49:16.242' } 11:54:16.242 {'0:24.298' } {'0:47.916'} {'0:30.442' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 1 23 {'2:04.936' } 0 {'B' } 23.973 0 54.912 0 46.051 0 165.1 {'51:21.178' } 11:56:21.178 {'0:23.973' } {'0:54.912'} {'0:46.051' } {0×0 char} {'George Kurtz' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 24 {'4:12.931' } 0 {'B' } NaN 0 50.035 0 49.21 0 81.5 {'55:34.109' } 12:00:34.109 {'2:33.686' } {'0:50.035'} {'0:49.210' } {0×0 char} {'Matt McMurry' } 00:02:29.300 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'RF'} {'04' } 3 25 {'4:58.015' } 0 {0×0 char} NaN 0 52.146 0 31.972 0 69.2 {'1:00:32.124'} 12:05:32.124 {'3:33.897' } {'0:52.146'} {'0:31.972' } {0×0 char} {'Matt McMurry' } 00:03:27.873 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 26 {'1:45.353' } 0 {0×0 char} 25.439 0 49.18 0 30.734 0 195.8 {'1:02:17.477'} 12:07:17.477 {'0:25.439' } {'0:49.180'} {'0:30.734' } {0×0 char} {'Matt McMurry' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 27 {'1:42.469' } 0 {0×0 char} 24.66 0 47.846 0 29.963 0 201.3 {'1:03:59.946'} 12:08:59.946 {'0:24.660' } {'0:47.846'} {'0:29.963' } {0×0 char} {'Matt McMurry' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 28 {'2:00.711' } 0 {'B' } 24.304 0 46.724 0 49.683 0 170.9 {'1:06:00.657'} 12:11:00.657 {'0:24.304' } {'0:46.724'} {'0:49.683' } {0×0 char} {'Matt McMurry' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'RF'} {'04' } 3 29 {'21:36.394' } 0 {0×0 char} NaN 0 49.33 0 30.589 0 15.9 {'1:27:37.051'} 12:32:37.051 {'20:16.475'} {'0:49.330'} {'0:30.589' } {0×0 char} {'Matt McMurry' } 00:20:12.216 {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 30 {'1:44.728' } 0 {0×0 char} 25.743 0 49.129 0 29.856 0 196.9 {'1:29:21.779'} 12:34:21.779 {'0:25.743' } {'0:49.129'} {'0:29.856' } {0×0 char} {'Matt McMurry' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'GF'} {'04' } 3 31 {'1:41.236' } 0 {0×0 char} 24.231 1 47.379 1 29.626 1 203.7 {'1:31:03.015'} 12:36:03.015 {'0:24.231' } {'0:47.379'} {'0:29.626' } {0×0 char} {'Matt McMurry' } NaN {'LMP2' } {0×0 char} {'Crowdstrike Racing by APR' } {'ORECA' } {'FF'} {'1' } 1 1 {'3:32.696' } 0 {0×0 char} NaN 0 58.042 0 35.351 0 97 {'3:32.696' } 11:08:32.696 {'1:59.303' } {'0:58.042'} {'0:35.351' } {0×0 char} {'Bryan Sellers' } 00:01:38.131 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 2 {'1:52.705' } 0 {0×0 char} 26.952 0 51.59 0 34.163 0 183 {'5:25.401' } 11:10:25.401 {'0:26.952' } {'0:51.590'} {'0:34.163' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'RF'} {'1' } 1 3 {'2:50.267' } 0 {'B' } 27.92 0 NaN 0 NaN 0 121.1 {'8:15.668' } 11:13:15.668 {'0:27.920' } {'1:04.840'} {'1:17.507' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'RF'} {'1' } 2 4 {'4:32.718' } 0 {0×0 char} NaN 0 50.874 0 32.303 0 75.6 {'12:48.386' } 11:17:48.386 {'3:09.541' } {'0:50.874'} {'0:32.303' } {0×0 char} {'Madison Snow' } 00:03:06.522 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 2 5 {'1:47.814' } 2 {0×0 char} 25.333 1 50.399 1 32.082 2 191.3 {'14:36.200' } 11:19:36.200 {'0:25.333' } {'0:50.399'} {'0:32.082' } {0×0 char} {'Madison Snow' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 2 6 {'2:10.616' } 0 {'B' } 25.359 0 51.375 0 53.882 0 157.9 {'16:46.816' } 11:21:46.816 {'0:25.359' } {'0:51.375'} {'0:53.882' } {0×0 char} {'Madison Snow' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'RF'} {'1' } 1 7 {'5:13.723' } 0 {0×0 char} NaN 0 51.668 0 33.436 0 65.7 {'22:00.539' } 11:27:00.539 {'3:48.619' } {'0:51.668'} {'0:33.436' } {0×0 char} {'Bryan Sellers' } 00:03:45.882 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 8 {'1:51.659' } 0 {0×0 char} 26.41 0 53.052 0 32.197 0 184.7 {'23:52.198' } 11:28:52.198 {'0:26.410' } {'0:53.052'} {'0:32.197' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 9 {'2:00.730' } 0 {'B' } 25.244 2 50.316 2 45.17 0 170.8 {'25:52.928' } 11:30:52.928 {'0:25.244' } {'0:50.316'} {'0:45.170' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 10 {'10:32.913' } 0 {0×0 char} NaN 0 54.875 0 32.364 0 32.6 {'36:25.841' } 11:41:25.841 {'9:05.674' } {'0:54.875'} {'0:32.364' } {0×0 char} {'Bryan Sellers' } 00:09:01.343 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 11 {'1:48.898' } 0 {0×0 char} 25.827 0 50.699 0 32.372 0 189.4 {'38:14.739' } 11:43:14.739 {'0:25.827' } {'0:50.699'} {'0:32.372' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 12 {'2:00.352' } 0 {'B' } 25.537 0 50.51 0 44.305 0 171.4 {'40:15.091' } 11:45:15.091 {'0:25.537' } {'0:50.510'} {'0:44.305' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 13 {'4:56.268' } 0 {0×0 char} NaN 0 51.639 0 32.331 0 69.6 {'45:11.359' } 11:50:11.359 {'3:32.298' } {'0:51.639'} {'0:32.331' } {0×0 char} {'Bryan Sellers' } 00:03:28.719 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 14 {'1:48.474' } 0 {0×0 char} 25.65 0 50.5 0 32.324 0 190.1 {'46:59.833' } 11:51:59.833 {'0:25.650' } {'0:50.500'} {'0:32.324' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 15 {'2:00.671' } 0 {'B' } 25.262 0 50.719 0 44.69 0 170.9 {'49:00.504' } 11:54:00.504 {'0:25.262' } {'0:50.719'} {'0:44.690' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 16 {'5:30.377' } 0 {'B' } NaN 0 51.134 0 50.675 0 62.4 {'54:30.881' } 11:59:30.881 {'3:48.568' } {'0:51.134'} {'0:50.675' } {0×0 char} {'Bryan Sellers' } 00:03:46.078 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'RF'} {'1' } 1 17 {'6:33.744' } 0 {0×0 char} NaN 0 57.692 0 33.329 0 52.4 {'1:01:04.625'} 12:06:04.625 {'5:02.723' } {'0:57.692'} {'0:33.329' } {0×0 char} {'Bryan Sellers' } 00:04:57.874 {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 18 {'1:50.098' } 0 {0×0 char} 25.641 0 52.181 0 32.276 0 187.3 {'1:02:54.723'} 12:07:54.723 {'0:25.641' } {'0:52.181'} {'0:32.276' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 19 {'1:47.907' } 0 {0×0 char} 25.353 0 50.436 0 32.118 1 191.1 {'1:04:42.630'} 12:09:42.630 {'0:25.353' } {'0:50.436'} {'0:32.118' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'GF'} {'1' } 1 20 {'2:08.688' } 0 {'B' } 25.699 0 51.46 0 51.529 0 160.3 {'1:06:51.318'} 12:11:51.318 {'0:25.699' } {'0:51.460'} {'0:51.529' } {0×0 char} {'Bryan Sellers' } NaN {'GTD' } {0×0 char} {'Paul Miller Racing' } {'BMW' } {'RF'} {'10' } 2 1 {'11:11.323' } 0 {'B' } NaN 0 NaN 0 NaN 0 30.7 {'11:11.323' } 11:16:11.323 {'1:35.642' } {'1:06.766'} {'8:28.915' } {0×0 char} {'Filipe Albuquerque' } 00:01:13.349 {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 2 {'2:28.017' } 0 {0×0 char} NaN 0 56.958 0 30.479 0 139.3 {'13:39.340' } 11:18:39.340 {'1:00.580' } {'0:56.958'} {'0:30.479' } {0×0 char} {'Filipe Albuquerque' } 00:08:28.074 {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 3 {'1:41.453' } 0 {0×0 char} 24.892 0 47.433 0 29.128 0 203.3 {'15:20.793' } 11:20:20.793 {'0:24.892' } {'0:47.433'} {'0:29.128' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 4 {'2:20.179' } 0 {'B' } 23.777 0 59.975 0 56.427 0 147.1 {'17:40.972' } 11:22:40.972 {'0:23.777' } {'0:59.975'} {'0:56.427' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'RF'} {'10' } 2 5 {'3:43.349' } 0 {0×0 char} NaN 0 47.508 0 29.387 0 92.3 {'21:24.321' } 11:26:24.321 {'2:26.454' } {'0:47.508'} {'0:29.387' } {0×0 char} {'Filipe Albuquerque' } 00:02:26.795 {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 6 {'1:36.674' } 0 {0×0 char} 23.413 0 44.963 0 28.298 0 213.3 {'23:00.995' } 11:28:00.995 {'0:23.413' } {'0:44.963'} {'0:28.298' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 7 {'1:36.388' } 0 {0×0 char} 23.279 0 44.833 0 28.276 0 214 {'24:37.383' } 11:29:37.383 {'0:23.279' } {'0:44.833'} {'0:28.276' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 8 {'1:36.909' } 0 {0×0 char} 23.539 0 44.828 0 28.542 0 212.8 {'26:14.292' } 11:31:14.292 {'0:23.539' } {'0:44.828'} {'0:28.542' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 9 {'1:42.872' } 0 {0×0 char} 23.203 0 49.014 0 30.655 0 200.5 {'27:57.164' } 11:32:57.164 {'0:23.203' } {'0:49.014'} {'0:30.655' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 10 {'1:35.835' } 0 {0×0 char} 23.058 0 44.868 0 27.909 2 215.2 {'29:32.999' } 11:34:32.999 {'0:23.058' } {'0:44.868'} {'0:27.909' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 11 {'10:44.833' } 0 {'B' } 23.124 0 45.748 0 NaN 0 32 {'40:17.832' } 11:45:17.832 {'0:23.124' } {'0:45.748'} {'9:35.961' } {0×0 char} {'Filipe Albuquerque' } NaN {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 12 {'6:08.220' } 0 {'B' } NaN 0 NaN 0 NaN 0 56 {'46:26.052' } 11:51:26.052 {'1:36.265' } {'1:22.843'} {'3:09.112' } {0×0 char} {'Filipe Albuquerque' } 00:10:14.801 {'GTP' } {0×0 char} {'Konica Minolta Acura ARX-06' } {'Acura' } {'GF'} {'10' } 2 13 {'2:18.385' } 0 {0×0 char} 54.843 0 54.241 0 29.301 0 149 {'48:44.437' } 11:53:44.437 {'0:54.843' } {'0:54.241'} {'0:29.301' } {0×0 char} {'Filipe Albuquerque' } 00:03:03.673 {'GTP' } {0×0 char} {'Konica Minolta Ac...
% now you can distinguish between '1' and '01' in the NUMBER column:
disp(unique(t.NUMBER))
{'01' } {'02' } {'023'} {'04' } {'1' } {'10' } {'11' } {'12' } {'13' } {'14' } {'16' } {'17' } {'18' } {'19' } {'20' } {'21' } {'23' } {'24' } {'25' } {'27' } {'3' } {'31' } {'32' } {'33' } {'35' } {'36' } {'38' } {'42' } {'43' } {'44' } {'47' } {'51' } {'52' } {'53' } {'55' } {'57' } {'6' } {'60' } {'62' } {'63' } {'64' } {'66' } {'7' } {'70' } {'74' } {'75' } {'77' } {'78' } {'79' } {'8' } {'80' } {'83' } {'85' } {'87' } {'88' } {'9' } {'91' } {'93' } {'95' } {'96' }
rows_1 = find(strcmp(t.NUMBER,'1')) % rows in t with NUMBER '1'
rows_1 = 20×1
96 97 98 99 100 101 102 103 104 105
rows_01 = find(strcmp(t.NUMBER,'01')) % rows in t with NUMBER '01'
rows_01 = 16×1
1 2 3 4 5 6 7 8 9 10

the cyclist
the cyclist il 21 Set 2023
% Detect the automatic import options
opts = detectImportOptions("23_Time Cards_Practice 1.CSV");
% Change of import type of the first column
opts.VariableTypes{1} = 'categorical';
% Import file
data = readtable("23_Time Cards_Practice 1.CSV",opts);
% Display the unique values of the first column, to show that it worked
unique(data(:,1))
ans = 60×1 table
NUMBER ______ 01 02 023 04 1 10 11 12 13 14 16 17 18 19 20 21

Walter Roberson
Walter Roberson il 21 Set 2023
filename = "23_Time Cards_Practice 1.CSV";
opt = detectImportOptions(filename);
opt = setvartype(opt, 1, 'string');
opt = setvartype(opt, 4, 'duration');
opt = setvaropts(opt, 4, 'InputFormat', 'mm:ss.SSS');
data = readtable(filename, opt);
data(1:2,1:5)
ans = 2×5 table
NUMBER DRIVER_NUMBER LAP_NUMBER LAP_TIME LAP_IMPROVEMENT ______ _____________ __________ _________ _______________ "01" 2 1 13:38.866 0 "01" 2 2 06:17.456 0

Prodotti


Release

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by