iterate rows and columns pandas and calculate python example

Example 1: for row in column pandas

df = pd.DataFrame([{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}])
for index, row in df.iterrows():
    print(row['c1'], row['c2'])

Example 2: iterating over the two ranges simultaneously and saving it in database

from .models import userData as us
import pandas as pd

def enterData(request):
    data=pd.read_csv(r"abc.csv",encoding='ISO-8859-1')
    username=data['userName']
    address=data['address']
    for a, b in zip(username, address):
        db=ud(userName=a,Address=a)
        db.save()

Tags:

Python Example

Related