Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Line breaks are not recognised on a Windows computer #1255

Open
tischi opened this issue Apr 29, 2024 · 1 comment
Open

Line breaks are not recognised on a Windows computer #1255

tischi opened this issue Apr 29, 2024 · 1 comment

Comments

@tischi
Copy link

tischi commented Apr 29, 2024

Hi,

We have a seemingly Windows specific issue, where the line breaks of the CSV are not recognised.

I am not sure how to debug this efficiently, because I do not have a Windows computer with a development environment.

Is there anything general I could try to make this more robust across OS?

This is my current code, which opens the tables correctly on a Mac:

final InputStream inputStream = IOHelper.getInputStream( path );
// https://jtablesaw.github.io/tablesaw/userguide/importing_data.html
CsvReadOptions.Builder builder = CsvReadOptions.builder( inputStream )
	.separator( separator )
	.missingValueIndicator( "na", "none", "nan" )
	.sample( numSamples > 0 )
	.sampleSize( numSamples )
	.columnTypesPartial( nameToType );
final Table rows = Table.read().usingOptions( builder );

And here is the table that creates the problems on Windows:

test-crop-8bit-ds2.csv

@tischi
Copy link
Author

tischi commented Apr 30, 2024

Maybe it helps for the debugging that this file
iMGL_AAV2MOI105_6h_DAPI_IBA1_well6_image2_C2.csv
does not have this issue.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant