강의

멘토링

커뮤니티

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) 수강평 35개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

Pandas
Pandas
Pandas
Pandas

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.8

5.0

상열

70% 수강 후 작성

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...!!!!

5.0

김태우

100% 수강 후 작성

It's really good!

5.0

kim_dh

98% 수강 후 작성

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

강의상세_배울수있는것_타이틀

  • 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)

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • 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

선수 지식, 필요할까요?

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

강의소개.지공자소개

23,259

수강생

2,732

수강평

28

답변

4.9

강의 평점

35

강의_other

Experienced working analysts with solid practical backgrounds design the data analysis curriculum and teach the classes themselves.

If you want to learn more about Datarian

👉 https://datarian.io/

커리큘럼

전체

56개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

35개

4.8

35개의 수강평

  • tomorrow29986587님의 프로필 이미지
    tomorrow29986587

    수강평 1

    평균 평점 5.0

    5

    70% 수강 후 작성

    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
      지식공유자

      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

    수강평 7

    평균 평점 5.0

    5

    100% 수강 후 작성

    It's really good!

    • sunmiyoon
      지식공유자

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

  • kimdh1890님의 프로필 이미지
    kimdh1890

    수강평 8

    평균 평점 4.9

    5

    98% 수강 후 작성

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

    • sunmiyoon
      지식공유자

      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

    수강평 67

    평균 평점 4.8

    5

    98% 수강 후 작성

    Thank you for the great lecture.

    • sunmiyoon
      지식공유자

      Thank you, Teacher Mertel, for your class review!

  • kyun91510861님의 프로필 이미지
    kyun91510861

    수강평 7

    평균 평점 5.0

    5

    68% 수강 후 작성

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

    • sunmiyoon
      지식공유자

      Thank you, Myunggyun, for your course review!!

datarian님의 다른 강의

지식공유자님의 다른 강의를 만나보세요!

비슷한 강의

같은 분야의 다른 강의를 만나보세요!