Database for Beginners
ezdatascience
In this course, you will learn how to operate PostgreSQL and explore methods for integrating it with Python.
Basic
Python, PostgreSQL, SQLAlchemy
This course focuses on practical training in the core foundations of data analysis and data preprocessing using NumPy and Pandas. You will learn step-by-step, starting from Python's basic data structures to NumPy arrays and Pandas DataFrames, and master various processing techniques for analyzing real-world data. By practicing the most frequently used functions in data analysis—such as data cleaning, transformation, merging, and grouping—you can naturally improve your data preprocessing skills for machine learning. The course provides both conceptual explanations and hands-on exercises so that even beginners can easily follow along, allowing you to build a solid foundation for data analysis and machine learning.
4 learners are taking this course
Level Beginner
Course period Unlimited
You can handle data efficiently by utilizing Python lists and dictionaries.
You can perform NumPy array creation, indexing, slicing, and vectorized operations.
You can understand the concept of Broadcasting and apply it to actual data processing.
You can create Pandas Series and DataFrames and manage various types of data.
You can perform file I/O (CSV, etc.) and load data.
You can process data to suit your analysis purposes using data cleaning, merging, and grouping (GroupBy).
You can perform the data preprocessing steps for machine learning yourself.
This course provides a systematic way to learn data preprocessing techniques required for machine learning using NumPy and Pandas.
You can master the data structures and processing methods frequently used in practice, and learn how to transform various types of data into an analyzable format.
In this course, you will learn step-by-step from lists and dictionaries to NumPy arrays and Pandas DataFrames, allowing you to build a solid foundation in data analysis and machine learning.
This course is suitable for learners who want to start in the fields of data analysis, artificial intelligence (AI), machine learning, and data science.
Through this course, you will learn the following.
Understanding Python's List and Dictionary data structures
Data processing using lists and dictionaries
Creation and utilization of NumPy arrays
Array Indexing and Slicing
NumPy Array Modification and Vectorization
Principles and Applications of Broadcasting
Generating Random Numbers
Creating Pandas Series and DataFrames
DataFrame Indexing and Data Retrieval
File I/O such as CSV
Data selection and filtering
Data cleaning and processing
Merging multiple DataFrames (Merge, Concatenate)
Data grouping and aggregation using GroupBy
Data Preprocessing Practice for Machine Learning
Learners starting data analysis for the first time
Those who have learned basic Python syntax
Those who want to learn data preprocessing before learning machine learning
Those who are learning NumPy and Pandas for the first time
It is helpful if you know basic Python syntax (variables, conditional statements, loops, functions).
No specialized knowledge is required.
The lecture is conducted with a focus on hands-on practice.
It is recommended to practice together in a Python and Jupyter Notebook environment.
If you have any questions during the lecture, you can ask them through the inquiry section.
The lecture content may be continuously supplemented and updated as needed.
For a smooth learning experience, we recommend watching in 720p resolution or higher.
Who is this course right for?
Beginners starting data analysis for the first time
Those who want to learn data analysis after studying basic Python syntax
Learners who are new to NumPy and Pandas
Those who want to learn data preprocessing before starting machine learning
Students and developers preparing for a career in the field of data science
Need to know before starting?
It is helpful if you know basic Python syntax (variables, conditional statements, loops, functions).
No prior data analysis experience is required.
We recommend practicing in a Python and Jupyter Notebook environment.
The course proceeds step-by-step so that even beginners can follow along.
All
20 lectures ∙ (9hr 6min)
Course Materials:
2. List structure
28:38
3. Handling Lists
27:36
4. List loops
40:04
6. Package
20:36
8. NumPy array
27:54
12. Broadcasting
29:08
13. Random number
28:42
16. File I/O
23:18
17. Data reference
28:24
20. Data Grouping
20:56
Explore other courses in the same field!