Icon

Economics

Extraction Cleansing (preprocessing with some blending amongst subtopics) Blending (join all the data from differentsubtopics) Write rename city_name colrename city_name colWrite to filetag yearsto gdpcity --> lowercaseGross GDP(by city region)Gross GDP (by local authority)join datasourcesGDP per head(by city region)tag yearsto gdptag yearsto gdptag yearsto gdpGDP per head(by local authority)join datasourcesCleanse allGDP-related dataIndustrial Structure2018Industrial Structure2017cleanseindustrial 2018cleanseindustrial 2017Industrial Structure2016 #1Industrial Structure2016 #2Concat all 2016 dataIndustrial Structure2016 #2industrial 2016- list #1industrial 2016- list #2industrial 2016- londongive colssuitable namesconvert totalto intjoin 2017 and 2018industrial datajoin allindustrial datarename columnsto reflect datesjoin GDPdata with industrialMedian pricepaid - regionrename city_name colMedian pricepaid - countiesMedian pricepaid - LAjoin housingdata with restconcatenate & cleansehousing datareset therow IDsCities list Column Rename Column Rename Table Writer Column Rename Case Converter Excel Reader Excel Reader Concatenate Excel Reader Column Rename Column Rename Column Rename Excel Reader Concatenate GDP Data Cleansing Excel Reader Excel Reader CleanseIndustrial Data CleanseIndustrial Data Excel Reader Excel Reader Concatenate Excel Reader Extract 2016Industrial Data Extract 2016Industrial Data Extract 2016Industrial Data Column Rename String To Number Joiner Joiner Column Rename Joiner Excel Reader Column Rename Excel Reader Excel Reader Joiner ProcessHousing Data RowID CSV Reader Extraction Cleansing (preprocessing with some blending amongst subtopics) Blending (join all the data from differentsubtopics) Write rename city_name colrename city_name colWrite to filetag yearsto gdpcity --> lowercaseGross GDP(by city region)Gross GDP (by local authority)join datasourcesGDP per head(by city region)tag yearsto gdptag yearsto gdptag yearsto gdpGDP per head(by local authority)join datasourcesCleanse allGDP-related dataIndustrial Structure2018Industrial Structure2017cleanseindustrial 2018cleanseindustrial 2017Industrial Structure2016 #1Industrial Structure2016 #2Concat all 2016 dataIndustrial Structure2016 #2industrial 2016- list #1industrial 2016- list #2industrial 2016- londongive colssuitable namesconvert totalto intjoin 2017 and 2018industrial datajoin allindustrial datarename columnsto reflect datesjoin GDPdata with industrialMedian pricepaid - regionrename city_name colMedian pricepaid - countiesMedian pricepaid - LAjoin housingdata with restconcatenate & cleansehousing datareset therow IDsCities list Column Rename Column Rename Table Writer Column Rename Case Converter Excel Reader Excel Reader Concatenate Excel Reader Column Rename Column Rename Column Rename Excel Reader Concatenate GDP Data Cleansing Excel Reader Excel Reader CleanseIndustrial Data CleanseIndustrial Data Excel Reader Excel Reader Concatenate Excel Reader Extract 2016Industrial Data Extract 2016Industrial Data Extract 2016Industrial Data Column Rename String To Number Joiner Joiner Column Rename Joiner Excel Reader Column Rename Excel Reader Excel Reader Joiner ProcessHousing Data RowID CSV Reader

Nodes

Extensions

Links