import pandas as pd
from codaio import Coda, Document, Cell
doc=Document.from_environment('XWykP50uN-')
transactions_table=doc.get_table('grid-bsHZ_AO1l5')
df_new=pd.DataFrame([
{'Name':'Ricardo','transaction_id':'12dgt'},
{'Name':'Manoel','transaction_id':'fklsod'},
])
df_new
mapping_dict={
'Name':'Name',
'transaction_id':'transaction_id'
}
all_data=[]
for i in range(len(df_new)):
row_data=[]
for j in range(len(df_new.columns)):
row_data.append(Cell(column=mapping_dict[df_new.columns[j]],value_storage=df_new.iloc[i,j]))
all_data.append(row_data)
transactions_table.upsert_rows(all_data)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter