Importing an Excel into Jupyter Notebook- Financial Statement Analysis
#Financialstatementanalysis
Please watch Taewoo's videos here, and thank you for inspiring me to code!
/ taewookim
Time Stamps
0:00 Introduction
1:22 Things to know before starting
3:35 Going through the code
Code (cleaned up)
Install whats needed
conda install pandas
maybe add a ! (!Conda) if it does not install at first
import pandas as pd
Import in excel
df= pd.read_excel(r'C:/location of your file')
df.dropna(how='all', inplace=True)
index_PL= df.loc[ df["Data provided by SimFin"]=='Profit & Loss statement'].index [0]
index_CF= df.loc[ df["Data provided by SimFin"]=='Cash Flow statement'].index [0]
index_BS= df.loc[ df["Data provided by SimFin"]=='Balance Sheet'].index [0]
1.4 PL statement
df_PL=df.iloc[index_PL:index_BS-2,1:]
df_PL.columns = df_PL.iloc[0]
df_PL.set_index("in million USD",inplace=True)
df_PL.fillna(0, inplace=True)
df_PL=df_PL[1:]
1.5 BS
df_BS= df.iloc[index_BS-1:index_CF-3,1:]
df_BS.columns = df_BS.iloc[0]
df_BS.set_index("in million USD",inplace=True)
df_BS.fillna(0, inplace=True)
df_BS=df_BS[1:]
1.6 CF
df_CF= df.iloc[index_CF-2:,1:]
df_CF.dropna(how='all',inplace=True)
df_CF.columns = df_CF.iloc[0]
df_CF = df_CF[1:]
df_CF.set_index("in million USD",inplace=True)
df_CF.fillna(0,inplace=True)
Follow my Instagram!
/ palmtreeinvestments01
Beats made by Jawkward, check him out here
/ jawkward
Art and Animation made by JP, check him out here
/ redheadbandits
Disclaimer: I'm not a licensed investment advisor, and today's video (and spreadsheet) is just for entertainment and fun. This video (and spreadsheet) is NOT investment advice. Also, I'm not a tax advisor and today's video (and spreadsheet) is NOT tax advice. Please talk to your licensed investment advisor before making any financial decisions. Please talk to your licensed tax advisor before making any tax decisions.
I make no representations as to the accuracy, completeness, suitability or validity of any information. I will not be liable for any errors, omissions, losses, injuries or damages arising from its display or use. All information is provided AS IS with no warranties, and confers no rights. I will not be responsible for the accuracy of material that is linked on this site.
Your continued reading/use of my YouTube Channel, blog, Excel files, and other materials constitutes your agreement with and acceptance of this disclaimer.
Title
Importing an Excel into Jupyter Notebook- Financial Statement Analysis
Tags
Importing an Excel into Jupyter Notebook- Financial Statement Analysis,palm tree investments,Taewoo kim,jupyter notebook financial statement analysis,python financial statement analysis,python financial analysis,jupyter notebook financial analysis,excel to python,excel to jupyter,financial statements python,financial statements jupyter,automate fsa,automate financial statement analysis