import requests
import pandas as pd
from utils import *
class Py38():
def __init__(self):
super().__init__()
def ipo(self):
url = 'https://www.38.co.kr/html/fund/index.htm?o=k'
page = requests.get(url, headers=headers())
tables = pd.read_html(page.text, match='공모주 청약일정')
for idx, r in tables[4].iterrows():
if not pd.isna(r['종목명']) and len(r['종목명']) < 50:
print(r)
pass
if __name__ == "__main__":
k38 = Py38()
k38.ipo()
종목명 나라셀라
공모주일정 2023.05.22~05.23
확정공모가 -
희망공모가 20,000~24,000
청약경쟁률 NaN
주간사 신영증권
분석 NaN
Unnamed: 7 NaN
Name: 1, dtype: object
.....................................