transforming JSON into CSV structure

Question

transforming JSON into CSV structure

I am attempting to utilize a JSON file as input data. Below is an excerpt of sample data.

[
{
id: 1671349531,
name: "A Wild Restaurant Expansion",
blurb: "We are looking to expand from our current location to a new and better facility...",
goal: 17000,
pledged: 0,
state: "live",
slug: "a-wild-restaurant-expansion",
...
}

Is it feasible to convert this intricate JSON format into a CSV for easier data manipulation in R?

For instance, there are key categories within the data like basic information, photo, creator, location, category, urls.

Would it be practical to create a CSV file with subcategories such as basic_information.id, creator.id, etc.?

javascript json r csv

Answer 1

Answer №1

After doing some research, I have found a solution by using this npm package to convert JSON to CSV format.

To implement this, first install the node package and then utilize the code snippet below with your own JSON data:

var converter = require('json-2-csv');

var documents = [
    {
        Make: 'Nissan',
        Model: 'Murano',
        Year: '2013',
        Specifications: {
            Mileage: '7106',
            Trim: 'S AWD'
        }
    },
    {
        Make: 'BMW',
        Model: 'X5',
        Year: '2014',
        Specifications: {
            Mileage: '3287',
            Trim: 'M'
        }
    }
];

var json2csvCallback = function (err, csv) {
    if (err) throw err;
    console.log(csv);
};

converter.json2csv(documents, json2csvCallback);

The output of this will be as follows:

Make,Model,Year,Specifications.Mileage,Specifications.Trim
Nissan,Murano,2013,7106,S AWD
BMW,X5,2014,3287,M

Answer 2

After doing some research, I have found a solution by using this npm package to convert JSON to CSV format.

To implement this, first install the node package and then utilize the code snippet below with your own JSON data:

var converter = require('json-2-csv');

var documents = [
    {
        Make: 'Nissan',
        Model: 'Murano',
        Year: '2013',
        Specifications: {
            Mileage: '7106',
            Trim: 'S AWD'
        }
    },
    {
        Make: 'BMW',
        Model: 'X5',
        Year: '2014',
        Specifications: {
            Mileage: '3287',
            Trim: 'M'
        }
    }
];

var json2csvCallback = function (err, csv) {
    if (err) throw err;
    console.log(csv);
};

converter.json2csv(documents, json2csvCallback);

The output of this will be as follows:

Make,Model,Year,Specifications.Mileage,Specifications.Trim
Nissan,Murano,2013,7106,S AWD
BMW,X5,2014,3287,M

Answer 3

Answer №2

Here's an alternative approach that doesn't rely on json-2-csv for handling complex data:

// Example of some intricate demo data
var data = [
    {
        "id": "111",
        "name": "Johny Smith",
        "age": "23",
        "dates": [
            {
                "birthday": "01.01.1990",
                "nameday": "02.02",
                "phone": {
                    "home": "02123123123123",
                    "mobile": "07124123123",
                }
            }
        ]
    },
    {
        "id": "222",
        "name": "Jane Alex",
        "age": "43",
        "dates": [
            {
                "birthday": "06.06.1997",
                "nameday": "03.03",
                "phone": {
                    "home": "029999999999999",
                    "mobile": "0788888888",
                }
            }
        ]
    }
];

// Convert the data to a CSV-ready string
var converted = toCsv(data);

// Automatically generate and download the .CSV file
var element = document.createElement('a');
element.setAttribute('href', 'data:text/plain;charset=utf-8,' + encodeURIComponent(converted));
element.setAttribute('download', "Output.csv");
element.style.display = 'none';
document.body.appendChild(element);
element.click();
document.body.removeChild(element);


//////////////////////////////////// THE MAGIC ////////////////////////////////////

function toCsv(arr) {
    arr = pivot(arr);
    return arr.map(function (row) {
        return row.map(function (val) {
            return isNaN(val) ? JSON.stringify(val) : +val;
        }).join(',');
    }).join('\n');
}

function toConsumableArray(arr) {
    if (Array.isArray(arr)) {
        for (var i = 0, arr2 = Array(arr.length); i < arr.length; i++) {
            arr2[i] = arr[i];
        }
        return arr2;
    } else {
        return Array.from(arr);
    }
}

function pivot(arr) {
    var mp = new Map();

    function setValue(a, path, val) {
        if (Object(val) !== val) {
            // primitive value
            var pathStr = path.join('.');
            var i = (mp.has(pathStr) ? mp : mp.set(pathStr, mp.size)).get(pathStr);
            a[i] = val;
        } else {
            for (var key in val) {
                setValue(a, key == '0' ? path : path.concat(key), val[key]);
            }
        }
        return a;
    }

    var result = arr.map(function (obj) {
        return setValue([], [], obj);
    });
    let outcome = ([[].concat(toConsumableArray(mp.keys()))].concat(toConsumableArray(result)));

    return outcome;
}

Check out the working example on JS Fiddle -> https://jsfiddle.net/gbktnd1j/

Answer 4

Here's an alternative approach that doesn't rely on json-2-csv for handling complex data:

// Example of some intricate demo data
var data = [
    {
        "id": "111",
        "name": "Johny Smith",
        "age": "23",
        "dates": [
            {
                "birthday": "01.01.1990",
                "nameday": "02.02",
                "phone": {
                    "home": "02123123123123",
                    "mobile": "07124123123",
                }
            }
        ]
    },
    {
        "id": "222",
        "name": "Jane Alex",
        "age": "43",
        "dates": [
            {
                "birthday": "06.06.1997",
                "nameday": "03.03",
                "phone": {
                    "home": "029999999999999",
                    "mobile": "0788888888",
                }
            }
        ]
    }
];

// Convert the data to a CSV-ready string
var converted = toCsv(data);

// Automatically generate and download the .CSV file
var element = document.createElement('a');
element.setAttribute('href', 'data:text/plain;charset=utf-8,' + encodeURIComponent(converted));
element.setAttribute('download', "Output.csv");
element.style.display = 'none';
document.body.appendChild(element);
element.click();
document.body.removeChild(element);


//////////////////////////////////// THE MAGIC ////////////////////////////////////

function toCsv(arr) {
    arr = pivot(arr);
    return arr.map(function (row) {
        return row.map(function (val) {
            return isNaN(val) ? JSON.stringify(val) : +val;
        }).join(',');
    }).join('\n');
}

function toConsumableArray(arr) {
    if (Array.isArray(arr)) {
        for (var i = 0, arr2 = Array(arr.length); i < arr.length; i++) {
            arr2[i] = arr[i];
        }
        return arr2;
    } else {
        return Array.from(arr);
    }
}

function pivot(arr) {
    var mp = new Map();

    function setValue(a, path, val) {
        if (Object(val) !== val) {
            // primitive value
            var pathStr = path.join('.');
            var i = (mp.has(pathStr) ? mp : mp.set(pathStr, mp.size)).get(pathStr);
            a[i] = val;
        } else {
            for (var key in val) {
                setValue(a, key == '0' ? path : path.concat(key), val[key]);
            }
        }
        return a;
    }

    var result = arr.map(function (obj) {
        return setValue([], [], obj);
    });
    let outcome = ([[].concat(toConsumableArray(mp.keys()))].concat(toConsumableArray(result)));

    return outcome;
}

Check out the working example on JS Fiddle -> https://jsfiddle.net/gbktnd1j/

transforming JSON into CSV structure

Answer №1

Answer №2

Similar questions

Utilizing server-side variables with JavaScript in Node.js, Express.js, and EJS

Is the behavior of a function with synchronous AJAX (XMLHttpRequest) call in JavaScript (Vanilla, without jQuery) the same as asynchronous?

Is there a way to prevent the Alt+F4 function from closing tabs in the Internet Explorer browser

managing arrays in JavaScript with multiple tables

Tips for verifying if two passwords match during registration and displaying an error message if they do not match

VueJS method for making an HTTP GET request

Setting up Datatables using AngularJS

Fundamental JavaScript feature experiencing functionality issues

A recursive function that utilizes a for loop is implemented

Java: Combine values of the same type into a single JSON object

Creating Eye-Catching Images by Incorporating Image Overlays Using Just One Image

jquery-powered scrollable content container

Verify if an express module has a next() function available

You can install the precise version of a package as mentioned in package.json using npm

The issue of javascript Map not updating its state is causing a problem

Determine the specific button that was clicked within a React component

transferring data between PHP frames

Executing JavaScript code upon successful form submission: An overview

I'm experiencing an issue with fullCalendar where the dayRender function is not functioning as expected

loading the css and javascript files based on the specified prop parameter