# coding: utf-8   # ## Section 5 Homework - Fill in the Blanks   # Import the packages needed to perform the analysis     import _ as pd import _ as np import _ as plt import _ as sns       # Load the data provided for the exercise     # Import the csv dataset data = _("P4-Demographic-Data.csv")     # Explore the data         # Visualize the dataframe data       # Rename the column names data._ = ['CountryName', 'CountryCode', 'BirthRate', 'InternetUsers', 'IncomeGroup']       # Check top 6 rows data._(6)       # Check bottom 7 rows data._(7)       # Check the structure of the data frame data._()     # Check the summary of the data data._()     # ### Request 1 # You are employed as a Data Scientist by the World Bank and you are working on a project to analyse the World’s demographic trends. #  # You are required to produce a scatterplot illustrating Birth Rate and Internet Usage statistics by Country. #  # The scatterplot needs to also be categorised by Countries’ Income Groups.      # Plot the BirthRate versus Internet Users categorized by Income Group vis1 = sns._( data = data, x = '_', y = '_', fit_reg = False, hue = '_', size = 10 )         #request 2  #find the counties that have internt users between 20 and 80   newdf = data[(_._>20) & ( _.Internetusers <40 )]     # Plot the BirthRate versus Internet Users categorized by Income Group on newdf frame  vis2 = sns._( data = newdf, x = '_', y = '_', fit_reg = False, hue = '_', size = 10 )

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 8EYW
icon
Related questions
Question
100%

 

# coding: utf-8

 

# ## Section 5 Homework - Fill in the Blanks

 

# Import the packages needed to perform the analysis

 

 

import _ as pd

import _ as np

import _ as plt

import _ as sns

 

 

 

# Load the data provided for the exercise

 

 

# Import the csv dataset

data = _("P4-Demographic-Data.csv")

 

 

# Explore the data

 

 

 

 

# Visualize the dataframe

data

 

 

 

# Rename the column names

data._ = ['CountryName', 'CountryCode', 'BirthRate', 'InternetUsers', 'IncomeGroup']

 

 

 

# Check top 6 rows

data._(6)

 

 

 

# Check bottom 7 rows

data._(7)

 

 

 

# Check the structure of the data frame

data._()

 

 

# Check the summary of the data

data._()

 

 

# ### Request 1

# You are employed as a Data Scientist by the World Bank and you are working on a project to analyse the World’s demographic trends.

# You are required to produce a scatterplot illustrating Birth Rate and Internet Usage statistics by Country.

# The scatterplot needs to also be categorised by Countries’ Income Groups. 

 

 

# Plot the BirthRate versus Internet Users categorized by Income Group

vis1 = sns._( data = data, x = '_', y = '_', fit_reg = False, hue = '_', size = 10 )

 

 

 

 

#request 2 

#find the counties that have internt users between 20 and 80

 

newdf = data[(_._>20) & ( _.Internetusers <40 )]

 

 

# Plot the BirthRate versus Internet Users categorized by Income Group on newdf frame 

vis2 = sns._( data = newdf, x = '_', y = '_', fit_reg = False, hue = '_', size = 10 )

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Elements of Tables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage