Dear community,
Is there a simply way how to import a .csv file that preserves leading zeros?
I have a data set that allows partial times, and upon import, a time of 00:10 and a time of 10: _ _ , they both comes out at 10 when I import as .csv, which means I cannot distinguish between partial times and times during the night.
I found the following page: https://stackoverflow.com/questions/...variable-names,
but this imports all variables as string, which is something I do not want. Also because the dataset keeps evolving over time and I do not know in advance which variables it will contain on which I can apply destring. I would simply like to specify the variables that need to be imported as string.
Would you happen to know if there is a way to do this?
Thank you for your thoughts,
Best wishes,
Moniek
Is there a simply way how to import a .csv file that preserves leading zeros?
I have a data set that allows partial times, and upon import, a time of 00:10 and a time of 10: _ _ , they both comes out at 10 when I import as .csv, which means I cannot distinguish between partial times and times during the night.
I found the following page: https://stackoverflow.com/questions/...variable-names,
but this imports all variables as string, which is something I do not want. Also because the dataset keeps evolving over time and I do not know in advance which variables it will contain on which I can apply destring. I would simply like to specify the variables that need to be imported as string.
Would you happen to know if there is a way to do this?
Thank you for your thoughts,
Best wishes,
Moniek
Comment