KNIME_​Part2_​MSDS_​402

Read the Data:
File name - Govt_Units_2026_Final.xlsx

• Contains information of US Census Bureau's Government Master Address File(GMAF)

Missing Values:

• Removing the rows which has web_address values missing

Column Merger:

• Merging ZIP and ZIP4 columns

• Replacing Primary column(ZIP) and deleting secondary(ZIP4) column

Filter the data:

Filtering Mayors in all states

• Filtering out Mayors in all states

Combining columns:

• Combining a few columns and putting them together in a new combined column

Scatter Plot:

• Scatter plot of number of people in each state

Statistics:

• Overall statistics of the data sheet with filtered data

Excel Writer:

• Create a new excel file with 2 new sheets