Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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), ● ● ● ● ●

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
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), 5. Add the extra information in your DataFrame (You do not have to compute the FDI share for the new countries). ●
Transcribed Image Text: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), 5. Add the extra information in your DataFrame (You do not have to compute the FDI share for the new countries). ●
Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Business to Business
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS