
파이썬 판다스(pandas)로 데이터 분석 및 가공하기
Kyeongrok Kim
판다스(pandas)를 이용해 실전에서 많이 나오는 데이터 처리 패턴을 배워보고 처리한 데이터를 분석해봅니다.
초급
Python, Pandas
This lecture is a comprehensive course that covers the entire process of stock backtesting using Python from start to finish.

You can go a little further with basic Python syntax.
Learn the basics of using MySQL and MySQL Workbench.
👩💻 From building a backtest database to writing a library !
Learn how to write and implement algorithms carefully . 👨💻
In this lecture, we'll use Python to build a backtest database and create a backtest library that allows you to backtest your own algorithms. (This isn't an algorithm lecture on buy and sell signals!)
As you'll see in the section on creating buy and sell signals, there's a lot more to consider when developing a trading algorithm than you might think. While there are certainly many excellent packages for backtesting, achieving a high degree of freedom requires developing your own backtesting program or possessing a significant understanding of backtesting libraries. For that reason, I've created my own backtesting program to ensure that after taking this course, you can implement everything you imagined.
Above all, I hope that after taking the course, you will learn to treat your own data critically !
In this lecture...
1 Learn basic SQL statements while building your own database (MySQL) .
2 I think those who have just finished learning Python will feel more confident in Python if they listen to this!
(The course is structured so that you can take it even after completing only the basic Python grammar .)
3. I hope that as you take the course with me, you will learn that although writing an algorithm that performs backtesting may seem simpler than you think, there are many things to consider.
4 Learn how to create a basic GUI using Python, and how to use matplotlib, pandas, and mysql-connector-python .
The lectures were written with a focus on practical training as much as possible, and the entire lecture is organically connected, so I hope you will follow along and proceed.
In total, we create two GUIs (graphical user interfaces).
• The program below updates our MySQL database.
• The program below is a program that performs backtesting.
Q. How much weight is given to trading algorithms in the course?
A. This course will focus almost entirely on trading algorithms. Its purpose is to teach beginners how to build a stock price database and how to write a backtesting program.
Q. Can I immediately apply my own backtesting algorithm after taking the course?
A. It depends on your level of understanding, but I personally believe that if you fully understand this lecture, you'll be able to begin backtesting your own algorithm. However, as I've repeatedly emphasized throughout the lecture, even simple-looking trading algorithms require considerable attention to detail when actually developing a program.
Q. Is it okay to follow the lecture even if I don't have a high level of understanding of Python syntax?
A. Yes, I tried to cover the basic grammar so that as many people as possible can understand it, and I also organized the parts that may be confusing since I just finished learning Python grammar.
Who is this course right for?
For those who have just finished learning Python grammar and are at a loss as to what to do
For those who want to start backtesting with Python
Need to know before starting?
Basic Python Grammar
All
56 lectures ∙ (13hr 59min)
Course Materials:
4. SQL Practice (1)
13:55
5. SQL Practice (2)
17:36
6. SQL Practice (3)
12:12
All
14 reviews
4.6
14 reviews
Reviews 2
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 2.5
4
제가 연령대가 있는 수강자 임에도 불구 하고 어렵다 라는 느낌은 없었던 좋은 강의 였습니다. 강사님이 전체적으로 아주 쉽게 설명 해주실려고 하셨고 딕션도 나름 정확하게 해주실려고 노력을 많이 하시는것 같았습니다. 아쉬운 점은 동영상 녹화시 너무 큰 화면을 이용하셔서 코드를 보기가 쉽지 않았고 질문 피드백이 만족 스럽지 못했다 는게 단점으로 생각해서 별 하나는 빼고 점수를 드렸습니다. 하지만 여타 환경상의 문제 외는 백테스트 라는 녀석을 하기 위한 초석은 여기서 잡게 되어 너무 좋았습니다. 앞으로는 좀더 세세한 동영상 환경에서 피드백이 잘 이루어지는 컨텐츠를 개발 해주시기를 바라고 만약 강의가 나온다면 100% 강의 할것입니다
Reviews 1
∙
Average Rating 3.0
3
강의 내용은 좋은 듯 합니다. 글자가 너무 작고, 코드 공유 안되는 게 학습에 큰 어려움이 있네요. 다른 강의 및 책들은 대부분 코드 공유하는데 아쉽습니다. 강의를 따라하면서 실행이 안되면 강사님 코드 보면서 뭘 잘 못 기입했나 하면서 봐야 되는데 강의를 매번 돌려가면서 파악해야 합니다. 특히나 지난 회차 강의는 특히나 찾아 보기 어렵네요. 다른 분도 코드 공유 요청하셨지만 코드 누출 여부 때문에 어렵다고 하신 부분 봤지만... 공감하기 어렵네요. 아니면 강의가 편하게 편집되어 있었으면...이런 요청도 없을 테지만요.. 아쉽습니다. 그래도 꼭 필요한 강의라서 완강하고 열심히 듣겠습니다.
죄송합니다. 처음 찍었던 강의라 부족한 부분이 많았던 것 같습니다. 다음에 혹시 강의를 찍게 된다면 코드도 공개하고 더 큰 폰트로 촬영하도록 하겠습니다.
Reviews 1
∙
Average Rating 5.0
Explore other courses in the same field!