DAT490 - Assignment 1
Question 1
Clean data and create a new csv file with relevant entries
0
Afghanistan
2065.036235
1
Africa Eastern and Southern
3568.597017
2
Africa Western and Central
4142.398382
3
Albania
13671.48842
4
Algeria
11510.55709
5
Angola
6670.331458
6
Antigua and Barbuda
21548.72501
7
Arab World
14599.70789
8
Argentina
22063.90437
9
Armenia
13653.76338
0
Afghanistan
64.833
1
Africa Eastern and Southern
64.00519747
2
Africa Western and Central
58.11572272
3
Albania
78.573
4
Algeria
76.88
5
Angola
61.147
6
Antigua and Barbuda
77.016
7
Arab World
71.98970937
8
Argentina
76.667
9
Armenia
75.087
0
Afghanistan
2065.036235
1
Africa Eastern and Southern
3568.597017
2
Africa Western and Central
4142.398382
3
Albania
13671.48842
4
Algeria
11510.55709
5
Angola
6670.331458
6
Antigua and Barbuda
21548.72501
7
Arab World
14599.70789
8
Argentina
22063.90437
9
Armenia
13653.76338
0
0
Afghanistan
1
3
Albania
2
4
Algeria
3
5
Angola
4
6
Antigua and Barbuda
5
8
Argentina
6
9
Armenia
7
10
Australia
8
11
Austria
9
12
Azerbaijan
a)
b)
c)
d)
Australia
Austria
Belgium
Bermuda
Canada
Chile
Costa Rica
Cyprus
Denmark
Finland
France
Germany
Greece
Hong Kong
Iceland
Ireland
Israel
Italy
Japan
Luxembourg
Macao
Malta
Netherlands
New Zealand
Norway
Portugal
Qatar
Singapore
Slovenia
South Korea
Spain
Sweden
Switzerland
United Kingdom
e)
Albania
Algeria
Antigua and Barbuda
Argentina
Armenia
Azerbaijan
Barbados
Belarus
Belize
Bosnia and Herzegovina
Brazil
Cape Verde
China
Colombia
Costa Rica
Ecuador
El Salvador
Georgia
Guatemala
Honduras
Iran
Jamaica
Lebanon
Libya
Mexico
Montenegro
Morocco
Nicaragua
North Macedonia
Palestine
Paraguay
Peru
Saint Lucia
Samoa
Serbia
Solomon Islands
Sri Lanka
Thailand
Tunisia
Vietnam
Dominican Republic
Jordan
Maldives
f)
g)
0
154
202
1
70
94
Question 2
Clean data and create a new csv file
0
Afghanistan
2.694
1
Albania
5.004
2
Algeria
5.043
3
Argentina
5.793
4
Armenia
5.062
5
Australia
7.177
6
Austria
7.396
7
Azerbaijan
5.168
8
Bangladesh
4.499
9
Belarus
5.234
0
Afghanistan
16
1
Albania
36
2
Algeria
35
3
Angola
19
4
Argentina
40
5
Armenia
35
6
Australia
77
7
Austria
76
8
Azerbaijan
25
9
Bahamas
65
0
Afghanistan
2.694
1
Albania
5.004
2
Algeria
5.043
3
Argentina
5.793
4
Armenia
5.062
5
Australia
7.177
6
Austria
7.396
7
Azerbaijan
5.168
8
Bangladesh
4.499
9
Belarus
5.234