Issue with summing and data manipulation in d3
I have a data set that i'm trying to work with in js.D3 and i'm struggling.
The dataset has the following attributes:
- Job Offers (Int)
- City (String)
- Date (DateTime)
- Industry (String)
- College Graduate (Boolean value)
I want to sum all job offers received by city by month and for some reason i'm coming up short and receiving an error.
First I have done the following to ensure I have clean data (I.E. no missing records etc):
const cleanJobData = data.filter(d=> d.city !=="" && d.dateTime !=="" && d.jobOffer !== "" && d.jobOffer!== 0)
I then tried to use d3.rollup to sum job offers by city:
const jobOffersByMonth = d3.rollup(cleanJobData,
fcm => d3.sum(fcm, d=> d.jobOffer),
d => d.dateTime.getMonth(), city => city.city);
This now gives me a map of months with corresponding totals for job offers by city. I want to now sort this from greatest to least by number of offers per city. if I try and use d3.sort() I receive an error that d3.sort is not a function. What am I doing wrong here?
I also tried using a group function const jobOffersByMonth = d3.group(cleanJobData, d => d.dateTime.getMonth(), v => v.city, fcm => d3.sum(fcm, v => v.jobOffers)) but I receive the error: T is not iterable
Can you please check if the following code fulfill your requirement.
const data = [{
jobOffer: 23,
city: 'mumbai',
dateTime: new Date(2014, 1, 1),
industry: 'aa',
},
{
jobOffer: 23,
city: 'delhi',
dateTime: new Date(2012, 1, 1),
industry: 'aa',
},
{
jobOffer: 23,
city: 'delhi',
dateTime: new Date(2011, 2, 2),
industry: 'aa',
},
{
jobOffer: 23,
city: 'pak',
dateTime: new Date(2013, 1, 1),
industry: 'aa',
},
]
const cleanJobData = data.filter(d => d.city !== "" && d.dateTime !== "" && d.jobOffer !== "" && d.jobOffer !== 0);
var nested_data = d3.nest()
.key(function(d) {
return d.city;
})
.rollup(function(leaves) {
return d3.sum(leaves, function(d) {
return d.jobOffer;
})
})
.entries(cleanJobData)
.sort((a, b) => b.value - a.value)
console.log(nested_data)I believe that d3.sort is trying to use the Array sort function on d3 which is not an Array and therefore, it's true: d3.sort is not a function.
You would have to use sort on jobOffersByMonth (after converting it to an Array from a Map, which is what is returned after doing a rollup) and create an appropriate function to pass to it, perhaps taking advantage of d3's ascending or descending, like this user's answer here: https://stackoverflow.com/a/25168203/1168004 or
// given jobOffersByMonth looks something like:
// Map {
// "{MONTH_NAME}" => int
// }
// we must first convert it into an Array to sort it
// using Array.from(jobOffersByMonth) or [...jobOffersByMonth]
[...jobOffersByMonth].sort(function(x, y){
return d3.ascending(x[1], y[1]); // could alternatively be descending
});
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111469 visits
- search for elements in a list 111052 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98813 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96317 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92513 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62027 visits
- Adding methods to es6 child class 22364 visits
