강의

멘토링

커뮤니티

Data Science

/

Data Analysis

[Concept Class] Learn and Immediately Use Pandas

Learn Pandas' core features, comparing with SQL!

(5.0) 5 reviews

137 learners

  • breachers
Python
Pandas

Reviews from Early Learners

What you will gain after the course

  • Able to handle data for analysis.

  • You can process machine learning data yourself.

  • I can do data tasks using Excel.

Data analysis + preprocessing!
Develop your data skills with Pandas.

Is this the course I need? 😮

Please read the sentences below and check them.

I want to prepare for a data career
If you were looking for a starting point

I know a little bit about SQL now, but if you want to strengthen your data capabilities in a more serious way,

Data analysis, which is being done a lot these days,
If you've heard of it but don't know what it is,

There is too much data to analyze with Excel alone.
If you were looking for another way

👉 If any of these apply to you, it's time to learn Pandas right now!

Now, why Pandas ? 🎓

Data capabilities are becoming increasingly important, and at the heart of this is data handling. Data handling refers to the ability to manipulate data as desired. Pandas, along with SQL, is arguably the most widely used data handling skill among current data professionals .

If you learn Pandas

From simple Excel and CSV data
You can freely handle the data within the DB.
IT service analysis, machine learning input data generation, etc.
It can be used in many ways.

This lecture is the third in a series of "Learn and Use Data" lectures. Whether you're a beginner with SQL or new to data handling, this Pandas lecture is ideal for you. Let's learn together!


Learn the basics easily
I'll help you!

Anyone who knows the basics of Python is OK!

Bringing data capabilities to your work
I want to strengthen
Current practitioner
(Marketing planning, etc.)

With Pandas
Data Handling
Related work
Developers who need to do it

Data related
Preparing for a career
Job seekers and
Students

Based on SQL
Data capabilities
I want to expand
Everyone

This course is for anyone who has ever wondered what to do with data too large for Excel, or who knows some SQL but isn't familiar with Pandas.

When I first started studying and working in the data science field, I used SQL frequently. Thanks to this, I quickly became comfortable with SQL, but Pandas took a long time to become familiar with, and I had difficulty learning how to use it effectively. However, by applying SQL concepts to Pandas, I was able to gain a grasp of the somewhat awkward Pandas language .

This course incorporates the methods and know-how I've personally applied to my own projects, so you can easily learn Pandas from the basics . If you're interested in data science, data analysis, or engineering, data handling is one of the most important foundations. I hope you'll learn Pandas, the core of data handling, and strengthen your skills. 😊


After attending the lecture you will 🙌

After completing all the lectures, we have structured the curriculum so that you can perform data cleaning using Pandas .

The lecture is divided into 3 steps .

  1. 'Read', which is the overall content of reading data
  2. 'Join' to view split data together
  3. 'Mutation', which changes existing data

We first explain the concepts for each stage to help you grasp the overall picture, and then we create a curriculum that allows you to naturally follow the code along with actual live coding.

This course is different in these ways 📖

Ensuring continuity with familiar datasets

We'll continue to use datasets similar to those learned in previous SQL lectures (continuity guaranteed).

Easy explanation that anyone can understand

We explain unfamiliar technical terms as clearly as possible to help even non-specialists understand them without difficulty.

Based on official documentation, packed with key points

The concepts are core! Based on the official Pandas documentation and CheatSheet, this guide is reliable and contains only the essentials.

I thought about it in practice

It is focused on developing practical skills that will allow you to actually code.


Check out the Q&A 💬

Q. Do I need any prerequisite knowledge before taking the course?

This Pandas course assumes a basic understanding of Python syntax . A basic understanding of Python syntax is essential for following the course, so we recommend familiarizing yourself with Python before taking this course.

However, even if you've never used Python before, you can still follow along with the code presented in this course. Working with Pandas offers a different grammar than standard Python. We provide a free Python textbook called "Byte of Python" and sample lectures, so please refer to them before making your decision.

