Welcome

LIVE Classes

Courses

Practice Platforms

Leaderboard

Rewards

Referral

Profile

Finish

Welcome LIVE Classes Courses Practice Platforms Leaderboard Rewards Referral Profile Finish

Welcome to HCL GUVI

Hey there! Welcome to HCL GUVI—Grab Your Vernacular Imprint—where tech learning is easy, fun, and curated specially for you. Incubated by IIT Madras & IIM Ahmedabad in 2014 and now part of HCL Group, we're making quality tech education accessible to all.

Join 3M+ learners breaking barriers and upskilling for a brighter future. We're here to guide you every step of the way! 🚀

LIVE Classes

Zen Classes are HCL GUVI's most refined and flagship product—live, expert-led tech programs for beginners and pros. With IITM Pravartak affiliations, master Full-Stack, Data Science, DevOps, UI/UX, and more in multiple languages!

Explore More

Courses

Looking for flexibility? HCL GUVI's 200+ self-paced courses let you learn anytime, anywhere! From free lessons to IIT-M & Autodesk-certified programs, gain in-demand skills in your preferred language.

Explore More

Practice Platforms

Enhance your coding skills with HCL GUVI's Practice Platforms—interactive, structured, and designed to help you master programming effortlessly.

CodeKata:

A structured coding practice platform with 1500+ coding problems designed by industry experts. Ideal for beginners and professionals preparing for tech interviews with real-world coding challenges.

Try Now >

WebKata:

An interactive platform to master HTML, CSS, JavaScript, and Bootstrap with a live coding environment. Perfect for hands-on web development practice without any setup.

Try Now >

SQLKata:

A practice ground for mastering SQL queries used in real-world applications. Write, optimize, and refine your queries to build strong database skills.

Try Now >

Debugging:

Hone your bug-fixing skills with real-world debugging challenges in Python, C++, JavaScript, and Golang. More languages coming soon!

Try Now >

IDE:

A free online compiler supporting 20+ programming languages with auto-complete, debugging, and AI-powered code generation—all in the cloud!

Try Now >

Leaderboard

Climb the leaderboard as you earn Geekoins by learning and practicing! The top scorers get featured, making learning competitive and rewarding. Keep going—you could be next!

Explore More

Rewards

Earn Geekoins by watching videos and practicing problems, then redeem them for exciting rewards. The more you engage, the more you win!

Explore More

Referral

Love learning with HCL GUVI? Share it with friends! Invite them using your unique link or code and unlock exciting rewards—Amazon vouchers, iPhones, and more. A Win-Win.

Explore More

Profile

Your HCL GUVI profile is your digital portfolio! Track progress, showcase skills, add projects, and build a resume. Keep it updated—opportunities await!

Explore More

That's It! You Are Ready!

You're all set to dive into your learning journey with HCL GUVI. Explore, upskill, and make each step count—exciting possibilities awaits!

Home
Pandas Tutorial

Pandas Tutorial

A practical handbook for learning Pandas and working with structured data in Python. This guide covers core Pandas concepts such as Series, DataFrames, data cleaning, filtering, aggregation, and basic data analysis. It helps learners manipulate and analyze data efficiently using real-world examples.

3 Modules

135 Lessons

English

2.5 Hrs

Reading Plan

MODULE 1

Introduction to Pandas

3 mins

Features of Pandas

1 min

Application of Pandas

1 min

Pros and Cons

1 min

MODULE 2

Pandas DataFrame References

111 mins

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

Between time() Method

1 min

1 min

1 min

1 min

1 min

Combine first() Method

1 min

Compare() Method

1 min

Convert dtypes() Method

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

1 min

Drop duplicates() Method

1 min

1 min

1 min

1 min

1 min

1 min

1 min

DataFrame.filter() Method

1 min

DataFrame.first() Method

1 min

DataFrame.first valid index() Method

1 min

DataFrame.floordiv() Method

1 min

DataFrame.from dict() Method

1 min

DataFrame.from records() Method

1 min

DataFrame.ge() Method

1 min

DataFrame.get() Method

1 min

DataFrame.groupby() Method

1 min

DataFrame.gt() Method

1 min

Pandas DataFrame head()

1 min

Pandas DataFrame hist()

1 min

DataFrame.idxmax() Method

1 min

DataFrame.idxmin() Method

1 min

DataFrame.infer objects() Method

1 min

DataFrame.info() Method

1 min

DataFrame.insert() Method

1 min

Pandas DataFrame interpolate()

1 min

Droplevel() Method

1 min

Dropna() Method

1 min

Duplicated() Method

1 min

DataFrame.isin() Method

1 min

DataFrame.isna() Method

1 min

DataFrame.isnull() Method

