5 ms·
WAIT. All these words on SO and here have been written because people don't know to change the column type from "General" to "Text"?
by TeMPOraL 5y ago
WAIT. All these words on SO and here have been written because people don't know to change the column type from "General" to "Text"?
- Linosaurus 5y agoThey would like to be able to just open a csv file in excel without going through a file import wizard. Changing the column type after the fact is too late.
- intended 5y agoIf you get to the point that you are using r and python, it should be because you are doing working with larger data sets, or it’s specifically sophisticated. If you can learn a language, you could constrain type conversions easily once you have for knowledge. Its not like there aren’t painful gotchas in other tools- it’s an issue if you aren’t aware of them and if they impact your work. If it’s big, unusually complex, you probably want a DB before analysis. If it’s repetitive, or advanced modeling/ml: python/r
- deleted 5y ago[deleted]