Calculating utilization rates of storage units

Calculating utilization rates of storage units

Python Data Structures External Dataset

Forward this email to a friend or colleague and challenge them to solve it.

Hi,

Suppose you're analyzing the utilization of a small storage facility. Customers can rent out a unit on a monthly or annual basis. Monthly customers can end their rental at the end of each month, and annual customers can end their rental at the end of each year.

You have the following dataset, which shows each unit's monthly revenue and the type of rental contract. If a unit is not currently rented revenue will be 0 and there will be no customer_id.

Using all of this information, calculate the total revenue per unit and the utilization of each unit. Utilization can be calculated by taking the months the unit is in use and dividing by all months recorded. The resulting output should look like the example table below:

unit_num	total_revenue	pct_utilization
1	XXX	YYY
2	ZZZ	WWW
...	...	...

To help get you started, below is code (Python) to import the referenced datasets:

        # Import libraries
        
import pandas as pd
        
import numpy as np
        
# Import data
        
df = pd.read_csv('https://raw.githubusercontent.com/erood/interviewqs.com_code_snippets/master/Datasets/storage_unit_revenue.csv')

Our solution will be written using Python for premium users.

You’ve accumulated 376 questions since joining our email list. Create a premium account to access detailed solutions to each problem (including this one) + our new Case studies.

Was this email forwarded to you? You can join our list here to receive questions