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.
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!
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
초급자로서 판다스에 대한 개념을 전반적으로 익히고, 실제 분석에 어떻게 활용할 수 있을지 꼼꼼하게 배울 수 있는 명강의라고 생각합니다. 판다스 관련 강의들을 몇 가지 들어봤는데 세심한 부분들까지 하나하나 퀄리티있게 알려주는 강의는 이 강의 밖에는 없는 것 같아요. 다시 한 번 더 복습을 한 뒤에 실제 업무용 데이터로도 적용해서 분석해보려고 합니다. 좋은 강의 만들어주셔서 진심으로 감사드립니다!!
전체적으로 좋은 강좌였습니다. 저의 경의 판다스를 혼자 책으로 공부하고 이 강좌를 판다스 반복 학습 및 응용을 목적으로 신청하여 듣게 되었습니다.
판다스 치트시트 강좌는 사실 별로였습니다. 판다스를 처음 보시거나 파이썬을 처음, 아님 아주 기초분이신분들은 별로 도움이 안되실겁니다. 유튜브영상으론 괜찮은데 돈을받고 강의로썬 좀 안타까운 부분이 있습니다.
서울시 코로나 분석 강의는 좋았습니다. 판다스를 응용하여 데이터를 어떤게 가공하여 자신이 원하는 형태, 결과를 얻을수 있는가를 연습할수 있어서, 판다스 기초를 공부한 저로썬 아주 유용한 파트가 되었습니다.
그리고 중간중간에 알려주시는 팁도 엄청 도움이 많이 되었습니다. shift-tab이라던가, 함수뒤 ? 을 사용하여 돗스트링을 볼수 있다던가... 아마 이런게 꿀팁이겠죠...
한줄 요약 : 판다스 처음 시작하시는 분들껜 비추, 판다스좀 아시는 분들께 강추합니다.