Parse the JSON file in the local directory and extract specific keys for each object, storing them in an array

Question

Parse the JSON file in the local directory and extract specific keys for each object, storing them in an array

Seeking to retrieve data from a local JSON file that contains nodeIDs with longitude, latitude, and adjacent nodeIDs as values.

For example:

[{"33583379": {"lat": 40.7046387, "lon": -74.0167729, "adj": ["33583379", "1659428533"]}, "33583380": {"lat": 40.7043271, "lon": -74.0169624, "adj": ["33583379", "33583381"]}, etc.}]

The goal is to extract the Object name, "lat", and "long" values of each object and store them in arrays like this:

[33583379, -73.984293,40.729468],
  [33583380, -73.987752,40.732017]

Attempted to use Object.keys(data[0]) but it retrieves all object names, and finding a way to fetch them one by one in the same loop has been a challenge.

Any assistance is welcome. Have been struggling for hours to extract the necessary key values from the JSON file and format them into an array. PS: Working on a project in React.

javascript json

Answer 1

Answer №1

To retrieve data from a JSON file, you can use the following code snippet: require('location-of-json'). Extract the latitude and longitude details using a for-loop and store them in an array.

a=require('./test.json')
data=[]

for(var i in this.a[0]){
  console.log(new Array(this.a[0][i].lat,this.a[0][i].lon))
  this.data.push(new Array(this.a[0][i].lat,this.a[0][i].lon))
}

This implementation is done using React. Feel free to check out the code here: https://stackblitz.com/edit/react-nphzxn

Answer 2

To retrieve data from a JSON file, you can use the following code snippet: require('location-of-json'). Extract the latitude and longitude details using a for-loop and store them in an array.

a=require('./test.json')
data=[]

for(var i in this.a[0]){
  console.log(new Array(this.a[0][i].lat,this.a[0][i].lon))
  this.data.push(new Array(this.a[0][i].lat,this.a[0][i].lon))
}

This implementation is done using React. Feel free to check out the code here: https://stackblitz.com/edit/react-nphzxn

Parse the JSON file in the local directory and extract specific keys for each object, storing them in an array

Answer №1

Similar questions

Remove Vue Component from the styling of current application

Calculate the pixel distance between various divs by measuring the horizontal distance from the left border to the right

Prevent any clicking on the page for a brief period of time following the execution of a function

Encountering a TypeScript type error when returning a promise from a function

Daniel Opitz explores the best placement for DataTables within the slim4 framework

Dynamic sliding box jumps instead of simply fading in/out

Upon upgrading kombu, an issue has arisen where the task_id is not JSON serializable

Enhancing Efficiency with Laravel 5: Updating Multiple Data Entries

Form submission is not functioning as expected

I'm looking to add autocomplete functionality to a text input in my project, and then retrieve and display data from a MySQL database using

Use vtip jQuery for showcasing titles

What is the best way to include the API body in a GET request?

validating if Object may be either 'null' or 'undefined'

What is a method for saving a file from Chrome to a network drive using scripting language, even though it's currently functioning in IE?

What is the best way to transform JSON into a Swift Dictionary so that it can be used for an HTTP POST

The "ID" value for the row that was chosen is unable to be parsed with AJAX JQUERY

Unable to render Google map on Vue CLI component

Illuminate objects using three.js

Angular ng-if directive contains a specific class

Error message encountered in React Material-UI while attempting to run the basic Hello World test - Invalid hook call