Cleaning the Internal Data
Instructions
Complete the following steps for cleaning the internal data provided.
Steps
1Download and Review the Data File
The file below contains conversion data from Buhi’s website. Identify any extreme outliers, incorrect value formats, impossible values, null values, and data outside of Q3. These values are errors in the data.
2Clean Landing Page – Conversions Data
Remove the erroneous values you identified by clearing the individual cells containing them, not entire rows. After clearing a cell, simply leave it empty. Then, upload your cleaned file and check the correctness of your cleaned data by clicking Validate.
Note: If there are any errors remaining when you validate your file, you’ll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column 0 in the feedback refers to the ID column, column 1 is Landing Page, and so on.(If you’re using a spreadsheet application, deleting erroneous values in one column may cause a long value from an adjacent column to appear to bleed into the now-empty cell. This only affects the way the spreadsheet is Cleaning the Internal Data displayed, not the actual value of the cell in question, which is still empty.)
Upload Cleaned Internal Data,
Accepted File Requirements,
File must be uploaded as a csv,
File must contain 7 columns with the names: “ID”, “Landing Page”, “Date Range”, “Country”, “Ad Campaign Clicks”, “Converted Sales”, “Instructions”
File must contain 391 rows (+-10)
Instructions
Complete the following steps for cleaning the internal data provided.
Steps
1Download and Review the Data File,
The file below contains conversion data from Buhi’s website., Identify any extreme outliers incorrect value formats impossible values null values and data outside of Q3,. These values are errors in the data.,
2Clean Landing Page Conversions Data,
Remove the erroneous values you identified by clearing the individual cells containing the not entire rows., After clearing a cell simply leave it empty., Then, upload your cleaned file and check the correctness of your cleaned data by clicking Validate.
Note: If there are any errors remaining when you validate your file, you’ll receive feedback pointing out the rows and columns where the errors are. When referring to column numbers, the numbering starts at zero. Therefore, column 0 in the feedback refers to the ID column, column 1 is Landing Page, and so on.(If you’re using a spreadsheet application, deleting erroneous values in one column may cause a long value from an adjacent column to appear to bleed into the now-empty cell. This only affects the way the spreadsheet is displayed, not the actual value of the cell in question, which is still empty.)
Upload Cleaned Internal Data
Accepted File Requirements
File must be uploaded as a csv
File must contain 7 columns with the names: “ID”, “Landing Page”, “Date Range”, “Country”, “Ad Campaign Clicks”, “Converted Sales”, “Instructions”
File must contain 391 rows (+-10)