embed(
{
"data": {"values":data_trans(df)},
"transform": [
{"filter": "datum.Year == 2000"},
{"calculate": "datum.Sex == 2 ? 'Female' : 'Male'", "as": "gender"},
{"calculate": "datum.Sex == 2 ? -datum.People : datum.People", "as": "signed_people"}
],
"width": 300,
"height": 200,
"mark": "bar",
"encoding": {
"y": {
"field": "Age",
"type": "ordinal",
"sort": "descending"
},
"x": {
"aggregate": "sum", "field": "signed_people",
"title": "Population",
"axis": {"format": "s"}
},
"color": {
"field": "gender",
"scale": {"range": ["#675193", "#ca8861"]},
"legend": {"orient": "top", "title": null}
}
},
"config": {
"view": {"stroke": null},
"axis": {"grid": true}
}
}
)