The numeric values in a column are floored/rounded down when the first value in that column is an integer or .0 float with an arbitrary number of zeros.
Side by side .csv file and its preview, three numeric value columns
Val has 1.0 in the second row and is previewed as it should be - as floats (same if its just 1)
Val2 has 1.0 in the first row and is previewed as integers
Val3 has 1 in the first row and is previewed as integers
The numeric values in a column are floored/rounded down when the first value in that column is an integer or .0 float with an arbitrary number of zeros.
Side by side .csv file and its preview, three numeric value columns Val has 1.0 in the second row and is previewed as it should be - as floats (same if its just 1) Val2 has 1.0 in the first row and is previewed as integers Val3 has 1 in the first row and is previewed as integers