Skip to content

Integer and Boolean type keys #4

Open

Description

@ammuluk

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
}

Activity

  1. rossw7 commented on Dec 16, 2018

    @rossw7

    I would love this also..

  2. rossw7 commented on Dec 18, 2018

    @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},

  3. chamkank commented on Jan 10, 2019

    @chamkank
    Owner

    @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', ...]} }).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions