krajeshj / brandwrangling Goto Github PK

The spreadsheet is an example and show information which could have been download from a database. The first column show company name, second column an abbreviation of a product and the number of products. Then we have columns for address city and country. In the last call the name of the persons is shown who placed the order. There are several problems with the spreadsheet: first the spelling of company names is not consistent and incorrect there is no column showing the names of the products in the last column with the names alphabetical ordering is not possible, only when we have the last names in separate column. Also gender is not listed, but that can be derived from the column names: dhr=mr= male and mevr=mrs=female. finally if we want to geocode the data – place the addresses of the persons in a map, all address information must be in one column.