Sometimes import will type a column as numeric (123) when the data is a mix of numbers and strings.
When this happens, the non-numeric column values are converted to NaN.
I would like to be able to assign the column type myself. In this case, I would assign the column type as string.
Sometimes import will type a column as numeric (123) when the data is a mix of numbers and strings. When this happens, the non-numeric column values are converted to NaN. I would like to be able to assign the column type myself. In this case, I would assign the column type as string.