CODEWITHSUNDEEP
pythonpandasrow
user9406886
user9406886

Reputation:

Loop through dataframe rows

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

Upvotes: 0

Views: 342

Answers (1)

ansev
ansev

Reputation: 30920

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

Upvotes: 1

Related Questions