Q. Is this a course that non-majors can also take?

Anyone with Python knowledge and an interest in data analysis can enroll. Due to the online nature of the course, you may not have a proper place to ask questions if you encounter any difficulties. We encourage you to actively utilize the Inflearn [Community]. We'll provide assistance as quickly as possible.

Q. Can I take the course even if I don't know SQL?

This course is designed so that those who know SQL can take it while comparing the concepts of SQL with Pandas, but even those who don't know SQL can take it without any problems .

Curious about Joe's other lectures?

Recommended for
these people

Who is this course right for?

  • Those who need data preprocessing skills for data analysis

  • Individuals who need data refining skills for machine learning model creation.

Need to know before starting?

  • Python Basics

Hello
This is

4,130

Learners

284

Reviews

40

Answers

4.9

Rating

6

Courses

누구나 데이터를 직접 다루는 자유를 얻을 수 있는 곳

[강의자 소개]

  • 데이터 엔지니어 및 분석가 현업 재직 경험 (SSG.COM, 크몽, 놀이의발견)

  •  <기획자의 SQL> 저자 - 인사이트

     

  • SQL 출강 경험 다수 (다수의 기업 및 개인 대상)

     

     

     

[학생/취준생 40% 특별 할인]

  • data.pelican.joe@gmail.com로 중요정보를 가린 학생증 사진을 첨부해서 메일을 보내주시면 40% 할인 쿠폰을 보내드려요.

     

@business: data.pelican.joe@gmail.com
@github: https://github.com/SqlForPmInsight/data_interview_question
@thread: https://www.threads.com/@breachers_data
@insta: https://www.instagram.com/breachers_data

Curriculum

All

57 lectures ∙ (4hr 51min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • stevekhkim1996님의 프로필 이미지
    stevekhkim1996

    Reviews 5

    Average Rating 5.0

    5

    89% enrolled

    こんにちは。 講義はよく聞いています。 SQLと連携して説明してくれるので、理解するのに大きな助けになります。 もしスラックQ&A部屋はどのように接続できますか?

    • asdfg26005304님의 프로필 이미지
      asdfg26005304

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      入門に適した講義です!説明を簡単明瞭によくしてくださって最小限のPython基本文法だけを熟知すれば誰でも十分に従うことができる難易度の講義です。私のように、どこかでPythonデータ分析を撮った経験がある方も、この講義を通じてもう一度復習し、基本基をしっかり固める時間になると思います。良い講義ありがとうございます!

      • yanggee4431668님의 프로필 이미지
        yanggee4431668

        Reviews 2

        Average Rating 5.0

        5

        12% enrolled

        Pandas、Phythonについての情報も知りませんでしたが、前回のSQLクエリもとてもフレンドリーで詳細に説明していただき、データ処理のための作業に大きな助けになっています。いつも良い講義を作ってくれてありがとう〜^^

        • breachers
          Instructor

          親切で詳しい説明で理解度を高めることができたというコメントありがとうございます :) これからもさらに発展した講義でお返事できるよう努力いたします。ありがとうございます!

      • hyongsu44님의 프로필 이미지
        hyongsu44

        Reviews 868

        Average Rating 5.0

        5

        100% enrolled

        パンダス川のおかげで。 AI関連の資格の取得とデータサイエンスに関して多くの役に立つと思います。 明けましておめでとうございます。

        • breachers
          Instructor

          AI関連の資格を取得するのに役立つと思いますレビューを残していただきありがとうございます。多くの人がデータ分析を簡単に学び、活用できるように努力しましょう:) ありがとうございます!

      • kimhuks3156님의 프로필 이미지
        kimhuks3156

        Reviews 1

        Average Rating 5.0

        5

        32% enrolled

        sqlと比べて説明してくれてよかったです

        • breachers
          Instructor

          レビューありがとうございます:)

      $33.00

      breachers's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!