New answers tagged parameters
The excel parameter's datatype would be 'File', with a filter of "xls;xlsx" as per @crmackey comment. The sheet parameter's datatype would be 'String'. There is no automatic behavior for populating the 'sheets' into a combobox/choice list from the 'File'. This is something you'll need to do yourself. Fortunately this has been done, you could just copy the ...
You can use data type "table view".
To get the median of the POP_RANK you should use a searchCursor and use list comprehension. The list can then be fed to method that determines the median. I got the method here Edit: You have created confusion by creating two versions of the cities layer in your code. I have removed the country_layer and instead only use the cities layer, since that is ...
Top 50 recent answers are included