1 min

DataFrame.items() Method

1 min

Pandas DataFrame iteritems()

1 min

DataFrame.iterrows() Method

1 min

DataFrame.itertuples() Method

1 min

DataFrame.join() Method

1 min

DataFrame.keys() Method

1 min

DataFrame.kurt() Method

1 min

DataFrame.kurtosis() Method

1 min

DataFrame.last() Method

1 min

DataFrame.last valid index() Method

1 min

DataFrame.le() Method

1 min

DataFrame.lt() Method

1 min

DataFrame.mad() Method

1 min

DataFrame.max() Method

1 min

DataFrame.mean() Method

1 min

DataFrame.median() Method

1 min

DataFrame.memory usage() Method

1 min

DataFrame.min() Method

1 min

DataFrame.mod() Method

1 min

DataFrame.mul() Method

1 min

DataFrame Multiply() Method

1 min

DataFrame.ne() Method

1 min

DataFrame.notna() Method

1 min

DataFrame.nlargest() Method

1 min

DataFrame.notnull() Method

1 min

DataFrame.nsmallest() Method

1 min

DataFrame.nunique() Method

1 min

DataFrame.pad() Method

1 min

DataFrame.pop() Method

1 min

DataFrame.pow() Method

1 min

DataFrame.prod() Method

1 min

DataFrame.product() Method

1 min

DataFrame.quantile() Method

1 min

DataFrame.query() Method

1 min

DataFrame.radd() Method

1 min

DataFrame.pct change() Method

1 min

DataFrame.mode() Method

1 min

DataFrame.pipe() Method

1 min

DataFrame.rank() Method

1 min

DataFrame.rdiv() Method

1 min

DataFrame.reindex() Method

1 min

DataFrame.pivot() Method

1 min

DataFrame.pivot table() Method

1 min

DataFrame.rename() Method

1 min

Contributors

Pandas Tutorial

This handbook introduces Pandas step by step, starting with data structures like Series and DataFrames. You’ll learn how to load data, clean messy datasets, filter and aggregate information, and perform basic analysis. The focus stays on practical usage for data analysis and reporting tasks.

Why This Handbook Matters

Pandas is a core tool in Python’s data ecosystem. Understanding Pandas allows developers and analysts to work efficiently with real-world data, uncover insights, and prepare datasets for visualization and machine learning.

Ideal Learners for This Handbook

This handbook is ideal for Python learners moving into data analysis, students exploring data science, and developers handling data-driven applications. It’s also useful for anyone working with spreadsheets and looking to automate data processing.

Prerequisites

This course is suitable for:

Basic understanding of Python programming
Familiarity with variables, loops, and functions
Basic knowledge of lists or arrays
Willingness to work with structured data

Run & Test your Code with our very own IDE that supports 16 languages

Open IDE

3 Modules

135 Lessons

English

2.5 Hrs

Contributors

Recommended Handbooks

4.7

C++ Handbook

Level up your programming skills with our C++ Tutorials hub, guiding you from beginner to advanced. Start your journey now!

English

6254

3 Hrs

4.7

Python Basics Handbook

Level up your programming skills with our Python Tutorials hub, guiding you from beginner to advanced. Start your journey now!

English

7323

3.5 Hrs

4.6

Javascript Handbook

Level up your programming skills with our JavaScript Tutorials hub, guiding you from beginner to advanced. Start your journey now!

English

6188

2 Hrs

ReactJS Projects Handbook

Learn ReactJS by building projects that mirror real-world applications. Strengthen your skills with step-by-step guidance and hands-on coding experience.

English

2.5 Hrs

Computer Networks Tutorial

A complete guide to computer networking, from fundamentals to protocols, routing, addressing, and real-world data communication.

English

1.5 Hrs

Operating System Tutorial

Your complete guide to Operating Systems, from fundamentals to advanced topics like memory management, scheduling, threads, and deadlock handling.

English

1 Hr

DBMS and SQL Tutorial

A complete handbook to guide you through DBMS fundamentals and SQL mastery, perfect for building data-driven applications, managing data systems, or preparing for database roles.

English

0.5 Hr

Java Tutorial

Beginner-friendly Java handbook covering core concepts, OOP principles, and hands-on programming examples.

English

2 Hrs

C Language Tutorial

A step-by-step C programming handbook for beginners. Understand C syntax, logic, memory, and hands-on coding to build solid programming foundations.

English

0.5 Hr

PHP Tutorial

Step-by-step PHP handbook for web developers. Master server-side scripting with practical code and concepts.

English

0.5 Hr

Android Tutorial

Beginner-friendly Android handbook covering app fundamentals, UI design, and hands-on development concepts.

English

1 Hr

