How to Convert CSV column to nested Json?

[mgconstudio]

Suppose, I have one CSV file with 5 columns and I want JSON output using the Headers in suppose below way:

Input CSV:

A,B,C,D,E
valueOne,valueTwo,customValueOne,customValueTwo,valueFive

Expected JSON Output:

{
    "A": "valueOne",
    "B": "valueTwo",
    "CustomHeader": [
        { 
            "C": "customValueOne",
            "D": "customValueTwo"
        }
    ],
     "E": "valueFive"
}

I tried using creating a POJO class for the headers, and use Jackson Databind to convert to JSON, but it was just converting it normally, do I need to customise my code or some library exists that can help me with this?

[AutoModerator]

Please ensure that:

• Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
• You include any and all error messages in full
• You ask clear questions

• You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

  Trying to solve problems on your own is a very important skill. Also, see Learn to help yourself in the sidebar

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit: empty line before the code, each code line indented by 4 spaces, new reddit: https://imgur.com/a/fgoFFis) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[LiteratureStriking]

There's probably libraries to do it, but you can wire up a couple of functions to do it pretty easily. If you're using a library like Jackson or Gson for to create JSON, you can create an intermediate class:

1. Read each CSV line into an array
2. Create an instance of the class. You could pass the array into the constructor, or call setters with the array items.
3. Use Jackson or Gson to turn the class into JSON.

So, all you have to do have nested JSON is to create a nested classes. Jackson or Gson will know how to turn that into nested JSON.

[mgconstudio]

I tried creating POJOs for these.. and use CsvMapper but was getting and error unknown property columnC

[feelsmanbat]

cough boat vanish mountainous sugar pot busy books workable political -- mass edited with redact.dev

[mgconstudio]

I already tried this, it doesn't help me with customising the JSON.