Advanced Pandas Tutorial: 7 Data Analysis Techniques You Need to Know

Master Advanced Pandas Techniques for Data Analysis | Python Tutorial In this hands-on tutorial, we'll cover essential advanced Pandas techniques including rolling averages, pivot tables, lambda functions, percent change, .query and cross-tabulation. ---------------------- Dataset used in this video - https://www.kaggle.com/datasets/yusufdelikkaya/online-sales-dataset ---------------------- 🐼 Pandas Cheat Sheet - https://stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet 💻 Data Analysis with Python Masterclass - https://stan.store/KarinaDataScientist/p/start-programming-with-python 💌 Join my newsletter and get access to various freebies - https://stan.store/KarinaDataScientist 🧠 AI to help you analyse your data - https://powerdrill.ai/?via=karina-samsonova ---------------------- Timestamps: ---------------------- 00:00 Intro 00:30 Dataset 00:42 Read the file 01:22 Convert object to datetime 02:00 Add new column 03:35 Add Weekday 04:58 Rolling Sum 08:23 Percent change 11:05 Advanced aggregation 14:49 lambda funciton 17:51 Advanced pivot 20:07 Cross tabulation 21:45 Product analysis 23:24 .query for filtering 24:20 Category performance 🎥 Other videos you might be interested in ---------------------- https://youtu.be/MZCUIcCSySY https://youtu.be/xLW796-J5fI ---------------------- About me ---------------------- Hi, my name is Karina and I'm a finance person turned data person. My mission is to transform intimidating tech into accessible tools. I aim to empower 1 million people to harness the power of AI, Python, SQL, and Excel to work smarter, not harder. Contact ---------------------- Youtube: youtube comments are by far the best way to get a response from me! email for business inquiries only: [email protected] ---------------------- Social Media: ---------------------- TikTok: https://www.tiktok.com/@karinadatascientist Instagram: https://www.instagram.com/karinadatascientist/ Linkedin: https://www.linkedin.com/in/karina-samsonova/