{"id":76,"date":"2017-09-30T19:43:47","date_gmt":"2017-09-30T17:43:47","guid":{"rendered":"https:\/\/www.pschatzmann.ch\/home\/?p=76"},"modified":"2020-11-21T22:22:53","modified_gmt":"2020-11-21T21:22:53","slug":"edgar-introduction-with-pandas","status":"publish","type":"post","link":"https:\/\/www.pschatzmann.ch\/home\/2017\/09\/30\/edgar-introduction-with-pandas\/","title":{"rendered":"EDGAR Filing Data Analysis – An Introduction with Pandas"},"content":{"rendered":"
\n
\n
<\/div>\n
\n
<\/div>\n
\n
\n

Edgar can be used to analyse the financials of a single company over time.
\nHowever, we try to get an overall picture of the profits over all companies.<\/p>\n

For this we use the Python Data Analysis Library Pandas<\/a> and my simple Edgar REST API<\/a>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
In\u00a0[199]:<\/div>\n
\n
\n
\n
import<\/span> pandas<\/span> \nimport<\/span> matplotlib.pyplot<\/span> as<\/span> plt<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
Profits by Country\u00b6<\/a><\/h1>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n
\n
\n
We can get a quick overview with the help of the follwing REST get request. We ask for countries by year and we limit the data to the first top 14 (+ 1 for all others) most important entries:<\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
In\u00a0[200]:<\/div>\n
\n
\n
\n
url<\/span> =<\/span> 'https:\/\/pschatzmann.ch\/edgar\/values?format=csv&col=country&row=year&parameter=NetIncomeLoss&n=15'<\/span>\ndf<\/span> =<\/span> pandas<\/span>.<\/span>read_csv<\/span>(<\/span>url<\/span>,<\/span> sep<\/span>=<\/span>\";\"<\/span>,<\/span> index_col<\/span>=<\/span>0<\/span>)<\/span>\ndf<\/span>\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
Out[200]:<\/div>\n
\n
\n