Skip to main content

Get data spreadsheet dengan pandas

import pandas as pd
id_spreadsheet = "idspreadsheet"


url = f"https://docs.google.com/spreadsheets/d/{id_spreadsheet}/export?format=csv&gid=0"

df=pd.read_csv(url)

# iterrows
for index,row in df.iterrows():
print(f"textnya : {row["Title"]}")


# itertuples
for row in df.itertuples():
print(f"text: {row.Title}")


# dataframes values
for row in df.values:
print(row)