Df1

docx

School

Birla Institute of Technology, Mesra *

*We aren’t endorsed by this school

Course

1234

Subject

Accounting

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by UltraCrown1625

Df1: AgreementNumber_ops Prob_ops prob_bucket_ops paid_flag_ops risk_segment_ops S_AMT_ops Repayment_ops DPD_bucket_ops risk_priority_ops calls_count_ops total_call_duration_ops mean_call_duration_ops median_call_duration_ops total_call_picked_ops total_call_responsive_ops call_picked_%_ops call_response_%_ops call_picked_flag_ops 0 DMI0017307001 NaN -1.0 0.0 no_risk NaN 0.0 120+ high_priority NaN NaN NaN NaN NaN NaN NaN NaN 0.0 1 DMI0021216128 NaN -1.0 0.0 no_risk NaN 0.0 120+ high_priority NaN NaN NaN NaN NaN NaN NaN NaN 0.0 Df2: company_id allocation_month loan_id transaction_id prob risk_segment_num risk_segment risk_priority created 0 3304d574-ba2c-49ce-a8d0-43ce2c83a381 2023-7-01 DMI0000941147 None -1.0 -1 no_risk medium_priority 2023-07-11 21:31:31 1 3304d574-ba2c-49ce-a8d0-43ce2c83a381 2023-7-01 DMI0001312611 None -1.0 -1 no_risk medium_priority 2023-07-11 21:31:31 df_final=pd.merge(df2,df1,how='inner',left_on='loan_id',right_on ='AgreementNumber_ops') NOw I am merging the above df1 and df2 but the shape I am getting is zero i am not able to merge using loan_id of d2 and AgreementNumber_ops of df1 The dytpe of both are object 2 / 2 Based on the information provided, it appears that you are attempting to merge two DataFrames, df1 and df2 , using the loan_id column from df2 and the AgreementNumber_ops column from df1 . However, you mentioned that the resulting merged DataFrame, df_final , has a shape of zero, indicating that no rows were matched during the merge operation. One possible reason for this issue could be the difference in the values between the loan_id and AgreementNumber_ops columns. Since the dtype of both columns is 'object', it's essential to ensure that the values in these columns are identical or have a common format for successful merging. To investigate further, you can check if there are any leading or trailing whitespaces, formatting differences, or case sensitivity variations in the values of the loan_id and AgreementNumber_ops columns. These differences can prevent the merge operation from finding matching rows. You can use the strip() function to remove leading and trailing whitespaces from string values.

Here's an example that demonstrates how to strip the whitespaces from the columns before merging: pythonCopy code df2[ 'loan_id' ] = df2[ 'loan_id' ]. str .strip() df1[ 'AgreementNumber_ops' ] = df1[ 'AgreementNumber_ops' ]. str .strip() df_final = pd.merge(df2, df1, how= 'inner' , left_on= 'loan_id' , right_on= 'AgreementNumber_ops' ) By stripping the whitespaces from both columns before the merge, you can improve the chances of finding matching rows. If there are other formatting differences or inconsistencies, you may need to preprocess the data further to align the values properly. Remember to ensure that the values in both columns are indeed the same or compatible for a successful merge. You Units Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total (kWh) Total (kWh/bed) Emission(kWh) Total Emissions (TCO2e) Total Emissions (kgCO2e/bed) kWh 6,807 7,113 6,531 6,066 5,123 5,144 5,162 5,787 7,410 7,223 6,849 69,213 1,236 0.19338 13384.49 239.01 kWh 1,899 1,840 1,806 1,629 1,616 1,717 4,036 2,834 5,263 5,728 5,648 4,498 38,514 313 0.19338 7447.80 60.55 kWh 1,975 1,668 1,838 1,796 1,841 1,606 1,646 1,584 2,383 3,651 3,480 3,403 26,871 572 0.19338 5196.28 110.56 kWh -111 1,195 1,204 989 1,004 923 910 857 902 1,195 1,399 1,255 11,722 586 0.19338 2266.86 113.34 kWh 13,627 12,869 14,341 13,629 14,633 14,314 15,126 14,672 11,745 16,261 17,107 16,991 1,75,312 1,037 0.19338 33901.91 200.60 kWh 2,023 1,982 2,239 2,040 2,014 1,757 1,839 1,819 1,730 1,965 2,316 2,244 23,966 773 0.19338 4634.47 149.50 kWh 40,047 33,991 33,079 29,472 26,288 21,483 20,842 22,489 19,785 28,939 32,686 33,276 3,42,377 4,389 0.19338 66208.88 848.83 kWh 3,953 3,571 3,908 3,638 3,686 3,296 3,255 3,033 2,125 3,535 3,471 3,128 40,598 1,015 0.19338 7850.88 196.27 kWh 10,032 9,182 10,268 9,836 9,738 8,760 8,867 8,327 7,598 11,017 12,391 13,887 1,19,903 1,131 0.19338 23186.78 218.74 kWh 16,943 14,192 14,866 11,528 9,988 6,521 6,563 6,292 6,407 12,993 22,128 25,217 1,53,636 1,995 0.19338 29710.17 385.85 kWh 45,497 42,716 38,007 32,160 27,804 15,590 14,529 13,848 18,033 40,801 53,143 57,697 3,99,824 2,173 0.19338 77317.95 420.21 kWh 8,684 7,902 8,356 7,475 7,190 7,108 7,048 6,506 7,134 7,594 8,214 8,052 91,261 1,086 0.19338 17648.11 210.10 kWh 35,351

30,964 29,275 24,060 22,802 15,623 14,726 14,344 13,774 23,940 31,371 37,085 2,93,313 3,492 0.19338 56720.79 675.25 kWh 7,093 6,482 6,829 6,480 6,957 6,390 6,678 6,302 6,128 7,768 8,001 7,985 83,093 1,052 0.19338 16068.58 203.40 kWh 26,904 23,223 23,454 21,957 19,324 11,469 9,785 9,575 12,246 21,171 26,634 27,743 2,33,484 2,955 0.19338 45151.19 571.53 kWh 1,310 1,446 1,473 1,089 963 916 925 911 1,010 1,255 1,433 1,469 14,201 302 0.19338 2746.17 58.43 kWh 6,029 4,936 5,278 4,945 4,826 4,282 4,158 2,804 2,968 4,827 5,231 5,221 55,503 1,088 0.19338 10733.23 210.46 kWh 8,532 9,616 7,651 6,691 6,653 6,538 6,560 6,287 7,283 10,298 10,629 9,972 96,710 1,443 0.19338 18701.70 279.13 kWh 30,089 24,916 24,648 20,787 17,391 10,621 10,538 10,851 11,573 19,613 29,585 31,193 2,41,801 2,779 0.19338 46759.52 537.47 kWh 31,862 30,070 30,523 29,066 29,821 28,625 29,155 26,812 28,477 40,994 42,142 44,192 3,91,738 1,248 0.19338 75754.35 241.26 kWh 13,542 25,321 21,247 18,277 21,167 14,827 12,731 12,558 11,926 20,162 27,135 40,452 2,39,344 2,196 0.19338 46284.28 424.63 kWh 36,521 31,211 28,229 23,079 19,645 12,611 11,077 11,710 19,195 27,814 39,482 44,106 3,04,678 1,835 0.19338 58918.67 354.93 kWh 6,985 6,355 6,722 6,012 5,783 5,717 5,670 5,232 5,737 6,097 6,607 6,476 73,392 834 0.19338 14192.54 161.28 kWh 976 10,043 10,262 10,560 9,277 8,732 7,906 7,904 15,265 7,133 10,788 12,122 1,10,968 1,563 0.19338 21459.01 302.24 kWh 28,733 23,789 21,129 15,904 14,143 7,332 7,153 7,365 10,456 15,628 28,790 28,767 2,09,188 1,395 0.19338 40452.85 269.69 kWh 8,465 7,348 7,643 7,089 7,211 6,130 6,010 4,984 5,642 7,474 8,678 7,911 84,585 2,820 0.19338 16357.09 545.24 kWh 9,227 9,447 10,673 9,066 10,562 8,900 8,398 7,000 9,772 12,525 12,391 11,541 1,19,501 1,683 0.19338 23109.10 325.48 kWh 16,903 14,627 15,806 14,775 15,598 13,058 12,508 11,816 12,812 16,491 18,445 17,556 1,80,396 2,957 0.19338 34884.88 571.88 kWh 29,309 26,052 26,214 21,825 20,735 10,256 8,582 7,711 10,687 19,520 28,747 28,236 2,37,873 2,332 0.19338 45999.92 450.98 kWh 36,817 31,894 31,044 19,967 16,675 8,404 6,561 6,081 10,298 17,754 28,864 23,367 2,37,726 1,251 0.19338 45971.43 241.95 kWh 10,000 9,526 11,296 11,912 12,104 11,663 10,771 10,695 10,351 12,314 12,608 12,866 1,36,105 1,944 0.19338 26319.89 376.00 kWh 14,630 13,177 13,421 10,347 8,359 7,105 7,182 6,875 9,666 12,989 13,716 13,697 1,31,163 1,474 0.19338 25364.30 284.99 kWh 50,989 51,954 46,381 43,838 37,192 20,285 19,180 19,534 25,779 38,855 45,390 55,649 4,55,027 4,418 0.19338 87993.18 854.30 kWh 57,923 54,300 46,568 43,122 36,439 21,825 19,861 21,690

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

27,480 47,022 60,690 68,837 5,05,756 2,841 0.19338 97803.15 549.46 kWh 9,009 8,635 8,512 6,970 7,326 6,277 6,719 7,507 6,983 9,154 10,461 10,594 98,146 846 0.19338 18979.55 163.62 kWh 15,673 13,780 14,108 13,167 12,135 8,537 8,112 7,982 9,152 11,625 13,721 15,720 1,43,711 1,466 0.19338 27790.85 283.58 kWh 61,876 54,004 49,996 39,687 32,750 17,636 15,398 16,417 16,509 30,669 42,321 48,043 4,25,304 2,376 0.19338 82245.36 459.47 kWh 19,888 9,123 9,969 9,097 8,744 7,323 7,328 7,529 7,357 8,941 9,763 10,330 1,15,391 3,846 0.19338 22314.33 743.81 kWh 11,931 10,311 9,481 7,628 6,518 5,048 4,255 4,335 5,301 8,442 10,714 11,771 95,737 1,243 0.19338 18513.54 240.44 kWh 29,629 24,272 20,087 16,912 15,462 9,743 8,125 8,252 8,732 14,426 20,864 23,229 1,99,732 1,997 0.19338 38624.21 386.24 kWh 44,821 37,213 31,430 26,630 22,828 10,893 8,725 8,415 11,602 24,213 36,795 44,110 3,07,675 2,772 0.19338 59498.17 536.02 kWh 33,178 25,447 21,290 16,418 15,758 9,741 9,851 10,233 14,949 26,089 39,708 46,996 2,69,659 2,123 0.19338 52146.56 410.60 kWh 7,420 6,967 8,593 7,726 7,687 7,156 6,821 6,829 8,396 12,333 12,613 11,970 1,04,511 1,230 0.19338 20210.38 237.77 kWh 1,345 305 1,200 910 849 823 824 816 907 1,038 1,198 1,236 11,449 716 0.19338 2214.01 138.38 kWh 41,266 34,370 34,530 27,113 22,837 12,004 11,713 13,943 14,327 27,842 39,674 44,442 3,24,061 2,946 0.19338 62666.84 569.70 kWh 25,592 24,059 25,248 20,722 20,172 15,685 15,350 13,006 14,297 18,806 23,024 25,042 2,41,001 1,385 0.19338 46604.73 267.84 kWh 43,033 36,696 35,233 30,693 28,612 19,616 17,521 17,920 14,701 15,908 26,854 34,121 3,20,908 5,439 0.19338 62057.13 1051.82 kWh 18,812 19,093 15,366 17,411 18,725 12,278 10,477 9,139 10,412 14,955 18,736 24,949 1,90,352 6,345 0.19338 36810.17 1227.01 kWh 12,585 10,454 11,514 9,720 10,533 9,631 9,549 9,665 8,741 11,570 11,902 12,360 1,28,222 741 0.19338 24795.59 143.33 kWh 11,774 10,816 12,559 11,665 12,510 10,972 10,041 9,337 6,974 8,463 8,534 8,172 1,21,817 1,138 0.19338 23556.89 220.16 kWh 4,994 5,429 5,544 4,202 2,575 2,497 2,502 2,477 2,752 -11,200 5,534 5,710 33,015 1,942 0.19338 6384.48 375.56 kWh 23,594 20,506 21,185 22,242 26,899 21,381 24,393 22,219 23,197 25,182 30,150 35,929 2,96,877 4,639 0.19338 57410.09 897.03 kWh 13,673 12,079 10,472 7,705 7,280 7,020 4,042 3,982 4,711 7,873 8,807 12,953 1,00,595 2,012 0.19338 19453.02 389.06 kWh 11,198 8,012 -8,339 9,757 8,347 13,629 5,879 5,877 5,955 5,263 7,921 8,718 82,217 2,936 0.19338 15899.03 567.82 kWh 9,915 8,186 9,563 8,167 7,407 4,601 4,299 4,136 4,214 9,065 13,442 15,833 98,827 1,335 0.19338 19111.09 258.26 kWh

26,473 22,740 20,800 16,817 14,433 9,715 8,404 7,603 9,229 15,745 21,732 24,577 1,98,268 1,349 0.19338 38340.97 260.82 kWh 53,564 44,788 44,492 37,577 35,358 15,741 13,298 16,024 15,578 28,750 37,436 43,945 3,86,549 3,944 0.19338 74750.86 762.76 kWh 2,820 3,112 -13,380 1,390 1,313 1,268 1,272 1,254 1,399 1,589 1,777 1,822 5,635 297 0.19338 1089.68 57.35 kWh 41,917 36,475 35,814 28,070 24,318 11,337 9,173 9,342 9,731 20,529 29,722 32,750 2,89,177 2,472 0.19338 55921.07 477.96 kWh 51,742 44,908 41,972 39,346 36,845 18,228 16,479 14,993 18,596 41,190 54,164 62,011 4,40,474 5,063 0.19338 85178.82 979.07 kWh 11,206 11,149 12,744 10,258 10,674 10,332 7,688 9,008 10,301 9,546 13,815 14,674 1,31,394 1,476 0.19338 25408.88 285.49 kWh 35,562 29,227 25,641 23,852 20,815 11,918 9,176 9,665 11,029 22,014 29,906 35,240 2,64,043 3,106 0.19338 51060.64 600.71 kWh 17,808 13,970 14,487 12,833 12,305 7,274 6,143 6,274 7,225 12,656 18,153 16,716 1,45,843 1,894 0.19338 28203.12 366.27 kWh 24,232 19,091 19,578 18,708 17,931 12,542 12,239 11,552 12,307 18,619 24,889 26,016 2,17,704 2,221 0.19338 42099.52 429.59 kWh 19,108 17,837 20,641 20,202 21,954 20,906 21,001 20,315 20,816 26,474 26,262 25,608 2,61,123 1,612 0.19338 50496.04 311.70 kWh 1,285 1,418 1,439 1,106 290 283 287 289 313 355 405 407 7,877 179 0.19338 1523.27 34.62 kWh 67,081 59,507 55,189 45,090 43,097 22,254 18,452 18,018 18,680 36,825 56,371 64,673 5,05,237 2,088 0.19338 97702.79 403.73 kWh 51,856 43,895 39,951 31,311 28,870 14,573 13,365 12,619 14,965 29,330 45,323 42,035 3,68,093 4,435 0.19338 71181.77 857.61 kWh 7,796 6,979 8,349 8,038 8,501 7,839 7,408 6,714 7,133 11,189 11,690 11,955 1,03,593 773 0.19338 20032.72 149.50 kWh 49,955 41,796 40,792 37,196 31,528 15,408 14,120 14,727 13,368 28,239 46,821 57,593 3,91,543 3,659 0.19338 75716.60 707.63 kWh 27,660 24,479 25,650 22,995 17,159 7,357 6,820 7,103 6,426 12,092 16,931 20,360 1,95,032 3,096 0.19338 37715.33 598.66 kWh 51,410 46,428 42,220 41,149 35,408 20,636 20,215 21,044 18,254 32,759 48,621 53,108 4,31,252 2,493 0.19338 83395.53 482.06 kWh 7,486 6,117 5,259 4,424 4,109 2,635 3,207 3,091 4,570 8,787 11,344 12,028 73,058 1,588 0.19338 14127.86 307.13 kWh 39,865 50,774 43,157 39,578 29,849 8,138 10,612 16,124 27,413 39,183 51,174 49,630 4,05,496 1,740 0.19338 78414.86 336.54 kWh 28,945 23,437 22,444 19,341 17,791 10,148 9,756 10,087 12,498 18,126 24,079 24,963 2,21,615 1,847 0.19338 42855.81 357.13 kWh 7,079 6,796 8,275 7,723 8,156 7,502 7,618 6,371 7,110 9,339 9,355 9,205 94,527 1,313 0.19338 18279.67 253.88 kWh 9,062 13,531

9,759 4,658 16,177 9,415 8,588 8,946 9,784 9,937 10,898 8,756 1,19,511 1,707 0.19338 23110.96 330.16 kWh 63,669 57,591 54,941 49,573 41,267 39,515 43,238 39,873 34,514 56,994 63,849 68,217 6,13,241 2,787 0.19338 118588.47 539.04 kWh 32,295 27,442 24,860 21,942 17,201 9,939 8,962 8,610 8,154 16,988 22,789 25,729 2,24,911 2,122 0.19338 43493.23 410.31 kWh 40,315 33,824 31,391 26,970 25,905 12,542 11,676 12,028 10,475 24,928 38,940 44,383 3,13,376 2,725 0.19338 60600.57 526.96 kWh 34,417 30,575 28,636 27,777 26,698 15,332 16,663 14,238 15,000 24,568 32,209 34,018 3,00,129 5,359 0.2 60025.77 1071.89 kWh 1,00,802 95,406 94,446 77,434 25,570 25,570 35,865 41,201 43,417 69,178 81,789 88,976 7,79,653 6,339 0.2 155930.63 1267.73 kWh 7,813 12,677 6,316 6,803 4,967 2,463 1,842 1,975 2,722 6,774 11,074 12,872 78,299 1,666 0.2 15659.75 333.19 kWh 8,847 7,336 7,735 5,389 3,286 1,003 696 837 1,412 4,571 6,995 9,089 57,195 2,860 0.2 11439.10 571.95 kWh 76,845 66,700 64,926 57,048 48,948 26,641 25,889 27,193 22,764 43,328 60,430 65,795 5,86,507 3,470 0.2 117301.48 694.09 kWh 8,314 10,262 5,984 5,010 4,945 1,549 1,449 1,484 11,093 4,762 10,057 14,760 79,668 2,570 0.2 15933.66 513.99 kWh 19,264 16,600 17,309 14,474 10,525 4,548 3,302 4,251 3,462 5,981 14,863 13,740 1,28,318 3,208 0.2 25663.52 641.59 kWh 41,229 33,775 32,694 28,715 24,551 10,377 9,615 12,300 12,996 33,563 51,497 61,704 3,53,014 3,330 0.2 70602.86 666.06 kWh 14,999 14,202 16,297 13,894 13,779 11,670 11,016 16,961 10,067 13,973 14,385 16,025 1,67,268 2,172 0.2 33453.53 434.46 kWh 20,147 18,272 20,305 17,555 17,667 14,044 13,050 12,771 15,824 22,532 24,423 24,902 2,21,493 1,204 0.2 44298.65 240.75 kWh 13,245 17,254 14,118 12,881 10,681 9,397 8,705 9,485 10,217 14,968 17,678 16,688 1,55,315 1,849 0.2 31062.95 369.80 kWh 5,512 6,143 528 528 528 5,00,000 528 528 2,611 2,722 3,245 4,874 5,27,747 6,680 0.2 105549.38 1336.07 kWh 2,156 2,086 2,007 1,331 733 197 120 111 266 859 1,561 2,014 13,440 286 0.2 2688.06 57.19 kWh 31,133 31,123 31,049 23,376 4,174 4,174 5,681 5,733 8,816 26,109 21,083 24,385 2,16,838 4,252 0.2 43367.55 850.34 kWh 24,501 17,259 24,948 20,549 18,120 8,695 7,383 7,607 8,402 17,685 22,277 26,173 2,03,599 3,039 0.2 40719.85 607.76 kWh 30,847 21,593 23,087 20,738 19,825 11,582 9,976 10,463 10,452 17,328 23,918 25,506 2,25,316 2,590 0.2 45063.12 517.97 kWh 2,24,717 1,66,957 1,68,092 1,07,653 94,961 54,639 45,424 52,405 53,916 90,740 1,18,810 1,29,606 13,07,922 4,165 0.2 261584.32 833.07 kWh 18,348 17,000 18,248 17,262 16,152 14,149 12,936 13,385 21,651 32,245 28,286 29,566 2,39,227

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1,441 0.2 47845.33 288.22 kWh 34,832 30,508 29,382 26,758 24,738 16,607 16,013 17,917 20,853 31,942 36,166 39,319 3,25,035 3,694 0.2 65007.06 738.72 kWh 16,741 18,318 20,135 18,315 18,733 16,809 15,275 14,350 16,490 20,009 18,348 16,210 2,09,733 1,398 0.2 41946.56 279.64 kWh 34,500 32,835 31,504 25,340 19,301 9,999 9,390 8,927 9,668 16,488 24,103 29,938 2,51,992 8,400 0.2 50398.46 1679.95 kWh 53,499 41,878 41,766 31,452 22,252 10,367 7,649 7,710 11,852 22,569 34,294 41,253 3,26,540 5,353 0.2 65307.99 1070.62 kWh 12,647 15,836 15,946 13,472 13,988 11,994 10,749 10,879 12,536 16,533 17,030 16,321 1,67,930 1,646 0.2 33585.98 329.27 kWh 34,500 32,547 38,375 36,518 38,056 27,310 22,643 19,572 37,562 43,339 44,451 39,117 4,13,989 2,179 0.2 82797.82 435.78 kWh 50,081 42,109 44,078 37,930 31,874 17,472 14,682 15,856 19,113 35,892 41,104 50,590 4,00,781 5,725 0.2 80156.18 1145.09 kWh 50,575 44,864 37,119 29,758 26,596 17,222 14,145 13,928 19,733 33,356 44,790 56,492 3,88,578 4,366 0.2 77715.61 873.21 kWh 38,219 27,897 32,645 35,010 18,058 20,526 25,208 23,568 24,101 32,525 33,821 33,293 3,44,872 3,348 0.2 68974.44 669.65 kWh 3,852 3,592 4,023 3,980 4,061 3,609 3,310 3,189 3,237 4,148 4,425 4,502 45,927 258 0.2 9185.36 51.60 kWh 50,200 44,167 45,299 40,615 35,761 22,368 18,588 24,821 21,154 31,702 47,107 47,035 4,28,818 3,697 0.2 85763.58 739.34 kWh 22,373 19,165 19,957 18,060 17,581 13,685 12,842 12,947 14,646 17,508 19,315 19,233 2,07,313 2,115 0.2 41462.61 423.09 kWh 32,945 31,980 31,902 24,027 17,000 7,915 5,839 5,888 9,055 17,234 26,199 31,500 2,41,484 1,349 0.2 48296.81 269.81 kWh 22,770 10,143 9,752 6,475 3,546 943 599 561 1,287 4,157 7,594 9,778 77,605 776 0.2 15521.04 155.21 kWh 29,008 6,776 6,776 6,776 15,611 11,724 10,048 9,389 10,164 17,086 19,338 19,896 1,62,591 1,465 0.2 32518.15 292.96 kWh 28,231 29,484 28,334 18,821 10,293 2,737 1,745 1,614 3,746 12,082 22,089 28,428 1,87,605 1,477 0.2 37521.01 295.44 kWh 55,705 48,938 54,776 44,916 36,585 21,634 18,544 18,733 23,429 34,879 46,941 52,732 4,57,814 5,386 0.2 91562.74 1077.21 kWh 10,977 11,904 11,868 8,936 6,324 2,945 2,169 2,193 3,371 6,409 9,753 11,719 88,567 805 0.2 17713.41 161.03 kWh 26,451 24,197 28,374 24,521 25,451 24,275 18,159 19,778 19,966 25,996 28,152 28,427 2,93,747 1,688 0.2 58749.40 337.64 kWh 86,809 80,316 79,449 63,069 62,189 24,112 29,858 36,672 26,666 63,772 76,205 91,647 7,20,764 11,262 0.2 144152.76 2252.39 kWh 14,051 13,643 13,603 10,248 7,250 3,374 2,488 2,515 3,860 7,348 11,171 13,433 1,02,983 2,060 0.2 20596.63 411.93 kWh 21,109 15,562 14,651 9,989

