{
"year_range" : ["2000","2014"],
"features" : ["monthly_income", "water_access", "roof_material", "wall_material", "cb_size", "floor_area", "years_electrified", "total_adults","total_children","total_part_time","total_unemployed","total_pensioners"],
"searchlist" : ["earn per month","external","money from small business","watersource", "roof", "wall", "main switch", "floor area","electricity", "males","part time","unemployed","pension"],
"transform": {
	"monthly_income" : "x['earn per month'] + x.fillna(0)['money from small business'] + x.fillna(0)['external']",
	"water_access" : "x['watersource']",
	"roof_material" : "x['roof']",
	"wall_material" : "x['wall']",
	"cb_size" : "x['main switch']",
	"floor_area" : "x['floor area']",
	"years_electrified" : "x['electricity']",
    "total_adults" : "x.fillna(0)['number of males: 16-24'] + x.fillna(0)['number of females: 16-24'] + x.fillna(0)['number of males: 25 - 34'] + x.fillna(0)['number of females: 25-34'] + x.fillna(0)['number of males: 35-49'] + x.fillna(0)['number of females: 35 - 49'] + x.fillna(0)['number of males: 50+']",
    "total_children" : "x.fillna(0)['number of males: <16'] + x.fillna(0)['number of females: <16']",
	"total_part_time" : "x.fillna(0)['head emploed part time'] + x.fillna(0)['spouse employed part time'] + x.fillna(0)['persons older than 16 years: employed parttime']",
	"total_unemployed" : "x.fillna(0)['head unemployed'] + x.fillna(0)['spouse unemployed'] + x.fillna(0)['persons older than 16 years: employed unemployed']",
	"total_pensioners" : "x.fillna(0)['head on pension'] + x.fillna(0)['spouse on pension'] + x.fillna(0)['persons older than 16 years: pension']"
	},
"bins" : {},
"labels" : {},
"cut" : {},
"replace" : {
    	"water_access": {
		"1":"nearby river/dam/borehole", 
		"2":"block/street taps", 
		"3":"tap in yard", 
		"4":"tap inside house"
		},
	"roof_material": {
        	"1":"IBR/Corr.Iron/Zinc", 
        "2":"Thatch/Grass", 
        	"3":"Wood/Masonite board", 
		"4":"Brick", 
		"5":"Blocks", 
		"6":"Plaster", 
		"7":"Concrete", 
		"8":"Tiles", 
        	"9":"Plastic", 
        	"10":"Asbestos", 
        "11":"Daub/Mud/Clay"
        	},
	"wall_material": {
		"1":"IBR/Corr.Iron/Zinc", 
		"2":"Thatch/Grass", 
		"3":"Wood/Masonite board", 
		"4":"Brick", 
        	"5":"Blocks", 
        	"6":"Plaster", 
        "7":"Concrete", 
        	"8":"Tiles", 
        	"9":"Plastic", 
		"10":"Asbestos", 
		"11":"Daub/Mud/Clay"
		}
	},
"geo" : "Municipality"
}
