hone icon indicating copy to clipboard operation
hone copied to clipboard

Integer and Boolean type keys

Open ammuluk opened this issue 6 years ago • 3 comments

Is there a way to specify the type of the key when converting to JSON? I have csv columns which are integers and boolean. When i use this module to convert csv to json, those values are outputted as strings.

{ "number": "240", "isdown": "FALSE" } I am excepting { "number": 240, "isdown": false }

ammuluk avatar Aug 21 '18 03:08 ammuluk

I would love this also..

rossw7 avatar Dec 16 '18 22:12 rossw7

I have made changes to deal with strings or integers. (probably could do the same for boolean, just not in my usecase/data)

'Severity': {'Product': 10, 'Normalized': 10},

rossw7 avatar Dec 18 '18 15:12 rossw7

@ammuluk Apologies for the late response! @rossw7 has opened #6 to deal with integer values.

Booleans will be a little bit tricky because there is no standard way to represent a boolean value in a CSV file (ex: true can be True, TRUE, true, yes, YES, Yes, etc), but it would be interesting to add some sort of option to let the user manually specify which values should be type converted (ex: {'bool': {False: ['No', 'no', ...], True: ['YES', 'yes', ...]} }).

chamkank avatar Jan 10 '19 03:01 chamkank