šŸ·ļø LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION ā†’
Log in
Computer Science
3
answers
0
watching
291
views

the data in a data warehouse have which of the following characteristics?

  1. are organized by subject
  2. are coded in different formats
  3. are updated in real-time
  4. are constantly purged as new data come in.
  5. are organized in a hierarchical structure.

Watch
3
answers
0
watching
291
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share
Already have an account? Log in
Share
Bunny Greenfelder
Bunny GreenfelderLv2
19 Feb 2020
Already have an account? Log in
Share

Related questions


Covid_Data = [["age bracket",["BC","AB","SK"]],
[(12,17),[[212286,303122],[200521,315968],[51128,87621]]],
[(18,29),[[576245,816781],[412013,695111],[100170,181751]]],
[(30,39),[[561039,740505],[459399,715542],[106941,172421]]],
[(40,49),[[514551,649358],[437833,608434],[102214,143466]]]]

le that contains a list of lists, to which the variable Covid_Data refers, which contains
information about vaccination numbers, by age bracket, in some provinces. 1 The rst item in Covid_Data
is a list whose rst item is a string "age bracket" , and whose second item is a list of the names of several
provinces. The other items in Covid_Data are lists whose rst item is a tuple denoting an age bracket and
whose second item is a list of lists. Each of these sublists correspond to data from a province and the rst
item is the number of people fully vaccinated and the second item is the population of that province in the
givien age group.
Just copy/paste this list of lists to your program. But keep in mind that your code should work even if we
use a dierent starting list (representing a dierent set of provinces, though with the same format) to test
your program.
Determine percentage of people fully vaccinated in an age range for
each given province .
To do this you will need to write a function called prov_percent_vaccinated_in_age_range, which takes
the list of lists described above as the rst parameter, and the name of a particular province, given as a
string (ie. "BC"), as the second parameter, the lower and upper bounds on an age range are the third and
fourth parameters. This function should return the percent fully vaccinated in the given age range in the
given province.
To do this you may nd the list method .index() useful to determine the index of of the data corresponding
to a province. Note that L.index("Prov") will be 2 if "Prov" is the 3th item in list L. For example, in the
sample data, the index of "SK" in the list Covid_Data[0][1] is 2. To limit the number of decimal places
returned use the function round(). For example, If x = 3.567, then round(x,1) returns 3.6.
Next create a function percent_vaccinated_in_age_range which takes the list of lists described above as its
rst parameter, the lower and upper bounds of an age range as its other two parameters. This function rst
prints out a line indicating the age range, then it should call the function prov_percent_vaccinated_in_age_range
and for each province represented in the data prints out a line indicating the percent fully vaccinated in
that province.

For example: Write a function called add_vaccinated_in_age_bracket that takes the list of lists (described above) as its
rst parameter and modies it. The second parameter is the name of a province given as a string, the third
parameter is an age bracket ( given as a tuple), and the nal parameter is a number to add to the number
of fully vaccinated people in the given age bracket for the given province.
This change should be done by modifying the input list itself. No new lists should be created and this
function has no return value.
Assume that recently, in "SK", there has been a vaccination blitz in high schools. This has added 10000 to
the number of fully vaccinated in the age bracket from 12 to 17.
Print "–- After High School Vaccination Blitz –-".
In the main program, call the function add_vaccinated_in_age_bracket to record the results of this vaccination
blitz. Finally call percent_vaccinated_in_age_range again for the age range 12 to 2


Objective: Take a sample feed, parse it, augment it, and output individual JSON objects for each product in it.

product.txt

  • The file contains several fields of basic product information for 1000 products.
  • Data for each product is on one line, with fields separated by a vertical pipe character.

This particular retailer classifies products into a particular store, department, category, and subcategory.

Example >

  • A Blender might have the following "taxonomy" or category classification.

Home & Garden > Kitchen & Dining > Appliances > Blenders

Store

Department

Category

Subcategory

store_id

department_id

