이 질문을 팔로우합니다.
- 팔로우하는 게시물 피드에서 업데이트를 확인할 수 있습니다.
- 정보 수신 기본 설정에 따라 이메일을 받을 수 있습니다.
.csv using readtable doesn't make difference between the value 1 and 01
조회 수: 1 (최근 30일)
이전 댓글 표시
Steve Groleau
2023년 9월 21일
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
Jon
2023년 9월 21일
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
2023년 9월 21일
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
2023년 9월 21일
편집: the cyclist
2023년 9월 21일
@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
2023년 9월 21일
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
2023년 9월 21일
편집: Jon
2023년 9월 21일
@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.
답변 (3개)
Voss
2023년 9월 21일
편집: Voss
2023년 9월 21일
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
Voss
2023년 9월 21일
You're welcome! Any questions, let me know. Otherwise, please "Accept" this answer. Thanks!
the cyclist
2023년 9월 21일
% 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
2023년 9월 21일
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
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!오류 발생
페이지가 변경되었기 때문에 동작을 완료할 수 없습니다. 업데이트된 상태를 보려면 페이지를 다시 불러오십시오.
웹사이트 선택
번역된 콘텐츠를 보고 지역별 이벤트와 혜택을 살펴보려면 웹사이트를 선택하십시오. 현재 계신 지역에 따라 다음 웹사이트를 권장합니다:
또한 다음 목록에서 웹사이트를 선택하실 수도 있습니다.
사이트 성능 최적화 방법
최고의 사이트 성능을 위해 중국 사이트(중국어 또는 영어)를 선택하십시오. 현재 계신 지역에서는 다른 국가의 MathWorks 사이트 방문이 최적화되지 않았습니다.
미주
- América Latina (Español)
- Canada (English)
- United States (English)
유럽
- 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)
아시아 태평양
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)