state-population.csv data

state/region	ages	year	population
AL	under18	2012	1117489
AL	total	2012	4817528
AL	under18	2010	1130966
AL	total	2010	4785570
AK	total	1990	553290
AK	under18	1990	177502
AK	total	1992	588736
AK	under18	1991	182180
CA	under18	2012	9209007
CA	total	2012	37999878
CA	under18	2011	9252336
CA	total	2011	37668681
NH	under18	2000	310352
NH	total	1999	1222015
NH	under18	1999	308423
NH	total	2001	1255517

TX	under18	1990	4906220
TX	total	1990	17056755
TX	total	1991	17398005
TX	under18	1991	5000793
TX	total	1993	18161612
TX	under18	1993	5217899
TX	under18	1992	5109805
TX	total	1992	17759738
TX	under18	1994	5331524
TX	total	1994	18564062
TX	total	1995	18958751
TX	under18	1995	5421784
TX	under18	2005	6290970
TX	total	2006	23359580
TX	under18	2006	6446798
TX	total	2008	24309039
TX	under18	2008	6675917
TX	total	2007	23831983
TX	under18	2007	6565872
TX	under18	2013	7041986
TX	total	2013	26448193
TX	total	2009	24801761
TX	under18	2009	6792907
TX	total	2010	25245178
TX	under18	2010	6879014
TX	under18	2011	6931758
TX	total	2011	25640909
TX	under18	2012	6985807
TX	total	2012	26060796

state-population.csv data above

Question 1. in python

Using the data in the attached state-population.csv file

find out the 3 largest and 3 smallest population states among the states (district) from 1990 to 2012.

Save your output in the ranking.csvfiles. The CSV file format should be:

1991,

2012, xx, xx, xx, xx, xx, xx

Find out what % of U.S. population lives in TX in years 2000 and 2012, and how many times population has increased/dropped in the 13 years. Also compare the increment rate between TX and the USA.

Output format:

Year 2000: TX population is xxx, USA population is xxx, xx% Americans live in TX.

Year 2012: TX population is xxx, USA population is xxx, xx% Americans live in TX.

TX population increased xx times from 2000 to 2012

U.S. population increased xx times from 2000 to 2012

TX population increases faster/slower than average of population of U.S.