15.16 Iteration over DataFrame

Duration: 3 min

This video lesson is available to enrolled students.

Return to /learn/KVS-NVS-TIER-2-COMPUTER-SCIENCE/introduction-to-python/file-handling-data-analysis/pandas-basics/asset-1516-iteration-over-dataframe after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. KVS/NVS Interview Preparation: Interview Preparation
  2. The Teaching & Pedagogy Playbook / शिक्षण एवं शिक्षाशास्त्र मार्गदर्शिका: शिक्षा, समाज एवं जेंडर / Education, Society and Gender, Theories of Development / विकास के सिद्धांत, विज्ञान शिक्षणशास्त्र / Science Pedagogy, Teaching-Learning Process and Classroom Management / शिक्षण-अधिगम प्रक्रिया एवं कक्षा प्रबंधन, Teacher: Qualities, Professional Ethics and Development / शिक्षक: गुण, व्यावसायिक नैतिकता एवं विकास, Curriculum, Arts and Co-curricular Areas / पाठ्यचर्या, कला एवं सह-शैक्षिक क्षेत्र, Educational Psychology / शैक्षिक मनोविज्ञान, Growth and Development / वृद्धि और विकास, Cognitive Processes / संज्ञानात्मक प्रक्रियाएँ, Teaching Methods / शिक्षण विधियाँ, Methods of Research and Research Design / शोध विधियाँ एवं अभिकल्प, Social Science Pedagogy / सामाजिक विज्ञान शिक्षणशास्त्र, Educational Policies, Acts and Administration / शैक्षिक नीतियाँ, अधिनियम एवं प्रशासन, Learning and Behavioural Theories / अधिगम और व्यवहारवादी सिद्धांत, Teaching Planning and Teaching Skills / शिक्षण योजना और शिक्षण कौशल
  3. Computer Systems and Organisation: Basics of COA, Cache Memory Organization, Introduction to OS, Digital Systems & Boolean Basics, Logic Gates & Hardware, Number System, Number Representation
  4. Computer Networks: Introduction to CN, Data Communication, Net Layer: IP Addressing, Application Layer, Hardware basics
  5. Database Management: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, SQL
  6. Introduction to Python: Introduction to Python, Tokens, Variables, Data Types, I/O, Operators & Expressions, Control Flow & Looping, Collections & Strings, Functions & Modules, File Handling & Data Analysis
  7. Emerging Trends: Emerging Trends and AI, Sets, Relations, Functions and Discrete Mathematics / समुच्चय, संबंध, फलन और विविक्त गणित, Trade, Marketing and Consumer Protection / व्यापार, विपणन एवं उपभोक्ता संरक्षण, Internet of Things, Cloud Computing, Solid State Physics and Electronics / ठोस अवस्था भौतिकी और इलेक्ट्रॉनिकी, Network Access Technologies
  8. Artificial Intelligence: Simple and Compound Interest / साधारण और चक्रवृद्धि ब्याज
  9. Digital Society & Cyber Law: Society, Law & Ethics, Cyber Safety and Security, Teaching Aids and Educational Technology / शिक्षण सहायक सामग्री एवं शैक्षिक तकनीकी, Computer Software, डिजिटल समाज, नैतिकता और साइबर कानून / Digital Society, Ethics and Cyber Law, Digital India and Online Services, Culture, Socialisation and Social Control / संस्कृति, समाजीकरण और सामाजिक नियंत्रण, Web Publishing & Hosting
  10. Application Software: MS Office Applications, Operating System, Terms & Abbreviations, Computer Hardware, Language Design, C Fundamentals
  11. KVS/NVS Tier 2 Live Class Notes: EMRS TGT/PGT Live Class, Subjective Notes
  12. Full Mock Test:
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

This video is a lecture on iterating over a Pandas DataFrame in Python, presented by an instructor in front of a digital screen. The lecture begins by introducing the concept of iteration over a DataFrame, explaining its use for row-wise processing, conditional checking, and custom logic. The primary method demonstrated is `iterrows()`, with the instructor showing the syntax `for index, row in df.iterrows():` and an example print statement `print(index, row['Name'], row['Marks'])`. The output of this code is shown, displaying the index, name, and marks for each row. The instructor then transitions to another method, `iteruples()`, demonstrating its syntax `for row in df.itertuples():` and the print statement `print(row.Roll, row.Name, row.Marks)`, which accesses columns by name. The final part of the lecture covers column-wise iteration using `items()`, with the syntax `for col, data in df.items():` and the print statements `print(col)` and `print(data)`. The video concludes with a thank you message.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video opens with a title slide on a digital screen that reads 'Iteration over DataFrame'. The instructor, standing to the right, begins the lecture. The screen then transitions to a slide titled 'Used when:', listing three bullet points: 'row-wise processing', 'Conditional checking', and 'Custom logic'. The instructor explains these use cases. The next slide shows the code for iteration using `iterrows()`, with the syntax `for index, row in df.iterrows():` and the print statement `print(index, row['Name'], row['Marks'])`. The instructor writes on the screen, underlining 'index' and 'row'. The output of the code is displayed at the bottom, showing '0 Amit 85' and '1 Neha 90'. The instructor then draws a yellow squiggly line over the 'for' loop and points to the code, explaining the process.

  2. 2:00 – 2:43 02:00-02:43

    The instructor continues to explain the `iterrows()` method, drawing arrows to the `index` and `row` variables in the code. The screen then changes to a new slide titled 'Iteration using itertuples()'. The code shown is `for row in df.itertuples():` and `print(row.Roll, row.Name, row.Marks)`. The instructor explains that this method returns a named tuple for each row, allowing access to columns by name. The output '1 Amit 85' is shown. The screen then transitions to a final slide titled 'Column-wise iteration', showing the code `for col in df:` and `print(col)`. The instructor explains this method. The final slide is titled 'Using items() (Column + Data)', showing the code `for col, data in df.items():` and the print statements `print(col)` and `print(data)`. The instructor explains that this method iterates over both the column name and the data series. The video ends with a 'Thank you' message on the screen.

The lecture systematically covers three primary methods for iterating over a Pandas DataFrame. It starts with the most common method, `iterrows()`, which provides the index and row data for each iteration, suitable for row-wise operations. It then introduces `itertuples()`, which is more efficient as it returns a named tuple, allowing for faster access to column values by name. Finally, it covers `items()`, which is used for column-wise iteration, providing the column name and its corresponding data series. The progression demonstrates a logical flow from row-based to column-based iteration, highlighting the appropriate use case for each method.

Loading lesson…