7,554 2,852 2,952 4,255 5,236 10,617 14,929 20,302 1,30,007 4,643 0.2 26001.49 928.62 kWh 5,746 8,864 4,982 5,135 2,812 12,985 5,995 5,770 4,654 8,797 10,573 10,378 86,690 1,171 0.2 17338.08 234.30 kWh 22,817 22,144 22,098 16,646 11,767 5,469 4,036 4,069 6,273 11,931 18,149 21,823 1,67,222 1,706 0.2 33444.34 341.27 kWh 16,026 13,935 12,004 10,259 9,429 5,703 5,723 5,927 5,046 7,606 13,169 16,500 1,21,327 6,386 0.2 24265.31 1277.12 kWh 19,078 17,895 18,130 16,768 18,655 13,917 10,326 11,799 10,762 16,842 17,874 16,443 1,88,490 1,611 0.2 37697.96 322.20 kWh 81,488 83,452 78,516 70,307 60,167 31,992 28,764 33,852 30,495 61,396 74,814 83,366 7,18,609 8,074 0.2 143721.83 1614.85 kWh 12,533 11,618 12,583 12,317 12,264 9,889 10,454 11,522 11,870 12,871 15,596 17,577 1,51,094 1,778 0.2 30218.78 355.52 kWh 46,253 21,837 21,778 2,159 2,159 2,159 2,159 2,159 2,159 10,858 11,097 9,331 1,34,105 1,742 0.2 26821.05 348.33 kWh 10,878 9,955 10,889 9,617 10,265 7,782 6,686 7,137 7,480 13,020 12,799 11,183 1,17,692 1,201 0.2 23538.36 240.19 kWh 1,02,332 87,532 86,230 66,746 68,394 10,027 6,402 76,245 31,360 61,209 87,942 96,562 7,80,981 4,821 0.2 156196.17 964.17 kWh 13,431 12,656 12,114 11,317 9,685 4,566 3,336 3,391 3,998 10,250 12,814 15,410 1,12,968 2,567 0.2 22593.64 513.49 kWh 24,865 23,421 26,788 24,403 27,910 21,206 18,592 18,407 18,771 29,010 29,780 28,508 2,91,660 1,205 0.2 58331.98 241.04 kWh 10,835 11,766 16,353 12,307 8,238 9,344 8,361 8,311 9,934 14,634 14,761 12,551 1,37,397 1,655 0.2 27479.35 331.08 kWh 38,462 10,765 27,299 26,640 26,685 27,842 28,341 28,659 25,883 36,091 36,282 36,615 3,49,564 2,021 0.2 69912.88 404.12 kWh 45,892 36,409 34,191 32,882 39,542 44,403 34,164 22,626 30,642 36,252 40,991 33,089 4,31,084 1,850 0.2 86216.82 370.03 kWh 26,007 24,200 26,111 26,159 21,512 16,953 18,450 18,152 22,007 27,082 27,175 27,032 2,80,839 2,340 0.2 56167.84 468.07 kWh 67,214 58,509 59,450 51,808 31,635 10,620 11,210 9,609 10,201 44,790 51,313 54,752 4,61,111 6,404 0.2 92222.14 1280.86 kWh 67,114 79,636 70,859 47,710 28,654 9,001 28,024 5,739 11,131 32,951 57,892 74,145 5,12,856 7,327 0.2 102571.12 1465.30 kWh 33,917 50,507 8,023 31,066 33,906 39,665 36,850 37,978 31,612 27,413 30,217 31,751 3,92,906 1,786 0.2 78581.21 357.19 kWh 18,299 17,216 18,829 17,526 17,455 12,955 12,842 12,788 13,321 19,662 21,256 19,690 2,01,840 1,904 0.2 40368.03 380.83 kWh 17,651 16,053 17,016 16,855 14,586 12,134 12,431 12,129 9,349 12,527 15,069 14,722 1,70,522 1,483 0.2 34104.36 296.56 Questions - Please ensure you show all calculations Q1. If you had to give an award to the

most efficient site in the country per bed, who would you choose and why? Q2. List the regions in order of energy effciency from worst to best. Please display this using a chart of your choice Q3. What do you think affects the energy consumption of a student accommodation building? Why? Q4. What contribution is each region making to the total energy consumption (%)? Q5. Which is the best performing site in terms of carbon? And the worst? Q6. What changes would you recommend for a site that has shown interest in becoming more energy efficient? 2 / 2 To calculate the total energy consumption and emissions per bed, we need to sum up the values for each month and then calculate the averages. Total energy consumption (kWh) per bed: Jan-21: 6,807 Feb-21: 7,113 Mar-21: 6,531 Apr-21: 6,066 May-21: 5,123 Jun-21: 5,144 Jul-21: 5,162 Aug-21: 5,787 Sep-21: 7,410 Oct-21: 7,223 Nov-21: 6,849 Dec-21: 69,213 Sum: 69,213 kWh Total energy consumption per bed: 69,213 kWh Total emissions (TCO2e) per bed: Total emissions (TCO2e) = Total energy consumption (kWh) * Emission factor (kgCO2e/kWh) Emission factor: 0.19338 kgCO2e/kWh Total emissions (TCO2e) per bed = 69,213 kWh * 0.19338 kgCO2e/kWh = 13,384.49 kgCO2e Average emissions (kgCO2e/bed) = Total emissions (TCO2e) per bed / 12 = 13,384.49 kgCO2e / 12 = 1,115.37 kgCO2e/bed Please note that the values provided are the totals for the given months and may not represent the complete annual values. You Questions - Please ensure you show all calculations Q1. If you had to give an award to the most efficient site in the country per bed,

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

who would you choose and why? Q2. List the regions in order of energy effciency from worst to best. Please display this using a chart of your choice Q3. What do you think affects the energy consumption of a student accommodation building? Why? Q4. What contribution is each region making to the total energy consumption (%)? Q5. Which is the best performing site in terms of carbon? And the worst? Q6. What changes would you recommend for a site that has shown interest in becoming more energy efficient? Using below data : Site Name Region Beds Utility Units Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Total (kWh) Total (kWh/bed) Emission(kWh) Total Emissions (TCO2e) Total Emissions (kgCO2e/bed) Site 1 Scotland 56 Electricity kWh 6,807 7,113 6,531 6,066 5,123 5,144 5,162 5,787 7,410 7,223 6,849 69,213 1,236 0.19338 13384.49 239.01 Site 2 Scotland 123 Electricity kWh 1,899 1,840 1,806 1,629 1,616 1,717 4,036 2,834 5,263 5,728 5,648 4,498 38,514 313 0.19338 7447.80 60.55 Site 3 South West 47 Electricity kWh 1,975 1,668 1,838 1,796 1,841 1,606 1,646 1,584 2,383 3,651 3,480 3,403 26,871 572 0.19338 5196.28 110.56 Site 4 South West 20 Electricity kWh -111 1,195 1,204 989 1,004 923 910 857 902 1,195 1,399 1,255 11,722 586 0.19338 2266.86 113.34 Site 5 South West 169 Electricity kWh 13,627 12,869 14,341 13,629 14,633 14,314 15,126 14,672 11,745 16,261 17,107 16,991 1,75,312 1,037 0.19338 33901.91 200.60 Site 6 South West 31 Electricity kWh 2,023 1,982 2,239 2,040 2,014 1,757 1,839 1,819 1,730 1,965 2,316 2,244 23,966 773 0.19338 4634.47 149.50 Site 7 South West 78 Electricity kWh 40,047 33,991 33,079 29,472 26,288 21,483 20,842 22,489 19,785 28,939 32,686 33,276 3,42,377 4,389 0.19338 66208.88 848.83 Site 8 South West 40 Electricity kWh 3,953 3,571 3,908 3,638 3,686 3,296 3,255 3,033 2,125 3,535 3,471 3,128 40,598 1,015 0.19338 7850.88 196.27 Site 9 Midlands 106 Electricity kWh 10,032 9,182 10,268 9,836 9,738 8,760 8,867 8,327 7,598 11,017 12,391 13,887 1,19,903 1,131 0.19338 23186.78 218.74 Site 10 Midlands 77 Electricity kWh 16,943 14,192 14,866 11,528 9,988 6,521 6,563 6,292 6,407 12,993 22,128 25,217 1,53,636 1,995 0.19338 29710.17 385.85 Site 11 Midlands 184 Electricity kWh 45,497 42,716 38,007 32,160 27,804 15,590 14,529 13,848 18,033 40,801 53,143 57,697 3,99,824 2,173 0.19338 77317.95 420.21 Site 12 South West 84 Electricity kWh 8,684 7,902 8,356 7,475 7,190 7,108 7,048 6,506 7,134 7,594 8,214 8,052 91,261 1,086 0.19338 17648.11 210.10 Site 13 South West 84 Electricity kWh 35,351 30,964 29,275 24,060 22,802 15,623 14,726 14,344 13,774 23,940 31,371 37,085 2,93,313 3,492 0.19338 56720.79

675.25 Site 14 South East 79 Electricity kWh 7,093 6,482 6,829 6,480 6,957 6,390 6,678 6,302 6,128 7,768 8,001 7,985 83,093 1,052 0.19338 16068.58 203.40 Site 15 South East 79 Electricity kWh 26,904 23,223 23,454 21,957 19,324 11,469 9,785 9,575 12,246 21,171 26,634 27,743 2,33,484 2,955 0.19338 45151.19 571.53 Site 16 South East 47 Electricity kWh 1,310 1,446 1,473 1,089 963 916 925 911 1,010 1,255 1,433 1,469 14,201 302 0.19338 2746.17 58.43 Site 17 South West 51 Electricity kWh 6,029 4,936 5,278 4,945 4,826 4,282 4,158 2,804 2,968 4,827 5,231 5,221 55,503 1,088 0.19338 10733.23 210.46 Site 18 South West 67 Electricity kWh 8,532 9,616 7,651 6,691 6,653 6,538 6,560 6,287 7,283 10,298 10,629 9,972 96,710 1,443 0.19338 18701.70 279.13 Site 19 South West 87 Electricity kWh 30,089 24,916 24,648 20,787 17,391 10,621 10,538 10,851 11,573 19,613 29,585 31,193 2,41,801 2,779 0.19338 46759.52 537.47 Site 20 South West 314 Electricity kWh 31,862 30,070 30,523 29,066 29,821 28,625 29,155 26,812 28,477 40,994 42,142 44,192 3,91,738 1,248 0.19338 75754.35 241.26 Site 21 North East 109 Electricity kWh 13,542 25,321 21,247 18,277 21,167 14,827 12,731 12,558 11,926 20,162 27,135 40,452 2,39,344 2,196 0.19338 46284.28 424.63 Site 22 Scotland 166 Electricity kWh 36,521 31,211 28,229 23,079 19,645 12,611 11,077 11,710 19,195 27,814 39,482 44,106 3,04,678 1,835 0.19338 58918.67 354.93 Site 23 Scotland 88 Electricity kWh 6,985 6,355 6,722 6,012 5,783 5,717 5,670 5,232 5,737 6,097 6,607 6,476 73,392 834 0.19338 14192.54 161.28 Site 24 Scotland 71 Electricity kWh 976 10,043 10,262 10,560 9,277 8,732 7,906 7,904 15,265 7,133 10,788 12,122 1,10,968 1,563 0.19338 21459.01 302.24 Site 25 South West 150 Electricity kWh 28,733 23,789 21,129 15,904 14,143 7,332 7,153 7,365 10,456 15,628 28,790 28,767 2,09,188 1,395 0.19338 40452.85 269.69 Site 26 South West 30 Electricity kWh 8,465 7,348 7,643 7,089 7,211 6,130 6,010 4,984 5,642 7,474 8,678 7,911 84,585 2,820 0.19338 16357.09 545.24 Site 27 South West 71 Electricity kWh 9,227 9,447 10,673 9,066 10,562 8,900 8,398 7,000 9,772 12,525 12,391 11,541 1,19,501 1,683 0.19338 23109.10 325.48 Site 28 South West 61 Electricity kWh 16,903 14,627 15,806 14,775 15,598 13,058 12,508 11,816 12,812 16,491 18,445 17,556 1,80,396 2,957 0.19338 34884.88 571.88 Site 29 South West 102 Electricity kWh 29,309 26,052 26,214 21,825 20,735 10,256 8,582 7,711 10,687 19,520 28,747 28,236 2,37,873 2,332 0.19338 45999.92 450.98 Site 30 South West 190 Electricity kWh 36,817 31,894 31,044 19,967 16,675 8,404 6,561 6,081 10,298 17,754 28,864 23,367 2,37,726 1,251 0.19338 45971.43 241.95

