Q:

How to update a DataFrame in pandas while iterating row by row?

mahmoud2506
Save to bookmark
|
2022-05-25
|
  270 
0

Rows in pandas are the different cell (column) values that are aligned horizontally and also provide uniformity. Each row can have the same or different value. Rows are generally marked with the index number but in pandas, we can also assign index names according to the needs.

In this article, we are going to learn how to update a DataFrame row while iterating? For this purpose, we are going to use pandas.DataFrame.iterrows() method.

pandas.DataFrame.iterrows() method

This special function allows us to iterate each row in the DataFrame.

Syntax:

DataFrame.iterrows()

To work with pandas, we need to import pandas package first, below is the syntax:

import pandas as pd
Python programming, examples, Python programming examples,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-25
need an explanation for this answer? contact us directly to get an explanation for this answer

Let us understand with the help of an example:

# Importing pandas package
import pandas as pd

# Creating dictionary
d = {
    'Fruits':['Apple','Orange','Banana'],
    'Price':[50,40,30],
    'Vitamin':['C','D','B6']
}

# Creating DataFrame
df = pd.DataFrame(d)

# Display original DataFrame
print("Original DataFrame:\n",df,"\n")


# Iterating rows and updating price 
# of each item by +10
for i,row in df.iterrows():
     price = 10
     if row['Price'] <=60:
          price += row['Price']
          df._set_value(i,'Price',price)

# Display modified DataFrame
print("Modified DataFrame\n",df)

Output:

Example: Update a DataFrame in pandas

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now