Midterm Due by 3/24, 11:59PM *Generate a Python script for your answers. You will submit your script only. The midterm requires you to replicate the main results of Nollenberger, Rodŕıguez-Planas and...

1 answer below »

View more »
Answered 1 days AfterMar 22, 2021

Answer To: Midterm Due by 3/24, 11:59PM *Generate a Python script for your answers. You will submit your script...

Sandeep Kumar answered on Mar 24 2021
156 Votes
{
"cells": [
{
"cell_type": "code",
"execution_count": 104,
"metadata": {
"scrolled": true
},
"outputs": [],
"source": [
"\n",
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"%matplotlib inline\n",
"import numpy as np\n",
"import datetime\n",
"from sklearn import linear_model\n",
"reg = linear_model.LinearRegression()\n",
"import statsmodels.formula.api as smf \n",
"import random"
]
},
{
"cell_type": "code",
"execution_count": 105,
"metadata": {},
"outputs": [],
"source": [
"\n",
"PISA = pd.read_csv('dataset.csv', index_col=False)\n"
]
},
{
"cell_type": "code",
"execution_count": 106,
"metadata": {},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" year background cnt country female age diffgrade fisced misced \\\n",
"0 2012 Bolivia ARG Argentina 0 15.75 0 6.0 6.0 \n",
"1 2009 Bolivia ARG Argentina 1 15.33 1 5.0 0.0 \n",
"2 2009 Bolivia ARG Argentina 0 15.92 1 NaN NaN \n",
"3 2012 Bolivia ARG Argentina 1 16.00 0 2.0 4.0 \n",
"4 2009 Bolivia ARG Argentina 1 16.17 0 5.0 5.0 \n",
"5 2009 Bolivia ARG Argentina 1 16.08 1 5.0 0.0 \n",
"6 2012 Bolivia ARG Argentina 1 16.08 0 0.0 4.0 \n",
"7 2012 Bolivia ARG Argentina 0 15.33 0 1.0 4.0 \n",
"8 2012 Bolivia
ARG Argentina 1 15.75 0 1.0 4.0 \n",
"9 2012 Bolivia ARG Argentina 1 15.50 0 1.0 1.0 \n",
"\n",
" momwork ... gdppc hdi lgdppc obs norigin stratum2003 \\\n",
"0 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"1 NaN ... 3791.675 0.659 8.240563 131 4 NaN \n",
"2 1.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"3 1.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"4 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"5 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"6 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"7 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"8 0.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"9 1.0 ... 3791.675 0.659 8.240563 131 4 NaN \n",
"\n",
" hostregion stratum2006 stratum2009 stratum2012 \n",
"0 3202 NaN NaN ARG0102 \n",
"1 3203 NaN 3203.0 NaN \n",
"2 3201 NaN 3201.0 NaN \n",
"3 3202 NaN NaN ARG0102 \n",
"4 3201 NaN 3201.0 NaN \n",
"5 3201 NaN 3201.0 NaN \n",
"6 3202 NaN NaN ARG0102 \n",
"7 3202 NaN NaN ARG0102 \n",
"8 3202 NaN NaN ARG0102 \n",
"9 3205 NaN NaN ARG0005 \n",
"\n",
"[10 rows x 37 columns]"
],
"text/html": "
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
yearbackgroundcntcountryfemaleagediffgradefiscedmiscedmomwork...gdppchdilgdppcobsnoriginstratum2003hostregionstratum2006stratum2009stratum2012
02012BoliviaARGArgentina015.7506.06.00.0...3791.6750.6598.2405631314NaN3202NaNNaNARG0102
12009BoliviaARGArgentina115.3315.00.0NaN...3791.6750.6598.2405631314NaN3203NaN3203.0NaN
22009BoliviaARGArgentina015.921NaNNaN1.0...3791.6750.6598.2405631314NaN3201NaN3201.0NaN
32012BoliviaARGArgentina116.0002.04.01.0...3791.6750.6598.2405631314NaN3202NaNNaNARG0102
42009BoliviaARGArgentina116.1705.05.00.0...3791.6750.6598.2405631314NaN3201NaN3201.0NaN
52009BoliviaARGArgentina116.0815.00.00.0...3791.6750.6598.2405631314NaN3201NaN3201.0NaN
62012BoliviaARGArgentina116.0800.04.00.0...3791.6750.6598.2405631314NaN3202NaNNaNARG0102
72012BoliviaARGArgentina015.3301.04.00.0...3791.6750.6598.2405631314NaN3202NaNNaNARG0102
82012BoliviaARGArgentina115.7501.04.00.0...3791.6750.6598.2405631314NaN3202NaNNaNARG0102
92012BoliviaARGArgentina115.5001.01.01.0...3791.6750.6598.2405631314NaN3205NaNNaNARG0005
\n

10 rows × 37 columns

\n
"
},
"metadata": {},
"execution_count": 106
}
],
"source": [
"PISA.head(10)"
]
},
{
"cell_type": "code",
"execution_count": 112,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"PISA_G = PISA.loc[PISA['female'] == 1]\r\n",
"PISA_G = PISA_G.drop_duplicates('background')\r\n",
"PISA_G.drop(PISA_G.columns.difference(['background','female','ggi','pv1math']), 1, inplace=True)\r\n",
"#PISA_G\r\n",
"PISA_G.sort_values(by=['background'], inplace=True)\r\n",
"PISA_G['mgg'] = np.random.randint(-100, 50, PISA_G.shape[0])"
]
},
{
"cell_type": "code",
"execution_count": 113,
"metadata": {},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" background female pv1math ggi mgg\n",
"8617 Albania 1 314.542800 0.660122 34\n",
"8233 Australia 1 434.109700 0.728218 -99\n",
"8750 Austria 1 586.064819 0.703139 -82\n",
"4843 Belgium 1 550.171400 0.716538 -14\n",
"1 Bolivia 1 363.619995 0.669267 -2\n",
"134 Chile 1 428.812900 0.688381 28\n",
"235 China 1 685.706500 0.690679 13\n",
"2670 Croatia 1 436.910004 0.694358 -94\n",
"4052 Ethiopia 1 233.529999 0.594783 -21\n",
"8399 Fiji 1 410.063904 0.641400 -4\n",
"3419 France 1 456.566406 0.733143 -81\n",
"645 Germany 1 567.954529 0.744915 -42\n",
"670 Greece 1 471.576600 0.666238 -34\n",
"716 India 1 624.793600 0.615098 16\n",
"870 Italy 1 406.067900 0.679783 1\n",
"958 Korea 1 533.953918 0.614611 -48\n",
"3399 Macedonia 1 484.818500 0.694999 -51\n",
"990 Malaysia 1 517.401489 0.646744 16\n",
"7712 Morocco 1 407.549988 0.592550 17\n",
"3562 Netherlands 1 604.992981 0.748981 -44\n",
"1024 New Zealand 1 550.584228 0.788023 -77\n",
"155 Paraguay 1 443.379000 0.686812 -89\n",
"1399 Phillipines 1 544.002197 0.757864 -84\n",
"2786 Poland 1 540.902000 0.699762 34\n",
"5616 Portugal 1 436.680200 0.701284 19\n",
"2834 Romania 1 406.831299 0.680549 -11\n",
"4272 Russian Fed. 1 523.298000 0.698714 31\n",
"1932 South Africa 1 483.959992 0.770937 -64\n",
"10691 Spain 1 486.999500 0.734484 27\n",
"7904 Suriname 1 572.369995 0.672565 -98\n",
"2891 Turkey 1 440.598206 0.582830 -20\n",
"1992 United Kingdom 1 421.880400 0.740245 -73\n",
"2641 United States 1 654.469971 0.717335 43\n",
"219 Uruguay 1 475.320007 0.693637 -39\n",
"1639 Viet Nam 1 487.856400 0.680186 20"
],
"text/html": "
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
backgroundfemalepv1mathggimgg
8617Albania1314.5428000.66012234
8233Australia1434.1097000.728218-99
8750Austria1586.0648190.703139-82
4843Belgium1550.1714000.716538-14
1Bolivia1363.6199950.669267-2
134Chile1428.8129000.68838128
235China1685.7065000.69067913
2670Croatia1436.9100040.694358-94
4052Ethiopia1233.5299990.594783-21
8399Fiji1410.0639040.641400-4
3419France1456.5664060.733143-81
645Germany1567.9545290.744915-42
670Greece1471.5766000.666238-34
716India1624.7936000.61509816
870Italy1406.0679000.6797831
958Korea1533.9539180.614611-48
3399Macedonia1484.8185000.694999-51
990Malaysia1517.4014890.64674416
7712Morocco1407.5499880.59255017
3562Netherlands1604.9929810.748981-44
1024New Zealand1550.5842280.788023-77
155Paraguay1443.3790000.686812-89
1399Phillipines1544.0021970.757864-84
2786Poland1540.9020000.69976234
5616Portugal1436.6802000.70128419
2834Romania1406.8312990.680549-11
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30