Skip to content

Instantly share code, notes, and snippets.

@codetricity
Created February 12, 2018 01:49
Show Gist options
  • Save codetricity/d2d822227bc118f61bce5ee9c1c10a4d to your computer and use it in GitHub Desktop.
Save codetricity/d2d822227bc118f61bce5ee9c1c10a4d to your computer and use it in GitHub Desktop.
Example of using jquery.csv.js
var fs = require('fs');
var $ = jQuery = require('jquery');
require('./jquery.csv.js');
var contents = fs.readFileSync('flavors_of_cacao.csv', 'utf8')
var data = $.csv.toArrays(contents);
var rating_1 = 0;
var rating_1_5 = 0;
var rating_1_75 = 0;
var rating_2 = 0;
var rating_2_25 = 0;
var rating_2_5 = 0;
var rating_2_75 = 0;
var rating_3 = 0;
var rating_3_25 = 0;
var rating_3_5 = 0;
for (rowNumber in data) {
// console.log(data[rowNumber]);
var rating = data[rowNumber][6];
if (rating == '1') {
rating_1 += 1;
} else if (rating == '1.5') {
rating_1_5 += 1;
} else if (rating == '1.75') {
rating_1_75 += 1;
} else if (rating == '2') {
rating_2 += 1;
} else if (rating == '2.25') {
rating_2_25 += 1;
} else if (rating == '2.5') {
rating_2_5 += 1;
} else if (rating == '2.75') {
rating_2_75 += 1;
} else if (rating == '3') {
rating_3 += 1;
} else if (rating == '3.25') {
rating_3_25 += 1;
} else if (rating == '3.5') {
rating_3_5 += 1;
}
}
console.log("rating 1: " + rating_1);
console.log("rating 1.5: " + rating_1_5);
console.log("rating 1.75: " + rating_1_75);
console.log("rating 2: " + rating_2);
console.log("rating 2.25: " + rating_2_25);
console.log("rating 2.5: " + rating_2_5);
console.log("rating 2.75: " + rating_2_75);
console.log("rating 3: " + rating_3);
console.log("rating 3.25: " + rating_3_25);
console.log("rating 3.5: " + rating_3_5);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment