Loop through dataframe rows

Question

I want to push data to a sheet. When i'm printing my code it is working, but on my sheet it prints only the last element of my list.

Here is my code :

import json
from urllib.request import urlopen
import pygsheets
import pandas as pd
with urlopen("myapiurl") as response: source = response.read()
data = json.loads(source)


#authorization
gc = pygsheets.authorize(service_file='myjsonfile')

#open the google spreadsheet
sh = gc.open('Test')

#select the first sheet
wks = sh[0]

# Create empty dataframe
df = pd.DataFrame()

#update the first sheet with df, starting at cell B2.
wks.set_dataframe(df,(1,1))

for item in data["resultsPage"]["results"]["Entry"]:
    id = item["event"]["id"]
    print(id)
    df['id_string'] = id

your loop will overwrite df['id_string'] each time, so you'll only end up with the last id. — Dan
– Dan, Commented Aug 22, 2019 at 14:37
@mnlgr off the top of my head, you should append it to a list and then add it to the dataframe — Celius Stingher
– Celius Stingher, Commented Aug 22, 2019 at 14:41
declare an empty array out outside the for loop and then change the last line with the name of the empty array and call the append function and append the id to it on every loop. and then at the end assign the array you declared to the df["id_string"] — basilisk
– basilisk, Commented Aug 22, 2019 at 14:42

ansev · Accepted Answer · 2019-08-22 14:40:34Z

1

You can save ids in a list id_s an finally copy it in the colum of DataFrame. it will work because you don't rewrite the colum.

import json
from urllib.request import urlopen
import pygsheets
import pandas as pd
with urlopen("myapiurl") as response: source = response.read()
data = json.loads(source)


#authorization
gc = pygsheets.authorize(service_file='myjsonfile')

#open the google spreadsheet
sh = gc.open('Test')

#select the first sheet
wks = sh[0]

# Create empty dataframe
df = pd.DataFrame()

#update the first sheet with df, starting at cell B2.
wks.set_dataframe(df,(1,1))
id_s=[]
for item in data["resultsPage"]["results"]["Entry"]:
    id = item["event"]["id"]
    print(id)
    id_s.append(id)
df['id_string'] = id_s

answered Aug 22, 2019 at 14:40

ansev

31k5 gold badges21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loop through dataframe rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related