강의

멘토링

로드맵

BEST
Data Science

/

Data Analysis

Pandas for Data Analysis: From Basics to Data Analysis

Datarian's Pandas basic course with over 10,000 cumulative students and rich online/offline lecture experience. Learn Pandas, Python's representative data analysis library, systematically with official documentation. You can also improve your proficiency by learning theories and solving problems in parallel.

(4.8) 32 reviews

375 learners

Pandas

Reviews from Early Learners

What you will learn!

  • Processing data with Pandas

  • Analysis and visualization using Pandas

  • Improve your Pandas proficiency by solving problems

Pandas for data analysis,
Get a solid understanding with the official documentation!

Pandas, why should I learn it?

Using the Python library, Pandas
You can analyze data easily and conveniently.

When data analysts conduct analysis in Python, the first thing they typically do is import the Pandas library . Whether it's visualization, machine learning, or applying statistical models, preprocessing data to create a suitable format is essential. Pandas is the library (package) most specialized for this data handling process, and is therefore the most widely used.

Get started with Pandas, the essential Python data analysis course, with Datarian!

✔️ Course Roadmap


What makes this course special?

Use the official Pandas documentation.

We'd all agree that "Googling is essential" when coding. While the web offers a wealth of documentation for information, the official documentation is by far the best. It offers precise terminology and usage guidelines. Even those already proficient with Pandas are often surprised by the official documentation, exclaiming, "Wow, there's such a great feature!"

For those of you just starting out with Pandas, why not start with the official documentation, the best textbook ever? Our course will serve as a guide to help you on this journey. You'll learn by reading the official documentation, following along with example code, and adding additional explanations.


Comparisons with SQL and Excel help you understand quickly.

The data Pandas handles is a "two-dimensional data frame." While the term "two-dimensional data frame" might sound unfamiliar, it's actually a concept you're already familiar with. Think of it as tabular data, like those often seen in spreadsheets like Excel. If you're familiar with SQL tables, you'll understand it even better.

Because Pandas is a tool that handles similar data types, it often offers similar, or even more powerful, features than SQL and Excel. That's why, when learning a new function, I've included comparisons with SQL or Excel. Learning by comparing it to what you already know will make it easier and faster to understand, right?

This course is helpful for those who are starting Python to do more in-depth analysis and visualization than what can be done with SQL, or for those who need Pandas to handle large amounts of data that cannot be imported into Excel, or for those who are already using other tools.

Q. SQL, is it something I absolutely need to know?

I recommend starting with SQL first, but if you have experience with Excel, I don't think you'll have much difficulty understanding the lecture :)

Excel, Pandas, and SQL are all similar tools in that they handle tabular data with rows and columns . Their supported features are also very similar. The official documentation, which is also included in the lecture, requires no prior knowledge of any language other than Python. While some concepts common to SQL when working with data tables, such as joining two tables using common keys and group-by operations, are omitted from the video, supplementary material is provided at the bottom of the video. If you've watched the sample lecture and thought, "This is worth a try," that's enough.


Improve your skills by solving problems together.

Seeing is believing! Learning is only as effective as practicing. Take the time to truly understand and master the grammar you've learned, understanding the specific situations and tasks for which it's applicable.

At the end of each section, we'll provide a list of problems that allow you to practice the functions you've learned in that section. We encourage you to pause the lecture and review by solving the problems. We'll also share the solution process in the final video, "Problem Solving," of each section. The final section consists of problems that synthesize everything you've learned so far, so let's keep going!


Recommended students

Pandas
Systematically
Anyone who wants to understand

With problem solving
Pandas
Those who want to study

When using SQL
Analysis area with Python
Those who want to expand

Spreadsheets such as Excel
I tried it
Anyone who wants to learn Pandas


The curriculum
Please check it out.

Pandas Warm Up!

We'll learn about Google Colaboratory (Colab), the platform we'll use in this course, and then work through the official Pandas documentation. We'll explore the steps involved in loading and saving data with Pandas, and learn how to select specific columns and rows.

