Question: Need in the code Python using OLAP (Online analytical processing) Generate Data Cube Assume the data cube will be generated out of two nominal attributes

Need in the code Python using OLAP (Online analytical processing)

Need in the code Python using OLAP (Online analytical processing) Generate Data

Generate Data Cube Assume the data cube will be generated out of two nominal attributes and one numeric attribute. Complete the following class definition. The class must have following methods and more as needed. The input will be a data set from which the cube will be generated. The input data will be stored in a dataframe object. In (5) class dataCube: #class variables #_init_o alhost:8888/lab 1/3 3/2021 C2_1 #generate() #slice() #dice #rollup) #dril Down pass #delete this line In [ ]: Generate the data cube out of {a1, a11, a12). The data cube object must hold and process the count-aggregations for nominal attributes and sum-aggregations for numeric attributes. Hint: Review the lecture slides about conceptual structure of a data cube. In [2): #dc - dataCube(...) Print the data cube in the following form. a12 H M TOTAL M TOTAL a12 COUNT H Y a11 N SUM Y a11 N U U TOTAL TOTAL In 1): Perform a slicing operation and print the resulting sub-cube. In (): Perform a dicing operation and print the resulting sub-cube. In ): Perform a roll-up operation and print the aggregation result. In : Perform a drill-down operation and print the aggregation result. In 1: Generate Data Cube Assume the data cube will be generated out of two nominal attributes and one numeric attribute. Complete the following class definition. The class must have following methods and more as needed. The input will be a data set from which the cube will be generated. The input data will be stored in a dataframe object. In (5) class dataCube: #class variables #_init_o alhost:8888/lab 1/3 3/2021 C2_1 #generate() #slice() #dice #rollup) #dril Down pass #delete this line In [ ]: Generate the data cube out of {a1, a11, a12). The data cube object must hold and process the count-aggregations for nominal attributes and sum-aggregations for numeric attributes. Hint: Review the lecture slides about conceptual structure of a data cube. In [2): #dc - dataCube(...) Print the data cube in the following form. a12 H M TOTAL M TOTAL a12 COUNT H Y a11 N SUM Y a11 N U U TOTAL TOTAL In 1): Perform a slicing operation and print the resulting sub-cube. In (): Perform a dicing operation and print the resulting sub-cube. In ): Perform a roll-up operation and print the aggregation result. In : Perform a drill-down operation and print the aggregation result. In 1

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 Databases Questions!