CODEWITHSUNDEEP
javascriptlodash
newdeveloper
newdeveloper

Reputation: 1451

Filtering data between specific timestamp using javascript

I need to filter data where timestamp is > 06.

"use strict"

const data =  [ 
  {timestamp: "2020-04-23 05:05", totalAvg: 2.596211180124224},
  {timestamp: "2020-04-23 05:10", totalAvg: 3.22052273203436},
  {timestamp: "2020-04-23 05:15", totalAvg: 4.75883386099804},
  {timestamp: "2020-04-23 05:20", totalAvg: 4.052205882352941},
  {timestamp: "2020-04-23 05:25", totalAvg: 6.801380301941049},
  {timestamp: "2020-04-23 05:30", totalAvg: 5.147239169614846},
  {timestamp: "2020-04-23 05:35", totalAvg: 5.035438241980298},
  {timestamp: "2020-04-23 05:40", totalAvg: 5.043628013777267},
  {timestamp: "2020-04-23 05:45", totalAvg: 3.491275770565422},
  {timestamp: "2020-04-23 05:50", totalAvg: 3.9865817073170735},
  {timestamp: "2020-04-23 05:55", totalAvg: 2.8146341463414632},
  {timestamp: "2020-04-23 06:00", totalAvg: 4.0066161616161615},
  {timestamp: "2020-04-23 06:05", totalAvg: 4.870049261083743},
  {timestamp: "2020-04-23 06:10", totalAvg: 3.3189162561576357}
];


var filteredZoneData = _.filter(data, o => {
  return !((parseInt((o.timestamp).substring(11, 13)) < 06) || (parseInt(o.timestamp.substring(11, 13)) < 24));
})

console.log(filteredZoneData)
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

here using 06 is giving error like Legacy octal literals are not allowed in strict mode

Upvotes: 1

Views: 198

Answers (2)

mplungjan
mplungjan

Reputation: 177955

There is no need to test 06 when you parseInt anyway so change to 

var filteredZoneData = _.filter(
  data, o => +o.timestamp.substring(11, 13) >= 6 // there will be no 24 in the timestamp 
);

or for a range:

var filteredZoneData = _.filter(data, o => { 
  const t = +o.timestamp.substring(11, 13);
  return t >= 6 && t < 24;
});

Example using lodash

"use strict"

const data = [ {timestamp: "2020-04-23 05:05", totalAvg: 2.596211180124224}, {timestamp: "2020-04-23 05:10", totalAvg: 3.22052273203436}, {timestamp: "2020-04-23 05:15", totalAvg: 4.75883386099804}, {timestamp: "2020-04-23 05:20", totalAvg: 4.052205882352941}, {timestamp: "2020-04-23 05:25", totalAvg: 6.801380301941049}, {timestamp: "2020-04-23 05:30", totalAvg: 5.147239169614846}, {timestamp: "2020-04-23 05:35", totalAvg: 5.035438241980298}, {timestamp: "2020-04-23 05:40", totalAvg: 5.043628013777267}, {timestamp: "2020-04-23 05:45", totalAvg: 3.491275770565422}, {timestamp: "2020-04-23 05:50", totalAvg: 3.9865817073170735}, {timestamp: "2020-04-23 05:55", totalAvg: 2.8146341463414632}, {timestamp: "2020-04-23 06:00", totalAvg: 4.0066161616161615}, {timestamp: "2020-04-23 06:05", totalAvg: 4.870049261083743}, {timestamp: "2020-04-23 06:10", totalAvg: 3.3189162561576357} ];

var filteredZoneData = _.filter(data, o => +o.timestamp.substring(11, 13) >= 6); // there will be no 24 in the timestamp

console.log(filteredZoneData)
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

But why use a library when JS can do it without?

const data = [ {timestamp: "2020-04-23 05:05", totalAvg: 2.596211180124224}, {timestamp: "2020-04-23 05:10", totalAvg: 3.22052273203436}, {timestamp: "2020-04-23 05:15", totalAvg: 4.75883386099804}, {timestamp: "2020-04-23 05:20", totalAvg: 4.052205882352941}, {timestamp: "2020-04-23 05:25", totalAvg: 6.801380301941049}, {timestamp: "2020-04-23 05:30", totalAvg: 5.147239169614846}, {timestamp: "2020-04-23 05:35", totalAvg: 5.035438241980298}, {timestamp: "2020-04-23 05:40", totalAvg: 5.043628013777267}, {timestamp: "2020-04-23 05:45", totalAvg: 3.491275770565422}, {timestamp: "2020-04-23 05:50", totalAvg: 3.9865817073170735}, {timestamp: "2020-04-23 05:55", totalAvg: 2.8146341463414632}, {timestamp: "2020-04-23 06:00", totalAvg: 4.0066161616161615}, {timestamp: "2020-04-23 06:05", totalAvg: 4.870049261083743}, {timestamp: "2020-04-23 06:10", totalAvg: 3.3189162561576357} ];


let filteredZoneData = data.filter(
  dt => dt.timestamp.split(" ")[1] > "06"
);
console.log(filteredZoneData);

// or if you prefer

filteredZoneData = data.filter(
  dt => parseInt(dt.timestamp.split(" ")[1]) >= 6
);

console.log(filteredZoneData);

Upvotes: 1

Nina Scholz
Nina Scholz

Reputation: 386600

You could check the substring directly with the wanted value as string.

const data =  [ 
  {timestamp: "2020-04-23 05:05", totalAvg: 2.596211180124224},
  {timestamp: "2020-04-23 05:10", totalAvg: 3.22052273203436},
  {timestamp: "2020-04-23 05:15", totalAvg: 4.75883386099804},
  {timestamp: "2020-04-23 05:20", totalAvg: 4.052205882352941},
  {timestamp: "2020-04-23 05:25", totalAvg: 6.801380301941049},
  {timestamp: "2020-04-23 05:30", totalAvg: 5.147239169614846},
  {timestamp: "2020-04-23 05:35", totalAvg: 5.035438241980298},
  {timestamp: "2020-04-23 05:40", totalAvg: 5.043628013777267},
  {timestamp: "2020-04-23 05:45", totalAvg: 3.491275770565422},
  {timestamp: "2020-04-23 05:50", totalAvg: 3.9865817073170735},
  {timestamp: "2020-04-23 05:55", totalAvg: 2.8146341463414632},
  {timestamp: "2020-04-23 06:00", totalAvg: 4.0066161616161615},
  {timestamp: "2020-04-23 06:05", totalAvg: 4.870049261083743},
  {timestamp: "2020-04-23 06:10", totalAvg: 3.3189162561576357}
];


var filteredZoneData = _.filter(data, o => 
  o.timestamp.slice(11, 13) >= '06' && o.timestamp.slice(11, 13) < '24'
)

console.log(filteredZoneData)
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

Upvotes: 1

Related Questions