You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
.csv using readtable doesn't make difference between the value 1 and 01
1 view (last 30 days)
Show older comments
Steve Groleau
on 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 Comments
Jon
on 21 Sep 2023
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?
Steve Groleau
on 21 Sep 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
on 21 Sep 2023
Edited: the cyclist
on 21 Sep 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
on 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
on 21 Sep 2023
Edited: Jon
on 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.
Answers (3)
Voss
on 21 Sep 2023
Edited: Voss
on 21 Sep 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 Comments
Voss
on 21 Sep 2023
You're welcome! Any questions, let me know. Otherwise, please "Accept" this answer. Thanks!
the cyclist
on 21 Sep 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
on 21 Sep 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
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- 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 Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)