Linux Guide Tutorial

A practical Linux handbook covering command-line basics, file management, and system operations.

English

2.5 Hrs

Data Structures and Algorithms Tutorial

Learn core data structures and algorithms with practical examples to improve coding efficiency and problem-solving skills.

English

0.5 Hr

Computer Architecture

A beginner-friendly guide to computer architecture covering processors, memory, and system-level concepts.

English

0.5 Hr

HTML 5 References Tutorial

A handy HTML5 reference guide covering modern tags, attributes, and semantic elements.

English

1.5 Hrs

Docker Tutorial

A hands-on Docker handbook covering containers, images, and modern application deployment basics.

English

0 Hr

GIT (Using Github) Tutorial

A hands-on Git and GitHub handbook for managing code, tracking changes, and collaborating on projects.

English

0.5 Hr

Go Language Tutorial

A beginner-friendly Go handbook covering core language concepts and modern backend programming.

English

0.5 Hr

GIT Guide

A practical Git guide covering version control basics, branching, and real project workflows.

English

1 Hr

CSS Tutorial

A beginner-friendly CSS handbook covering page styling, layouts, and responsive design basics.

English

1 Hr

Advanced Data Structures

A focused handbook covering advanced data structures for efficient and scalable problem solving.

English

0 Hr

Spring Framework Tutorial

A hands-on Spring Framework handbook covering core concepts and backend development fundamentals.

English

1 Hr

Spring Boot Tutorial

A practical Spring Boot handbook focused on building and running modern Java backend applications.

English

0.5 Hr

Kotlin Tutorial

A beginner-friendly Kotlin handbook covering modern language features and real-world development concepts.

English

1 Hr

Apache Cordova Tutorial

A hands-on Apache Cordova handbook for building cross-platform mobile apps with web technologies.

English

0 Hr

Python Tutorial

A beginner-friendly Python handbook covering core concepts and practical programming examples.

English

1.5 Hrs

SASS-SCSS Tutorial

A hands-on SASS / SCSS handbook for writing clean, reusable, and scalable stylesheets.

English

0.5 Hr

MongoDB Tutorial

A hands-on MongoDB handbook covering NoSQL concepts and modern database operations.

English

0.5 Hr

Numpy Tutorial

A hands-on NumPy handbook for fast numerical computation and data manipulation using Python.

English

1.5 Hrs

PL-SQL Tutorial

A hands-on PL/SQL handbook for writing procedural database programs and business logic.

English

0.5 Hr

Python Built-in Functions Tutorial

A handy reference guide to Python’s built-in functions for cleaner and faster coding.

English

0.5 Hr

Elasticsearch Tutorial

A hands-on Elasticsearch handbook covering indexing, searching, and data analysis concepts.

English

0 Hr

Matplotlib Tutorial

A hands-on Matplotlib handbook for creating charts and visualizing data using Python.

English

0.5 Hr

Web Scraping Tutorial

A hands-on web scraping handbook for extracting and working with data from websites.

English

0 Hr

Networking with Python

A hands-on handbook for building network-enabled applications using Python.

English

0.5 Hr

Tkinter Tutorial

A hands-on Tkinter handbook for building desktop applications with Python.

English

0.5 Hr

Java Programs Tutorial

A hands-on Java programs handbook for practicing core concepts and problem-solving in Java.

English

2 Hrs

Pandas Tutorial

Reading Plan

Introduction to Pandas

Pandas DataFrame References

Pandas Series References

Contributors

Pandas Tutorial

Why This Handbook Matters

Ideal Learners for This Handbook

Prerequisites

Run & Test your Code with our very own IDE that supports 16 languages

Contributors

Recommended Handbooks

C++ Handbook

Python Basics Handbook

Javascript Handbook

ReactJS Projects Handbook

Computer Networks Tutorial

Operating System Tutorial

DBMS and SQL Tutorial

Java Tutorial

C Language Tutorial

PHP Tutorial

Android Tutorial

Linux Guide Tutorial

Data Structures and Algorithms Tutorial

Computer Architecture

HTML 5 References Tutorial

Docker Tutorial

GIT (Using Github) Tutorial

Go Language Tutorial

GIT Guide

CSS Tutorial

Advanced Data Structures

Spring Framework Tutorial

Spring Boot Tutorial

Kotlin Tutorial

Apache Cordova Tutorial

Python Tutorial

SASS-SCSS Tutorial

MongoDB Tutorial

Numpy Tutorial

PL-SQL Tutorial

Python Built-in Functions Tutorial

Elasticsearch Tutorial

Matplotlib Tutorial

Web Scraping Tutorial

Networking with Python

Tkinter Tutorial

Java Programs Tutorial