강의

멘토링

로드맵

Inflearn brand logo image
BEST
Data Science

/

Data Analysis

Mastering Data Analysis and Visualization with Just Two Documents

When you use Pandas for data analysis, preprocessing, machine learning, and deep learning, you tend to use only the functions you use frequently. There is a Pandas Cheat Sheet that collects and organizes only these essential contents. For those who get tired of learning Pandas from a thick book, we will teach you Python Pandas with just two pages of documents. Learn the core functions of Pandas with the cheat sheet provided in the official Pandas tutorial.

(4.8) 169 reviews

2,551 learners

  • todaycode
Python
Pandas

Reviews from Early Learners

What you will learn!

  • Key features from the Pandas Cheat Sheet

  • Python Data Analysis

  • Data preprocessing for machine learning and deep learning

  • Data Visualization

  • Crawling, preprocessing, analyzing, and visualizing the Seoul City COVID-19 site using Pandas

Python Pandas Data Analysis, the essentials all at once!

In just two documents
Pandas data analysis
Can you solve it?

There is a library called Pandas that allows you to use Excel-like functions in Python.

Excel can't handle it
Large-scale data processing is also OK.

Pandas is for data analysis and preprocessing.
It is a Python data analysis library.

When doing data analysis, preprocessing, or visualization with Python Pandas, you will mainly use the functions that you use most. And there is a cheat sheet that organizes these core functions into just two pages.

However, if you look at a cheat sheet that only contains such core contents, you may be at a loss as to what content to practice and how to practice it. In this lecture, we will explain only the core contents of the cheat sheet and guide you through how to easily use complex Matplotlib with Pandas. Let's try it together.


Who would benefit from learning this?

data analysis,
Required for ML/DL
I want to do preprocessing
People who do it

Large volume of data
Open it with Excel
The file won't open
Those who were confused

Using Excel
do data analysis
In complex formulas
Tired person

Various in Excel
I implemented the formula, but
It's slow
People who had to work overtime

📣 Check your player knowledge!

  • Prerequisite knowledge of Python and Jupyter Notebooks, Anaconda, and row/column concepts in Excel is required.

Focusing on official documents
Easy, fast and accurate.

One, in the Jupyter notebook
Using docstring

You don't need to memorize all the methods. The functions used are fixed. In this lecture, I will teach you how to practice by searching the official documentation in Jupyter Notebook so that you can learn on your own by looking at the help and documentation.

2. Pandas data visualization
How to do it twice as well!

Do you know which graph is appropriate for which data? In this lecture, we will look at the differences and usage of bar graphs, frequency distribution tables, histograms, and normal distributions. In addition, we will explain various Python visualization methods and options through the official Pandas documentation.

Bonus, visualize Series and DataFrame data!

Python Pandas Visualization Example

Python Pandas Visualization Example
Python Pandas Visualization Example
Python Pandas Visualization Example

Additional updates!
Perfect for practical use
Data analysis project.

We will analyze the Seoul City COVID-19 Status Site using Pandas from data crawling to preprocessing, analysis, and visualization. You can analyze the content learned in just two documents into a project similar to the actual work . (Section 13)

First, we directly analyze data that we frequently encounter in our daily lives through the news.

  • Which district has the most confirmed cases?
  • Which hospital treated the most confirmed cases?
  • Are there any hospitals that people are frequently transferred to by district?
  • Which district has the most confirmed cases from overseas?
  • How can I preprocess texts from multiple countries, such as Europe, South America, etc?
  • How much difference will there be in the number of confirmed cases coming from overseas from month to month?

Second, understand and practice data preprocessing methods using Pandas.

  • How do I get the year, month, day, day of the week, and week number from a text date?
  • How can we calculate the cumulative number of confirmed cases using confirmed case status data?
  • What is the difference between groupby, crosstab, pivot, and pivot_table, and which function is appropriate to use?

3. Understand the data structure of data frames and series and process them into a form suitable for analysis.

  • How should I create a data frame for drawing a graph using Pandas' plot?
  • How can I change my dataframe if I want to display values in different colors based on their categorical values in the graph?
  • Is there any way to convert a series to a dataframe?

Python Visualization & Analysis Examples,
Check it out for yourself in class!


Created this course
If you are curious about the knowledge sharer? 👩‍💻

Knowledge Sharer Park Jo-eun X Inflearn Interview

Recommended for
these people

Who is this course right for?

  • Anyone who wants to do preprocessing for data analysis, machine learning, and deep learning in Python

  • If you were confused because a large amount of data could not be loaded when opening it in Excel

  • Are you tired of Excel's complicated formulas?

  • If you implemented various formulas in Excel but had to work overtime because the speed was slow

Need to know before starting?

  • Python

  • Jupiter Notebook

  • anaconda

  • Excel's Row and Column Concept

