Groupby sum, count the number based on condition and concatenate in pandas : <p>I have a dataframe as shown below</p>

<pre><code>Sector Property_ID  Unit_ID  Unit_usage   Property_Usage  Rent_Unit_Status  Unit_Area
SE1    1            1        Shop         Commercial      Rented            200
SE1    1            2        Resid        Commercial      Rented            200
SE1    1            3        Shop         Commercial      Vacant            100
SE1    2            1        Shop         Residential     Vacant            200
SE1    2            2        Apartment    Residential     Rented            100
SE2    1            1        Resid        Commercial      Rented            400
SE2    1            2        Shop         Commercial      Vacant            100
SE2    2            1        Apartment    Residential     Vacant            500
</code></pre>

<p>From the above dataframe I would like to prepare below dataframe.</p>

<pre><code>Sector  No_of_Properties  No_of_Units  Total_area  %_Vacant   %_Rented  %_Shop  %_Apartment
SE1     2                 5            800         37.5       62.5      62.5    12.5
SE2     2                 3            1000        60         40        10      50
</code></pre>
