Introducing a programming learning service created by Kinocode / Kinoquest is the best way to learn Python, where you can immediately output the knowledge you have learned and feel your skills have been firmly established! ・There are more than 350 questions ・No need to set up an environment! ・There is a curriculum so you won't get lost in how to study ▼ Register here ▼ https://kino-code.com/kq_service_a/?u... ーーーThis video is a compilation of all 14 introductory Pandas lessons in one video. Learn the basics of Pandas in 3 hours. It is perfect for those who have completed the Python beginner's course or those who want to use Python to learn data collection, processing, and data preprocessing. ▼Table of contents00:00:00 Course introduction00:04:01 How to use JupyterLab ~ A popular tool for Python users that allows you to write and execute programs, and display tables and graphs00:16:19 What is Pandas ~ What it can do and how to use it00:31:03 What is DataFrame ~ Creating a data frame, changing indexes and columns, data manipulation00:49:48 What is Series ~ How to create a series, extract data, and perform arithmetic operations01:04:51 Reading and writing files ~ Reading and writing CSV and Excel files, and how to connect to a database01:22:24 How to extract data ~ Extracting specific columns or rows, or data that matches specific conditions01:39:33 Sorting data ~ Sorting from smallest to largest, sorting multiple columns01:49:10 Data aggregation with groupby ~ How to aggregate totals and averages for each category02:00:10 Data aggregation with pivot_table ~ You can customize the aggregation method02:10:10 Combining data frames with merge - How to combine data frames together02:20:37 Combining data frames with concat - Vertical combination of data frames, etc.02:29:29 How to handle time series data - Aggregation for a specified number of days, aggregation only at the end of the month, weekly or monthly aggregation02:40:41 How to use map, apply, and applymap ＾ How to apply functions to Series and DataFrame▼ For transcription, source code, and files used, see the blog belowPandas Introductory Course #01 Pandas Course Introduction (https://kino-code.com/pandas_course_i...) Pandas Introductory Course #02 How to use Jupyter Lab (https://kino-code.com/pandas_course_j...) Pandas Introductory Course #03 What is Pandas? (https://kino-code.com/pandas_course_p...) Pandas Introductory Course #04 What is DataFrame (https://kino-code.com/pandas_course_d...) Pandas Introductory Course #05 What is a Series? (https://kino-code.com/pandas_course_s...) Pandas Introductory Course #06 How to read and write CSV and Excel files, and connect to a database (https://kino-code.com/pandas_course_r...) Pandas Introductory Course #07 How to extract data (https://kino-code.com/pandas_course_d...) Pandas Introductory Course #08 How to sort data (https://kino-code.com/pandas_sort/) Pandas Introductory Course #09 How to aggregate data (groupby) (https://kino-code.com/pandas_groupby/) Pandas Introductory Course #10 How to aggregate data (pivot_table) (https://kino-code.com/pandas_pivot_ta...) Pandas Introductory Course #11 How to combine data (merge)(https://kino-code.com/pandas_merge/) Introductory Pandas Course #12 How to combine data frames (concat)(https://kino-code.com/pandas-concat/) Introductory Pandas Course #13 How to handle time series data(https://kino-code.com/pandas_chronolo...) Introductory Pandas Course #14 How to apply functions to Series and DataFrames (map, apply, applymap methods)(https://kino-code.com/pandas_function/) ▼Recommended videos Python Super Beginner's Course • Python Super Beginner's Course Combined Edition Learn the very basics of Python in just one hour... Introductory Pandas Course (playlist) • Introductory Pandas Course Course for programming beginners Python x Work Automation (playlist) • Automate tedious work with Python Theory aside, use Docker to quickly set up a Python data analysis environment • Theory aside, use Docker to quickly set up a Python data analysis environment... Analyzing stock price data with Python • Analyzing stock price data with Python Analyzing data with Python through stock price analysis... ▼Self-introductionCurrently: FreelancePrevious job: Recruit▼SNSTwitter: / likesFacebook: /%e3%82%ad%e3%83%8e%e3%82%b3%e3%83%bc%e3%83...Website: https://kino-code.com/ ▼Business inquiriesAt Kinocode, we are currently only accepting work automation development and consulting work. Please contact us via the contact information, Twitter DM, or the email address listed under "Kinocode home page → Overview". ▼Tags#Python #Pandas #Programming