練習 - 台泥的資產負債表

練習_台泥的資產負債表.py

import numpy as np
import pandas as pd
from pandas import Series, DataFrame
import requests

def get_fs_html(stock_no): 
    url = 'http://goodinfo.tw/StockInfo/StockFinDetail.asp?RPT_CAT=BS_M_QUAR&STOCK_ID=' + stock_no
    html = requests.get(url, headers={'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36'})
    return html


def get_table(html):
    targetTableIndex = 0
    table = pd.read_html(html.content,
                         attrs = {'class': 'solid_1_padding_3_4_tbl',},
                         header = 0
                        )[targetTableIndex]    
    return table


table = get_table(get_fs_html('1101'))
table.tail(2)

http://goodinfo.tw/StockInfo/StockFinDetail.asp?RPT_CAT=IS_M_YEAR&STOCK_ID=1101