Site 31 Scotland 70 Electricity kWh 10,000 9,526 11,296 11,912 12,104 11,663 10,771 10,695 10,351 12,314 12,608 12,866 1,36,105 1,944 0.19338 26319.89 376.00 Site 32 Scotland 89 Electricity kWh 14,630 13,177 13,421 10,347 8,359 7,105 7,182 6,875 9,666 12,989 13,716 13,697 1,31,163 1,474 0.19338 25364.30 284.99 Site 33 Scotland 103 Electricity kWh 50,989 51,954 46,381 43,838 37,192 20,285 19,180 19,534 25,779 38,855 45,390 55,649 4,55,027 4,418 0.19338 87993.18 854.30 Site 34 Scotland 178 Electricity kWh 57,923 54,300 46,568 43,122 36,439 21,825 19,861 21,690 27,480 47,022 60,690 68,837 5,05,756 2,841 0.19338 97803.15 549.46 Site 35 South East 116 Electricity kWh 9,009 8,635 8,512 6,970 7,326 6,277 6,719 7,507 6,983 9,154 10,461 10,594 98,146 846 0.19338 18979.55 163.62 Site 36 North East 98 Electricity kWh 15,673 13,780 14,108 13,167 12,135 8,537 8,112 7,982 9,152 11,625 13,721 15,720 1,43,711 1,466 0.19338 27790.85 283.58 Site 37 North East 179 Electricity kWh 61,876 54,004 49,996 39,687 32,750 17,636 15,398 16,417 16,509 30,669 42,321 48,043 4,25,304 2,376 0.19338 82245.36 459.47 Site 38 North West 30 Electricity kWh 19,888 9,123 9,969 9,097 8,744 7,323 7,328 7,529 7,357 8,941 9,763 10,330 1,15,391 3,846 0.19338 22314.33 743.81 Site 39 North West 77 Electricity kWh 11,931 10,311 9,481 7,628 6,518 5,048 4,255 4,335 5,301 8,442 10,714 11,771 95,737 1,243 0.19338 18513.54 240.44 Site 40 North West 100 Electricity kWh 29,629 24,272 20,087 16,912 15,462 9,743 8,125 8,252 8,732 14,426 20,864 23,229 1,99,732 1,997 0.19338 38624.21 386.24 Site 41 North East 111 Electricity kWh 44,821 37,213 31,430 26,630 22,828 10,893 8,725 8,415 11,602 24,213 36,795 44,110 3,07,675 2,772 0.19338 59498.17 536.02 Site 42 North East 127 Electricity kWh 33,178 25,447 21,290 16,418 15,758 9,741 9,851 10,233 14,949 26,089 39,708 46,996 2,69,659 2,123 0.19338 52146.56 410.60 Site 43 North East 85 Electricity kWh 7,420 6,967 8,593 7,726 7,687 7,156 6,821 6,829 8,396 12,333 12,613 11,970 1,04,511 1,230 0.19338 20210.38 237.77 Site 44 Midlands 16 Electricity kWh 1,345 305 1,200 910 849 823 824 816 907 1,038 1,198 1,236 11,449 716 0.19338 2214.01 138.38 Site 45 Midlands 110 Electricity kWh 41,266 34,370 34,530 27,113 22,837 12,004 11,713 13,943 14,327 27,842 39,674 44,442 3,24,061 2,946 0.19338 62666.84 569.70 Site 46 Midlands 174 Electricity kWh 25,592 24,059 25,248 20,722 20,172 15,685 15,350 13,006 14,297 18,806 23,024 25,042 2,41,001 1,385 0.19338 46604.73 267.84 Site 47 Midlands 59 Electricity kWh 43,033 36,696 35,233 30,693 28,612 19,616 17,521 17,920 14,701 15,908 26,854 34,121 3,20,908 5,439

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

0.19338 62057.13 1051.82 Site 48 Midlands 30 Electricity kWh 18,812 19,093 15,366 17,411 18,725 12,278 10,477 9,139 10,412 14,955 18,736 24,949 1,90,352 6,345 0.19338 36810.17 1227.01 Site 49 Midlands 173 Electricity kWh 12,585 10,454 11,514 9,720 10,533 9,631 9,549 9,665 8,741 11,570 11,902 12,360 1,28,222 741 0.19338 24795.59 143.33 Site 50 Midlands 107 Electricity kWh 11,774 10,816 12,559 11,665 12,510 10,972 10,041 9,337 6,974 8,463 8,534 8,172 1,21,817 1,138 0.19338 23556.89 220.16 Site 51 Midlands 17 Electricity kWh 4,994 5,429 5,544 4,202 2,575 2,497 2,502 2,477 2,752 -11,200 5,534 5,710 33,015 1,942 0.19338 6384.48 375.56 Site 52 North West 64 Electricity kWh 23,594 20,506 21,185 22,242 26,899 21,381 24,393 22,219 23,197 25,182 30,150 35,929 2,96,877 4,639 0.19338 57410.09 897.03 Site 53 North West 50 Electricity kWh 13,673 12,079 10,472 7,705 7,280 7,020 4,042 3,982 4,711 7,873 8,807 12,953 1,00,595 2,012 0.19338 19453.02 389.06 Site 54 North West 28 Electricity kWh 11,198 8,012 -8,339 9,757 8,347 13,629 5,879 5,877 5,955 5,263 7,921 8,718 82,217 2,936 0.19338 15899.03 567.82 Site 55 North West 74 Electricity kWh 9,915 8,186 9,563 8,167 7,407 4,601 4,299 4,136 4,214 9,065 13,442 15,833 98,827 1,335 0.19338 19111.09 258.26 Site 56 North West 147 Electricity kWh 26,473 22,740 20,800 16,817 14,433 9,715 8,404 7,603 9,229 15,745 21,732 24,577 1,98,268 1,349 0.19338 38340.97 260.82 Site 57 North West 98 Electricity kWh 53,564 44,788 44,492 37,577 35,358 15,741 13,298 16,024 15,578 28,750 37,436 43,945 3,86,549 3,944 0.19338 74750.86 762.76 Site 58 North West 19 Electricity kWh 2,820 3,112 -13,380 1,390 1,313 1,268 1,272 1,254 1,399 1,589 1,777 1,822 5,635 297 0.19338 1089.68 57.35 Site 59 North West 117 Electricity kWh 41,917 36,475 35,814 28,070 24,318 11,337 9,173 9,342 9,731 20,529 29,722 32,750 2,89,177 2,472 0.19338 55921.07 477.96 Site 60 North West 87 Electricity kWh 51,742 44,908 41,972 39,346 36,845 18,228 16,479 14,993 18,596 41,190 54,164 62,011 4,40,474 5,063 0.19338 85178.82 979.07 Site 61 North East 89 Electricity kWh 11,206 11,149 12,744 10,258 10,674 10,332 7,688 9,008 10,301 9,546 13,815 14,674 1,31,394 1,476 0.19338 25408.88 285.49 Site 62 North East 85 Electricity kWh 35,562 29,227 25,641 23,852 20,815 11,918 9,176 9,665 11,029 22,014 29,906 35,240 2,64,043 3,106 0.19338 51060.64 600.71 Site 63 Midlands 77 Electricity kWh 17,808 13,970 14,487 12,833 12,305 7,274 6,143 6,274 7,225 12,656 18,153 16,716 1,45,843 1,894 0.19338 28203.12 366.27 Site 64 Midlands 98 Electricity kWh 24,232 19,091 19,578 18,708 17,931 12,542 12,239 11,552 12,307 18,619 24,889 26,016 2,17,704 2,221 0.19338 42099.52

429.59 Site 65 Midlands 162 Electricity kWh 19,108 17,837 20,641 20,202 21,954 20,906 21,001 20,315 20,816 26,474 26,262 25,608 2,61,123 1,612 0.19338 50496.04 311.70 Site 66 South East 44 Electricity kWh 1,285 1,418 1,439 1,106 290 283 287 289 313 355 405 407 7,877 179 0.19338 1523.27 34.62 Site 67 South East 242 Electricity kWh 67,081 59,507 55,189 45,090 43,097 22,254 18,452 18,018 18,680 36,825 56,371 64,673 5,05,237 2,088 0.19338 97702.79 403.73 Site 68 Midlands 83 Electricity kWh 51,856 43,895 39,951 31,311 28,870 14,573 13,365 12,619 14,965 29,330 45,323 42,035 3,68,093 4,435 0.19338 71181.77 857.61 Site 69 North West 134 Electricity kWh 7,796 6,979 8,349 8,038 8,501 7,839 7,408 6,714 7,133 11,189 11,690 11,955 1,03,593 773 0.19338 20032.72 149.50 Site 70 North West 107 Electricity kWh 49,955 41,796 40,792 37,196 31,528 15,408 14,120 14,727 13,368 28,239 46,821 57,593 3,91,543 3,659 0.19338 75716.60 707.63 Site 71 North West 63 Electricity kWh 27,660 24,479 25,650 22,995 17,159 7,357 6,820 7,103 6,426 12,092 16,931 20,360 1,95,032 3,096 0.19338 37715.33 598.66 Site 72 South East 173 Electricity kWh 51,410 46,428 42,220 41,149 35,408 20,636 20,215 21,044 18,254 32,759 48,621 53,108 4,31,252 2,493 0.19338 83395.53 482.06 Site 73 South East 46 Electricity kWh 7,486 6,117 5,259 4,424 4,109 2,635 3,207 3,091 4,570 8,787 11,344 12,028 73,058 1,588 0.19338 14127.86 307.13 Site 74 Scotland 233 Electricity kWh 39,865 50,774 43,157 39,578 29,849 8,138 10,612 16,124 27,413 39,183 51,174 49,630 4,05,496 1,740 0.19338 78414.86 336.54 Site 75 Midlands 120 Electricity kWh 28,945 23,437 22,444 19,341 17,791 10,148 9,756 10,087 12,498 18,126 24,079 24,963 2,21,615 1,847 0.19338 42855.81 357.13 Site 76 South East 72 Electricity kWh 7,079 6,796 8,275 7,723 8,156 7,502 7,618 6,371 7,110 9,339 9,355 9,205 94,527 1,313 0.19338 18279.67 253.88 Site 77 South East 70 Electricity kWh 9,062 13,531 9,759 4,658 16,177 9,415 8,588 8,946 9,784 9,937 10,898 8,756 1,19,511 1,707 0.19338 23110.96 330.16 Site 78 North East 220 Electricity kWh 63,669 57,591 54,941 49,573 41,267 39,515 43,238 39,873 34,514 56,994 63,849 68,217 6,13,241 2,787 0.19338 118588.47 539.04 Site 79 North East 106 Electricity kWh 32,295 27,442 24,860 21,942 17,201 9,939 8,962 8,610 8,154 16,988 22,789 25,729 2,24,911 2,122 0.19338 43493.23 410.31 Site 80 North East 115 Electricity kWh 40,315 33,824 31,391 26,970 25,905 12,542 11,676 12,028 10,475 24,928 38,940 44,383 3,13,376 2,725 0.19338 60600.57 526.96 Site 1 Scotland 56 Natural Gas kWh 34,417 30,575 28,636 27,777 26,698 15,332 16,663 14,238 15,000 24,568 32,209 34,018 3,00,129 5,359 0.2 60025.77

1071.89 Site 2 Scotland 123 Natural Gas kWh 1,00,802 95,406 94,446 77,434 25,570 25,570 35,865 41,201 43,417 69,178 81,789 88,976 7,79,653 6,339 0.2 155930.63 1267.73 Site 3 South West 47 Natural Gas kWh 7,813 12,677 6,316 6,803 4,967 2,463 1,842 1,975 2,722 6,774 11,074 12,872 78,299 1,666 0.2 15659.75 333.19 Site 4 South West 20 Natural Gas kWh 8,847 7,336 7,735 5,389 3,286 1,003 696 837 1,412 4,571 6,995 9,089 57,195 2,860 0.2 11439.10 571.95 Site 5 South West 169 Natural Gas kWh 76,845 66,700 64,926 57,048 48,948 26,641 25,889 27,193 22,764 43,328 60,430 65,795 5,86,507 3,470 0.2 117301.48 694.09 Site 6 South West 31 Natural Gas kWh 8,314 10,262 5,984 5,010 4,945 1,549 1,449 1,484 11,093 4,762 10,057 14,760 79,668 2,570 0.2 15933.66 513.99 Site 8 South West 40 Natural Gas kWh 19,264 16,600 17,309 14,474 10,525 4,548 3,302 4,251 3,462 5,981 14,863 13,740 1,28,318 3,208 0.2 25663.52 641.59 Site 9 Midlands 106 Natural Gas kWh 41,229 33,775 32,694 28,715 24,551 10,377 9,615 12,300 12,996 33,563 51,497 61,704 3,53,014 3,330 0.2 70602.86 666.06 Site 10 Midlands 77 Natural Gas kWh 14,999 14,202 16,297 13,894 13,779 11,670 11,016 16,961 10,067 13,973 14,385 16,025 1,67,268 2,172 0.2 33453.53 434.46 Site 11 Midlands 184 Natural Gas kWh 20,147 18,272 20,305 17,555 17,667 14,044 13,050 12,771 15,824 22,532 24,423 24,902 2,21,493 1,204 0.2 44298.65 240.75 Site 12 South West 84 Natural Gas kWh 13,245 17,254 14,118 12,881 10,681 9,397 8,705 9,485 10,217 14,968 17,678 16,688 1,55,315 1,849 0.2 31062.95 369.80 Site 14 South East 79 Natural Gas kWh 5,512 6,143 528 528 528 5,00,000 528 528 2,611 2,722 3,245 4,874 5,27,747 6,680 0.2 105549.38 1336.07 Site 16 South East 47 Natural Gas kWh 2,156 2,086 2,007 1,331 733 197 120 111 266 859 1,561 2,014 13,440 286 0.2 2688.06 57.19 Site 17 South West 51 Natural Gas kWh 31,133 31,123 31,049 23,376 4,174 4,174 5,681 5,733 8,816 26,109 21,083 24,385 2,16,838 4,252 0.2 43367.55 850.34 Site 18 South West 67 Natural Gas kWh 24,501 17,259 24,948 20,549 18,120 8,695 7,383 7,607 8,402 17,685 22,277 26,173 2,03,599 3,039 0.2 40719.85 607.76 Site 19 South West 87 Natural Gas kWh 30,847 21,593 23,087 20,738 19,825 11,582 9,976 10,463 10,452 17,328 23,918 25,506 2,25,316 2,590 0.2 45063.12 517.97 Site 20 South West 314 Natural Gas kWh 2,24,717 1,66,957 1,68,092 1,07,653 94,961 54,639 45,424 52,405 53,916 90,740 1,18,810 1,29,606 13,07,922 4,165 0.2 261584.32 833.07 Site 22 Scotland 166 Natural Gas kWh 18,348 17,000 18,248 17,262 16,152 14,149 12,936 13,385 21,651 32,245 28,286 29,566 2,39,227 1,441 0.2 47845.33 288.22 Site 23 Scotland 88 Natural Gas kWh

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

