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
Get step-by-step solutions from verified subject matter experts
