How to read TrainBatch1_CaseInfo.csv

How to read TrainBatch1_CaseInfo.csv  

  By: RomStriker on July 22, 2024, 1:06 p.m.

Hi,

I am trying to load the csv file, but I am not sure which encoding and delimiter to use. By default, I get unreadable text with many question mark symbols.

Regards, Roman

Re: How to read TrainBatch1_CaseInfo.csv  

  By: minghuizhang24 on July 31, 2024, 5:41 a.m.

Hi,

Thanks for reaching out.

We have tested locally and it succeeded. Could you please provide more bug logs in reading the CSV information?

Best,

Re: How to read TrainBatch1_CaseInfo.csv  

  By: RomStriker on July 31, 2024, 10:57 p.m.

Can you tell me what program you used to read the CSV file? I have used Microsoft Excel on Windows and LibreOffice on Ubuntu, and both failed to read the file properly. I also tried to read it using Pandas in python but there I also get an error.

Pandas Error:

  File "parsers.pyx", line 838, in pandas._libs.parsers.TextReader.read_low_memory
  File "parsers.pyx", line 905, in pandas._libs.parsers.TextReader._read_rows
  File "parsers.pyx", line 874, in pandas._libs.parsers.TextReader._tokenize_rows
  File "parsers.pyx", line 891, in pandas._libs.parsers.TextReader._check_tokenize_status
  File "parsers.pyx", line 2061, in pandas._libs.parsers.raise_parser_error
pandas.errors.ParserError: Error tokenizing data. C error: Expected 1 fields in line 4, saw 2

Regards, Roman

Re: How to read TrainBatch1_CaseInfo.csv  

  By: minghuizhang24 on Aug. 1, 2024, 1:41 a.m.

Hi,

Could you please try the re-generated CSV file here:

TrainBatch1_CaseInfo: https://drive.google.com/file/d/1wYwTLIYnnrqk8afKnKer8k4BoHvGPgVG/view?usp=sharing TrainBatch2_CaseInfo: https://drive.google.com/file/d/1z1e8BX3cXzcSD4RqFgt044cPNMyIp8Uh/view?usp=sharing

We used the python library of 'csv' to read these files.

Best,

Re: How to read TrainBatch1_CaseInfo.csv  

  By: RomStriker on Aug. 2, 2024, 12:11 a.m.

Thanks, it works now.

Regards, Roman