34,832 30,508 29,382 26,758 24,738 16,607 16,013 17,917 20,853 31,942 36,166 39,319 3,25,035 3,694 0.2 65007.06 738.72 Site 25 South West 150 Natural Gas kWh 16,741 18,318 20,135 18,315 18,733 16,809 15,275 14,350 16,490 20,009 18,348 16,210 2,09,733 1,398 0.2 41946.56 279.64 Site 26 South West 30 Natural Gas kWh 34,500 32,835 31,504 25,340 19,301 9,999 9,390 8,927 9,668 16,488 24,103 29,938 2,51,992 8,400 0.2 50398.46 1679.95 Site 28 South West 61 Natural Gas kWh 53,499 41,878 41,766 31,452 22,252 10,367 7,649 7,710 11,852 22,569 34,294 41,253 3,26,540 5,353 0.2 65307.99 1070.62 Site 29 South West 102 Natural Gas kWh 12,647 15,836 15,946 13,472 13,988 11,994 10,749 10,879 12,536 16,533 17,030 16,321 1,67,930 1,646 0.2 33585.98 329.27 Site 30 South West 190 Natural Gas kWh 34,500 32,547 38,375 36,518 38,056 27,310 22,643 19,572 37,562 43,339 44,451 39,117 4,13,989 2,179 0.2 82797.82 435.78 Site 31 Scotland 70 Natural Gas kWh 50,081 42,109 44,078 37,930 31,874 17,472 14,682 15,856 19,113 35,892 41,104 50,590 4,00,781 5,725 0.2 80156.18 1145.09 Site 32 Scotland 89 Natural Gas kWh 50,575 44,864 37,119 29,758 26,596 17,222 14,145 13,928 19,733 33,356 44,790 56,492 3,88,578 4,366 0.2 77715.61 873.21 Site 33 Scotland 103 Natural Gas kWh 38,219 27,897 32,645 35,010 18,058 20,526 25,208 23,568 24,101 32,525 33,821 33,293 3,44,872 3,348 0.2 68974.44 669.65 Site 34 Scotland 178 Natural Gas kWh 3,852 3,592 4,023 3,980 4,061 3,609 3,310 3,189 3,237 4,148 4,425 4,502 45,927 258 0.2 9185.36 51.60 Site 35 South East 116 Natural Gas kWh 50,200 44,167 45,299 40,615 35,761 22,368 18,588 24,821 21,154 31,702 47,107 47,035 4,28,818 3,697 0.2 85763.58 739.34 Site 36 North East 98 Natural Gas kWh 22,373 19,165 19,957 18,060 17,581 13,685 12,842 12,947 14,646 17,508 19,315 19,233 2,07,313 2,115 0.2 41462.61 423.09 Site 37 North East 179 Natural Gas kWh 32,945 31,980 31,902 24,027 17,000 7,915 5,839 5,888 9,055 17,234 26,199 31,500 2,41,484 1,349 0.2 48296.81 269.81 Site 40 North West 100 Natural Gas kWh 22,770 10,143 9,752 6,475 3,546 943 599 561 1,287 4,157 7,594 9,778 77,605 776 0.2 15521.04 155.21 Site 41 North East 111 Natural Gas kWh 29,008 6,776 6,776 6,776 15,611 11,724 10,048 9,389 10,164 17,086 19,338 19,896 1,62,591 1,465 0.2 32518.15 292.96 Site 42 North East 127 Natural Gas kWh 28,231 29,484 28,334 18,821 10,293 2,737 1,745 1,614 3,746 12,082 22,089 28,428 1,87,605 1,477 0.2 37521.01 295.44 Site 43 North East 85 Natural Gas kWh 55,705 48,938 54,776 44,916 36,585 21,634 18,544 18,733 23,429 34,879 46,941 52,732 4,57,814 5,386 0.2 91562.74 1077.21 Site

45 Midlands 110 Natural Gas kWh 10,977 11,904 11,868 8,936 6,324 2,945 2,169 2,193 3,371 6,409 9,753 11,719 88,567 805 0.2 17713.41 161.03 Site 46 Midlands 174 Natural Gas kWh 26,451 24,197 28,374 24,521 25,451 24,275 18,159 19,778 19,966 25,996 28,152 28,427 2,93,747 1,688 0.2 58749.40 337.64 Site 52 North West 64 Natural Gas kWh 86,809 80,316 79,449 63,069 62,189 24,112 29,858 36,672 26,666 63,772 76,205 91,647 7,20,764 11,262 0.2 144152.76 2252.39 Site 53 North West 50 Natural Gas kWh 14,051 13,643 13,603 10,248 7,250 3,374 2,488 2,515 3,860 7,348 11,171 13,433 1,02,983 2,060 0.2 20596.63 411.93 Site 54 North West 28 Natural Gas kWh 21,109 15,562 14,651 9,989 7,554 2,852 2,952 4,255 5,236 10,617 14,929 20,302 1,30,007 4,643 0.2 26001.49 928.62 Site 55 North West 74 Natural Gas kWh 5,746 8,864 4,982 5,135 2,812 12,985 5,995 5,770 4,654 8,797 10,573 10,378 86,690 1,171 0.2 17338.08 234.30 Site 57 North West 98 Natural Gas kWh 22,817 22,144 22,098 16,646 11,767 5,469 4,036 4,069 6,273 11,931 18,149 21,823 1,67,222 1,706 0.2 33444.34 341.27 Site 58 North West 19 Natural Gas kWh 16,026 13,935 12,004 10,259 9,429 5,703 5,723 5,927 5,046 7,606 13,169 16,500 1,21,327 6,386 0.2 24265.31 1277.12 Site 59 North West 117 Natural Gas kWh 19,078 17,895 18,130 16,768 18,655 13,917 10,326 11,799 10,762 16,842 17,874 16,443 1,88,490 1,611 0.2 37697.96 322.20 Site 61 North East 89 Natural Gas kWh 81,488 83,452 78,516 70,307 60,167 31,992 28,764 33,852 30,495 61,396 74,814 83,366 7,18,609 8,074 0.2 143721.83 1614.85 Site 62 North East 85 Natural Gas kWh 12,533 11,618 12,583 12,317 12,264 9,889 10,454 11,522 11,870 12,871 15,596 17,577 1,51,094 1,778 0.2 30218.78 355.52 Site 63 Midlands 77 Natural Gas kWh 46,253 21,837 21,778 2,159 2,159 2,159 2,159 2,159 2,159 10,858 11,097 9,331 1,34,105 1,742 0.2 26821.05 348.33 Site 64 Midlands 98 Natural Gas kWh 10,878 9,955 10,889 9,617 10,265 7,782 6,686 7,137 7,480 13,020 12,799 11,183 1,17,692 1,201 0.2 23538.36 240.19 Site 65 Midlands 162 Natural Gas kWh 1,02,332 87,532 86,230 66,746 68,394 10,027 6,402 76,245 31,360 61,209 87,942 96,562 7,80,981 4,821 0.2 156196.17 964.17 Site 66 South East 44 Natural Gas kWh 13,431 12,656 12,114 11,317 9,685 4,566 3,336 3,391 3,998 10,250 12,814 15,410 1,12,968 2,567 0.2 22593.64 513.49 Site 67 South East 242 Natural Gas kWh 24,865 23,421 26,788 24,403 27,910 21,206 18,592 18,407 18,771 29,010 29,780 28,508 2,91,660 1,205 0.2 58331.98 241.04 Site 68 Midlands 83 Natural Gas kWh 10,835 11,766 16,353 12,307 8,238 9,344 8,361 8,311 9,934 14,634 14,761 12,551 1,37,397 1,655 0.2 27479.35 331.08 Site

72 South East 173 Natural Gas kWh 38,462 10,765 27,299 26,640 26,685 27,842 28,341 28,659 25,883 36,091 36,282 36,615 3,49,564 2,021 0.2 69912.88 404.12 Site 74 Scotland 233 Natural Gas kWh 45,892 36,409 34,191 32,882 39,542 44,403 34,164 22,626 30,642 36,252 40,991 33,089 4,31,084 1,850 0.2 86216.82 370.03 Site 75 Midlands 120 Natural Gas kWh 26,007 24,200 26,111 26,159 21,512 16,953 18,450 18,152 22,007 27,082 27,175 27,032 2,80,839 2,340 0.2 56167.84 468.07 Site 76 South East 72 Natural Gas kWh 67,214 58,509 59,450 51,808 31,635 10,620 11,210 9,609 10,201 44,790 51,313 54,752 4,61,111 6,404 0.2 92222.14 1280.86 Site 77 South East 70 Natural Gas kWh 67,114 79,636 70,859 47,710 28,654 9,001 28,024 5,739 11,131 32,951 57,892 74,145 5,12,856 7,327 0.2 102571.12 1465.30 Site 78 North East 220 Natural Gas kWh 33,917 50,507 8,023 31,066 33,906 39,665 36,850 37,978 31,612 27,413 30,217 31,751 3,92,906 1,786 0.2 78581.21 357.19 Site 79 North East 106 Natural Gas kWh 18,299 17,216 18,829 17,526 17,455 12,955 12,842 12,788 13,321 19,662 21,256 19,690 2,01,840 1,904 0.2 40368.03 380.83 Site 80 North East 115 Natural Gas kWh 17,651 16,053 17,016 16,855 14,586 12,134 12,431 12,129 9,349 12,527 15,069 14,722 1,70,522 1,483 0.2 34104.36 296.56 To answer your questions, I'll perform calculations and analysis based on the provided data. Q1. To determine the most efficient site per bed, we need to calculate the energy consumption per bed for each site and compare the values. The site with the lowest energy consumption per bed would be the most efficient. Site Name Region Beds Total (kWh) Total (kWh/bed) Site 1 Scotland 56 69,213 1,236 Site 2 Scotland 123 38,514 313 Site 3 South West 47 26,871 572 Site 4 South West 20 11,722 586 Site 5 South West 169 1,75,312 1,037 Site 6 South West 31 23,966 773 Site 7 South West 78 3,42,377 4,389 Site 8 South West 40 40,598 1,015 Site 9 Midlands 106 1,19,903 1,131 Site 10 Midlands 77 1,53,636 1,995 Site 11 Midlands 184 3,99,824 2,173 Site 12 South West 84 91,261 1,086 Site 13 South West 84 2,93,313 3,492 Site 14 South East 79 83,093 1,052 Site 15 South East 79 2,33,484 2,955 Site 16 South East 47 14,201 302 Site 17 South West 51 55,503 1,088 Site 18 South West 67 96,710 1,443 Site 19 South West 87 2,41,801 2,779 Site 20 South West 314 3,91,738 1,248 Site 21 North East 109 2,39,344 2,196 Site 22 Scotland 166 3,04,678 1,835 Site 23 Scotland 88 73,392 834 Site 24 Scotland

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

