Looking for a specific portion of a key-value pair

Question

Looking for a specific portion of a key-value pair

Currently, I am working on developing an application that will showcase parking tickets issued in New York City. The API that I am utilizing can be found at this link. My goal is to generate a graph illustrating the number of tickets handed out per month. Within the dataset, there exists a column named "issue_date", which contains the year, month, and additional numbers that are unfamiliar to me. Is it feasible to extract only the year and month portion from this column rather than the entire string? For instance, if I wish to view tickets issued in January, would it be possible for me to search for entries like 2017-01 without considering the rest of the data and causing errors in my code? Thank you for your assistance!

I wanted to mention that I am currently a first-year college student with limited programming knowledge. Apologies for any inconvenience caused by my lack of expertise.

javascript json

Answer 1

Answer №1

To extract the first 7 characters from the date, you simply need to grab them.

Below is a code snippet that demonstrates how to tally the number of entries per month and store this information in an array:

fetch("https://data.cityofnewyork.us/resource/ati4-9cgt.json")
   .then(resp => resp.json()).then(data => {
        const byMonth = Object.entries(data.reduce( (acc, row) => {
            const month = row.issue_date.slice(0,7); // <--- extracting YYYY-MM
            acc[month] = acc[month] || 0;
            acc[month]++; // <--- incrementing count
            return acc;
        }, {})).sort((a, b) => a[0].localeCompare(b[0])); // <--- sorting months
        console.log(byMonth); // <--- displaying [[month, count], [month, count], ...] 
    });

Answer 2

To extract the first 7 characters from the date, you simply need to grab them.

Below is a code snippet that demonstrates how to tally the number of entries per month and store this information in an array:

fetch("https://data.cityofnewyork.us/resource/ati4-9cgt.json")
   .then(resp => resp.json()).then(data => {
        const byMonth = Object.entries(data.reduce( (acc, row) => {
            const month = row.issue_date.slice(0,7); // <--- extracting YYYY-MM
            acc[month] = acc[month] || 0;
            acc[month]++; // <--- incrementing count
            return acc;
        }, {})).sort((a, b) => a[0].localeCompare(b[0])); // <--- sorting months
        console.log(byMonth); // <--- displaying [[month, count], [month, count], ...] 
    });

Answer 3

Answer №2

Use regular expressions to match the issue date format, for example: /^2017-01/

If you have an array of objects, you can filter them based on the issue date by using:

onlyOnJanuary2017 = wholeArray.filter(object => object.issue_date.match(/^2017-01/));

like shown here: https://jsfiddle.net/twpq6nvd/

Additionally, if you want to group them by month and year, you can try this approach:

var result = arr.reduce((accumulator, item) => {
  const date = new Date(item.issue_date)
  var key = `${date.getFullYear()}-${date.getMonth()}`
  accumulator[key] = accumulator[key] || [];
  accumulator[key].push(item);
  return accumulator;
}, {})

https://jsfiddle.net/d3qa96bg/1/

Answer 4

Use regular expressions to match the issue date format, for example: /^2017-01/

If you have an array of objects, you can filter them based on the issue date by using:

onlyOnJanuary2017 = wholeArray.filter(object => object.issue_date.match(/^2017-01/));

like shown here: https://jsfiddle.net/twpq6nvd/

Additionally, if you want to group them by month and year, you can try this approach:

var result = arr.reduce((accumulator, item) => {
  const date = new Date(item.issue_date)
  var key = `${date.getFullYear()}-${date.getMonth()}`
  accumulator[key] = accumulator[key] || [];
  accumulator[key].push(item);
  return accumulator;
}, {})

https://jsfiddle.net/d3qa96bg/1/

Looking for a specific portion of a key-value pair

Answer №1

Answer №2

Similar questions

How can I access an array option that combines both global and target-specific specifications within a grunt plugin?

Implementing additional input with Jquery causes tooltips to malfunction

Heroku refreshes my JSON document

What could be causing this addEventListener to fail when I am assigning elements to a class?

Watching a Computed Value in EmberJS

Verification - enter a unique key for each ajax call

Is there a way to implement a RESTful persistence solution with backbone.js using PHP?

The Checkbox generated by Javascript is failing to properly close the tag

The child division was not dynamically included

Dynamic form population with dropdown selection using Ajax - Coldfusion continuation

Exploring the functionality of jQuery by incorporating a variable into the selector

What is the best approach to perform a search in mongoose based on specific query parameters?

Minimize API Requests in Your AngularJS Application

Use Object.assign to swap out the current state with a new

After the rendering of the HTML, the value of the jQuery input does not change

Tips for incorporating dynamic content into React Material UI expansion panels while maintaining the ability to have only one tab active at a time

How to implement and utilize a history-object interface in React with Typescript?

Utilizing Laravel 8 for seamless file uploads with AJAX on onchange event

The function is coming back with a value of undefined

Saving Backbone.js Collection as Text File on HDD & Re-importing Data