Our great sponsors
-
CSVLint
CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
u/Logical_Master3904 I think the app should either require that the column metadata is also supplied by the user, or the app could infer from the data but that can get pretty complicated. For what it's worth I do something similar in the CSV Lint plug-in, It detects the datatypes from the data, so for each column it takes all the string values, keeps track of some character counts/statistics and then basically guesses what type it is. It's messy and not perfect, but it works like 95% of the time, see code here: AnalyzeColumn