read and update csv file in nodejs

1const fs = require('fs')
2const csv = require('csv-parser')
3const randomWords = require('random-words')
4const users = [];
5function generateUsername(firstname, surname) {
6    return `${firstname[0]}-${surname}`.toLowerCase();
7}
8fs.createReadStream('input.csv')
9  .pipe(csv())
10  .on('data', function (row) {
11    const username = generateUsername(row.Firstname, row.Surname);
12    const password = randomWords(3).join("-");
13    
14    const user = {
15        username,
16        firstname: row.Firstname,
17        surname: row.Surname,
18        roles: row.Roles,
19        password
20    }
21    users.push(user)
22  })
23  .on('end', function () {
24      console.table(users)
25      // TODO: SAVE users data to another file
26    })
27

1$ npm i -s csv-parser
2

1$ npm i -s csv-parse
2