Python and Pandas: The Essentials, Quickly Explained for Beginners

From the basics of Numpy and Pandas to data preprocessing, visualization, and crawling, all in one place! This is an introductory Python course for data analysis.

Using pandas, we will learn data processing patterns that frequently appear in real-world situations and analyze the processed data.

This is a Python coding test lecture centered on problem solving, tailored to those who are new to coding tests.

Do you want to master the Python language? This course is designed to help even those with no coding experience learn Python easily through fun examples. In addition, the extensive coding exercises will greatly help improve your coding skills.

Learn NoSQL technology for handling big data, one of the fundamental technologies used in the full-stack and data science fields at modern startups. MongoDB is one of the easiest NoSQL technologies to learn and use quickly. In this course, you will learn the basics of MongoDB in a short time, as well as how to work with and utilize MongoDB using Python.

This is an introductory course designed by SuCoding, an IT author and coding creator, using a stable learning method that ensures even non-majors can complete it without frustration. We have boldly removed complex theories and selected only the essential syntax to deliver a practice-oriented experience. Even if you are starting to code for the first time, by following the lecture to the end, you will be able to create your own programs using Python.

This course is for both beginners who have never been exposed to programming before and those who have some theoretical knowledge about Python. The main purpose of the course is to create interest and enjoyment in Python based on real projects. I hope that through this course, you will gain more ideas and have more fun with Python.

This course is a hands-on program for practicing the fundamentals of machine learning mathematics and statistics using Python. While machine learning and deep learning require programming skills, a mathematical background is necessary to understand the underlying principles. Through this course, you can step-by-step master the foundational mathematics required for artificial intelligence.

This lecture is a follow-up lecture to 'Python Data-Based Stock Quant Investment Part 1'. If Part 1 was more of an introduction, Part 2 is an in-depth lecture that focuses on the entire flow of practical strategy implementation and quantitative investment development. This class focuses on advanced Pandas techniques for handling time series data, and how to implement signal-based strategies and static/dynamic asset allocation strategies that require adjusting asset weights at various intervals based on this. Furthermore, it goes beyond strategy implementation and learns about 'code framework' that directly verifies and backtests various investment strategies with minimal code modifications, how to extend this to improve it so that it can lead to actual investment, and what to watch out for in this process. In addition to the programming component, you can experience the best Python quant investment flow that you cannot find in investment books, blogs, YouTube, etc. by deeply covering theoretical contents such as the two types of return concepts (simple return, log return) and evaluation indicators related to backtesting.

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.

Solve coding test problems using Python.

Through this course, you will learn about SQL and databases, SQL syntax, database design for practical use, how to use databases through programming, and real-world applications of data analysis.

This hands-on course teaches you how to use AI to analyze sales and inventory data and create evidence-based ordering plans. You’ll learn how to clearly communicate your objectives, constraints, and desired outputs to AI, then apply those skills to sales analysis, demand forecasting, and multi-item order optimization. Using the provided training data, prompts, and code, you’ll verify calculation results and test the basis for your decisions by changing the conditions. By the end, you’ll complete an ordering plan for 30 products and a one-page decision-making report, which you can use for job preparation and to expand your practical skills.

Based on the instructor’s experience of struggling when first learning machine learning, this course has been newly designed—unlike conventional courses—to help you understand machine learning easily and apply it to real-world problems.

We will develop a web app that collects data using concurrent/parallel programming in Python, loads it into MongoDB, analyzes it, and visualizes the collected data using FastAPI, a modern web framework. In the process, you will learn and understand Python concurrent/parallel programming using coroutines, multi-threading, and multi-processing, and understand how to use them to improve Python's performance. We will help you apply Python concurrent/parallel codes directly to your work. We will not only teach you how to develop and end, but also how to deploy and operate an actual app on the AWS cloud.

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.

In this class, you will learn about the principles and methods of analyzing and processing various types of financial data using Python's Pandas library, apply them to situations you may encounter in the real world, and ultimately learn how to implement backtesting based on financial statement data (based on Kang Hwan-guk's book, "You Can Do Quant Investment"). As a result, you can break away from being a "passive investor" who simply follows what others say without verifying or basing the investment logic, and become a "self-directed and active investor" who can freely extract various elements necessary for strategy implementation from data and quantitatively analyze them using Python and Pandas.

Now display Python results as web pages! You can create your own web page using only Python. This is an opportunity to create an Interactive Dashboard that allows you to check results created with Python, such as data analysis and machine learning, on a web page!

If you ask an AI to "build a model with this data," the first few lines might look plausible, but as soon as things get slightly complex, it starts using the wrong columns, introduces data leakage, and results in a model that performs worse despite a higher score. This course does not teach you better prompts. Instead, it covers how to directly design a loop (harness) where an agent understands data, plans, writes code, validates its own results, and backtracks when wrong. After manually walking through the five-piece loop of DS-STAR, you will assemble components one by one, from data profile cards, hooks, and skill hierarchies to independent validators and ablation.

We’ll guide non-majors and beginners to quickly earn the Big Data Analysis Engineer practical certification! Keep the theory light and the practical training solid. Even without complex background knowledge, you’ll focus on past exam questions and study only the key points that are sure to appear on the test.