given the table below as an input: in python
calculate the total amount used per category
in both macro and micro by multiplying the amount used times the
frequency. Some information is not given in the macro or micro
columns, which is marked as -9999,99.
for example: Car category = ( Gas macro would be12,9 x 5 )
+ (tires 18 x 4 ) + .....
- Given The Table Below As An Input In Python Calculate The Total Amount Used Per Category In Both Macro And Micro By Mul 1 (125.19 KiB) Viewed 44 times
Category Sub-category Amount Used (macro) Amount Used (micro) Frequency as factor Frequency (text) Cars Gas 12,9 -9999,99 5 year Cars Tires 18 -9999,99 4 year Cars Seatbelts 50 -9999,99 5 year Cars Seats 50 0,87408312 9 year . Cars Windows 50 -9999,99 8 year Cars Wheel -9999,99 7,48 1 year Cars Driver 227 -9999,99 4 year Cars Fabric 36 -9999,99 12 year Bike Seat 1740 -9999,99 1 year Bike Wheels 140,9 -9999,99 1 year Bike Bell 54,88 -9999,99 1 year Bike Lights 1300 -9999,99 1 year