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 O if the country has the FDI share below the average and 1 otherwise.
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 O if the country has the FDI share below the average and 1 otherwise.
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
Related questions
Question
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.
●
●
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education