Pandas is the most useful data analysis package in Python. You can use it to clean-up, transform and analyze data. Recently, I had a chance to use Pandas for some work. So, in this video let me share a quick but fairly in-depth introduction to Pandas with a real-world case study.

📃❓✅SAMPLE FILES & INSTRUCTIONS:
==================================

~ i n s t a l l a t i o n ⚒ ~

Download and install Pandas & other data analysis packages:
- from Anaconda anaconda.com/
- from Pandas website pandas.pydata.org/
- from VS Code code.visualstudio.com/docs/datascience/data-science-tutorial

~ s a m p l e f i l e 📃 ~

- Direct Download chandoo.org/wp/wp-content/uploads/2022/09/hotel-booking-data.txt
- On Kaggle kaggle.com/datasets/ronecone/hotel-booking-data

~ c o d e 👨‍💻 ~

- Jupyter Notebook files.chandoo.org/py/pandas-intro.ipynb
- Kaggle Notebook kaggle.com/ronecone/data-cleanup-simple-analysis

⏱ VIDEO CHAPTERS 👇
===================
0:00 - What is Pandas for Python?
0:55 - About the sample data & getting started
2:17 - Importing the libraries and loading data to data frame
4:08 - Fixing the data frame delimiter issue
5:21 - Using basic pandas functions (describe etc.)
7:15 - Fixing the text data issue by removing them
8:35 - Solving the problem correctly
11:20 - Adding a column with IF this then that type rule
13:38 - Filling the text value up (using fillna method)
16:13 - Removing the unnecessary rows
16:37 - Doing quick analysis of data (tables & graphs)

📚 LEARN MORE ABOUT PYTHON
============================

Watch my 1-hour Python Tutorial to understand and write your first programs - youtu.be/uoC48wrJ-yM

🤷‍♀️ Other ways to clean this data
===========================

We can also use Power Query in Excel to cleanse and process this data. See this tutorial for that - youtu.be/bSaLlNLAW44

📚 LEARN MORE ABOUT PANDAS
============================

Data Science with Pandas - Tutorial on VSCODE page - code.visualstudio.com/docs/datascience/data-science-tutorial
Pandas documentation & examples - pandas.pydata.org/docs/getting_started/intro_tutorials/01_table_oriented.html
📕📗📘 Pandas books:
Python for Data Analysis: Data Wrangling with Pandas, NumPy, and IPython by Wes McKinney - amzn.to/3QPTgCt
Pandas Cookbook by Daniel Chen - amzn.to/3ROiQbW

~

🐼 What do pandas use to record their thoughts?
Notebooks of course 📓 🤣

#pandas #python #datascience

• Learn how to use PANDAS in Python in 15 minutes - with 10 real examples ( Download)
• Master Python Pandas in 15 minutes ( Download)
• Pandas for Data Analytics in 15 Minutes | Python Crash Course ( Download)
• Pandas for Data Science in 20 Minutes | Python Crash Course ( Download)
• Learn Python Pandas in 15 minutes ( Download)
• LEARN PANDAS in about 10 minutes! A great python module for Data Science! ( Download)
• Learn Python & Pandas in 20 Minutes (project files included!) ( Download)
• Pandas in 15 Minutes ( Download)
• NumPy for Beginners in 15 minutes | Python Crash Course ( Download)
• Python Pandas | Section 3 Class 2 | Data Science | Learn in 15 Minutes ( Download)
• Python Pandas: Crash Course in 20 Minutes ( Download)
• Become Pro in Pandas DataFrame in 15 minutes ( Download)
• Learn Python in 59.001 seconds ( Download)
• Master Pandas Data Manipulation in 15 Minutes | iloc |iat | at | loc |dropna | fillna. ( Download)
• Python Pandas Tutorial #2 - Understanding Pandas Series ( Download)