Question 250521 in Html Question posted in
Some basic documentation can be found here.

Html – Get conditional values in JavaScript

I have a JavaScript layer for my HTML which has its first 3 rows presented below:

var TR_Accomodation = {
    'Hacı Sabancı': {
      'İl': 'ADANA',
      'Dist': 100,
      'Accomodation_Type': 'hotel',
      'Count': 52
    },
    'Ceyhan': {
      'İl': 'ADANA',
      'Dist': 100,
      'Accomodation_Type': 'motel',
      'Count': 25
    },
    'Ceyhan': {
      'İl': 'ADANA',
      'Dist': 50,
      'Accomodation_Type': 'hotel',
      'Count': 31
    }, ...

dataset has 8000 rows, 81 distinct values for "İl", 4 for "Dist" and 6 in my html I have a listener by drop down list to get İl values and the second one to get the features ‘Ceyhan’ so on.

How can I get the values for each dist value and each Accomodation_Type.

In detail, I want to have variables like Dist_50km_hotel so that presents the e.g. number of hotels at most distance of 50 km of Ceyhan.

How can I extract Count value for feature Ceyhan where the "Dist" is 50 and ‘Accomodation_Type’ is equal to "hotel" and save that in a new variable.

Tags:

2

Answers


  1. 0

    You need to convert it to an array using Object Entries. That will let you filter it based on the object. After that you convert it back to your object format.

    const TR_Accomodation = {
  'Hacı Sabancı': {
    'İl': 'ADANA',
    'Dist': 100,
    'Accomodation_Type': 'hotel',
    'Count': 52
  },
  'Ceyhan': {
    'İl': 'ADANA',
    'Dist': 100,
    'Accomodation_Type': 'motel',
    'Count': 25
  },
  'Ceyhan2': {
    'İl': 'ADANA',
    'Dist': 50,
    'Accomodation_Type': 'hotel',
    'Count': 31
  }
}

const filterByDistance = km => {
  // change to an array
  const placesInArray = Object.entries(TR_Accomodation);
  // filter based on distance
  const filteredPlaces = placesInArray.filter(([k, details]) => details.Dist <= km);
  //change back to your object format
  return Object.fromEntries(filteredPlaces);
};

const withIn50 = filterByDistance(50);
const withIn100 = filterByDistance(100);

console.log(withIn50);
console.log(withIn100);
    Login or Signup to reply.
  2. 0

    You should convert your structure to an array since an object cannot have the same 2 keys:

    {
const TR_Accomodation = [{
    Location: 'Hacı Sabancı',
    '': 'ADANA',
    'Dist': 100,
    'Accomodation_Type': 'hotel',
    'Count': 52
  },
  {
    Location:'Ceyhan',
    'İl': 'ADANA',
    'Dist': 100,
    'Accomodation_Type': 'motel',
    'Count': 25
  },
  {
    Location:'Ceyhan',
    'İl': 'ADANA',
    'Dist': 50,
    'Accomodation_Type': 'hotel',
    'Count': 31
  }
]

const type = 'hotel';
const distance = 50;
const location = 'Ceyhan';

const count = TR_Accomodation.reduce((r, {Dist,Accomodation_Type, Location,Count}) => 
  (Dist <= distance && Accomodation_Type === type && (Location === location) && (r+=Count), r), 0);
  
console.log(count);
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search