I don't understand your question. When I look in the actual csv file in the first column, which is labeled "Number" I only see the value 1, I don't see anywhere 01,
In anycase what would be the difference betwee 1 and 01?
Al momento, stai seguendo questa domanda
- Vedrai gli aggiornamenti nel tuofeed del contenuto seguito.
- Potresti ricevere delle e-mail a seconda delle tuepreferenze per le comunicazioni.
.csv using readtable doesn't make difference between the value 1 and 01
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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
Steve Groleau
il 21 Set 2023
Hi, here is a picture of the data file. It matter because the two diffirent number are refencing to two different cars (car 1 and car 01). Same thing with the 23 vs 023.
Thank you
the cyclist
il 21 Set 2023
Modificato: the cyclist
il 21 Set 2023
@Jon, if you open the file with a simple text editor (rather than an application like Excel that will guess at format), you can see that some entries are 1, and some are 01.
If 1 and 01 are categorical variables, signifying different entities, then it matters. (Obviously, it must, or @Steve Groleau wouldn't be asking.)
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
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.
Risposte (3)
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
2 Commenti
Voss
il 21 Set 2023
You're welcome! Any questions, let me know. Otherwise, please "Accept" this answer. Thanks!
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
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
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Si è verificato un errore
Impossibile completare l'azione a causa delle modifiche apportate alla pagina. Ricarica la pagina per vedere lo stato aggiornato.
Translated by 
Seleziona un sito web
Seleziona un sito web per visualizzare contenuto tradotto dove disponibile e vedere eventi e offerte locali. In base alla tua area geografica, ti consigliamo di selezionare: .
Puoi anche selezionare un sito web dal seguente elenco:
Come ottenere le migliori prestazioni del sito
Per ottenere le migliori prestazioni del sito, seleziona il sito cinese (in cinese o in inglese). I siti MathWorks per gli altri paesi non sono ottimizzati per essere visitati dalla tua area geografica.
Americhe
- América Latina (Español)
- Canada (English)
- United States (English)
Europa
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Asia-Pacifico
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)