search

thinkingmachines / linksight-2018

LinkSight is a web app for applying the Philippine Standard Geographic Code to messy and misspelled barangay, municipality, city, and province names.
https://linksight.thinkingmachin.es
GNU General Public License v3.0
11 stars 1 forks source link

When I upload a dataset, I want to be able to correct the datatype auto-detected by LinkSight for each column #153

Closed piafaustino closed 6 years ago

piafaustino commented 6 years ago

I uploaded a test dataset that contained an answer key of expected PSGC values. LinkSight converted this column to numbers, but I need for it to remain as a text column because of the leading zeroes. See screengrab below of the expected_psgc column in which the leading zeroes got chopped off:

screen shot 2018-08-21 at 5 48 54 pm

We need to have a feature that will allow the user to manually change any auto-detected datatypes per column.

marksteve commented 6 years ago

@piafaustino Hmm. Let's add this as we add export filetypes? Right now we only export to CSVs and everything is a string in CSVs (parsers just try to detect data types and coerce to native types). So we can just make everything strings when we load datasets and it should be all good.

piafaustino commented 6 years ago

Putting in backlog for now. This should be addressed by #155