Practical Data Manipulation Techniques in JavaScript

Topic Overview and Importance

Hello and welcome! Today, we're exploring practical data manipulation techniques in JavaScript . We'll use JavaScript arrays to represent our data stream and perform projection, filtering, and aggregation. And here's the star of the show: our operations will be neatly packaged within a JavaScript class! No mess, all clean code.

Introduction to Data Manipulation

Data manipulation is akin to being a sculptor but for data. We chisel and shape our data to get the desired structure. JavaScript arrays are perfect for this, and our operations will be conveniently bundled inside a JavaScript class . So, let's get our toolbox ready! Here's a simple JavaScript class, DataStream, that will serve as our toolbox: JavaScript class DataStream {constructor(data) {this.data = data;}}

Data Projection in Practice

Our first stop is data projection. Think of it like capturing a photo of our desired features. Suppose we have data about people. If we're only interested in names and ages, we project our data to include just these details. We'll extend our DataStream class with a projectData method for this: JavaScript class DataStream {constructor(data) {this.data = data;} projectData(keys) {const projectedData = this.data.map(d => {let newObj = {}; keys.forEach(key => {newObj[key] = d[key] !== undefined ? d[key] : null;}); return newObj;}); return projectedData;}} // Let's use it! const ds = new DataStream([{ 'name': 'Alice', 'age': 25, 'profession': 'Engineer' }, { 'name': 'Bob', 'age': 30, 'profession': 'Doctor' },]); const projectedDs = ds.projectData(['name', 'age']); console.log(projectedDs); // Outputs: [{ 'name': 'Alice', 'age': 25 }, { 'name': 'Bob', 'age': 30 }] As you can see, we now have a new array with just the names and ages!

Data Filtering in Practice

Next, we have data filtering, which is like cherry-picking our preferred data entries. We'll extend our DataStream class with a filterData method that uses a "test" function to filter data: JavaScript class DataStream {constructor(data) {this.data = data;} // ... other methods ... filterData(testFunc) {const filteredData = this.data.filter(testFunc); return filteredData;}} // Applying it: const ds = new DataStream([{ 'name': 'Alice', 'age': 25, 'profession': 'Engineer' }, { 'name': 'Bob', 'age': 30, 'profession': 'Doctor' },]); const ageTest = x => x['age'] > 26; // our "test" function const filteredDs = ds.filterData(ageTest); console.log(filteredDs); // Outputs: [{ 'name': 'Bob', 'age': 30, 'profession': 'Doctor' }] With the filter method, our output is an array with only Bob’s data, as he's the only one who passes the 'age over 26' test.

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

Combining Projection, Filtering, and Aggregation

Now, let's combine projection, filtering, and aggregation to see the collective power of these techniques. We'll extend our example to demonstrate this flow:

Data Projection: Choose only the desired fields.
Data Filtering: Filter the data based on certain conditions.
Data Aggregation: Summarize the filtered data.

We'll modify our DataStream class to include all the methods and then use them together in a workflow. On top of that, projection and filtering methods will now return an instance of DataStream, not an array as before, so that we can chain these methods when calling them:

JavaScript

class DataStream {
    constructor(data) {
        this.data = data;
    }

    projectData(keys) {
        const projectedData = this.data.map(d => {
            let newObj = {};
            keys.forEach(key => {
                newObj[key] = d[key] !== undefined ? d[key] : null;
            });
            return newObj;
        });
        return new DataStream(projectedData);  // Return a new DataStream object for chaining
    }

    filterData(testFunc) {
        const filteredData = this.data.filter(testFunc);
        return new DataStream(filteredData);  // Return a new DataStream object for chaining
    }

    aggregateData(key, aggFunc) {
        const values = this.data.map(d => d[key]);
        return aggFunc(values);
    }
}

// Example usage
const ds = new DataStream([
    { 'name': 'Alice', 'age': 25, 'profession': 'Engineer', 'salary': 70000 },
    { 'name': 'Bob', 'age': 30, 'profession': 'Doctor', 'salary': 120000 },
    { 'name': 'Carol', 'age': 35, 'profession': 'Artist', 'salary': 50000 },
    { 'name': 'David', 'age': 40, 'profession': 'Engineer', 'salary': 90000 },
]);

// Step 1: Project the data to include only 'name', 'age', and 'salary'
const projectedDs = ds.projectData(['name', 'age', 'salary']);

// Step 2: Filter the projected data to include only those with age > 30
const filteredDs = projectedDs.filterData(x => x['age'] > 30);

// Step 3: Aggregate the filtered data to compute the average salary
const averageSalary = filteredDs.aggregateData('salary', salaries => salaries.reduce((a, b) => a + b) / salaries.length);
console.log(averageSalary);  // Outputs: 70000.0

class DataStream {
    constructor(data) {
        this.data = data;
    }

    projectData(keys) {
        const projectedData = this.data.map(d => {
            let newObj = {};
            keys.forEach(key => {
                newObj[key] = d[key] !== undefined ? d[key] : null;
            });
            return newObj;
        });
        return new DataStream(projectedData);  // Return a new DataStream object for chaining
    }

    filterData(testFunc) {
        const filteredData = this.data.filter(testFunc);
        return new DataStream(filteredData);  // Return a new DataStream object for chaining
    }

    aggregateData(key, aggFunc) {
        const values = this.data.map(d => d[key]);
        return aggFunc(values);
    }
}

// Example usage
const ds = new DataStream([
    { 'name': 'Alice', 'age': 25, 'profession': 'Engineer', 'salary': 70000 },
    { 'name': 'Bob', 'age': 30, 'profession': 'Doctor', 'salary': 120000 },
    { 'name': 'Carol', 'age': 35, 'profession': 'Artist', 'salary': 50000 },
    { 'name': 'David', 'age': 40, 'profession': 'Engineer', 'salary': 90000 },
]);

// Step 1: Project the data to include only 'name', 'age', and 'salary'
const projectedDs = ds.projectData(['name', 'age', 'salary']);

// Step 2: Filter the projected data to include only those with age > 30
const filteredDs = projectedDs.filterData(x => x['age'] > 30);

// Step 3: Aggregate the filtered data to compute the average salary
const averageSalary = filteredDs.aggregateData('salary', salaries => salaries.reduce((a, b) => a + b) / salaries.length);
console.log(averageSalary);  // Outputs: 70000.0

Here:

Projection: We choose only the name, age, and salary fields from our data. The projectData method now returns a DataStream object, allowing us to chain multiple operations.
Filtering: We filter the projected data to include only those persons whose age is greater than 30. The filterData method also returns a DataStream object for chaining.
Aggregation: We calculate the average salary of the filtered data. The final output shows the average salary for those aged over 30, which is 70,000.

By combining these methods, our data manipulation becomes both powerful and concise. Try experimenting and see what you can create!