Question: Given the following (in python): import pandas as pd pop=pd.read_csv(https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-population.csv) areas=pd.read_csv(https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-areas.csv) abbrevs=pd.read_csv(https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-abbrevs.csv) Please answer the following question: 2) Choose the top 5 observations from the

Given the following (in python):

import pandas as pd

pop=pd.read_csv("https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-population.csv") areas=pd.read_csv("https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-areas.csv") abbrevs=pd.read_csv("https://raw.githubusercontent.com/jakevdp/data-USstates/master/state-abbrevs.csv")

Please answer the following question:

2) Choose the top 5 observations from the given data sets? You can used DATA_NAME.head function.

3) Write a Python program to select the 'year' and state/region columns from the pop data.

4) Write a Python program which shows the rows whose years are less than 2012 in pop data.

5) Find the population and state/region where the years are 2012 in pop data.

6) Is there any null data in areas data? If yes, how many null values in each column?

7) Is there any null data in pop data? If yes, how many null values in each column?

8) Is there any null data in abbrevs data? If yes, how many null values in each column?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!