Programming Language

Programming Language/Python

[Python] 판다스 데이터프레임 이쁘게 출력하는 방법, tabulate

코드 import pandas as pd from tabulate import tabulate import os import warnings warnings.simplefilter("ignore") stock_file_list = os.listdir('./stock-data/2022-05') stock_file_list.sort() for stock_file in stock_file_list: df = pd.read_excel(f'./stock-data/2022-05/{stock_file}') df = df[['종목명', '종가', '등락률']] df.columns = ['종목명', f'종가_{stock_file[10:14]}', f'등락률_{stock_file[10:14]}'] globals()[f'{..

Programming Language/Python

[Python] 오늘을 기준으로 다음 주식 개장일이 언제인지 확인하는 방법

라이브러리 설치 pip install exchange_calendars 코드 import datetime import exchange_calendars as ecals XKRX = ecals.get_calendar("XKRX") print(XKRX.next_open(datetime.date.today()).strftime("%Y-%m-%d")) 결과 오늘은 2022년 5월 21일 토요일이기 때문에 다음 주식 개장일은 2022년 5월 23일 월요일이 맞다.

Programming Language/Python

[Python] 오늘이 주식 개장일인지 확인하는 방법

라이브러리 설치 pip install exchange_calendars 코드 import datetime import exchange_calendars as ecals XKRX = ecals.get_calendar("XKRX") print(XKRX.is_session(datetime.date.today())) 결과 오늘은 2022년 5월 21일 토요일이기 때문에 False 값으로 떨어진다.

Programming Language/Python

[Python] 해당 날짜가 주식 개장일인지 확인하는 방법

라이브러리 설치 pip install exchange_calendars 코드 import exchange_calendars as ecals XKRX = ecals.get_calendar("XKRX") print(XKRX.is_session("2022-05-04")) print(XKRX.is_session("2022-05-05")) print(XKRX.is_session("2022-05-06")) 결과 5월 5일은 어린이날이여서 개장하지 않았음을 알 수 있다.

Programming Language/Python

[Python] UserWarning: Workbook contains no default style, apply openpyxl's default warn("Workbook contains no default style, apply openpyxl's default")

파이썬 사용중 다음과 같은 에러가 발생 UserWarning: Workbook contains no default style, apply openpyxl's default warn("Workbook contains no default style, apply openpyxl's default") 원본 코드는 다음과 같다. import pandas as pd df = pd.read_excel('./stock-data/kospi_20220520.xlsx') print(df) 다음과 같이 수정하면 경고 뜨지 않음 import pandas as pd import warnings warnings.simplefilter("ignore") df = pd.read_excel('./stock-data/kospi_20220..

Programming Language/Python

[Kaggle] London Bike, RNN and LSTM

https://www.kaggle.com/datasets/hmavrodiev/london-bike-sharing-dataset London bike sharing dataset Historical data for bike sharing in London 'Powered by TfL Open Data' www.kaggle.com import numpy as np import pandas as pd import matplotlib.pyplot as plt %matplotlib inline import os for dirname, _, filenames in os.walk('/kaggle/input'): for filename in filenames: print(os.path.join(dirname, file..

Programming Language/Python

[Kaggle] 런던 자전거 데이터 세트, 시계열 딥러닝 전 데이터 전처리 정리

https://www.kaggle.com/datasets/hmavrodiev/london-bike-sharing-dataset London bike sharing dataset Historical data for bike sharing in London 'Powered by TfL Open Data' www.kaggle.com import numpy as np import pandas as pd import matplotlib.pyplot as plt %matplotlib inline import os for dirname, _, filenames in os.walk('/kaggle/input'): for filename in filenames: print(os.path.join(dirname, file..

Programming Language/Python

[Kaggle] 런던 자전거 데이터 세트, 시계열 딥러닝 전 데이터 전처리해보기

https://www.kaggle.com/datasets/hmavrodiev/london-bike-sharing-dataset London bike sharing dataset Historical data for bike sharing in London 'Powered by TfL Open Data' www.kaggle.com import numpy as np import pandas as pd import matplotlib.pyplot as plt %matplotlib inline import os for dirname, _, filenames in os.walk('/kaggle/input'): for filename in filenames: print(os.path.join(dirname, file..

Programming Language/Python

[Kaggle] 런던자전거 - 머신러닝, 딥러닝 모델 비교해보기

https://www.kaggle.com/datasets/hmavrodiev/london-bike-sharing-dataset London bike sharing dataset Historical data for bike sharing in London 'Powered by TfL Open Data' www.kaggle.com import numpy as np import pandas as pd import matplotlib.pyplot as plt import seaborn as sns import missingno as msno import os for dirname, _, filenames in os.walk('/kaggle/input'): for filename in filenames: prin..

박경태
'Programming Language' 카테고리의 글 목록 (14 Page)