CODEWITHSUNDEEP
pythonpandas
Ecko
Ecko

Reputation: 115

Adding value to each row

I have a pandas dataframe and for each row (column value) I would like to add +5. Meaning that I would leave the original numbers and add 5 to each.

Dataframe:

import pandas as pd 
info= {"Num":[12,14,13,12,14,13,15], "NAME":['John','Camili','Rheana','Joseph','Amanti','Alexa','Siri']}
 
data = pd.DataFrame(info)
print("Original Data frame:\n")
print(data)

Output:

Original Data frame:
  
   Num   NAME
0   12    John
1   14  Camili
2   13  Rheana
3   12  Joseph
4   14  Amanti
5   13   Alexa
6   15    Siri

Desired output:

   Num   NAME
0   17    John
1   19  Camili
2   18  Rheana
3   17  Joseph
4   19  Amanti
5   18   Alexa
6   20    Siri

Attempt to solve:

for i,e in enumerate(data['Num']):
    data.at[i,'Num']= +5

output:


data
Out[391]: 
   Num    NAME
0    5    John
1    5  Camili
2    5  Rheana
3    5  Joseph
4    5  Amanti
5    5   Alexa
6    5    Siri

Would appreciate an example with a for loop

Upvotes: 0

Views: 1674

Answers (2)

Ecko
Ecko

Reputation: 115

import pandas as pd 
info= {"Num":[12,14,13,12,14,13,15], "NAME":['John','Camili','Rheana','Joseph','Amanti','Alexa','Siri']}
 
data = pd.DataFrame(info)

Answer:

for index in range(len(data)):
    data['Num'].iloc[index] += 5

Output:

data
Out[617]: 
   Num    NAME
0   17    John
1   19  Camili
2   18  Rheana
3   17  Joseph
4   19  Amanti
5   18   Alexa
6   20    Siri

Upvotes: 0

furas
furas

Reputation: 142641

You need simple

data['Num'] += 5

without for-loop

Upvotes: 1

Related Questions