data_processed = aq.from(data_raw)
.join_left(aq.from(country_metadata), ["Country Code", "Code"])
.derive({'Year': aq.escape(d => d3.format(".0f")(d.Time))})
.rename({'GDP per capita (constant 2015 US$) [NY.GDP.PCAP.KD]':'GDP_per_capita'
,'Birth rate, crude (per 1,000 people) [SP.DYN.CBRT.IN]': 'Birth_rate'
,'Death rate, crude (per 1,000 people) [SP.DYN.CDRT.IN]': 'Death_rate'
,'Population ages 65 and above (% of total population) [SP.POP.65UP.TO.ZS]': 'Pop%_65+'
})
.select('Year'
,'Country Name'
,'GDP_per_capita'
,'Birth_rate'
,'Death_rate'
,'Pop%_65+'
,'Income Group'
)
.objects()