SpartaCodingClub - 금융인을 위한 파이썬 업무자동화 25기

완주 축하 이미지!

 

◎ 0주차

• 강의명: 금융인을 위한 파이썬 업무자동화 25기
• 기간: 2022년 11월 21일 (월) ~ 2022년 12월 26일 (월), 총 5주

완주할 수 있기를...

 

◎ 1주차

• Google Colaboratory (Colab) ⇒ 구글 계정으로 로그인 필요!!!

Welcome To Colaboratory

 

• !pip install bs4 requests 입력하여 설치

 

• !pip install openpyxl 입력하여 설치

 

• 1주차에서 순차적으로 사용한 import 구문들

import requests

from bs4 import BeautifulSoup

from openpyxl import Workbook

from datetime import datetime

import os

import urllib.request

import openpyxl

 

◎ 2주차

• !pip install pandas numpy 입력하여 설치

 

• !pip install yfinance 입력하여 설치

 

• yfinance - PyPI

yfinance

 

• 2주차에서 순차적으로 사용한 import 구문들

import pandas as pd

import numpy as np

import yfinance as yf

 

• Errors & Warnings #01

[Jupyter Notebook] FutureWarning: Passing a set as an indexer is deprecated and will raise in a future version. Use a list inste

 

• Errors & Warnings #02

[Jupyter Notebook] SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame.Try using .loc[row_

 

• Errors & Warnings #03

[Jupyter Notebook] FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. (

 

◎ 3주차

• 전자공시 OPENDART 시스템

전자공시 OPENDART 시스템

 

• !pip install dart-fss 입력하여 설치

 

• 3주차에서 순차적으로 사용한 import 구문들

import dart_fss as dart_fss

import pandas as pd

 

• Errors & Warnings #04

[Jupyter Notebook] ImportError: cannot import name 'MutableSet' from 'collections' (/usr/lib/python3.10/collections/__init__.py)

 

• Errors & Warnings #05

[Jupyter Notebook] AttributeError: module 'collections' has no attribute 'MutableMapping'

 

• dart-fss documentation

DART-FSS — dart-fss documentation v0.3.10 documentation

 

• Errors & Warnings #06

[Jupyter Notebook] ValueError: Unable to parse string "-" at position 78

 

• Errors & Warnings #07

[Jupyter Notebook] ValueError: If using all scalar values, you must pass an index

 

◎ 4주차

• !pip install yfinance pandas-datareader finance-datareader 입력하여 설치

 

• 4주차에서 순차적으로 사용한 import 구문들

from pandas_datareader import data as pdr


import yfinance as yf

yf.pdr_override()


import numpy as np

import pandas as pd


import FinanceDataReader as fdr

 

• 네이버 금융

네이버 금융

 

• !pip install matplotlib 추가 입력하여 설치

 

• Errors & Warnings #08

[Jupyter Notebook] ValueError: Cannot set a DataFrame with multiple columns to the single column ma2

 

◎ 5주차

• !pip install yfinance pandas-datareader finance-datareader 입력하여 설치

 

• !pip install dart-fss 입력하여 설치

 

• 5주차에서 순차적으로 사용한 import 구문들

from pandas_datareader import data as pdr


import yfinance as yf

yf.pdr_override()


import numpy as np

import pandas as pd


import FinanceDataReader as fdr

========================================

import dart_fss as dart_fss

import pandas as pd