Icon

04_​AmazonS3-MSBlobStorage_​Census_​Data

Will They Blend? Amazon S3 meets MS Blob Storage plus Excel
This workflow blends together data from three different sources: Amazon S3 and Azure Blob Store from the cloud and Microsoft Excel from a local file. From the Cloud From Excel In Maine women who speakno English have the shortestcommute. Should you stoplearning English? But then again the numberof women who speak noEnglish in this dataset isonly 31. Keep learningEnglish. connect to Amazon CloudS3 datass13hme.csvreadingselected fileinto KNIMEss13pme.csvreadingselected file into KNIMEjoin on SERIAL NOENG vs.SEX_textmean(Travel Time)& COUNTavg travel timevs. English proficiencyby sexjoin on SERIAL NOjoin on SERIAL NOMISSING -> 99ENG & SEXJWMNP as"Travel Timeto Work"remove rowswith missing ENGvalueremove COUNTMale& Femaleby ascendingENGremove meanMale& FemaleCOUNTvs. English proficiencyby sexSEX_MapValuesENG_MapValuesconnect toMS Azure CloudBlob Store data Amazon S3Connection Amazon S3File Picker CSV Reader Azure Blob StoreFile Picker CSV Reader Joiner Pivoting Bar Chart Joiner Joiner Missing Value Column Rename Row Filter Column Filter Column Rename Sorter Column Filter Column Rename Bar Chart Excel Reader (XLS) Excel Reader (XLS) Azure Blob StoreConnection This workflow blends together data from three different sources: Amazon S3 and Azure Blob Store from the cloud and Microsoft Excel from a local file. From the Cloud From Excel In Maine women who speakno English have the shortestcommute. Should you stoplearning English? But then again the numberof women who speak noEnglish in this dataset isonly 31. Keep learningEnglish. connect to Amazon CloudS3 datass13hme.csvreadingselected fileinto KNIMEss13pme.csvreadingselected file into KNIMEjoin on SERIAL NOENG vs.SEX_textmean(Travel Time)& COUNTavg travel timevs. English proficiencyby sexjoin on SERIAL NOjoin on SERIAL NOMISSING -> 99ENG & SEXJWMNP as"Travel Timeto Work"remove rowswith missing ENGvalueremove COUNTMale& Femaleby ascendingENGremove meanMale& FemaleCOUNTvs. English proficiencyby sexSEX_MapValuesENG_MapValuesconnect toMS Azure CloudBlob Store dataAmazon S3Connection Amazon S3File Picker CSV Reader Azure Blob StoreFile Picker CSV Reader Joiner Pivoting Bar Chart Joiner Joiner Missing Value Column Rename Row Filter Column Filter Column Rename Sorter Column Filter Column Rename Bar Chart Excel Reader (XLS) Excel Reader (XLS) Azure Blob StoreConnection

Nodes

Extensions

Links