Practice

Data Cleaning and Visualization Using Google Sheets

Dataset Description:

You have been provided with a dataset containing the following columns:

  • Country: Name of the country.
  • Income per Person: Average income per person in the country.
  • Internet Use Rate: Percentage of the population using the internet.
  • Urban Rate: Percentage of the population living in urban areas.

Objective:

Your task is to clean the dataset and create visualizations to explore the relationships between income, internet use, and urbanization across different countries.

Steps to Complete the Exercise:

  1. Load the Dataset into Google Sheets:

    • Open Google Sheets and create a new spreadsheet.
    • Copy and paste the dataset into the spreadsheet or use the IMPORTDATA function to import data from a CSV file.

  2. Data Cleaning and Formatting:

    • Identify and handle missing or erroneous data:
      • Check for any blank cells or N/A entries in the dataset.
      • Replace any missing or erroneous values with appropriate data (e.g., average income per person for missing values).
    • Ensure consistent formatting:
      • Convert any text values to numbers if necessary.
      • Remove any extra spaces or special characters from the data.
    • Rename column headers to be more descriptive if needed.

  3. Create Basic Visualizations:

    • Create a scatter plot to visualize the relationship between income per person and internet use rate.
    • Create a bar chart or pie chart to compare internet use rates across different countries.
    • Create a histogram to visualize the distribution of urbanization rates among the countries.

  4. Enhance Visualizations:

    • Add appropriate titles and labels to each chart to provide context and clarity.
    • Customize the appearance of the charts by adjusting colors, fonts, and styles to improve readability.

  5. Submission Guidelines:

  • Download your google sheet file to your computer.

    • Click on File
    • Select download

  • Attach it below and submit.

    • There is no external submission for this project. Please ignore the Incomplete status for external submission.