P/E value and Categories Update

Ed Chao

·

Follow

1 min read

·

Sep 8, 2020

--

Listen

Share

## P/E value and category
from datetime import date, datetime, timedelta
import pandas as pddef pevalue(warning_list):
    today = datetime.today().strftime('%Y%m%d')
    url = 'https://www.twse.com.tw/exchangeReport/BWIBBU_d?response=html&date=' + today + '&selectType=ALL'
    path = 'D:/00_我在管院研究所的日子/94_TWSE/PE/'
    filename = today + 'PE_Ratio.csv'
    df = pd.read_html(url, flavor = 'bs4')
    df = df[0].reset_index(drop = True)
    df.columns = ['ticker', 'company', 'interest', 'year', 'pe', 'ratio', 'd']
    df = df[['ticker', 'company', 'interest', 'pe', 'ratio']]
    df.ticker = df.ticker.astype('str')
    df.to_csv(path+filename, index = None, encoding = 'utf-8_sig')
    for i in range(len(warning_list)):
        for j in range(len(df)):
            if warning_list.股票代號[i] == (df.ticker[j] + '.TW'):
                warning_list.本益比[i] = df.pe[j]
                warning_list.股價淨值比[i] = df.ratio[j]
    return warning_listdef category(category_list)
    for i in range(len(warning_list)):
        for j in range(len(category_list)):
            if warning_list.股票代號[i] == category_list.類別[j]:
                warning_list.類型[i] = category_list.類型[j]
    return warning_list## main
today = datetime.today().strftime('%Y-%m-%d')
path1 = 'D:/00_我在管院研究所的日子/94_TWSE/財山短訊/'
file1 = today + '-財山短訊.csv'
path2 = 'D:/00_我在管院研究所的日子/94_TWSE/財山短訊/'
file2 = 'Stock_list(1090825).xlsx'
warning_list = pd.read_csv(path1 + file1)
category_list = pd.read_excel(path2 + file2)
pevalue(warning_list)
category(category_list)
warning_list.to_csv(path1 + file1, index = False, encoding = 'utf-8_sig')