71 1,10,968 1,563 Site 25 South West 150 2,09,188 1,395 Site 26 South West 30 84,585 2,820 Site 27 South West 71 1,19,501 1,683 Site 28 South West 61 1,80,396 2,957 Site 29 South West 102 2,37,873 2,332 Site 30 South West 190 2,37,726 1,251 Site 31 Scotland 70 1,36,105 1,944 Site 32 Scotland 89 1,31,163 1,474 Site 33 Scotland 103 4,55,027 4,418 Site 34 Scotland 178 5,05,756 2,841 Site 35 South East 116 98,146 846 Site 36 North East 98 1,43,711 1,466 Site 37 North East 179 4,25,304 2,376 Site 38 North West 30 1,15,391 3,846 Site 39 North West 77 95,737 1,243 Site 40 North West 100 1,99,732 1,997 Site 41 North East 111 3,07,675 2,772 Site 42 North East 127 2,69,659 2,123 Site 43 North East 85 1,04,511 1,230 Site 44 Midlands 16 11,449 716 Site 45 Midlands 110 3,24,061 2,946 Site 46 Midlands 174 2,41,001 1,385 Site 47 Midlands 59 3,20,908 5,439 Site 48 Midlands 30 1,90,352 6,345 Site 49 Midlands 173 1,28,222 741 Site 50 Midlands 107 1,21,817 1,138 Site 51 Midlands 17 33,015 1,942 Site 52 North West 64 2,96,877 4,639 Site 53 North West 50 1,00,595 2,012 Site 54 North West 28 82,217 2,936 Site 55 North West 74 98,827 You Q1. If you had to give an award to the most efficient site in the country per bed, who would you choose and why? Q2. List the regions in order of energy effciency from worst to best. Please display this using a chart of your choice Q3. What do you think affects the energy consumption of a student accommodation building? Why? Q4. What contribution is each region making to the total energy consumption (%)? Q5. Which is the best performing site in terms of carbon? And the worst? Q6. What changes would you recommend for a site that has shown interest in becoming more energy efficient? Using below data : answer above the Question | Site|Name| Region| Beds Utility| Units |Jan- 21 | Feb-21 | Mar-21 | Apr-21 | May-21| Jun-21| Jul-21 | Aug-21 | Sep-21| Oct-21 | Nov-21 | Dec-21 Total (kWh)| Total (kWh/bed) | Emission(kWh) | Total Emissions (TCO2e) |Total Emissions (kgCO2e/bed)| Site 1 Scotland 56 Electricity kWh 6,807 7,113 6,531 6,066 5,123 5,144 5,162 5,787 7,410 7,223 6,849 69,213 1,236 0.19338 13384.49 239.01 Site 2 Scotland 123 Electricity kWh 1,899 1,840 1,806 1,629 1,616 1,717 4,036 2,834 5,263 5,728 5,648 4,498 38,514 313 0.19338 7447.80 60.55 Site 3 South West 47 Electricity kWh 1,975 1,668 1,838 1,796 1,841 1,606 1,646 1,584 2,383 3,651 3,480 3,403 26,871 572 0.19338 5196.28 110.56 Site 4 South West 20 Electricity kWh -111 1,195

1,204 989 1,004 923 910 857 902 1,195 1,399 1,255 11,722 586 0.19338 2266.86 113.34 Site 5 South West 169 Electricity kWh 13,627 12,869 14,341 13,629 14,633 14,314 15,126 14,672 11,745 16,261 17,107 16,991 1,75,312 1,037 0.19338 33901.91 200.60 Site 6 South West 31 Electricity kWh 2,023 1,982 2,239 2,040 2,014 1,757 1,839 1,819 1,730 1,965 2,316 2,244 23,966 773 0.19338 4634.47 149.50 Site 7 South West 78 Electricity kWh 40,047 33,991 33,079 29,472 26,288 21,483 20,842 22,489 19,785 28,939 32,686 33,276 3,42,377 4,389 0.19338 66208.88 848.83 Site 8 South West 40 Electricity kWh 3,953 3,571 3,908 3,638 3,686 3,296 3,255 3,033 2,125 3,535 3,471 3,128 40,598 1,015 0.19338 7850.88 196.27 Site 9 Midlands 106 Electricity kWh 10,032 9,182 10,268 9,836 9,738 8,760 8,867 8,327 7,598 11,017 12,391 13,887 1,19,903 1,131 0.19338 23186.78 218.74 Site 10 Midlands 77 Electricity kWh 16,943 14,192 14,866 11,528 9,988 6,521 6,563 6,292 6,407 12,993 22,128 25,217 1,53,636 1,995 0.19338 29710.17 385.85 Site 11 Midlands 184 Electricity kWh 45,497 42,716 38,007 32,160 27,804 15,590 14,529 13,848 18,033 40,801 53,143 57,697 3,99,824 2,173 0.19338 77317.95 420.21 Site 12 South West 84 Electricity kWh 8,684 7,902 8,356 7,475 7,190 7,108 7,048 6,506 7,134 7,594 8,214 8,052 91,261 1,086 0.19338 17648.11 210.10 Site 13 South West 84 Electricity kWh 35,351 30,964 29,275 24,060 22,802 15,623 14,726 14,344 13,774 23,940 31,371 37,085 2,93,313 3,492 0.19338 56720.79 675.25 Site 14 South East 79 Electricity kWh 7,093 6,482 6,829 6,480 6,957 6,390 6,678 6,302 6,128 7,768 8,001 7,985 83,093 1,052 0.19338 16068.58 203.40 Site 15 South East 79 Electricity kWh 26,904 23,223 23,454 21,957 19,324 11,469 9,785 9,575 12,246 21,171 26,634 27,743 2,33,484 2,955 0.19338 45151.19 571.53 Site 16 South East 47 Electricity kWh 1,310 1,446 1,473 1,089 963 916 925 911 1,010 1,255 1,433 1,469 14,201 302 0.19338 2746.17 58.43 Site 17 South West 51 Electricity kWh 6,029 4,936 5,278 4,945 4,826 4,282 4,158 2,804 2,968 4,827 5,231 5,221 55,503 1,088 0.19338 10733.23 210.46 Site 18 South West 67 Electricity kWh 8,532 9,616 7,651 6,691 6,653 6,538 6,560 6,287 7,283 10,298 10,629 9,972 96,710 1,443 0.19338 18701.70 279.13 Site 19 South West 87 Electricity kWh 30,089 24,916 24,648 20,787 17,391 10,621 10,538 10,851 11,573 19,613 29,585 31,193 2,41,801 2,779 0.19338 46759.52 537.47 Site 20 South West 314 Electricity kWh 31,862 30,070 30,523 29,066 29,821 28,625 29,155 26,812 28,477 40,994 42,142 44,192 3,91,738 1,248 0.19338 75754.35 241.26 Site 21 North East 109 Electricity kWh 13,542 25,321 21,247 18,277 21,167 14,827 12,731 12,558 11,926 20,162 27,135 40,452

2,39,344 2,196 0.19338 46284.28 424.63 Site 22 Scotland 166 Electricity kWh 36,521 31,211 28,229 23,079 19,645 12,611 11,077 11,710 19,195 27,814 39,482 44,106 3,04,678 1,835 0.19338 58918.67 354.93 Site 23 Scotland 88 Electricity kWh 6,985 6,355 6,722 6,012 5,783 5,717 5,670 5,232 5,737 6,097 6,607 6,476 73,392 834 0.19338 14192.54 161.28 Site 24 Scotland 71 Electricity kWh 976 10,043 10,262 10,560 9,277 8,732 7,906 7,904 15,265 7,133 10,788 12,122 1,10,968 1,563 0.19338 21459.01 302.24 Site 25 South West 150 Electricity kWh 28,733 23,789 21,129 15,904 14,143 7,332 7,153 7,365 10,456 15,628 28,790 28,767 2,09,188 1,395 0.19338 40452.85 269.69 Site 26 South West 30 Electricity kWh 8,465 7,348 7,643 7,089 7,211 6,130 6,010 4,984 5,642 7,474 8,678 7,911 84,585 2,820 0.19338 16357.09 545.24 Site 27 South West 71 Electricity kWh 9,227 9,447 10,673 9,066 10,562 8,900 8,398 7,000 9,772 12,525 12,391 11,541 1,19,501 1,683 0.19338 23109.10 325.48 Site 28 South West 61 Electricity kWh 16,903 14,627 15,806 14,775 15,598 13,058 12,508 11,816 12,812 16,491 18,445 17,556 1,80,396 2,957 0.19338 34884.88 571.88 Site 29 South West 102 Electricity kWh 29,309 26,052 26,214 21,825 20,735 10,256 8,582 7,711 10,687 19,520 28,747 28,236 2,37,873 2,332 0.19338 45999.92 450.98 Site 30 South West 190 Electricity kWh 36,817 31,894 31,044 19,967 16,675 8,404 6,561 6,081 10,298 17,754 28,864 23,367 2,37,726 1,251 0.19338 45971.43 241.95 Site 31 Scotland 70 Electricity kWh 10,000 9,526 11,296 11,912 12,104 11,663 10,771 10,695 10,351 12,314 12,608 12,866 1,36,105 1,944 0.19338 26319.89 376.00 Site 32 Scotland 89 Electricity kWh 14,630 13,177 13,421 10,347 8,359 7,105 7,182 6,875 9,666 12,989 13,716 13,697 1,31,163 1,474 0.19338 25364.30 284.99 Site 33 Scotland 103 Electricity kWh 50,989 51,954 46,381 43,838 37,192 20,285 19,180 19,534 25,779 38,855 45,390 55,649 4,55,027 4,418 0.19338 87993.18 854.30 Site 34 Scotland 178 Electricity kWh 57,923 54,300 46,568 43,122 36,439 21,825 19,861 21,690 27,480 47,022 60,690 68,837 5,05,756 2,841 0.19338 97803.15 549.46 Site 35 South East 116 Electricity kWh 9,009 8,635 8,512 6,970 7,326 6,277 6,719 7,507 6,983 9,154 10,461 10,594 98,146 846 0.19338 18979.55 163.62 Site 36 North East 98 Electricity kWh 15,673 13,780 14,108 13,167 12,135 8,537 8,112 7,982 9,152 11,625 13,721 15,720 1,43,711 1,466 0.19338 27790.85 283.58 Site 37 North East 179 Electricity kWh 61,876 54,004 49,996 39,687 32,750 17,636 15,398 16,417 16,509 30,669 42,321 48,043 4,25,304 2,376 0.19338 82245.36 459.47 Site 38 North West 30 Electricity kWh 19,888 9,123 9,969 9,097 8,744 7,323 7,328

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

