Pandas Series & DataFrames | Custom Indexing + Real World CSV Data | BuildCoders
In this lecture, we go beyond the basics and start working with real-world data using Pandas!
Here's what you'll learn in this video:
✅ How to change the default indexing (0, 1, 2…) to your own custom index while creating a DataFrame
✅ What a CSV file is and why companies use it to store data
✅ How to load a real-world CSV file (Wine Reviews dataset from Kaggle) into a Pandas DataFrame using pd.read_csv()
✅ How to inspect your data using .head() and .shape without crashing your environment
✅ The full end-to-end workflow — from importing Pandas to exploring a dataset with 1.5 lakh+ rows
📌 Commands Covered:
index = [...] — custom row indexing while creating a DataFrame
pd.read_csv("file.csv", index_col=0) — reading a CSV file
df.head() — preview first 5 rows
df.shape — get total rows and columns
📂 Dataset Used: Wine Reviews — Kaggle
🔗 Previous Lecture: DataFrames and Series — Part 1 ( • DATAFRAMES and SERIES - Learn from Basics ... )
Link for collab - https://colab.research.google.com/drive/1D...
👍 If this helped you, Like, Share & Subscribe to BuildCoders for more AI/ML content made simple!
🔔 Hit the bell icon so you never miss a lecture.