category_id

subcategory_id

Ā 

These IDs are also represented in a sort of shorthand.

  • They should all be prefixed by the first three letters of their respective field name.

A store_id of 1 becomes sto1

A department_id of 2 becomes dep2

A category_id of 3 becomes cat3

A subcategory_id of 4 becomes sub4

targets.txt

  • A system to keep track of these various classifications
    • Example
      • A store_id of sto40 maps to a ā€œtarget valueā€ of 187298 in PromoteIQ's system

Output Example:

The desired output for the first product is one line of JSON that when pretty-printed looks like:

{

Ā  "sku": "22067130",

Ā  "name": "Brainboxes ES-571 Brainboxes Es-571 Industrial Isolated Ethernet to Serial + Switch - 1 x Network (R",

Ā  "description": "Brainboxes ES-571 Brand New Includes Lifetime Warranty Product # ES-571 Factory floors can be harsh environments.",

Ā  "priceList": 387.95,

Ā  "taxonomy": [

Ā Ā Ā  "sto2",

Ā Ā Ā  "dep7",

Ā Ā Ā  "cat270",

Ā Ā Ā  "sub18532"

Ā  ],

Ā  "targetValues": [

Ā Ā Ā  187167,

Ā Ā Ā  187177,

Ā Ā Ā  187950,

Ā Ā Ā  196404

Ā  ]

}

Ā 

The taxonomy IDs have been mapped to their long form and placed in the taxonomy property.

  • Each taxonomy ID has also been mapped to its corresponding target value ID from the targets.txt file
    • and that result is stored in the targetValues
    • The priceList property is the product price as a JSON float, not a string

7. Write a class MetroLine in which you define a new type MetroLine (10 points) A MetroLine is defined to have the following private properties: ā€¢ A String representing the colour of the line (e.g. blue, red, green, etc. No numbers. It's Montreal, not Manhattan!) ā€¢ A collection of MetroStation This collection can be either a built in array, an ArrayList, or any other kind of collection you feel would satisfy the requirements of the class. The collection must be able to define an ordering from "beginning" to "end" of the MetroLine. It does not matter which part you consider the beginning and which part is the "end" as long as it is consistent. (We recommend using ArrayList but you are free to do otherwise if you feel it will be casier.) A MetroLine should have the following methods defined: ā€¢ A constructor which takes nothing as input and performs any initialization necessary to maintain your collection of stations. ā€¢ A method addstation which takes as input a MetroStation and adds it to the end of your collection. The method can assume the station is not already part of the collection and should return void. Note that the order the MetroStations are added is the same as the path the trains will travel on (or it could be the reverse path as well). ā€¢ A method hasStation which takes as input a MetroStation and returns a boolean representing whether the metro line has a MetroStation with the same name or not. A method get LineColour which returns the colour of the line. ā€¢ A method get First Stop which returns the MetroStation representing the first stop of the metro line. If there is no such station (ic, if the collection of MetroStation is empty), your method should return null. ā€¢ A method get PriorStop which takes as input a MetroStation and returns the stop prior to the MetroStation passed as input. You may assume that the MetroStation passed as input is indeed in the collection of MetroStations If the current station is the first stop on the MetroLine then this method should return null. You may assume that there are no "loops" in the MetroLine That is, no station is present on the same line twice. A method getNext Stop which takes as input a MetroStation and returns the stop after the MetroStation passed as input. You may assume that the Metrostation passed as input is indeed in the collection of Metrostations. If the current station is the last stop on the MetroLine, then this method should return null. You may assume that there are no "loops" in the MetroLine That is, no station is present on the same line twice. For the above methods, you may assume that there is no aliasing issue. That is to say, you can use == to compare the references, or if you are using a type such as ArrayList to maintain your list of stations, you can use the indexOf or contains method defined on an ArrayList.

Weekly leaderboard

Home
Homework Help 3,900,000
Computer Science 2,000
Start filling in the gaps now
Log in