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,

EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter8: Arrays
Section: Chapter Questions
Problem 9PE
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
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SEE MORE TEXTBOOKS