Question: Use the file transactions.csv. (Download the file here.) Write a function called getCountries() that takes 0 arguments. The function should open the transactions file and

Use the file transactions.csv. (Download the file here.) Write a function called getCountries() that takes 0 arguments. The function should open the transactions file and determine all of the unique countries in that file. i.e. There should not be any repeated countries. Your function should return a list of the countries. The list should be sorted.

Have exception handling code in case the file cold not be found. That is, catch a FileNotFoundError. If this exception is generated, your function should simply print an error to the screen (e.g. "Unable to open the file.") and then terminate. Remember that only the relevant code should be placed inside the try block. That is, do not place too much code unrelated to the part you are worried about inside a given try block.

Here is what your code should look like when it is executed:

>>> print(getCountries())

['Australia', 'Belgium', 'Canada', 'Denmark', 'Finland', 'France', 'India', 'Ireland', 'Israel', 'Italy', 'Luxembourg', 'Netherlands', 'Norway', 'South Africa', 'Sweden', 'Switzerland', 'United Kingdom', 'United States']

the file :

1/2/2009 6:17 Product1 1200 Mastercard carolina Basildon England United Kingdom 1/2/2009 6:00 1/2/2009 6:08 51.5 -1.11667 (Accepted cards: Visa//Amex//Discover//MC)
1/2/2009 4:53 Product1 1200 Visa Betina Parkville MO United States 1/2/2009 4:42 1/2/2009 7:49 39.195 -94.6819 (Accepted cards: Visa//Amex//)
1/2/2009 13:08 Product1 1200 Mastercard Federica e Andrea Astoria OR United States 1/1/2009 16:21 1/3/2009 12:32 46.18806 -123.83 (Accepted cards: Visa//Amex//MC)
1/3/2009 14:44 Product1 1200 Visa Gouya Echuca Victoria Australia 9/25/2005 21:13 1/3/2009 14:22 -36.1333 144.75 (Accepted cards: Visa//Amex//)
1/4/2009 12:56 Product2 3600 Visa Gerd W Cahaba Heights AL United States 11/15/2008 15:47 1/4/2009 12:45 33.52056 -86.8025 (Accepted cards: Visa//Amex//Discover//Amex)
1/4/2009 13:19 Product1 1200 Visa LAURENCE Mickleton NJ United States 9/24/2008 15:19 1/4/2009 13:04 39.79 -75.2381 (No Mastercard No Visa Yes Amex)
1/4/2009 20:11 Product1 1200 Mastercard Fleur Peoria IL United States 1/3/2009 9:38 1/4/2009 19:45 40.69361 -89.5889
1/2/2009 20:09 Product1 1200 Mastercard adam Martin TN United States 1/2/2009 17:43 1/4/2009 20:01 36.34333 -88.8503
1/4/2009 13:17 Product1 1200 Mastercard Renee Elisabeth Tel Aviv Tel Aviv Israel 1/4/2009 13:03 1/4/2009 22:10 32.06667 34.76667
1/4/2009 14:11 Product1 1200 Visa Aidan Chatou Ile-de-France France 6/3/2008 4:22 1/5/2009 1:17 48.88333 2.15
1/5/2009 2:42 Product1 1200 Diners Stacy New York NY United States 1/5/2009 2:23 1/5/2009 4:59 40.71417 -74.0064
1/5/2009 5:39 Product1 1200 Amex Heidi Eindhoven Noord-Brabant Netherlands 1/5/2009 4:55 1/5/2009 8:15 51.45 5.466667
1/2/2009 9:16 Product1 1200 Mastercard Sean Shavano Park TX United States 1/2/2009 8:32 1/5/2009 9:05 29.42389 -98.4933
1/5/2009 10:08 Product1 1200 Visa Georgia Eagle ID United States 11/11/2008 15:53 1/5/2009 10:05 43.69556 -116.353
1/2/2009 14:18 Product1 1200 Visa Richard Riverside NJ United States 12/9/2008 12:07 1/5/2009 11:01 40.03222 -74.9578
1/4/2009 1:05 Product1 1200 Diners Leanne Julianstown Meath Ireland 1/4/2009 0:00 1/5/2009 13:36 53.67722 -6.31917
1/5/2009 11:37 Product1 1200 Visa Janet Ottawa Ontario Canada 1/5/2009 9:35 1/5/2009 19:24 45.41667 -75.7
1/6/2009 5:02 Product1 1200 Diners barbara Hyderabad Andhra Pradesh India 1/6/2009 2:41 1/6/2009 7:52 17.38333 78.46667
1/6/2009 7:45 Product2 3600 Visa Sabine London England United Kingdom 1/6/2009 7:00 1/6/2009 9:17 51.52721 0.14559
1/2/2009 7:35 Product1 1200 Diners Hani Salt Lake City UT United States 12/30/2008 5:44 1/6/2009 10:52 40.76083 -111.89
1/6/2009 12:56 Product1 1200 Visa Jeremy Manchester England United Kingdom 1/6/2009 10:58 1/6/2009 13:31 53.5 -2.21667
1/1/2009 11:05 Product1 1200 Diners Janis Ballynora Cork Ireland 12/10/2007 12:37 1/7/2009 1:52 51.86306 -8.58
1/5/2009 4:10 Product1 1200 Mastercard Nicola Roodepoort Gauteng South Africa 1/5/2009 2:33 1/7/2009 5:13 -26.1667 27.86667
1/6/2009 7:18 Product1 1200 Visa asuman Chula Vista CA United States 1/6/2009 7:07 1/7/2009 7:08 32.64 -117.083
1/2/2009 1:11 Product1 1200 Mastercard Lena Kuopio Ita-Suomen Laani Finland 12/31/2008 2:48 1/7/2009 10:20 62.9 27.68333
1/1/2009 2:24 Product1 1200 Visa Lisa Sugar Land TX United States 1/1/2009 1:56 1/7/2009 10:52 29.61944 -95.6347
1/7/2009 8:08 Product1 1200 Diners Bryan Kerrene New York NY United States 1/7/2009 7:39 1/7/2009 12:38 40.71417 -74.0064
1/2/2009 2:57 Product1 1200 Visa chris London England United Kingdom 1/3/2008 7:23 1/7/2009 13:14 51.52721 0.14559
1/1/2009 20:21 Product1 1200 Visa Maxine Morton IL United States 10/24/2008 6:48 1/7/2009 20:49 40.61278 -89.4592
1/8/2009 0:42 Product1 1200 Visa Family Los Gatos CA United States 1/8/2009 0:28 1/8/2009 3:39 37.22667 -121.974
1/8/2009 3:56 Product1 1200 Mastercard Katherine New York NY United States 1/8/2009 3:33 1/8/2009 6:19 40.71417 -74.0064
1/8/2009 3:16 Product1 1200 Mastercard Linda Miami FL United States 1/8/2009 3:06 1/8/2009 6:34 25.77389 -80.1939
1/8/2009 1:59 Product1 1200 Mastercard SYLVIA Vesenaz Geneve Switzerland 11/28/2007 11:56 1/8/2009 7:20 46.23333 6.2
1/3/2009 9:03 Product1 1200 Diners Sheila Brooklyn NY United States 1/3/2009 8:47 1/8/2009 10:38 40.65 -73.95
1/5/2009 13:17 Product1 1200 Mastercard Stephanie Badhoevedorp Noord-Holland Netherlands 1/5/2009 12:45 1/8/2009 11:45 52.33333 4.783333
1/6/2009 7:46 Product1 1200 Amex Kelly Reston VA United States 1/6/2009 7:30 1/8/2009 12:40 38.96861 -77.3414
1/5/2009 20:00 Product2 3600 Visa James Burpengary Queensland Australia 12/10/2008 19:53 1/8/2009 17:58 -27.1667 152.95
1/8/2009 16:24 Product1 1200 Visa jennifer Phoenix AZ United States 1/8/2009 15:57 1/8/2009 18:30 33.44833 -112.073
1/9/2009 6:39 Product1 1200 Mastercard Anneli Houston TX United States 1/9/2009 5:09 1/9/2009 7:11 29.76306 -95.3631
1/6/2009 22:19 Product2 3600 Amex Ritz Pittsfield VT United States 1/6/2009 12:00 1/9/2009 10:05 43.77222 -72.8133
1/6/2009 23:00 Product2 3600 Amex Sylvia Pittsfield VT United States 1/6/2009 12:00 1/9/2009 10:05 43.77222 -72.8133
1/7/2009 7:44 Product1 1200 Mastercard Marie Ball Ground GA United States 1/7/2009 5:35 1/9/2009 10:52 34.33806 -84.3767
1/3/2009 13:24 Product1 1200 Visa Mehmet Fatih Helsingor Frederiksborg Denmark 1/3/2009 12:47 1/9/2009 11:14 56.03333 12.61667
1/7/2009 15:12 Product2 3600 Visa Anabela Flossmoor IL United States 1/5/2009 19:55 1/9/2009 16:03 41.54278 -87.6847
1/7/2009 20:15 Product1 1200 Amex Nicole Houston TX United States 1/7/2009 17:17 1/9/2009 20:02 29.76306 -95.3631
1/3/2009 10:11 Product2 3600 Visa Christiane Delray Beach FL United States 1/3/2009 9:27 1/10/2009 9:46 26.46111 -80.0731
1/9/2009 15:58 Product1 1200 Mastercard Sari Newbury England United Kingdom 1/9/2009 14:53 1/10/2009 13:16 51.4 -1.31667
1/3/2009 13:11 Product1 1200 Mastercard simone Kobenhavn Kobenhavn Denmark 10/31/2008 0:31 1/10/2009 13:24 55.66667 12.58333
1/10/2009 12:57 Product1 1200 Amex Vanessa Sandy Springs GA United States 2/7/2007 20:16 1/10/2009 14:09 33.92417 -84.3786
1/10/2009 14:43 Product1 1200 Diners Anupam Kinsaley Dublin Ireland 1/9/2009 11:38 1/10/2009 14:37 53.42472 -6.17583
1/10/2009 12:05 Product1 1200 Visa Karina Fort Lauderdale FL United States 7/1/2008 12:53 1/10/2009 16:33 26.12194 -80.1436
1/6/2009 1:20 Product1 1200 Mastercard Frank Melbourne Victoria Australia 1/2/2009 17:51 1/10/2009 18:27 -37.8167 144.9667
1/10/2009 14:56 Product1 1200 Visa Angela Ankeny IA United States 1/8/2009 3:06 1/10/2009 19:41 41.72972 -93.6056
1/7/2009 10:01 Product1 1200 Visa Darren Pittsboro NC United States 1/7/2009 9:04 1/10/2009 20:02 35.72 -79.1775
1/1/2009 1:26 Product1 1200 Mastercard Nikki New Rochelle NY United States 1/1/2009 0:58 1/10/2009 21:31 40.91139 -73.7828
1/11/2009 2:04 Product1 1200 Visa chris Gold Coast Queensland Australia 1/11/2009 0:33 1/11/2009 2:11 -28 153.4333
1/11/2009 14:17 Product1 1200 Visa Stephanie Brussels Brussels (Bruxelles) Belgium 1/11/2009 13:39 1/11/2009 13:39 50.83333 4.333333
1/10/2009 21:38 Product1 1200 Visa Anushka Maple Ridge District Municipality British Columbia Canada 1/10/2009 21:17 1/11/2009 19:32 49.25 -122.5
1/7/2009 6:18 Product1 1200 Mastercard June Beachwood OH United States 2/23/2006 11:56 1/11/2009 19:35 41.46444 -81.5089
1/4/2009 8:39 Product2 3600 Diners Baybars Prince Albert Saskatchewan Canada 1/3/2009 17:17 1/11/2009 21:05 53.2 -105.75
1/5/2009 0:31 Product1 1200 Mastercard Bonnie Saltsjobaden Stockholm Sweden 1/4/2009 23:45 1/12/2009 0:37 59.28333 18.3
1/2/2009 6:07 Product1 1200 Visa Cindy Kemble England United Kingdom 12/30/2008 10:21 1/12/2009 2:24 51.67667 -2.01806
1/12/2009 3:25 Product1 1200 Mastercard chrissy W Lebanon NH United States 1/12/2009 3:12 1/12/2009 3:22 43.64917 -72.3108
1/4/2009 13:56 Product1 1200 Mastercard Tamar Headley England United Kingdom 11/29/2007 9:23 1/12/2009 5:38 51.11667 -0.81667
1/7/2009 0:12 Product2 3600 Mastercard Deirdre Lausanne Vaud Switzerland 12/1/2008 6:25 1/12/2009 6:55 46.53333 6.666667
1/12/2009 5:18 Product1 1200 Mastercard Bernadett Southampton England United Kingdom 1/12/2009 4:45 1/12/2009 8:08 50.9 -1.4
1/8/2009 15:16 Product1 1200 Visa Dottie Woodsboro MD United States 1/8/2009 14:56 1/12/2009 9:29 39.53306 -77.315
1/11/2009 11:33 Product1 1200 Visa Stefan Stavanger Rogaland Norway 1/11/2009 9:02 1/12/2009 10:37 58.96667 5.75
1/7/2009 20:22 Product1 1200 Visa Gina Red Deer Alberta Canada 11/23/2008 19:30 1/12/2009 12:24 52.26667 -113.8
1/2/2009 22:00 Product1 1200 Diners Lynne Memphis TN United States 1/2/2009 21:04 1/12/2009 13:18 35.14944 -90.0489
1/5/2009 13:52 Product1 1200 Mastercard Tammy Morges Vaud Switzerland 1/5/2009 5:55 1/12/2009 14:04 46.51667 6.5
1/8/2009 20:32 Product1 1200 Visa Kim Calgary Alberta Canada 1/8/2009 20:21 1/12/2009 14:07 51.08333 -114.083
1/8/2009 13:34 Product1 1200 Visa Bruce Belleville Ontario Canada 1/6/2009 14:38 1/12/2009 18:31 44.16667 -77.3833
1/11/2009 13:08 Product1 1200 Visa Rosa Maria Cincinnati OH United States 1/11/2009 12:38 1/12/2009 18:44 39.16194 -84.4569
1/12/2009 19:04 Product1 1200 Visa Lydia Comox British Columbia Canada 9/20/2008 20:53 1/12/2009 19:01 49.68333 -124.933
1/12/2009 13:41 Product1 1200 Visa Eric Gasperich Luxembourg Luxembourg 1/12/2009 13:16 1/13/2009 1:03 49.58556 6.123056
1/11/2009 10:38 Product1 1200 Mastercard AnaPaula Helens Bay Northern Ireland United Kingdom 9/4/2008 9:26 1/13/2009 2:36 54.65 -5.73333
1/13/2009 5:57 Product1 1200 Visa Robin Milan Lombardy Italy 10/15/2008 5:31 1/13/2009 5:55 45.46667 9.2
1/13/2009 6:13 Product1 1200 Visa Gitte Staten Island NY United States 1/13/2009 5:17 1/13/2009 7:33 40.63667 -74.1592
1/8/2009 13:14 Product1 1200 Visa Dr. Claudia Oslo Oslo Norway 1/8/2009 12:47 1/13/2009 10:49 59.91667 10.75

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

#Problem 1: #Use the file transactions.csv. (Download the file here.) Write thefunction called getCountries() that takes 0 arguments. #The function should open the transactions file and determine all...

Q:

Python 1 Use the states.csv file for the next 4 questions. Write a function called TotalPopulation that takes the 2D list of states as an argument and returns the total the population for all states....

Q:

Python code, Python code, Python code. Overview Pokemon are fantastic creatures that people can catch and train. Pokemon are classified into different 'types such as grass, fire or electric. To catch...

Q:

For this assignment you will construct a single python file called a4.py, with several text-processing functions. You are free to use your own solutions to these problems as building blocks for your...

Q:

code in python3 pls For this assignment you will construct a single python file called a4.py, with several text-processing functions. You are free to use your own solutions to these problems as...

Q:

Overview Pokemon are fantastic creatures that people can catch and train. Pokemon are classified into different 'types such as grass, fire or electric. To catch different types of pokemon, you might...

Q:

COMPUTER SCIENCE PROBLEM PYTHON Instructions: For this assignment, you will construct a single python file called a4.py, with several text-processing functions. You are free to use your own solutions...

Q:

Part 1: A Penny for a Gum Ball Mickey (40 pts) xperiment in selling gum balls, but we are going to make a few assumptions. Assume that you are selling gum balls from a vending machine. The machine is...

Q:

Python Codes, thank you:) In this question, you will use information from Statistics Canada to analyse percentage changes of Canada national population grouped by ages from year 2013 to year 2017. On...

Q:

"Population estimates on July 1st by age and sex" 1 2 3 4 Annual Table: 17-10-0005-01 (formerly CANSIM 051-0001) Geography: Canada, Province or territory Canada Both sexes Age group 2013 2014 2015...

Q:

The cost to issue new debt is 3% and new equity is 7%. The company is considering projects totalling $100 million next year and they wish to maintain a D/E ratio of 1. Internal funds of $50 million...

Q:

There is discussion among the board about our dividend strategy, although we're looking at what competitors are doing first. Looking at Baldwin, their current stock price is $56.59 per share. If this...

Q:

If the beta of a stock is greater than one, then _ Choose the statement that is most accurate. The slock has higher systematic risk relatbe to the everall shock narlet The stock has lower firm...

Q:

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.