7,529 7,357 8,941 9,763 10,330 1,15,391 3,846 0.19338 22314.33 743.81 Site 39 North West 77 Electricity kWh 11,931 10,311 9,481 7,628 6,518 5,048 4,255 4,335 5,301 8,442 10,714 11,771 95,737 1,243 0.19338 18513.54 240.44 Site 40 North West 100 Electricity kWh 29,629 24,272 20,087 16,912 15,462 9,743 8,125 8,252 8,732 14,426 20,864 23,229 1,99,732 1,997 0.19338 38624.21 386.24 Site 41 North East 111 Electricity kWh 44,821 37,213 31,430 26,630 22,828 10,893 8,725 8,415 11,602 24,213 36,795 44,110 3,07,675 2,772 0.19338 59498.17 536.02 Site 42 North East 127 Electricity kWh 33,178 25,447 21,290 16,418 15,758 9,741 9,851 10,233 14,949 26,089 39,708 46,996 2,69,659 2,123 0.19338 52146.56 410.60 Site 43 North East 85 Electricity kWh 7,420 6,967 8,593 7,726 7,687 7,156 6,821 6,829 8,396 12,333 12,613 11,970 1,04,511 1,230 0.19338 20210.38 237.77 Site 44 Midlands 16 Electricity kWh 1,345 305 1,200 910 849 823 824 816 907 1,038 1,198 1,236 11,449 716 0.19338 2214.01 138.38 Site 45 Midlands 110 Electricity kWh 41,266 34,370 34,530 27,113 22,837 12,004 11,713 13,943 14,327 27,842 39,674 44,442 3,24,061 2,946 0.19338 62666.84 569.70 Site 46 Midlands 174 Electricity kWh 25,592 24,059 25,248 20,722 20,172 15,685 15,350 13,006 14,297 18,806 23,024 25,042 2,41,001 1,385 0.19338 46604.73 267.84 Site 47 Midlands 59 Electricity kWh 43,033 36,696 35,233 30,693 28,612 19,616 17,521 17,920 14,701 15,908 26,854 34,121 3,20,908 5,439 0.19338 62057.13 1051.82 Site 48 Midlands 30 Electricity kWh 18,812 19,093 15,366 17,411 18,725 12,278 10,477 9,139 10,412 14,955 18,736 24,949 1,90,352 6,345 0.19338 36810.17 1227.01 Site 49 Midlands 173 Electricity kWh 12,585 10,454 11,514 9,720 10,533 9,631 9,549 9,665 8,741 11,570 11,902 12,360 1,28,222 741 0.19338 24795.59 143.33 Site 50 Midlands 107 Electricity kWh 11,774 10,816 12,559 11,665 12,510 10,972 10,041 9,337 6,974 8,463 8,534 8,172 1,21,817 1,138 0.19338 23556.89 220.16 Site 51 Midlands 17 Electricity kWh 4,994 5,429 5,544 4,202 2,575 2,497 2,502 2,477 2,752 -11,200 5,534 5,710 33,015 1,942 0.19338 6384.48 375.56 Site 52 North West 64 Electricity kWh 23,594 20,506 21,185 22,242 26,899 21,381 24,393 22,219 23,197 25,182 30,150 35,929 2,96,877 4,639 0.19338 57410.09 897.03 Site 53 North West 50 Electricity kWh 13,673 12,079 10,472 7,705 7,280 7,020 4,042 3,982 4,711 7,873 8,807 12,953 1,00,595 2,012 0.19338 19453.02 389.06 Site 54 North West 28 Electricity kWh 11,198 8,012 -8,339 9,757 8,347 13,629 5,879 5,877 5,955 5,263 7,921 8,718 82,217 2,936 0.19338 15899.03 567.82 Site 55 North West 74 Electricity kWh 9,915 8,186 9,563 8,167 7,407 4,601 4,299 4,136 4,214 9,065 13,442 15,833 98,827

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1,335 0.19338 19111.09 258.26 Site 56 North West 147 Electricity kWh 26,473 22,740 20,800 16,817 14,433 9,715 8,404 7,603 9,229 15,745 21,732 24,577 1,98,268 1,349 0.19338 38340.97 260.82 Site 57 North West 98 Electricity kWh 53,564 44,788 44,492 37,577 35,358 15,741 13,298 16,024 15,578 28,750 37,436 43,945 3,86,549 3,944 0.19338 74750.86 762.76 Site 58 North West 19 Electricity kWh 2,820 3,112 -13,380 1,390 1,313 1,268 1,272 1,254 1,399 1,589 1,777 1,822 5,635 297 0.19338 1089.68 57.35 Site 59 North West 117 Electricity kWh 41,917 36,475 35,814 28,070 24,318 11,337 9,173 9,342 9,731 20,529 29,722 32,750 2,89,177 2,472 0.19338 55921.07 477.96 Site 60 North West 87 Electricity kWh 51,742 44,908 41,972 39,346 36,845 18,228 16,479 14,993 18,596 41,190 54,164 62,011 4,40,474 5,063 0.19338 85178.82 979.07 Site 61 North East 89 Electricity kWh 11,206 11,149 12,744 10,258 10,674 10,332 7,688 9,008 10,301 9,546 13,815 14,674 1,31,394 1,476 0.19338 25408.88 285.49 Site 62 North East 85 Electricity kWh 35,562 29,227 25,641 23,852 20,815 11,918 9,176 9,665 11,029 22,014 29,906 35,240 2,64,043 3,106 0.19338 51060.64 600.71 Site 63 Midlands 77 Electricity kWh 17,808 13,970 14,487 12,833 12,305 7,274 6,143 6,274 7,225 12,656 18,153 16,716 1,45,843 1,894 0.19338 28203.12 366.27 Site 64 Midlands 98 Electricity kWh 24,232 19,091 19,578 18,708 17,931 12,542 12,239 11,552 12,307 18,619 24,889 26,016 2,17,704 2,221 0.19338 42099.52 429.59 Site 65 Midlands 162 Electricity kWh 19,108 17,837 20,641 20,202 21,954 20,906 21,001 20,315 20,816 26,474 26,262 25,608 2,61,123 1,612 0.19338 50496.04 311.70 Site 66 South East 44 Electricity kWh 1,285 1,418 1,439 1,106 290 283 287 289 313 355 405 407 7,877 179 0.19338 1523.27 34.62 Site 67 South East 242 Electricity kWh 67,081 59,507 55,189 45,090 43,097 22,254 18,452 18,018 18,680 36,825 56,371 64,673 5,05,237 2,088 0.19338 97702.79 403.73 Site 68 Midlands 83 Electricity kWh 51,856 43,895 39,951 31,311 28,870 14,573 13,365 12,619 14,965 29,330 45,323 42,035 3,68,093 4,435 0.19338 71181.77 857.61 Site 69 North West 134 Electricity kWh 7,796 6,979 8,349 8,038 8,501 7,839 7,408 6,714 7,133 11,189 11,690 11,955 1,03,593 773 0.19338 20032.72 149.50 Site 70 North West 107 Electricity kWh 49,955 41,796 40,792 37,196 31,528 15,408 14,120 14,727 13,368 28,239 46,821 57,593 3,91,543 3,659 0.19338 75716.60 707.63 Site 71 North West 63 Electricity kWh 27,660 24,479 25,650 22,995 17,159 7,357 6,820 7,103 6,426 12,092 16,931 20,360 1,95,032 3,096 0.19338 37715.33 598.66 Site 72 South East 173 Electricity kWh 51,410 46,428 42,220 41,149 35,408 20,636 20,215 21,044 18,254

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

32,759 48,621 53,108 4,31,252 2,493 0.19338 83395.53 482.06 Site 73 South East 46 Electricity kWh 7,486 6,117 5,259 4,424 4,109 2,635 3,207 3,091 4,570 8,787 11,344 12,028 73,058 1,588 0.19338 14127.86 307.13 Site 74 Scotland 233 Electricity kWh 39,865 50,774 43,157 39,578 29,849 8,138 10,612 16,124 27,413 39,183 51,174 49,630 4,05,496 1,740 0.19338 78414.86 336.54 Site 75 Midlands 120 Electricity kWh 28,945 23,437 22,444 19,341 17,791 10,148 9,756 10,087 12,498 18,126 24,079 24,963 2,21,615 1,847 0.19338 42855.81 357.13 Site 76 South East 72 Electricity kWh 7,079 6,796 8,275 7,723 8,156 7,502 7,618 6,371 7,110 9,339 9,355 9,205 94,527 1,313 0.19338 18279.67 253.88 Site 77 South East 70 Electricity kWh 9,062 13,531 9,759 4,658 16,177 9,415 8,588 8,946 9,784 9,937 10,898 8,756 1,19,511 1,707 0.19338 23110.96 330.16 Site 78 North East 220 Electricity kWh 63,669 57,591 54,941 49,573 41,267 39,515 43,238 39,873 34,514 56,994 63,849 68,217 6,13,241 2,787 0.19338 118588.47 539.04 Site 79 North East 106 Electricity kWh 32,295 27,442 24,860 21,942 17,201 9,939 8,962 8,610 8,154 16,988 22,789 25,729 2,24,911 2,122 0.19338 43493.23 410.31 Site 80 North East 115 Electricity kWh 40,315 33,824 31,391 26,970 25,905 12,542 11,676 12,028 10,475 24,928 38,940 44,383 3,13,376 2,725 0.19338 60600.57 526.96 Site 1 Scotland 56 Natural Gas kWh 34,417 30,575 28,636 27,777 26,698 15,332 16,663 14,238 15,000 24,568 32,209 34,018 3,00,129 5,359 0.2 60025.77 1071.89 Site 2 Scotland 123 Natural Gas kWh 1,00,802 95,406 94,446 77,434 25,570 25,570 35,865 41,201 43,417 69,178 81,789 88,976 7,79,653 6,339 0.2 155930.63 1267.73 Site 3 South West 47 Natural Gas kWh 7,813 12,677 6,316 6,803 4,967 2,463 1,842 1,975 2,722 6,774 11,074 12,872 78,299 1,666 0.2 15659.75 333.19 Site 4 South West 20 Natural Gas kWh 8,847 7,336 7,735 5,389 3,286 1,003 696 837 1,412 4,571 6,995 9,089 57,195 2,860 0.2 11439.10 571.95 Site 5 South West 169 Natural Gas kWh 76,845 66,700 64,926 57,048 48,948 26,641 25,889 27,193 22,764 43,328 60,430 65,795 5,86,507 3,470 0.2 117301.48 694.09 Site 6 South West 31 Natural Gas kWh 8,314 10,262 5,984 5,010 4,945 1,549 1,449 1,484 11,093 4,762 10,057 14,760 79,668 2,570 0.2 15933.66 513.99 Site 8 South West 40 Natural Gas kWh 19,264 16,600 17,309 14,474 10,525 4,548 3,302 4,251 3,462 5,981 14,863 13,740 1,28,318 3,208 0.2 25663.52 641.59 Site 9 Midlands 106 Natural Gas kWh 41,229 33,775 32,694 28,715 24,551 10,377 9,615 12,300 12,996 33,563 51,497 61,704 3,53,014 3,330 0.2 70602.86 666.06 Site 10 Midlands 77 Natural Gas kWh 14,999 14,202 16,297 13,894 13,779 11,670 11,016 16,961 10,067 13,973 14,385 16,025

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1,67,268 2,172 0.2 33453.53 434.46 Site 11 Midlands 184 Natural Gas kWh 20,147 18,272 20,305 17,555 17,667 14,044 13,050 12,771 15,824 22,532 24,423 24,902 2,21,493 1,204 0.2 44298.65 240.75 Site 12 South West 84 Natural Gas kWh 13,245 17,254 14,118 12,881 10,681 9,397 8,705 9,485 10,217 14,968 17,678 16,688 1,55,315 1,849 0.2 31062.95 369.80 Site 14 South East 79 Natural Gas kWh 5,512 6,143 528 528 528 5,00,000 528 528 2,611 2,722 3,245 4,874 5,27,747 6,680 0.2 105549.38 1336.07 Site 16 South East 47 Natural Gas kWh 2,156 2,086 2,007 1,331 733 197 120 111 266 859 1,561 2,014 13,440 286 0.2 2688.06 57.19 Site 17 South West 51 Natural Gas kWh 31,133 31,123 31,049 23,376 4,174 4,174 5,681 5,733 8,816 26,109 21,083 24,385 2,16,838 4,252 0.2 43367.55 850.34 Site 18 South West 67 Natural Gas kWh 24,501 17,259 24,948 20,549 18,120 8,695 7,383 7,607 8,402 17,685 22,277 26,173 2,03,599 3,039 0.2 40719.85 607.76 Site 19 South West 87 Natural Gas kWh 30,847 21,593 23,087 20,738 19,825 11,582 9,976 10,463 10,452 17,328 23,918 25,506 2,25,316 2,590 0.2 45063.12 517.97 Site 20 South West 314 Natural Gas kWh 2,24,717 1,66,957 1,68,092 1,07,653 94,961 54,639 45,424 52,405 53,916 90,740 1,18,810 1,29,606 13,07,922 4,165 0.2 261584.32 833.07 Site 22 Scotland 166 Natural Gas kWh 18,348 17,000 18,248 17,262 16,152 14,149 12,936 13,385 21,651 32,245 28,286 29,566 2,39,227 1,441 0.2 47845.33 288.22 Site 23 Scotland 88 Natural Gas kWh 34,832 30,508 29,382 26,758 24,738 16,607 16,013 17,917 20,853 31,942 36,166 39,319 3,25,035 3,694 0.2 65007.06 738.72 Site 25 South West 150 Natural Gas kWh 16,741 18,318 20,135 18,315 18,733 16,809 15,275 14,350 16,490 20,009 18,348 16,210 2,09,733 1,398 0.2 41946.56 279.64 Site 26 South West 30 Natural Gas kWh 34,500 32,835 31,504 25,340 19,301 9,999 9,390 8,927 9,668 16,488 24,103 29,938 2,51,992 8,400 0.2 50398.46 1679.95 Site 28 South West 61 Natural Gas kWh 53,499 41,878 41,766 31,452 22,252 10,367 7,649 7,710 11,852 22,569 34,294 41,253 3,26,540 5,353 0.2 65307.99 1070.62 Site 29 South West 102 Natural Gas kWh 12,647 15,836 15,946 13,472 13,988 11,994 10,749 10,879 12,536 16,533 17,030 16,321 1,67,930 1,646 0.2 33585.98 329.27 Site 30 South West 190 Natural Gas kWh 34,500 32,547 38,375 36,518 38,056 27,310 22,643 19,572 37,562 43,339 44,451 39,117 4,13,989 2,179 0.2 82797.82 435.78 Site 31 Scotland 70 Natural Gas kWh 50,081 42,109 44,078 37,930 31,874 17,472 14,682 15,856 19,113 35,892 41,104 50,590 4,00,781 5,725 0.2 80156.18 1145.09 Site 32 Scotland 89 Natural Gas kWh 50,575 44,864 37,119 29,758 26,596 17,222 14,145 13,928 19,733 33,356

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