Data Exploration A to Z.

We'll use Pandas to create simple visualizations to understand data trends and flows. You'll also learn how to create new columns by calculating values from existing columns, perform necessary calculations, and aggregate and scale data.

Data organized into tables!

Learn how to transform and sort tables, link with Google Spreadsheets, and create pivot tables for data. You'll also learn how to link rows from multiple tables and combine them using common columns.

Various types of data are also OK.

We'll learn how to handle time series data and textual data, and even how to use regular expressions to find specific patterns.


Datarian Team
Interested in other lectures?

Seeing is believing!
Datalian SQL Series

Basic SQL for Data Analysis (Click)

Intermediate SQL for Data Analysis (Click)

Python Series for Data Analysis

Python for Data Analysis: From Beginners to Tips (Click)

Recommended for
these people

Who is this course right for?

  • For those who want to understand Pandas systematically

  • For those who want to study Pandas with problem solving

  • For those who are currently using SQL and want to expand their analysis area with Python

  • Those who have used spreadsheets such as Excel and want to learn Pandas

Need to know before starting?

  • Basic Python (understanding of data structures such as list, dict, etc.)

Hello
This is

32,037

Learners

2,773

Reviews

23

Answers

4.9

Rating

37

Courses

실무 경험이 탄탄한 현업 분석가들이 데이터 분석 교육을 기획하고, 직접 강의합니다.

데이터리안에 대해서 더 알아보고 싶다면

👉 https://datarian.io/

Curriculum

All

56 lectures ∙ (6hr 25min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

32 reviews

4.8

32 reviews

  • tomorrow29986587님의 프로필 이미지
    tomorrow29986587

    Reviews 1

    Average Rating 5.0

    5

    70% enrolled

    Teacher, you are really the best! Thank you so much... The reference materials you show us during class are so good that I didn't know there was something like this... I'm just gratefulㅠ I think it would be good if you release more Python lectures...!!!!

    • sunmiyoon
      Instructor

      Sangyeol, who left this course review, is the best. Thank you so much... I'm so happy that you found the reference materials useful. I'm working hard on creating a Python visualization lecture. I'll visit you within the first half of this year! And I've collected the materials that I often recommend to those studying data analysis so that you can see them on KakaoTalk. You can see them even if you don't follow me, so I hope you find the materials useful to Sangyeol. Thank you~ :D http://pf.kakao.com/_DQxfsb (Open the link on your mobile phone and go to the board tab!)

  • rtgww77771099님의 프로필 이미지
    rtgww77771099

    Reviews 7

    Average Rating 5.0

    5

    100% enrolled

    It's really good!

    • sunmiyoon
      Instructor

      Thank you, Mr. Kim Tae-woo, for your course review :D Although it's late, congratulations on completing the course!

  • kimdh1890님의 프로필 이미지
    kimdh1890

    Reviews 8

    Average Rating 4.9

    5

    98% enrolled

    I'm listening to your lectures starting from SQL. Thank you for the helpful lectures. ♥

    • sunmiyoon
      Instructor

      Hello! This ID seems familiar to me. Did you enjoy the lecture? The SQL lecture and Python lecture have slightly different feelings, so I wonder how you listened to them. Thank you for your review!

  • muttul589114님의 프로필 이미지
    muttul589114

    Reviews 57

    Average Rating 4.8

    5

    98% enrolled

    Thank you for the great lecture.

    • sunmiyoon
      Instructor

      Thank you, Teacher Mertel, for your class review!

  • kyun91510861님의 프로필 이미지
    kyun91510861

    Reviews 7

    Average Rating 5.0

    5

    68% enrolled

    I've been listening to SQL since then and it's been very helpful~

    • sunmiyoon
      Instructor

      Thank you, Myunggyun, for your course review!!

Access is restricted to non-public courses.
Private Course

datarian's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!