Getting started with Pandas for Data Analysis work - A real world example

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.

In this video

• What is Pandas for Python?
• About the sample data & getting started
• Importing the libraries and loading data to data frame
• Fixing the data frame delimiter issue
• Using basic pandas functions (describe etc.)
• Fixing the text data issue by removing them
• Solving the problem correctly
• Adding a column with IF this then that type rule
• Filling the text value up (using fillna method)
• Removing the unnecessary rows
• Doing quick analysis of data (tables & graphs)

Download and install Pandas & other data analysis packages:

https://www.anaconda.com/

https://pandas.pydata.org/

https://code.visualstudio.com/docs/datascience/data-science-tutorial

Sample Files

https://chandoo.org/wp/wp-content/uploads/2022/09/hotel-booking-data.txt

https://www.kaggle.com/datasets/ronecone/hotel-booking-data