Hello
This is

18,791

Learners

787

Reviews

1,334

Answers

4.9

Rating

6

Courses

  • Microsoft MVP(Python Developer Technologies)

  • 오늘코드 YouTube 📺 https://youtube.com/todaycode

  • “모두가 데이터에 친숙해지는 날이 오길”– 마이크로소프트웨어 (링크)

  • 네이버 커넥트 재단 부스트코스 데이터사이언스 강의 설계 및 교수자

  • 서울대 빅데이터혁신공유대학, 서울대 평생교육원, 연세대 DX Academy, 한신대 ABC Camp, 한양대 대학원, 전남대,

    한국능률협회, 삼성SDS 멀티캠퍼스, 멋쟁이사자처럼, 패스트캠퍼스, 모두의연구소 등 다수의 교육기관 및 기업 강의

  • 다양한 도메인(제약, 통신, 자동차, 커머스, 교육, 정부기관 등)의 기업 데이터 분석

  • 20년이상 게임, 광고, 교육 등 다양한 도메인에서 웹 백엔드 개발자 및 데이터 분석가 현업 경험

Curriculum

All

63 lectures ∙ (11hr 10min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

169 reviews

4.8

169 reviews

  • 티보그님의 프로필 이미지
    티보그

    Reviews 1

    Average Rating 5.0

    5

    89% enrolled

    강사님의 분석 방법을 내것으로 만들고 싶어요. 감사합니다.

    • 세바스찬 주니어 3세

      욕심쟁이 입니까?

  • 세바스찬 주니어 3세님의 프로필 이미지
    세바스찬 주니어 3세

    Reviews 15

    Average Rating 4.7

    5

    89% enrolled

    초급자로서 판다스에 대한 개념을 전반적으로 익히고, 실제 분석에 어떻게 활용할 수 있을지 꼼꼼하게 배울 수 있는 명강의라고 생각합니다. 판다스 관련 강의들을 몇 가지 들어봤는데 세심한 부분들까지 하나하나 퀄리티있게 알려주는 강의는 이 강의 밖에는 없는 것 같아요. 다시 한 번 더 복습을 한 뒤에 실제 업무용 데이터로도 적용해서 분석해보려고 합니다. 좋은 강의 만들어주셔서 진심으로 감사드립니다!!

    • Eason Jung님의 프로필 이미지
      Eason Jung

      Reviews 1

      Average Rating 4.0

      4

      100% enrolled

      전체적으로 좋은 강좌였습니다. 저의 경의 판다스를 혼자 책으로 공부하고 이 강좌를 판다스 반복 학습 및 응용을 목적으로 신청하여 듣게 되었습니다. 판다스 치트시트 강좌는 사실 별로였습니다. 판다스를 처음 보시거나 파이썬을 처음, 아님 아주 기초분이신분들은 별로 도움이 안되실겁니다. 유튜브영상으론 괜찮은데 돈을받고 강의로썬 좀 안타까운 부분이 있습니다. 서울시 코로나 분석 강의는 좋았습니다. 판다스를 응용하여 데이터를 어떤게 가공하여 자신이 원하는 형태, 결과를 얻을수 있는가를 연습할수 있어서, 판다스 기초를 공부한 저로썬 아주 유용한 파트가 되었습니다. 그리고 중간중간에 알려주시는 팁도 엄청 도움이 많이 되었습니다. shift-tab이라던가, 함수뒤 ? 을 사용하여 돗스트링을 볼수 있다던가... 아마 이런게 꿀팁이겠죠... 한줄 요약 : 판다스 처음 시작하시는 분들껜 비추, 판다스좀 아시는 분들께 강추합니다.

      • pooh9431님의 프로필 이미지
        pooh9431

        Reviews 1

        Average Rating 5.0

        5

        37% enrolled

        좋은 커리큘럼입니다 저같은 입문자도 작동원리와 결과물을 함께 볼 수 있었고 무엇보다 질의응답 부분이 너무 마음에 듭니다. 모르는것이 있으면 선생님께 질문하듯 편하게 질의응답을 바로 바로 해주시고 그리고 선생님 목소리의 파장대가 너무 좋아서 집중이 잘됩니다.

        • 박태렬님의 프로필 이미지
          박태렬

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          통계학과를 졸업 후 데이터 분석직으로 일하다가 퇴사하고 박조은님 강의 통해서 파이썬을 이용한 데이터 분석 공부중입니다. 뻔한 예제 데이터가 아니라 시기적절한 데이터 활용해서 쉽게 알려주셔서 흥미있게 강의 따라갈 수 있었습니다. 유튜브도 잘 보고 있습니다. 감사합니다!

          Limited time deal ends in 4 days

          $33,820.00

          25%

          $35.20

          todaycode's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!