Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Hi there I am having trouble with creating a function called 'getInformation(selectedCountry)' for a CSV file with Universitas rankings data that will show both the national rank and the name of the university that has the highest national rank within the inputted selected country/rank.  I am not sure how to format the function before or after I open the CSV for reading? When a user types a rank number#  the University with that rank should display but im not sure how to proceed.   The expected output should look like this At international rank => 31 the University name is => SOUEL NATIONAL UNIVERSITY    Def getInformation(selectedCountry)   With open('TopUni.csv','r')as csv_file: csvReader=csv.reader(csv_file)

Hi there I am having trouble with creating a function called 'getInformation(selectedCountry)' for a CSV file with Universitas rankings data that will show both the national rank and the name of the university that has the highest national rank within the inputted selected country/rank.  I am not sure how to format the function before or after I open the CSV for reading? When a user types a rank number#  the University with that rank should display but im not sure how to proceed.   The expected output should look like this At international rank => 31 the University name is => SOUEL NATIONAL UNIVERSITY    Def getInformation(selectedCountry)   With open('TopUni.csv','r')as csv_file: csvReader=csv.reader(csv_file)

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 having trouble with creating a function called 'getInformation(selectedCountry)' for a CSV file with Universitas rankings data that will show both the national rank and the name of the university that has the highest national rank within the inputted selected country/rank.  I am not sure how to format the function before or after I open the CSV for reading? When a user types a rank number#  the University with that rank should display but im not sure how to proceed.

 

The expected output should look like this

At international rank => 31 the University name is => SOUEL NATIONAL UNIVERSITY 

 

Def getInformation(selectedCountry)

 

With open('TopUni.csv','r')as csv_file:

csvReader=csv.reader(csv_file)

с 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
The following requirements requires the user to specify a country name to display the corresponding information. We will refer to this country as the term Selected Country The university with top international rank You need to show the world rank and the name of the university that has the highest international rank within the selected country. This means that you need to check the international rank of all unversities in the selected country and show the required information. The output should be as follows At international rank => $$$ the university name is => UNIVERSITY where $$$ should be replaced by the international rank number, and UNIVERSITY should be replaced by the university name. The following is an example
Transcribed Image Text:The following requirements requires the user to specify a country name to display the corresponding information. We will refer to this country as the term Selected Country The university with top international rank You need to show the world rank and the name of the university that has the highest international rank within the selected country. This means that you need to check the international rank of all unversities in the selected country and show the required information. The output should be as follows At international rank => $$$ the university name is => UNIVERSITY where $$$ should be replaced by the international rank number, and UNIVERSITY should be replaced by the university name. The following is an example
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