davila7/filegpt · problems with understanding .csv

Feb 26, 2023

the idea is amazing. thank you for doing this. but i am having problems with FGPT understanding the file. e.g. i uploaded a file with swimming times where the times in one file were objects, and time in another, in both cases it was either giving me wrong info, or could not show minimum times or could not find a swimmer by last name.

davila7

Owner Feb 26, 2023

@PeterJa

Could you write a couple of rows of this file here in the comments?
With a sample it is possible that I can improve the algorithm so that it can understand this type of records

PeterJa

Feb 27, 2023

sure, here they are
result_rank,full_name,distance,time_id,event_desc,swimmer_age,swim_time,time,alt_adj_swim_time_formatted,standard_name,meet_name,swim_date,club_name,lsc_id,foreign_yesno,hytek_power_points,event_id,sanction_status,month
1,"Modglin, William",50,298555668,50 FR SCY,18,19.80,19.8,19.80,2023 Summer Juniors (LCM),2022 Speedo Winter Juniors East,2022-12-08,Zionsville Swim Club,IN,,912.0,1,Yes,12
2,"Modglin, William",50,298555646,50 FR SCY,18,19.86,19.86,19.86,2023 Summer Juniors (LCM),2022 Speedo Winter Juniors East,2022-12-08,Zionsville Swim Club,IN,,906.0,1,Yes,12
3,"Modglin, William",50,300865788,50 FR SCY,18,20.56,20.56,20.56,2023 Futures (LCM),2023 IN ZSC The Freeze,2023-01-15,Zionsville Swim Club,IN,,836.0,1,Yes,1
4,"Raches, William",50,298555647,50 FR SCY,17,20.59,20.59,20.59,2023 Futures (LCM),2022 Speedo Winter Juniors East,2022-12-08,Zionsville Swim Club,IN,,848.0,1,Yes,12
5,"Berry, Gabriel",50,298523971,50 FR SCY,17,21.38,21.38,21.38,2023 Futures (LCM),2022 IN WTSC Holiday Champs,2022-11-20,Zionsville Swim Club,IN,,771.0,1,Yes,11