What does this code do?

What percentage of debt to assets does this reflect?

What does the following code do? Please provide thoughts and conclusions.  

  

 

Transcribed Image Text:

#04.(i) pb_Lth_1['ROE']=all [ 'ROE'] pb_Lth_1['ROE' ]=pb_Lth_1['ROE'].fillna (0) pb_Lth_1[ 'roe_lvl'] =np.where(pb_Lth_1.ROE <0, 'ROE 0') pb_Lth_1 /var/folders/7y/2s0bb8ks1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: pb_Lth_1['ROE'] =all [ 'ROE'] /var/folders/7y/2s0bb8ks 1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py:3: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/ indexing.html#returning-a-view-versus-a-copy pb_Lth_1['ROE'] =pb_Lth_1['ROE'].fillna (0) /var/folders/7y/2s0bb8ks 1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py: 4: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy pb_Lth_1['roe_lvl'] =np. where (pb_Lth_1.ROE <0, 'ROE 0') industry priceTobook next_3months_ret next_6months_ret_pb_lvl_1 Marine Shipping 0.007926 0.850394 0.973819 symbol TOPS US EQUITY IVR US EQUITY RIG US EQUITY MFA US EQUITY 33 NYMT US EQUITY 3 11 15 16 https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy 4510 CVR US EQUITY C US EQUITY PRU US EQUITY 4835 RGA US EQUITY Insurance Reinsurance 4547 4663 4898 MSGE US EQUITY REITMortgage Oil & Gas Drilling REIT Mortgage REIT Mortgage Tools & Accessories Banks Diversified Insurance Life Entertainment 0.244829 0.827727 0.969364 0.997380 0.848168 0.543341 0.610864 0.997693 -0.078740 0.152985 0.480000 0.411430 0.387803 0.036923 0.088830 0.127978 0.262245 0.014413 0.383198 1.776000 0.563451 0.690909 0.358493 0.314018 0.311948 0.346270 0.438276 ROE roe_lvl pb <1 0.000000 ROE>0 pb <1-109.683902 ROE #04.(i) pb_Lth_1['ROE']=all [ 'ROE'] pb_Lth_1['ROE' ]=pb_Lth_1['ROE'].fillna (0) pb_Lth_1[ 'roe_lvl'] =np.where(pb_Lth_1.ROE <0, 'ROE 0') pb_Lth_1 /var/folders/7y/2s0bb8ks1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: pb_Lth_1['ROE'] =all [ 'ROE'] /var/folders/7y/2s0bb8ks 1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py:3: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/ indexing.html#returning-a-view-versus-a-copy pb_Lth_1['ROE'] =pb_Lth_1['ROE'].fillna (0) /var/folders/7y/2s0bb8ks 1md65hgctt8q2myr0000gn/T/ipykernel_50961/459020176.py: 4: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc [row_indexer, col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy pb_Lth_1['roe_lvl'] =np. where (pb_Lth_1.ROE <0, 'ROE 0') industry priceTobook next_3months_ret next_6months_ret_pb_lvl_1 Marine Shipping 0.007926 0.850394 0.973819 symbol TOPS US EQUITY IVR US EQUITY RIG US EQUITY MFA US EQUITY 33 NYMT US EQUITY 3 11 15 16 https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy 4510 CVR US EQUITY C US EQUITY PRU US EQUITY 4835 RGA US EQUITY Insurance Reinsurance 4547 4663 4898 MSGE US EQUITY REITMortgage Oil & Gas Drilling REIT Mortgage REIT Mortgage Tools & Accessories Banks Diversified Insurance Life Entertainment 0.244829 0.827727 0.969364 0.997380 0.848168 0.543341 0.610864 0.997693 -0.078740 0.152985 0.480000 0.411430 0.387803 0.036923 0.088830 0.127978 0.262245 0.014413 0.383198 1.776000 0.563451 0.690909 0.358493 0.314018 0.311948 0.346270 0.438276 ROE roe_lvl pb <1 0.000000 ROE>0 pb <1-109.683902 ROE