Inputs.table(aiddata)
aiddata = {
const data = await d3.csv(googleSheetCsvUrl, row => ({
yearDate: d3.timeParse('%Y')(row.year),
yearInt: +row.year,
donor: row.donor,
recipient: row.recipient,
amount: +row.commitment_amount_usd_constant,
purpose: row.coalesced_purpose_name,
}));
data.columns = Object.keys(data[0]);
return data;
}
geoJSON = FileAttachment("countries-50m.json").json()
import {legend, swatches} from "@d3/color-legend"
a) How does the amount donated vs. amount received change over time for each country?
countries = [... new Set(aiddata.map(d => d.recipient))]
selectYear
//data question a) Group the data with respect to years and donors, in the same way do for recipients
yearlyCountryDonationData = d3.rollups(aiddata, g => d3.sum(g, e => e.amount), d => d.donor, d => d.yearInt)
yearlyCountryRecieptData = d3.rollups(aiddata, g => d3.sum(g, e => e.amount), d => d.recipient, d => d.yearInt)
filteringDataByYearLocRecieve =
{
var filterData = [];
selectYear.forEach(year =>{
const tempYear = yearlyGiveTakeCountryWise.filter(d => d.yr == year)
filterData = filterData.concat(tempYear)
})
return filterData.filter(d => d.location == selectLocation).filter(d => d.txn =='recieving')
}
filteringDataByYearLocDonate =
{
var filterData = [];
selectYear.forEach(year =>{
const tempYear = yearlyGiveTakeCountryWise.filter(d => d.yr == year)
filterData = filterData.concat(tempYear)
})
return filterData.filter(d => d.location == selectLocation).filter(d => d.txn =='donating')
}
c) Are there countries that change their role over time?
Marks : Lines, Matrices,
Channels: colors, position
d3 = require('d3@7')
googleSheetCsvUrl = 'https://docs.google.com/spreadsheets/d/1YiuHdfZv_JZ-igOemKJMRaU8dkucfmHxOP6Od3FraW8/gviz/tq?tqx=out:csv'
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
