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

1 vue (au cours des 30 derniers jours)
Steve Groleau
Steve Groleau le 21 Sep 2023
Modifié(e) : Jon le 21 Sep 2023
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 commentaires
Afficher 3 commentaires plus anciens
Dyuman Joshi
Dyuman Joshi le 21 Sep 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 le 21 Sep 2023
Modifié(e) : Jon le 21 Sep 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.

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponses (3)

Voss
Voss le 21 Sep 2023
Modifié(e) : Voss le 21 Sep 2023
Ran in:
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
  2 commentaires
Steve Groleau
Steve Groleau le 21 Sep 2023
Perfect!
Thank you!
Voss
Voss le 21 Sep 2023
You're welcome! Any questions, let me know. Otherwise, please "Accept" this answer. Thanks!

Connectez-vous pour commenter.

the cyclist
the cyclist le 21 Sep 2023
Ran in:
% 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 le 21 Sep 2023
Ran in:
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

Catégories

En savoir plus sur Programming dans Help Center et File Exchange

Tags

Produits


Version

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by