44,790 56,492 3,88,578 4,366 0.2 77715.61 873.21 Site 33 Scotland 103 Natural Gas kWh 38,219 27,897 32,645 35,010 18,058 20,526 25,208 23,568 24,101 32,525 33,821 33,293 3,44,872 3,348 0.2 68974.44 669.65 Site 34 Scotland 178 Natural Gas kWh 3,852 3,592 4,023 3,980 4,061 3,609 3,310 3,189 3,237 4,148 4,425 4,502 45,927 258 0.2 9185.36 51.60 Site 35 South East 116 Natural Gas kWh 50,200 44,167 45,299 40,615 35,761 22,368 18,588 24,821 21,154 31,702 47,107 47,035 4,28,818 3,697 0.2 85763.58 739.34 Site 36 North East 98 Natural Gas kWh 22,373 19,165 19,957 18,060 17,581 13,685 12,842 12,947 14,646 17,508 19,315 19,233 2,07,313 2,115 0.2 41462.61 423.09 Site 37 North East 179 Natural Gas kWh 32,945 31,980 31,902 24,027 17,000 7,915 5,839 5,888 9,055 17,234 26,199 31,500 2,41,484 1,349 0.2 48296.81 269.81 Site 40 North West 100 Natural Gas kWh 22,770 10,143 9,752 6,475 3,546 943 599 561 1,287 4,157 7,594 9,778 77,605 776 0.2 15521.04 155.21 Site 41 North East 111 Natural Gas kWh 29,008 6,776 6,776 6,776 15,611 11,724 10,048 9,389 10,164 17,086 19,338 19,896 1,62,591 1,465 0.2 32518.15 292.96 Site 42 North East 127 Natural Gas kWh 28,231 29,484 28,334 18,821 10,293 2,737 1,745 1,614 3,746 12,082 22,089 28,428 1,87,605 1,477 0.2 37521.01 295.44 Site 43 North East 85 Natural Gas kWh 55,705 48,938 54,776 44,916 36,585 21,634 18,544 18,733 23,429 34,879 46,941 52,732 4,57,814 5,386 0.2 91562.74 1077.21 Site 45 Midlands 110 Natural Gas kWh 10,977 11,904 11,868 8,936 6,324 2,945 2,169 2,193 3,371 6,409 9,753 11,719 88,567 805 0.2 17713.41 161.03 Site 46 Midlands 174 Natural Gas kWh 26,451 24,197 28,374 24,521 25,451 24,275 18,159 19,778 19,966 25,996 28,152 28,427 2,93,747 1,688 0.2 58749.40 337.64 Site 52 North West 64 Natural Gas kWh 86,809 80,316 79,449 63,069 62,189 24,112 29,858 36,672 26,666 63,772 76,205 91,647 7,20,764 11,262 0.2 144152.76 2252.39 Site 53 North West 50 Natural Gas kWh 14,051 13,643 13,603 10,248 7,250 3,374 2,488 2,515 3,860 7,348 11,171 13,433 1,02,983 2,060 0.2 20596.63 411.93 Site 54 North West 28 Natural Gas kWh 21,109 15,562 14,651 9,989 7,554 2,852 2,952 4,255 5,236 10,617 14,929 20,302 1,30,007 4,643 0.2 26001.49 928.62 Site 55 North West 74 Natural Gas kWh 5,746 8,864 4,982 5,135 2,812 12,985 5,995 5,770 4,654 8,797 10,573 10,378 86,690 1,171 0.2 17338.08 234.30 Site 57 North West 98 Natural Gas kWh 22,817 22,144 22,098 16,646 11,767 5,469 4,036 4,069 6,273 11,931 18,149 21,823 1,67,222 1,706 0.2 33444.34 341.27 Site 58 North West 19 Natural Gas kWh 16,026 13,935 12,004 10,259 9,429 5,703 5,723 5,927 5,046 7,606 13,169 16,500 1,21,327 6,386 0.2

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

24265.31 1277.12 Site 59 North West 117 Natural Gas kWh 19,078 17,895 18,130 16,768 18,655 13,917 10,326 11,799 10,762 16,842 17,874 16,443 1,88,490 1,611 0.2 37697.96 322.20 Site 61 North East 89 Natural Gas kWh 81,488 83,452 78,516 70,307 60,167 31,992 28,764 33,852 30,495 61,396 74,814 83,366 7,18,609 8,074 0.2 143721.83 1614.85 Site 62 North East 85 Natural Gas kWh 12,533 11,618 12,583 12,317 12,264 9,889 10,454 11,522 11,870 12,871 15,596 17,577 1,51,094 1,778 0.2 30218.78 355.52 Site 63 Midlands 77 Natural Gas kWh 46,253 21,837 21,778 2,159 2,159 2,159 2,159 2,159 2,159 10,858 11,097 9,331 1,34,105 1,742 0.2 26821.05 348.33 Site 64 Midlands 98 Natural Gas kWh 10,878 9,955 10,889 9,617 10,265 7,782 6,686 7,137 7,480 13,020 12,799 11,183 1,17,692 1,201 0.2 23538.36 240.19 Site 65 Midlands 162 Natural Gas kWh 1,02,332 87,532 86,230 66,746 68,394 10,027 6,402 76,245 31,360 61,209 87,942 96,562 7,80,981 4,821 0.2 156196.17 964.17 Site 66 South East 44 Natural Gas kWh 13,431 12,656 12,114 11,317 9,685 4,566 3,336 3,391 3,998 10,250 12,814 15,410 1,12,968 2,567 0.2 22593.64 513.49 Site 67 South East 242 Natural Gas kWh 24,865 23,421 26,788 24,403 27,910 21,206 18,592 18,407 18,771 29,010 29,780 28,508 2,91,660 1,205 0.2 58331.98 241.04 Site 68 Midlands 83 Natural Gas kWh 10,835 11,766 16,353 12,307 8,238 9,344 8,361 8,311 9,934 14,634 14,761 12,551 1,37,397 1,655 0.2 27479.35 331.08 Site 72 South East 173 Natural Gas kWh 38,462 10,765 27,299 26,640 26,685 27,842 28,341 28,659 25,883 36,091 36,282 36,615 3,49,564 2,021 0.2 69912.88 404.12 Site 74 Scotland 233 Natural Gas kWh 45,892 36,409 34,191 32,882 39,542 44,403 34,164 22,626 30,642 36,252 40,991 33,089 4,31,084 1,850 0.2 86216.82 370.03 Site 75 Midlands 120 Natural Gas kWh 26,007 24,200 26,111 26,159 21,512 16,953 18,450 18,152 22,007 27,082 27,175 27,032 2,80,839 2,340 0.2 56167.84 468.07 Site 76 South East 72 Natural Gas kWh 67,214 58,509 59,450 51,808 31,635 10,620 11,210 9,609 10,201 44,790 51,313 54,752 4,61,111 6,404 0.2 92222.14 1280.86 Site 77 South East 70 Natural Gas kWh 67,114 79,636 70,859 47,710 28,654 9,001 28,024 5,739 11,131 32,951 57,892 74,145 5,12,856 7,327 0.2 102571.12 1465.30 Site 78 North East 220 Natural Gas kWh 33,917 50,507 8,023 31,066 33,906 39,665 36,850 37,978 31,612 27,413 30,217 31,751 3,92,906 1,786 0.2 78581.21 357.19 Site 79 North East 106 Natural Gas kWh 18,299 17,216 18,829 17,526 17,455 12,955 12,842 12,788 13,321 19,662 21,256 19,690 2,01,840 1,904 0.2 40368.03 380.83 Site 80 North East 115 Natural Gas kWh 17,651 16,053 17,016 16,855 14,586 12,134

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

12,431 12,129 9,349 12,527 15,069 14,722 1,70,522 1,483 0.2 34104.36 296.56 To answer your questions, I will analyze the data you provided. However, the data you provided seems to be incomplete. It includes information such as region, beds, utility, and monthly electricity consumption, but it lacks data for the other questions related to energy efficiency, emissions, and carbon performance. If you can provide complete data or clarify your requirements, I will be able to assist you further. You t_opt=0.5 print("Threshold value is: %.2f" % t_opt) y_pred = (xgb_model.predict_proba(train.drop(columns=['loan_id','month',' paid_flag','allocation_month','year']))[:,1] >=t_opt).astype(bool) y_test_pred = (xgb_model.predict_proba(val.drop(columns=['loan_id','month','pa id_flag','allocation_month','year']))[:,1] >=t_opt).astype(bool) ## training data classification report print(metrics.classification_report(train['paid_flag'], y_pred)) print(metrics.confusion_matrix(train['paid_flag'], y_pred)) I want the that threshold "t_opt" have selected currently = 0.5 I want that for eac threshold bet 0.1 to 1.0 there should be distribution curve for both To create a distribution curve for precision and recall for different threshold values, you can use a loop to iterate over a range of threshold values from 0.1 to 1.0. For each threshold value, calculate the precision and recall using classification_report from the sklearn.metrics module. Then, plot the precision and recall values on a graph to visualize the distribution curve. Here's an example code snippet to help you get started: pythonCopy code import numpy as np import matplotlib.pyplot as plt from sklearn import metrics thresholds = np.arange( 0.1 , 1.1 , 0.1 ) precision_values = [] recall_values = [] for threshold in thresholds: y_pred = (xgb_model.predict_proba(train.drop(columns=[ 'loan_id' , 'month' , 'paid_flag' , 'allocation_ month' , 'year' ]))[:, 1 ] >= threshold).astype( bool ) precision, recall, _, _ = metrics.precision_recall_fscore_support(train[ 'paid_flag' ], y_pred, average= 'binary' ) precision_values.append(precision) recall_values.append(recall) plt.plot(thresholds, precision_values, label= 'Precision' ) plt.plot(thresholds, recall_values, label= 'Recall' ) plt.xlabel( 'Threshold' ) plt.ylabel( 'Score' ) plt.legend() plt.title( 'Precision and Recall Distribution' ) plt.show() This code will generate a line plot with the threshold values on the x-axis and the precision and recall values on the y-axis. The

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

precision values will be represented by one line, and the recall values will be represented by another line. The precision_recall_fscore_support function is used to calculate precision and recall, and the average='binary' parameter ensures that binary classification metrics are computed. You can customize the plot further based on your preferences, such as adding axis labels, a legend, and a title. You write a python fnction that plot a distribution plot for a data Certainly! Here's an example of a Python function that plots a distribution plot for a given dataset using the seaborn library: pythonCopy code import seaborn as sns import matplotlib.pyplot as plt def plot_distribution ( data ): sns.histplot(data, kde= True ) plt.xlabel( 'Values' ) plt.ylabel( 'Density' ) plt.title( 'Distribution Plot' ) plt.show() This function takes a dataset ( data ) as input and uses the sns.histplot function from the seaborn library to create a distribution plot. The kde=True parameter adds a kernel density estimation curve to the plot. You can use this function by passing your dataset as an argument. For example, if you have a list of values called my_data , you can call the function like this: pythonCopy code my_data = [ 1 , 2 , 3 , 4 , 5 ] plot_distribution(my_data) The function will display a distribution plot with the values from my_data . You can customize the plot further based on your requirements, such as adding axis labels, a title, or changing the styling using seaborn's available options. You allocation['allocation_dpd_value'].value_counts() Output:: 32.0 183 33.0 254 34.0 175 35.0 190 36.0 192 ... 1376.0 2 my data contain a value from 30+ dpd to 365+ I want such that it break the data into 3 parts : 30 to 90 , 91 to 180, 181 to 365+ and the I can have distribution plot or histogram plot for eah bucket 1378.0 1 1380.0 1 1382.0 1 1386.0 1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

To create three buckets based on the values in the allocation_dpd_value column and plot a distribution for each bucket, you can follow these steps: 1. Import the necessary libraries: pythonCopy code import seaborn as sns import matplotlib.pyplot as plt 2. Define a function to plot the distribution for each bucket: pythonCopy code def plot_bucket_distribution ( data, bucket_name ): sns.histplot(data, kde= True ) plt.xlabel( 'Allocation DPD Value' ) plt.ylabel( 'Density' ) plt.title( f'Distribution Plot - {bucket_name}' ) plt.show() 3. Split the data into three buckets based on the specified ranges (30-90, 91-180, 181-365) using the pd.cut() function: pythonCopy code import pandas as pd bucket_labels = [ '30-90' , '91-180' , '181-365' ] buckets = pd.cut(data[ 'allocation_dpd_value' ], bins=[ 30 , 90 , 180 , 365 ], labels=bucket_labels) 4. Plot the distribution for each bucket: pythonCopy code for bucket in bucket_labels: bucket_data = data[buckets == bucket] [ 'allocation_dpd_value' ] plot_bucket_distribution(bucket_data, bucket) Here's the complete code snippet that incorporates the above steps: pythonCopy code import seaborn as sns import matplotlib.pyplot as plt import pandas as pd def plot_bucket_distribution ( data, bucket_name ): sns.histplot(data, kde= True ) plt.xlabel( 'Allocation DPD Value' ) plt.ylabel( 'Density' ) plt.title( f'Distribution Plot - {bucket_name}' ) plt.show() # Assuming 'allocation' is the DataFrame containing the data bucket_labels = [ '30-90' , '91-180' , '181-365' ] buckets = pd.cut(allocation[ 'allocation_dpd_value' ], bins=[ 30 , 90 , 180 , 365 ], labels=bucket_labels) for bucket in bucket_labels: bucket_data = allocation[buckets == bucket][ 'allocation_dpd_value' ] plot_bucket_distribution(bucket_data, bucket) Make sure to replace 'allocation' with the actual name of your DataFrame containing the data. The code will create three distribution plots, one for each bucket, based on the specified ranges. C

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version