JerBouma
2/17/2019 - 3:27 PM

[Checking Specific Pieces of Data] Taken from Thesis but interesting to apply nontheless. #python #pandas

[Checking Specific Pieces of Data] Taken from Thesis but interesting to apply nontheless. #python #pandas

# Checking Why Interest Ratio is so High/Low
data = pd.read_csv("ThesisData.csv").round(2)
data.shape

df = data.dropna()
df.shape

Company = 'DORIAN LPG LTD'

df = df.loc[df['Company'] == Company]
df['Leverage_Ratio'] = round(df["Liabilities"] / df["Equity"],2)
df['EBITDA'] = round(df['Net_Income'] + df["Depr_Amo"] + df["Interest_Expense"],2)
df['Interest_Ratio'] = round(df["Interest_Expense"] / df["EBITDA"],2)

df