Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
You need to show the list of all country names available in the TopUni.csv file in the order that they appear in the file. Each country name should be displayed only once without repetition. The names should be in upper case. Country names are separated by a comma and a space after it. The output should be as follows: Available countries => COUNTRY1, COUNTRY2, COUNTRY3, where COUNTRY1, COUNTRY2, COUNTRY3, should be replaced by the list of all country names. If the printed list of countries end with a comma and a space, that is fine. The following is an example output: E output.txt Available countries => USA, UNITED KINGDOM, JAPAN, FRANCE, CANADA, SWITZERLAND,

You need to show the list of all country names available in the TopUni.csv file in the order that they appear in the file. Each country name should be displayed only once without repetition. The names should be in upper case. Country names are separated by a comma and a space after it. The output should be as follows: Available countries => COUNTRY1, COUNTRY2, COUNTRY3, where COUNTRY1, COUNTRY2, COUNTRY3, should be replaced by the list of all country names. If the printed list of countries end with a comma and a space, that is fine. The following is an example output: E output.txt Available countries => USA, UNITED KINGDOM, JAPAN, FRANCE, CANADA, SWITZERLAND,

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

hi there, i am struggling with creating a script that will read through a CSV file and print the country names without repeating a given name like the pictured example. ill share my code below but i am unsure if i need to create a list of how to spilt the so that only names will generate to print ex - country1, country2, country3, etc 

 


with open('TopUni.csv', 'r') as csv_file:
csvReader = csv.reader(csv_file)
COUNTRYLIST = []
line = fileOne.readline()
while line != "":
countryName = line.rstrip()
line = fileOne.readline()
population = str(line)
print(line)

line = fileOne.readline()

 

с Country USA Massachusetts Institute of Technolog USA USA 1 Institution name 2 Harvard University 3 4 Stanford University 5 University of Cambridge 6 University of Oxford 7 Princeton University 8 Columbia University University of Chicago 9 10 University of Pennsylvania 11 Yale University 12 California Institute of Technology United Kingd United Kingd USA USA USA USA USA USA USA Japan USA USA USA USA University of California/ Los Angeles USA 13 University of California/ Berkeley University of Tokyo 14 15 Cornell University 16 University of Michigan/Ann Arbor 17 Johns Hopkins University 18 Northwestern University 19 20 University College London 21 Duke University PSL University 22 France 23 University of Illinois at Urbanaâ€"Cha USA 24 University of Washington - Seattle USA Canada 25 University of Toronto 26 University of Wisconsinâ€"Madison 27 New York University 28 McGill University 29 Kyoto University 30 ETH Zurich 31 Imperial College London 32 Seoul National University 33 34 35 36 Karolinska Institute 37 Sorbonne University Paris-Saclay University University of Texas at Austin University of California/ San Diego United Kingd USA USA USA Canada Japan Switzerland United Kingd South Korea France USA USA Sweden France Denmark 38 University of Copenhagen 39 University of California/ San Francisco USA 40 University of North Carolina at Chape USA National Rank D 1 2 3 1 5769SANI 2 4 8 10 2 11 12 13 14 15 3 16 1 17 18 1 19 20 2 1 1 4 1 2 21 22 1 3 1 23 24
Transcribed Image Text:с Country USA Massachusetts Institute of Technolog USA USA 1 Institution name 2 Harvard University 3 4 Stanford University 5 University of Cambridge 6 University of Oxford 7 Princeton University 8 Columbia University University of Chicago 9 10 University of Pennsylvania 11 Yale University 12 California Institute of Technology United Kingd United Kingd USA USA USA USA USA USA USA Japan USA USA USA USA University of California/ Los Angeles USA 13 University of California/ Berkeley University of Tokyo 14 15 Cornell University 16 University of Michigan/Ann Arbor 17 Johns Hopkins University 18 Northwestern University 19 20 University College London 21 Duke University PSL University 22 France 23 University of Illinois at Urbanaâ€"Cha USA 24 University of Washington - Seattle USA Canada 25 University of Toronto 26 University of Wisconsinâ€"Madison 27 New York University 28 McGill University 29 Kyoto University 30 ETH Zurich 31 Imperial College London 32 Seoul National University 33 34 35 36 Karolinska Institute 37 Sorbonne University Paris-Saclay University University of Texas at Austin University of California/ San Diego United Kingd USA USA USA Canada Japan Switzerland United Kingd South Korea France USA USA Sweden France Denmark 38 University of Copenhagen 39 University of California/ San Francisco USA 40 University of North Carolina at Chape USA National Rank D 1 2 3 1 5769SANI 2 4 8 10 2 11 12 13 14 15 3 16 1 17 18 1 19 20 2 1 1 4 1 2 21 22 1 3 1 23 24
Available countries You need to show the list of all country names available in the TopUni.csv file in the order that they appear in the file. Each country name should be displayed only once without repetition. The names should be in upper case. Country names are separated by a comma and a space after it. The output should be as follows: Available countries => COUNTRY1, COUNTRY2, COUNTRY3, where COUNTRY1, COUNTRY2, COUNTRY3, should be replaced by the list of all country names. If the printed list of countries end with a comma and a space, is fine. that The following is an example output: output.txt Available countries => USA, UNITED KINGDOM, JAPAN, FRANCE, CANADA, SWITZERLAND, SI
Transcribed Image Text:Available countries You need to show the list of all country names available in the TopUni.csv file in the order that they appear in the file. Each country name should be displayed only once without repetition. The names should be in upper case. Country names are separated by a comma and a space after it. The output should be as follows: Available countries => COUNTRY1, COUNTRY2, COUNTRY3, where COUNTRY1, COUNTRY2, COUNTRY3, should be replaced by the list of all country names. If the printed list of countries end with a comma and a space, is fine. that The following is an example output: output.txt Available countries => USA, UNITED KINGDOM, JAPAN, FRANCE, CANADA, SWITZERLAND, SI
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
File Input and Output Operations
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
  • SEE MORE 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