Converting Dataset Into Proper Csv Notation For Downloading Using Javascript

I currently have the following dataset: this.set1 // == [111000, 111000, 110000, 110000, 109000] this.set2 // == [2.073921204, 2.156188965, 2.210624695, 2.210624695, 2.286842346] t

Solution 1:

You need just a small modification.

Please see the snippet below and comments in it:

this.set1 = [111000, 111000, 110000, 110000, 109000];
this.set2 = [2.073921204, 2.156188965, 2.210624695, 2.210624695, 2.286842346];
this.set3 = [527.6497192, 522.3652954, 529.675415, 529.675415, 533.8148804];
this.set4 = [530.6442261, 524.7432861, 532.2295532, 532.2295532, 536.545166];
this.set5 = [80.73879242, 80.92513275, 80.95175934, 80.95175934, 80.79203796];

// select headers of the CSV columnsconst data = [
  ['set1', 'set2', 'set3', 'set4', 'set5']
];

// pull arrays by headers
data[0].forEach(h => data.push(this[h]));

// Convert data arrays to CSV formatconstCSVURL = 'data:text/csv;charset=UTF-8,';
let formattedData = data.map(e => e.join(',')).join('\n');
let encodedData = CSVURL + encodeURIComponent(formattedData);

// Generic download CSV functiondownloadFile('name.csv', encodedData);


functiondownloadFile(n, d) {
  const a = document.createElement('a');
  a.download = n;
  a.href = d;
  document.querySelector('body').appendChild(a);
  a.click();
}

Solution 2:

Utilizing partial advice given by @Heretic Monkey (for transposing the data) and @codeWonderland (for adding category names), I have arrived at the following solution:

// Reference to pulled-data arrayslet data = [
  this.set1this.set2this.set3this.set4this.set5
];

// NEW// Reference to data array names in same order as aforementioned data arrayconst dataNames = [
  'set1',
  'set2',
  'set3',
  'set4',
  'set5',
]

// NEW// Add label to each column
data.forEach((datum, index) => {
  datum.unshift(dataNames[index]);
});

// Convert data arrays to CSV formatconstCSVURL = 'data:text/csv;charset=UTF-8,';
let transposedData = data[0].map((col, i) => data.map(row => row[i])); // NEW: TRANSPOSE DATAlet formattedData = transposedData.map(e => e.join(',')).join('\n'); // Modifiedlet encodedData = CSVURL + encodeURIComponent(formattedData);

// Generic download CSV functiondownloadFile('name.csv', encodedData);

Also noting the recent addition for alternative column labeling by @Kosh Very , quoted as:

// pull arrays by headersdata[0].forEach(h => data.push(this[h])); 

Solution 3:

You could just add labels to each of them as the first element, this would get pulled as the title field.

// Reference to pulled-data arrays
let data = [
  this.set0
  this.set1
  this.set2
  this.set3
  this.set4
];

let i = 0for (datum indata) {
    datum.unshift(`set${i}`);
}

// Convert data arrays to CSV formatconst CSVURL = 'data:text/csv;charset=UTF-8,';
let formattedData = data.map(e => e.join(',')).join('\n');
let encodedData = CSVURL + encodeURIComponent(formattedData);

// Generic download CSV function
downloadFile('name.csv', encodedData);

Also, indexing starts with 0 ;3