Breaking down CSV rows and transforming numerical data (Typescript, Javascript)

Question

Breaking down CSV rows and transforming numerical data (Typescript, Javascript)

Looking to convert a row from a csv file into an array and then transform the numeric values from string format.

This represents my csv file row:

const row = "TEXT,2020-06-04 06:16:34.479 UTC,179,0.629323";

My objective is to create this array (with the last two values in number format):

["TEXT","2020-06-04 06:16:34.479 UTC",179,0.629323]

I attempted this in three different ways, but did not achieve the desired outcome.

Attempt 1:

const array1 = row.split(",");

Outcome:

["TEXT","2020-06-04 06:16:34.479 UTC","179","0.629323"]

Attempt 2:

const array2 = row.split(",");
for (let element in array3){
    array3[element] = +array3[element];
}

Outcome:

[null,null,179,0.629323]

Attempt 3:

const array3 = row.split(",").map(x=>+x);

Outcome:

[null,null,179,0.629323]

Any assistance would be greatly appreciated!

Thank you!

javascript arrays typescript csv csvtoarray

Answer 1

Answer №1

Exploring the functionality of isNaN()

const data = "TEXT,2020-06-04 06:16:34.479 UTC,179,0.629323";

const dataArray = data.split(",").map(item => isNaN(item) ? item : +item)

console.log(dataArray)

Answer 2

Exploring the functionality of isNaN()

const data = "TEXT,2020-06-04 06:16:34.479 UTC,179,0.629323";

const dataArray = data.split(",").map(item => isNaN(item) ? item : +item)

console.log(dataArray)

Answer 3

Answer №2

When working with JavaScript, the inNan Function can be used to determine whether a number can be converted to Number.

Here is an example method you can try:

const row = "TEXT,2020-06-04 06:16:34.479 UTC,179,0.629323";
const array1 = row.split(",");
const newArray = array1.map(value => toNumber(value))
console.log("newArray", newArray)

function toNumber(value) {
    if(isNaN(value) || value === "")
        return value
    else 
        if(value.indexOf(".") === -1)
            return parseInt(value)
        else
            return parseFloat(value)
}

Another way to achieve this is by multiplying each value by 1:

let array = row.split(",").map(value => isNaN(value) ? value : value * 1);

Answer 4

When working with JavaScript, the inNan Function can be used to determine whether a number can be converted to Number.

Here is an example method you can try:

const row = "TEXT,2020-06-04 06:16:34.479 UTC,179,0.629323";
const array1 = row.split(",");
const newArray = array1.map(value => toNumber(value))
console.log("newArray", newArray)

function toNumber(value) {
    if(isNaN(value) || value === "")
        return value
    else 
        if(value.indexOf(".") === -1)
            return parseInt(value)
        else
            return parseFloat(value)
}

Another way to achieve this is by multiplying each value by 1:

let array = row.split(",").map(value => isNaN(value) ? value : value * 1);

Breaking down CSV rows and transforming numerical data (Typescript, Javascript)

Answer №1

Answer №2

Similar questions

How can I simulate pressing the ENTER key in Selenium without selecting any element?

Nested React Components in React Router Components

Encountered an issue during my initial AJAX call

Unlock the Power of TWBS Ratchet: Manually Closing Modal Windows

When does the ng-disable function become activated?

Utilizing Firebase authentication to sign in via phone number in conjunction with Express on Node.js

Prevent Float Filtering in AngularJS

Is there a way to prevent prettier from automatically adding a new line when formatting HTML tags with ">"?

Removing double double quotes for Javascript

Selenium on Sauce Labs does not successfully load the page in Firefox after clicking

Use a conditional statement for each element within the array

In the context of React Typescript, the term 'Component' is being mistakenly used as a type when it actually refers to a value. Perhaps you intended to use 'typeof Component' instead?

Creating a new service in Vue is a simple process that allows you to utilize powerful tools like this.$t and this.$alert

Sharing code between a node.js server and browser with Typescript: A step-by-step guide

Managing the output from a function: Tips and strategies

transmitting information to Laravel via ajax

Exploration of mapping in Angular using the HttpClient's post

Creating a Dynamic Canvas Rendered to Fit Image Dimensions

Issue with Parcel / React 18 App.js failing to refresh cache

The deletion function necessitates a switch from a server component to a client component