You are working for a consultancy and receive data on gross domestic product (GDP) and foreing direct investment (FDI) for selected countries Antigua and Barbuda GDP: 2042.43 (millions of US dollars), FDI: 104.33 (millions of US dollars) Commonwealth of The Bahamas GDP: 15133.72 (millions of US dollars), FDI: 359.58 (millions of US dollars) • Barbados GDP: 4397.69 (millions of US dollars), FDI: 238.74 (millions of US dollars) • Belize GDP: 3830.7 (millions US dollars), FDI: 130.05 (millions US dollars) Commonwealth of Dominica GDP: 862.93 (millions of US dollars), FDI: 43.98 (millions of US dollars) ● ● ● • Dominican Republic GDP: 204713.4 (millions of US dollars), FDI: 3255 (millions of US dollars) • Grenada GDP: 2123.23 (millions of US dollars), FDI: 144.23 (millions of US dollars) Co-operative Republic of Guyana GDP: 13966.48 (millions US dollars), FDI: 1161.68 (millions US dollars) Republic of Haiti GDP: 33255.19 (millions of US dollars), FDI: 51.3 (millions of US dollars) • Jamaica GDP: 27603.96 (millions of US dollars), FDI: 320.48 (millions of US dollars) • Federation of Saint Christopher and Nevis GDP: 1258.61 (millions of US dollars), FDI: 40.01 (millions of US dollars) • Saint Lucia GDP: 2775.43 (millions of US dollars), FDI: 46.72 (millions of US dollars) • Saint Vincent and the Grenadines GDP: 1302.59 (millions of US dollars), FDI: 65.3 (millions of US dollars) Given this information, you are asked to perform the following tasks: 1. Create a Python list named Caribean with the name of the countries, the GDP, and the FDI. 2. Create a PANDAS Datrafame named Caribean_df with three columns (Countries, GDP, and FDI). 3. Create a new column in the DataFrame named 'FDI_Share' with the FDI as a proportion (share) of the GDP. 4. Create a new column called 'FDI_intensity' with 0 if the country has the FDI share below the average and 1 otherwise. Now, you have received extra information about the Republic of Cuba, the Republic of Suriname, and the Republic of Trinidad and Tobago: Republic of Cuba GDP: 138453.38 (millions of US dollars), FDI: 0 (millions of US dollars) Republic of Suriname GDP: 9712.75 (millions of US dollars), FDI: -174.71 (millions of US dollars) Republic of Trinidad and Tobago GDP: 39935.75 (millions of US dollars), FDI: -777.58 (millions of US dollars), ● ● ● ● ●

You are working for a consultancy and receive data on gross domestic product (GDP) and foreing direct investment (FDI) for selected countries Antigua and Barbuda GDP: 2042.43 (millions of US dollars), FDI: 104.33 (millions of US dollars) Commonwealth of The Bahamas GDP: 15133.72 (millions of US dollars), FDI: 359.58 (millions of US dollars) • Barbados GDP: 4397.69 (millions of US dollars), FDI: 238.74 (millions of US dollars) • Belize GDP: 3830.7 (millions US dollars), FDI: 130.05 (millions US dollars) Commonwealth of Dominica GDP: 862.93 (millions of US dollars), FDI: 43.98 (millions of US dollars) ● ● ● • Dominican Republic GDP: 204713.4 (millions of US dollars), FDI: 3255 (millions of US dollars) • Grenada GDP: 2123.23 (millions of US dollars), FDI: 144.23 (millions of US dollars) Co-operative Republic of Guyana GDP: 13966.48 (millions US dollars), FDI: 1161.68 (millions US dollars) Republic of Haiti GDP: 33255.19 (millions of US dollars), FDI: 51.3 (millions of US dollars) • Jamaica GDP: 27603.96 (millions of US dollars), FDI: 320.48 (millions of US dollars) • Federation of Saint Christopher and Nevis GDP: 1258.61 (millions of US dollars), FDI: 40.01 (millions of US dollars) • Saint Lucia GDP: 2775.43 (millions of US dollars), FDI: 46.72 (millions of US dollars) • Saint Vincent and the Grenadines GDP: 1302.59 (millions of US dollars), FDI: 65.3 (millions of US dollars) Given this information, you are asked to perform the following tasks: 1. Create a Python list named Caribean with the name of the countries, the GDP, and the FDI. 2. Create a PANDAS Datrafame named Caribean_df with three columns (Countries, GDP, and FDI). 3. Create a new column in the DataFrame named 'FDI_Share' with the FDI as a proportion (share) of the GDP. 4. Create a new column called 'FDI_intensity' with 0 if the country has the FDI share below the average and 1 otherwise. Now, you have received extra information about the Republic of Cuba, the Republic of Suriname, and the Republic of Trinidad and Tobago: Republic of Cuba GDP: 138453.38 (millions of US dollars), FDI: 0 (millions of US dollars) Republic of Suriname GDP: 9712.75 (millions of US dollars), FDI: -174.71 (millions of US dollars) Republic of Trinidad and Tobago GDP: 39935.75 (millions of US dollars), FDI: -777.58 (millions of US dollars), ● ● ● ● ●

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter1: An Introduction To Information Systems

Section: Chapter Questions

Problem 2PSE

See similar textbooks