[Concept Class] Learn and Immediately Use Pandas

You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

Train SQL queries with 50 diverse problems, preparing for real analysis environments and coding tests. * If you're new to SQL, taking the SQL [Concepts Course] first will help you follow along easily.

Train SQL queries through 50 diverse problems and prepare for real-world analysis environments and coding tests. * If you are new to learning SQL, you will be able to follow along without difficulty by first taking SQL [개념반].

Quickly learn the core of Python, the most chosen language for programming beginners, and try making programs yourself with the AI code tool, Cursor.

How do the sites we access every day work? Before we start studying data in earnest, let's take some time to learn about servers and the Internet, which are the background knowledge of IT.

This lecture guides you through data analysis using Python and how to apply it to the IT security field.

Pandas is one of the most widely used libraries in Python. Pandas, which has become an essential element for data analysis, you can learn everything about Pandas, the essential library for Python data analysis, through the <Pandas in One Shot> lecture.

AI that thinks and adapts? Now you can build it yourself. Master the core of reinforcement learning with intuitive explanations and code, not complex theories, and grow into a 'practical developer' through finance and industry projects.

With Python Quant Investment, you can create investment strategies based on data and invest according to the strategy. You can implement various asset allocation strategies and ultimately create your own investment strategy.

Finally, a probability and statistics course for everyone is here! Learn the principles of probability and statistics step by step through theory and coding practice.

Leveraging Python's basic syntax and popular libraries Auto-generating Python syntax and library code using ChatGPT

In Part 3 of Creating a Python Trading Room for Quant Investment, you will learn about portfolio theory and concepts necessary for real investment, as well as how to implement them with code. In Parts 1 & 2, you mainly learned about code implementation methods for analyzing financial data, and in Part 3, you will learn about 'portfolios', which are an important part of quantitative investment. With the question of why you should create a portfolio, you will learn portfolio theory, implement it in Python, and practice the code necessary for real portfolio investment. I hope this lecture will be helpful for your own portfolio investment.

If you're just learning Python and don't know what you can do or what you should do? Let's learn how to use web technologies with Python, such as web crawling, automation, and APIs.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

Revolutionize your stock investments with AI! In this lecture, you will directly build a real, working AI automated trading system targeting the top 25 NASDAQ stocks. We provide a special opportunity to gain experience and know-how through simulated investments with the 한국투자증권 API, and to perform AI stock automated trading with a real account. Even stock beginners will have no problem. We will easily explain basic stock concepts and why you should invest in US stocks, and provide all source code and remote support. From now on, investment is essential for the next 60 years of our lives. Create your own AI investment partner that will be with you!

This course is a course that practices the basics of machine learning mathematics and statistics using Python. Machine learning and deep learning require programming skills, but they also require a mathematical background to understand the principles. Through this course, you can gradually learn the basic mathematics required for artificial intelligence.

Unlike existing lectures, this course has been newly designed based on the instructor's initial failures in learning machine learning, enabling easy understanding and application to real-world problems.

In this class, you will learn techniques for retrieving (crawling) and processing data from various operating sites using Python, and apply them directly to various examples that you may encounter in the field. Through this, you will learn techniques that focus on solving practical problems based on an understanding of the basic principles of how the web works, rather than one-dimensional task automation by copying and pasting given codes, and accordingly, you will be able to collect and process data from any site in the future. You will also learn how to resolve various exceptions that occur in this process with code, and ultimately, you will be able to solve and automate various problems that occur in daily life with programming thinking.

This lecture is for beginners who are new to coding, as well as those who want to try out various uses of Python, covering basic concepts of Python, Numpy, Pandas, Plotly, Django, and crawling, as well as simple data analysis.

Learn a systematic approach to S&P 500 pair trading with Python. Lay the foundation for an investment strategy that excludes emotions through professional data analysis.

You can create a deep learning analysis environment in the cloud using Docker. When Docker images managed by Google, MS, etc. are combined with the cloud, you can work with the latest deep learning analysis methods on your computer.

Introductory lecture on recommendation systems by Datalian, who has over 10,000 cumulative students and rich online/offline lecture experience. Learn the basic theory of recommendation systems and practice movie data analysis together.

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.

🚀 Practical AI Anomaly Detection with Databricks! 💡 Stop using expensive and slow models! From large-scale data optimization to real-time deployment, complete an anomaly detection AI that can be used immediately in corporate practice.

This is a basic course on Python Excel programming that you can learn with the xlsxwriter tutorial. You can analyze data and automate tasks using Python and Excel.